simonw
commented
2 years ago Yeah, table.columns and table.columns_dict are meant to handle this: https://sqlite-utils.datasette.io/en/stable/python-api.html#columns
Closed chapmanjacobd closed 2 years ago
simonw
commented
2 years ago Yeah, table.columns and table.columns_dict are meant to handle this: https://sqlite-utils.datasette.io/en/stable/python-api.html#columns
It would be nice to have a
column_names. Similar totable_names.Or if you could get one or all of the following syntax to work for both Database and Table that might be even better:
Style 1
if 'table1' in dbif 'col1' in db['table1']Style 2
if 'table1' in db.tablesif 'col1' in db['table1'].columnsmaybe the table ones actually work but I'm too lazy to check. I just know that I have to do:
[c.name for c in db['table1'].columns]Edit: This is possible with
columns_dict. I have actually used that before but I forgot about it. Feel free to close, but I do think accessing this data could be more consistent and intuitive.