def test_insert_and_select():
session = {
'hostname': 'localhost',
'port': '12345',
'started': time(),
'completed': time() + 10,
'result': SessionResult.success}
session2 = {
'hostname': 'localhost',
'port': '12345',
'started': time(),
'completed': time() + 10,
'result': SessionResult.success}
times = [
{'time_point_name' : 'time_point1', 'time_point_ord': 1, 'time_point': time()},
{'time_point_name' : 'time_point2', 'time_point_ord': 2, 'time_point': time()},
{'time_point_name' : 'time_point3', 'time_point_ord': 3, 'time_point': time()},
{'time_point_name' : 'time_point4', 'time_point_ord': 4, 'time_point': time()}]
task = {
'source': 'asdf.cpp',
'pch_file': 'fdsa.pch',
'sessions': [session],
'times': times}
task2 = {
'source': 'asdf.cpp',
'sessions': [session2],
'times': times}
command = {
'command': 'compile',
'tasks': [task, task2]}
db = Database()
conn = db.get_connection()
db.create_structure(conn)
with conn:
id = db.insert_command(conn, command)
assert db.get_command(conn, id) == command
def test_create_structure():
db = Database()
with db.get_connection() as conn:
db.create_structure(conn)