def framework_dup_test(dbname):
dw_rep = make_dw_rep(dbname)
dup = NoDuplicateRowPredicate('ft1', ['key1', 'key2'])
case = Case(dw_rep, [dup])
start = time.monotonic() # the instantiations take almost no time
case.run()
end = time.monotonic()
elapsed = end - start
print('{}{}'.format(round(elapsed, 3), 's'))
def framework_row_count_test(path):
dw_rep = make_dw_rep(path)
count = RowCountPredicate('ft1', 1000000)
case = Case(dw_rep, [count])
start = time.monotonic() # the instantiations take almost no time
case.run() # but we may as well measure the time for
end = time.monotonic() # executing the case
elapsed = end - start
print('{}{}'.format(round(elapsed, 3), 's'))
def framework_not_null_test(dbname):
dw_rep = make_dw_rep(dbname)
not_null = ColumnNotNullPredicate('ft1', ['key1', 'key2'])
case = Case(dw_rep, [not_null])
start = time.monotonic() # the instantiations take almost no time
case.run()
end = time.monotonic()
elapsed = end - start
print('{}{}'.format(round(elapsed, 3), 's'))
def framework_fd_test(path):
dw_rep = make_dw_rep(path)
print("Running Case")
fd = FunctionalDependencyPredicate(["ft1"], ((("key1",), ("key2",)),))
case = Case(dw_rep, [fd])
start = time.monotonic()
case.run()
end = time.monotonic()
elapsed = end - start
print("Done: {}{}".format(round(elapsed, 3), "s"))
def framework_compare_test(path, number):
dw_rep = make_dw_rep(path)
expected_rows = []
counter = 0
print('Generating expected table')
start = time.monotonic()
for i in range(1, number + 1):
for j in range(1, number + 1):
counter += 10
expected_rows.append({'key1': i, 'key2': j, 'measure': counter})
end = time.monotonic()
elapsed = end - start
print('Done: {}{}'.format(round(elapsed, 3), 's'))
print('Running Case')
compare = CompareTablePredicate('ft1', expected_rows)
case = Case(dw_rep, [compare])
start = time.monotonic()
case.run()
end = time.monotonic()
elapsed = end - start
print('Done: {}{}'.format(round(elapsed, 3), 's'))
