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