def t_find_by_primary_key():
print(
"--------------------------------------------------------------------")
print("testing find by primary key")
key_cols = ["playerID"]
keys = ["willite01"]
print("Using keys: Willite01")
csv_table = CSVDataTable("people", connect_info, key_columns=key_cols)
result = csv_table.find_by_primary_key(keys)
print("Results = \n", json.dumps(result, indent=2))
print(
"--------------------------------------------------------------------")
def test_update_by_key():
print(
"--------------------------------------------------------------------")
print("Testing update by key")
key_cols = ["playerID"]
fields = ['playerID']
template = {'playerID': "boonera01"}
print("We are going to try changing player with id: boonera01")
csv_table = CSVDataTable("people", connect_info, key_columns=key_cols)
change = {'playerID': "Stone"}
result = csv_table.update_by_key(['boonera01'], change)
print("Changes that have occurred: " + str(result))
print("Now we try to find him again with new ID:")
print(csv_table.find_by_primary_key(['Stone']))
print(
"--------------------------------------------------------------------")