_memory

Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette

Custom SQL query returning 57 rows (hide)

databasetypenametbl_namerootpagesql
extra_database index sqlite_autoindex_searchable_fts_segdir_1 searchable_fts_segdir 6  
extra_database table searchable searchable 2 CREATE TABLE searchable ( pk integer primary key, text1 text, text2 text )
extra_database table searchable_fts searchable_fts 0 CREATE VIRTUAL TABLE "searchable_fts" USING FTS3 (text1, text2, content="searchable")
extra_database table searchable_fts_content searchable_fts_content 3 CREATE TABLE 'searchable_fts_content'(docid INTEGER PRIMARY KEY, 'c0text1', 'c1text2', 'c2content')
extra_database table searchable_fts_segdir searchable_fts_segdir 5 CREATE TABLE 'searchable_fts_segdir'(level INTEGER,idx INTEGER,start_block INTEGER,leaves_end_block INTEGER,end_block INTEGER,root BLOB,PRIMARY KEY(level, idx))
extra_database table searchable_fts_segments searchable_fts_segments 4 CREATE TABLE 'searchable_fts_segments'(blockid INTEGER PRIMARY KEY, block BLOB)
extra_database view searchable_view searchable_view 0 CREATE VIEW searchable_view AS SELECT * FROM searchable
fixtures index idx_compound_three_primary_keys_content compound_three_primary_keys 12 CREATE INDEX idx_compound_three_primary_keys_content ON compound_three_primary_keys(content)
fixtures index sqlite_autoindex_Table With Space In Name_1 Table With Space In Name 20  
fixtures index sqlite_autoindex_complex_foreign_keys_1 complex_foreign_keys 24  
fixtures index sqlite_autoindex_compound_primary_key_1 compound_primary_key 9  
fixtures index sqlite_autoindex_compound_three_primary_keys_1 compound_three_primary_keys 11  
fixtures index sqlite_autoindex_custom_foreign_key_label_1 custom_foreign_key_label 26  
fixtures index sqlite_autoindex_foreign_key_references_1 foreign_key_references 14  
fixtures index sqlite_autoindex_primary_key_multiple_columns_1 primary_key_multiple_columns 5  
fixtures index sqlite_autoindex_primary_key_multiple_columns_explicit_label_1 primary_key_multiple_columns_explicit_label 7  
fixtures index sqlite_autoindex_searchable_fts_segdir_1 searchable_fts_segdir 37  
fixtures index sqlite_autoindex_searchable_tags_1 searchable_tags 34  
fixtures index sqlite_autoindex_simple_primary_key_1 simple_primary_key 3  
fixtures index sqlite_autoindex_sortable_1 sortable 16  
fixtures index sqlite_autoindex_table/with/slashes.csv_1 table/with/slashes.csv 22  
fixtures index sqlite_autoindex_tags_1 tags 31  
fixtures table 123_starts_with_digits 123_starts_with_digits 18 CREATE TABLE [123_starts_with_digits] ( content text )
fixtures table Table With Space In Name Table With Space In Name 19 CREATE TABLE "Table With Space In Name" ( pk varchar(30) primary key, content text )
fixtures table attraction_characteristic attraction_characteristic 46 CREATE TABLE attraction_characteristic ( pk integer primary key, name text )
fixtures table binary_data binary_data 44 CREATE TABLE binary_data ( data BLOB )
fixtures table complex_foreign_keys complex_foreign_keys 23 CREATE TABLE "complex_foreign_keys" ( pk varchar(30) primary key, f1 text, f2 text, f3 text, FOREIGN KEY ("f1") REFERENCES [simple_primary_key](id), FOREIGN KEY ("f2") REFERENCES [simple_primary_key](id), FOREIGN KEY ("f3") REFERENCES [simple_primary_key](id) )
fixtures table compound_primary_key compound_primary_key 8 CREATE TABLE compound_primary_key ( pk1 varchar(30), pk2 varchar(30), content text, PRIMARY KEY (pk1, pk2) )
fixtures table compound_three_primary_keys compound_three_primary_keys 10 CREATE TABLE compound_three_primary_keys ( pk1 varchar(30), pk2 varchar(30), pk3 varchar(30), content text, PRIMARY KEY (pk1, pk2, pk3) )
fixtures table custom_foreign_key_label custom_foreign_key_label 25 CREATE TABLE "custom_foreign_key_label" ( pk varchar(30) primary key, foreign_key_with_custom_label text, FOREIGN KEY ("foreign_key_with_custom_label") REFERENCES [primary_key_multiple_columns_explicit_label](id) )
fixtures table facet_cities facet_cities 42 CREATE TABLE facet_cities ( id integer primary key, name text )
fixtures table facetable facetable 43 CREATE TABLE facetable ( pk integer primary key, created text, planet_int integer, on_earth integer, state text, city_id integer, neighborhood text, tags text, complex_array text, distinct_some_null, FOREIGN KEY ("city_id") REFERENCES [facet_cities](id) )
fixtures table foreign_key_references foreign_key_references 13 CREATE TABLE foreign_key_references ( pk varchar(30) primary key, foreign_key_with_label varchar(30), foreign_key_with_blank_label varchar(30), foreign_key_with_no_label varchar(30), foreign_key_compound_pk1 varchar(30), foreign_key_compound_pk2 varchar(30), FOREIGN KEY (foreign_key_with_label) REFERENCES simple_primary_key(id), FOREIGN KEY (foreign_key_with_blank_label) REFERENCES simple_primary_key(id), FOREIGN KEY (foreign_key_with_no_label) REFERENCES primary_key_multiple_columns(id) FOREIGN KEY (foreign_key_compound_pk1, foreign_key_compound_pk2) REFERENCES compound_primary_key(pk1, pk2) )
fixtures table generated_columns generated_columns 65 CREATE TABLE generated_columns ( body TEXT, id INT GENERATED ALWAYS AS (json_extract(body, '$.number')) STORED, consideration INT GENERATED ALWAYS AS (json_extract(body, '$.string')) STORED )
fixtures table infinity infinity 41 CREATE TABLE infinity ( value REAL )
fixtures table no_primary_key no_primary_key 17 CREATE TABLE no_primary_key ( content text, a text, b text, c text )
fixtures table primary_key_multiple_columns primary_key_multiple_columns 4 CREATE TABLE primary_key_multiple_columns ( id varchar(30) primary key, content text, content2 text )
fixtures table primary_key_multiple_columns_explicit_label primary_key_multiple_columns_explicit_label 6 CREATE TABLE primary_key_multiple_columns_explicit_label ( id varchar(30) primary key, content text, content2 text )
fixtures table roadside_attraction_characteristics roadside_attraction_characteristics 47 CREATE TABLE roadside_attraction_characteristics ( attraction_id INTEGER REFERENCES roadside_attractions(pk), characteristic_id INTEGER REFERENCES attraction_characteristic(pk) )
fixtures table roadside_attractions roadside_attractions 45 CREATE TABLE roadside_attractions ( pk integer primary key, name text, address text, latitude real, longitude real )
fixtures table searchable searchable 32 CREATE TABLE searchable ( pk integer primary key, text1 text, text2 text, [name with . and spaces] text )
fixtures table searchable_fts searchable_fts 0 CREATE VIRTUAL TABLE "searchable_fts" USING FTS4 (text1, text2, [name with . and spaces], content="searchable")
fixtures table searchable_fts_docsize searchable_fts_docsize 38 CREATE TABLE 'searchable_fts_docsize'(docid INTEGER PRIMARY KEY, size BLOB)
fixtures table searchable_fts_segdir searchable_fts_segdir 36 CREATE TABLE 'searchable_fts_segdir'(level INTEGER,idx INTEGER,start_block INTEGER,leaves_end_block INTEGER,end_block INTEGER,root BLOB,PRIMARY KEY(level, idx))
fixtures table searchable_fts_segments searchable_fts_segments 35 CREATE TABLE 'searchable_fts_segments'(blockid INTEGER PRIMARY KEY, block BLOB)
fixtures table searchable_fts_stat searchable_fts_stat 39 CREATE TABLE 'searchable_fts_stat'(id INTEGER PRIMARY KEY, value BLOB)
fixtures table searchable_tags searchable_tags 33 CREATE TABLE searchable_tags ( searchable_id integer, tag text, PRIMARY KEY (searchable_id, tag), FOREIGN KEY (searchable_id) REFERENCES searchable(pk), FOREIGN KEY (tag) REFERENCES tags(tag) )
fixtures table select select 40 CREATE TABLE [select] ( [group] text, [having] text, [and] text, [json] text )
fixtures table simple_primary_key simple_primary_key 2 CREATE TABLE simple_primary_key ( id varchar(30) primary key, content text )
fixtures table sortable sortable 15 CREATE TABLE sortable ( pk1 varchar(30), pk2 varchar(30), content text, sortable integer, sortable_with_nulls real, sortable_with_nulls_2 real, text text, PRIMARY KEY (pk1, pk2) )
fixtures table table/with/slashes.csv table/with/slashes.csv 21 CREATE TABLE "table/with/slashes.csv" ( pk varchar(30) primary key, content text )
fixtures table tags tags 30 CREATE TABLE tags ( tag TEXT PRIMARY KEY )
fixtures table units units 29 CREATE TABLE units ( pk integer primary key, distance int, frequency int )
fixtures view paginated_view paginated_view 0 CREATE VIEW paginated_view AS SELECT content, '- ' || content || ' -' AS content_extra FROM no_primary_key
fixtures view searchable_view searchable_view 0 CREATE VIEW searchable_view AS SELECT * from searchable
fixtures view searchable_view_configured_by_metadata searchable_view_configured_by_metadata 0 CREATE VIEW searchable_view_configured_by_metadata AS SELECT * from searchable
fixtures view simple_view simple_view 0 CREATE VIEW simple_view AS SELECT content, upper(content) AS upper_content FROM simple_primary_key