t = Transaction()
for i in range(10):
key = choice(keys)
t.add_query(query.select, key, 0, [1, 1, 1, 1, 1])
t.add_query(query.update, key, *choice(update_cols))
t.add_query(query.select, key, 0, [1, 1, 1, 1, 1])
t.run()
db.close()
exit()
update_time_0 = process_time()
for i in range(0, 10000):
query.update(choice(keys), *(choice(update_cols)))
update_time_1 = process_time()
print("Updating 10k records took: \t\t\t", update_time_1 - update_time_0)
# Measuring Select Performance
select_time_0 = process_time()
for i in range(0, 10000):
query.select(choice(keys), [1, 1, 1, 1, 1])
select_time_1 = process_time()
print("Selecting 10k records took: \t\t\t", select_time_1 - select_time_0)
# Measuring Aggregate Performance
agg_time_0 = process_time()
for i in range(0, 10000, 100):
result = query.sum(i, 100, randrange(0, 5))
agg_time_1 = process_time()
error = True
if error:
print('select error on', key, ':', record, ', correct:', records[key])
# else:
# print('select on', key, ':', record)
print("Select finished")
for _ in range(2):
for key in keys:
updated_columns = [None, None, None, None, None]
for i in range(1, grades_table.num_columns):
value = randint(0, 20)
updated_columns[i] = value
original = records[key].copy()
records[key][i] = value
query.update(key, *updated_columns)
record = query.select(key, 0, [1, 1, 1, 1, 1])[0]
error = False
for j, column in enumerate(record.columns):
if column != records[key][j]:
error = True
if error:
print('update error on', original, 'and', updated_columns, ':',
record, ', correct:', records[key])
#else:
# print('update on', original, 'and', updated_columns, ':', record)
updated_columns[i] = None
print("Update finished")
"""
for key in keys:
record = query.select(key, 0, [1, 1, 1, 1, 1])[0]