fixtures
Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette
This data as json, testall, testnone, testresponse, CSV
group_concat( "select '" || name || "' as table_name, * from pragma_table_info('" || name || "')" , ' union ') || ' order by table_name, cid' |
---|
select 'simple_primary_key' as table_name, * from pragma_table_info('simple_primary_key') union select 'primary_key_multiple_columns' as table_name, * from pragma_table_info('primary_key_multiple_columns') union select 'primary_key_multiple_columns_explicit_label' as table_name, * from pragma_table_info('primary_key_multiple_columns_explicit_label') union select 'compound_primary_key' as table_name, * from pragma_table_info('compound_primary_key') union select 'compound_three_primary_keys' as table_name, * from pragma_table_info('compound_three_primary_keys') union select 'foreign_key_references' as table_name, * from pragma_table_info('foreign_key_references') union select 'sortable' as table_name, * from pragma_table_info('sortable') union select 'no_primary_key' as table_name, * from pragma_table_info('no_primary_key') union select '123_starts_with_digits' as table_name, * from pragma_table_info('123_starts_with_digits') union select 'Table With Space In Name' as table_name, * from pragma_table_info('Table With Space In Name') union select 'table/with/slashes.csv' as table_name, * from pragma_table_info('table/with/slashes.csv') union select 'complex_foreign_keys' as table_name, * from pragma_table_info('complex_foreign_keys') union select 'custom_foreign_key_label' as table_name, * from pragma_table_info('custom_foreign_key_label') union select 'units' as table_name, * from pragma_table_info('units') union select 'tags' as table_name, * from pragma_table_info('tags') union select 'searchable' as table_name, * from pragma_table_info('searchable') union select 'searchable_tags' as table_name, * from pragma_table_info('searchable_tags') union select 'searchable_fts' as table_name, * from pragma_table_info('searchable_fts') union select 'searchable_fts_segments' as table_name, * from pragma_table_info('searchable_fts_segments') union select 'searchable_fts_segdir' as table_name, * from pragma_table_info('searchable_fts_segdir') union select 'searchable_fts_docsize' as table_name, * from pragma_table_info('searcha… |