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]