class TestDynamodbCreate(unittest.TestCase):
def setUp(self):
self.db = Dynamodb('Movies')
def tearDown(self):
self.db.drop_table()
def test_create_table(self):
self.assertEqual(self.db.table_status(), 'ACTIVE')
def setUp(self):
self.db = Dynamodb('Movies')
self.db.put_item({
'year': 2017,
'title': 'The Movie',
'info': {
'rating': decimal.Decimal(0)
}
})
class TestDynamodbOps(unittest.TestCase):
def setUp(self):
self.db = Dynamodb('Movies')
self.db.put_item({
'year': 2017,
'title': 'The Movie',
'info': {
'rating': decimal.Decimal(0)
}
})
def tearDown(self):
self.db.drop_table()
def test_valid_get_item(self):
item = self.db.get_item(2017, 'The Movie')
assert item is not None
def test_invalid_get_item(self):
item = self.db.get_item(2017, 'Invalid title')
assert item is None
#! /usr/bin/env /usr/bin/python
# -*- coding: utf-8 -*-
import spidev
import time
import datetime
from dynamodb import Dynamodb
#インスタンス
dyna = Dynamodb()
spi = spidev.SpiDev() # SpiDev オブジェクトのインスタンスを生成
spi.open(0, 0) # ポート0、デバイス0のSPIをオープン
spi.max_speed_hz = 1000000 # 最大クロックスピードを1MHzに設定
spi.bits_per_word = 8 # 1ワードあたり8ビットに設定
dummy = 0xff # ダミーデータを設定(1111 1111)
start = 0x47 # スタートビットを設定(0100 0111)
sgl = 0x20 # シングルエンドモードを設定(0010 0000)
ch0 = 0x00 # ch0 を選択(0000 0000)
msbf = 0x08 # MSB ファーストモードを選択(0000 1000)
# IC からデータを取得する関数を定義
def measure(ch):
# SPI インターフェイスでデータの送受信を行う
ad = spi.xfer2([(start + sgl + ch + msbf), dummy])
dbname = os.environ.get('REDSHIFT_DATABASE_NAME')
port = os.environ.get('REDSHIFT_DATABASE_PORT')
user = os.environ.get('REDSHIFT_USER_NAME')
pwd = os.environ.get('REDSHIFT_PASSWORD')
con = psycopg2.connect(dbname=dbname,
host=host,
port=port,
user=user,
password=pwd)
cur = con.cursor()
region = os.environ.get('AWS_DEFAULT_REGION')
table_name = os.environ.get('DYNAMODB_AGGR_TABLE_NAME')
client = boto3.resource('dynamodb', region_name=region)
dynamodb = Dynamodb(client, table_name)
#threads = []
accounts = find_accounts()
print('\n\n***accounts = %s' % accounts)
if len(sys.argv) == 1:
current_date = datetime.datetime.utcnow()
else:
current_date = parser.parse(sys.argv[1])
current_date = datetime.datetime(current_date.year, current_date.month,
1)
current_date = current_date + relativedelta(months=1) + relativedelta(
days=-1)
print("cuurent_date = %s" % current_date)
user = os.environ.get('REDSHIFT_USER_NAME')
pwd = os.environ.get('REDSHIFT_PASSWORD')
con = psycopg2.connect(dbname=dbname,
host=host,
port=port,
user=user,
password=pwd)
cur = con.cursor()
region = os.environ.get('AWS_DEFAULT_REGION')
table_name = os.environ.get('DYNAMODB_TABLE_NAME')
compare_table_name = os.environ.get('DYNAMODB_COMPARE_TABLE_NAME')
client = boto3.resource('dynamodb', region_name=region)
table = client.Table(table_name)
dynamodb = Dynamodb(client, compare_table_name)
if len(sys.argv) == 1:
current_date = datetime.datetime.utcnow()
else:
current_date = parser.parse(sys.argv[1])
current_date = datetime.datetime(current_date.year, current_date.month,
1)
current_date = current_date + relativedelta(months=1) + relativedelta(
days=-1)
print("cuurent_date = %s" % current_date)
#current_date = datetime.datetime.utcnow()
prev_date = current_date + relativedelta(days=-1)
#prev_date = current_date
next_date = current_date + relativedelta(days=1)
import datetime
from dateutil.relativedelta import relativedelta
from dateutil import parser
from dateutil import tz
from dynamodb import Dynamodb
import matplotlib
matplotlib.use('Agg')
region = os.environ.get('AWS_DEFAULT_REGION')
compare_table_name = os.environ.get('DYNAMODB_COMPARE_TABLE_NAME')
spike_table_name = os.environ.get('DYNAMODB_SPIKE_TABLE_NAME')
s3_graph_bucket = os.environ.get('S3_GRAPH_BUCKET')
client = boto3.resource('dynamodb', region_name=region)
compare_table = client.Table(compare_table_name)
spike_table = Dynamodb(client, spike_table_name)
s3 = boto3.client('s3')
s3_resource = boto3.resource('s3')
org = boto3.client('organizations')
def autolabel(ax, rects):
"""
Attach a text label above each bar displaying its height
"""
for rect in rects:
height = rect.get_height()
ax.text(rect.get_x() + rect.get_width() / 2.,
1.05 * height,
'%.2f' % height,
ha='center',
def setUp(self):
self.db = Dynamodb('Movies')