def test_index(): print("\n\n*************TEST FOUR CREATING AN INDEX**************") t = CSVDataTable.CSVDataTable(table_name="Test",column_names=['last_name','first_name','uni'],loadit=None) i = CSVDataTable.Index(index_name="Bob", index_columns = ["last_name","first_name"],kind="INDEX", table = t) print(i) r = {"last_name": "Ferguson", "first_name": "Donald", "uni":"sure"} kv = i.compute_key(r) i.add_to_index(row=r,rid="2") print("KV = ",kv, "added to index")
def test3(): i = CSVDataTable.Index(name="Bob", columns=["Last_Name", "First_Name"], kind="UNIQUE") r = {"Last_Name": "Ferguson", "First_Name": "Donald", "Uni": "sure"} kv = i.compute_key(r) print("KV = ", kv) i.add_to_index(row=r, rid="2") print("I = ", i)
def test_conflict(): print("\n\n*************TEST FIVE CREATING CONFLICTING INDEX THROWS ERROR WHEN UNIQUE**************") t= CSVDataTable.CSVDataTable(table_name="Test",column_names=['last_name','first_name','uni'],loadit=None) i = CSVDataTable.Index(index_name="Bob", index_columns = ["last_name","first_name"],kind="UNIQUE",table=t) r = {"last_name": "Ferguson", "first_name": "Donald", "uni":"sure"} kv = i.compute_key(r) i.add_to_index(row=r,rid="2") try: i.add_to_index(row=r, rid="3") except Exception as e: print("We caught an error: ", e)
def test_compute_key_add_to_index(): logging.debug("-------- test_compute_key_add_to_index ---------") i = CSVDataTable.Index(index_name="test", index_columns=["last_name", "first_name"], kind="INDEX") r = {"last_name": "zhang", "first_name": "zhida", "uni": "zz2578"} key = i.compute_key(r) print("key = ", key) i.add_to_index(r, "2") i.add_to_index(r, "3") print("i = ", i) print("\n\n\n\n\n\n")
def t3(): """ Test compute_index_value function. :return: """ print("Test compute_index_value function.") rows, cols = load("../CSVFile/rings.csv") t = CSVDataTable.CSVDataTable(table_name="rings", column_names=cols, primary_key_columns=['uni']) t.import_data(rows) print("T = ", t) i = CSVDataTable.Index(name="Bob", table= t, columns=['last_name', 'first_name'], kind="UNIQUE") r = {"last_name": "Wei", "first_name": "Erica", "uni":"cw1177"} kv = i.compute_index_value(r) print(" KV = ", kv) i.add_to_index(row=r, rid="3") print(i) #print("Should return error here. Duplicate"), correct #i.add_to_index(row=r, rid="4") t.save()