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_k(): connect_info = {"directory": data_dir, "file_name": "People.csv"} csv_table = CSVDataTable("people", connect_info, key_columns=['playerID']) k = csv_table.key_to_template("willite01") csv_table.delete_by_key("willite01") print(k)
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 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 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_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( "--------------------------------------------------------------------")
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 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( "--------------------------------------------------------------------")
def t_load(): connect_info = {"directory": data_dir, "file_name": "People.csv"} csv_tbl = CSVDataTable("people", connect_info, None) print("Created table = " + str(csv_tbl))
def t_load(): connect_info = {"directory": data_dir, "file_name": "People.csv"} csv_table = CSVDataTable("people", connect_info, key_columns=['playerID']) print('Created Table = ' + str(csv_table))
def test_init(): connect_info = {"directory": data_dir, "file_name": "People.csv"} csv_tbl = CSVDataTable("people", connect_info, None) print("CSV data", csv_tbl)