def test_delete_by_template(): print( "--------------------------------------------------------------------") print("Now testing delete_by_template") print("We are going to try and delete: boonera01") print("Showing that willite does exist: ") key_cols = ["playerID"] fields = ['playerID'] template = {'playerID': "boonera01"} csv_table = CSVDataTable("people", connect_info, key_columns=key_cols) print(csv_table.find_by_template(template)) print() print("Now we are going to delete him") result = csv_table.delete_by_template(template) print("The number of deletes occurred: " + str(result)) print( "Lets try to find boonera01 again: ... if nothing prints then it worked" ) print(csv_table.find_by_template(template)) print( "--------------------------------------------------------------------")
def test_update_by_template(): print( "--------------------------------------------------------------------") key_cols = ["playerID"] fields = ['playerID'] template = {'playerID': "boonera01"} csv_table = CSVDataTable("people", connect_info, key_columns=key_cols) result = csv_table.find_by_template(template=template) print("Now testing update by template:") print("Changing abadfe01 to something else") print("I am going to change the player too: playerID' : STONESTONE\n") change = {'playerID': "STONESTONE"} print("Proof that the player exists:") print(result) print("Changes made: " + str(csv_table.update_by_template(template, change))) print( "--------------------------------------------------------------------")
def test_match_all(): temp = {"nameLast": "Williams", "birthCity": "San Diego"} connect_info = {"directory": data_dir, "file_name": "People.csv"} csv_tbl = CSVDataTable("people", connect_info, None) result = csv_tbl.find_by_template( temp) # look at the template and return matches print(json.dumps(result, indent=2))
def test_delete_by_Key(): print( "--------------------------------------------------------------------") print("Now testing delete by key") csv_table = CSVDataTable("people", connect_info, key_columns=['playerID']) templateCSV = csv_table.key_to_template(['accarje01']) result = csv_table.find_by_template(templateCSV) print(json.dumps(result, indent=2)) print('Now deleting') k = csv_table.delete_by_key(["accarje01"]) print(k) print("After") result = csv_table.find_by_template(templateCSV) print(json.dumps(result, indent=2)) print( "--------------------------------------------------------------------")
def t_find_by_template(): print( "--------------------------------------------------------------------") print("Now testing find by template") key_cols = ["playerID"] fields = ['playerID'] template = {'playerID': "willite01"} csv_table = CSVDataTable("people", connect_info, key_columns=key_cols) result = csv_table.find_by_template(template=template) print("Results = \n", json.dumps(result, indent=2)) print( "--------------------------------------------------------------------")
def test_insert(): print( "--------------------------------------------------------------------") print("Now testing insert:") print( "We Are inserting: playerID': 'Mike', 'nameLast': 'Stone', 'birthCity': 'Long Island \n" ) template = {'playerID': 'Mike'} csv_table = CSVDataTable("people", connect_info, key_columns=['playerID']) csv_table.insert(template) print("Now we look to see if the insert worked:") print(csv_table.find_by_template(template)) print( "--------------------------------------------------------------------")