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()