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