def test_check_object_data_insert(self):
with DbManager(sqlite3, "MTSDB.db") as db:
generate.insert_data_in_db(0, db, self.result_list)
self.result_list[0] = str(self.result_list[0])
self.result_list[5] = str(self.result_list[5])
for av in db.execute_results("SELECT * FROM {0}".format(
common.CHECK_OBJECT_TABLE)):
assert (av == tuple(self.result_list))
def main(args):
"""
Main function
:param args: Arguments from command string
"""
with DbManager(sqlite3, args.output) as db:
create_table(db)
generate_data_and_insert_in_db(args, generate_datelist(datetime.datetime.now().date()), db)
def main(args):
"""
Main function
:param args: Arguments from command string
"""
with DbManager(sqlite3, args.db) as db:
result_data_list = get_and_parse_data_from_db(db)
create_result_table(db)
insert_data_in_result_db(db, result_data_list)
def setup(self):
with DbManager(sqlite3, "MTSDB.db") as db:
db.execute(
'CREATE TABLE IF NOT EXISTS {0} ({1} {2}, {3} {4}, {5} {6}, {7} {8}, {9} {10}, {11} {12})'
.format(common.CHECK_OBJECT_TABLE, common.COT_LOAD_DATE_COL,
common.COT_LOAD_DATE_TYPE, common.COT_ID_COL,
common.COT_ID_TYPE, common.COT_INT_COL,
common.COT_INT_TYPE, common.COT_FLOAT_COL,
common.COT_FLOAT_TYPE, common.COT_CHAR_COL,
common.COT_CHAR_TYPE, common.COT_DATE_COL,
common.COT_DATE_TYPE))
def setup(self):
with DbManager(sqlite3, "MTSDB.db") as db:
db.execute(
'CREATE TABLE IF NOT EXISTS {0} ({1} {2}, {3} {4}, {5} {6}, {7} {8}, {9} {10}, {11} {12})'
.format(common.CHECK_STATUS_TABLE, common.COT_NON_UNIQUE_COL,
common.COT_NON_UNIQUE_TYPE, common.COT_TOTAL_COUNT_COL,
common.COT_TOTAL_COUNT_TYPE, common.COT_NULL_COUNT_COL,
common.COT_NULL_COUNT_TYPE, common.COT_ZERO_COUNT_COL,
common.COT_ZERO_COUNT_TYPE, common.COT_AVERAGE_INT_COL,
common.COT_AVERAGE_INT_TYPE,
common.COT_AVERAGE_FLOAT_COL,
common.COT_AVERAGE_FLOAT_TYPE))
def teardown(self):
with DbManager(sqlite3, "MTSDB.db") as db:
db.execute("DROP TABLE {0}".format(common.CHECK_STATUS_TABLE))
def test_check_status_results_insert(self):
with DbManager(sqlite3, "MTSDB.db") as db:
calc_stats.insert_data_in_result_db(db, self.result_list)
for av in db.execute_results("SELECT * FROM {0}".format(
common.CHECK_STATUS_TABLE)):
assert (av == tuple(self.result_list))
def test_check_status_create(self):
with DbManager(sqlite3, "MTSDB.db") as db:
generate.create_table(db)
assert (db.execute("SELECT * FROM {0}".format(
common.CHECK_OBJECT_TABLE)))
def test_check_status_create(self):
with DbManager(sqlite3, "MTSDB.db") as db:
calc_stats.create_result_table(db)
assert (db.execute("SELECT * FROM {0}".format(
common.CHECK_STATUS_TABLE)))