def my_test_3(): """ Try passing multiple index definitions in table definition. Should pass. """ print_test_separator("Starting my_test_3") print( "##### Try passing multiple index definitions in table definition. Should pass.\n" ) cleanup() cat = CSVCatalog.CSVCatalog() cds = [] cds.append(CSVCatalog.ColumnDefinition("playerID", "text", True)) cds.append(CSVCatalog.ColumnDefinition("nameLast", "text", True)) cds.append(CSVCatalog.ColumnDefinition("nameFirst", column_type="text")) ids = [] ## TODO test this? # ids.append(CSVCatalog.IndexDefinition("PRIMARY", "PRIMARY", ["playerID"])) # ids.append(CSVCatalog.IndexDefinition("my_idx", "INDEX", ["playerID"])) ids.append(CSVCatalog.IndexDefinition("PRIMARY", "PRIMARY", ["playerID"])) ids.append( CSVCatalog.IndexDefinition("my_idx", "INDEX", ["nameLast", "nameFirst"])) t = cat.create_table("people", "data/People.csv", cds, ids) print("People table", json.dumps(t.describe_table(), indent=2)) print("\n##### Expected result: pass") print_test_separator("Complete my_test_3")
def test_index_def_to_json(): print("\n*********** Testing index def to JSON. *******************\n") cds = [] cds.append(CSVCatalog.ColumnDefinition('teamID', 'text', True)) cds.append(CSVCatalog.ColumnDefinition('yearID', 'text', True)) ind = CSVCatalog.IndexDefinition('INDEX_teamID_yearID', cds, "PRIMARY"); print(ind.to_json());