Datasette Fixtures
Data license: Apache License 2.0 · Data source: tests/fixtures.py · About: About Datasette
6 databases49 tables11 views10 queries
Recently visited
Queries
All 10 queries โ-
๐๐ข๐ญ๐ข๐๐ฌ
fixtures
select id, name from facet_cities order by id limit 1; -
pragma_cache_size
fixtures
PRAGMA cache_size; -
magic_parameters
fixtures
select :_header_user_agent as user_agent, :_now_datetime_utc as datetimeยท inputs:_header_user_agent,_now_datetime_utc -
Search neighborhoods
fixtures
select _neighborhood, facet_cities.name, state from facetable join facet_cities on facetable._city_id =...ยท inputs:text -
increment_counter_a
writes
counters
update counters set value = value + 1 where name = 'counter_a'
Tables and views
-
foreign_key_references 2 rows
pk, foreign_key_with_label, foreign_key_with_blank_label, foreign_key_with_no_label, foreign_key_compound_pk1, foreign_key_compound_pk2
-
foreign_key_references 2 rows
pk, foreign_key_with_label, foreign_key_with_blank_label, foreign_key_with_no_label, foreign_key_compound_pk1, foreign_key_compound_pk2
-
attraction_id, characteristic_id
-
attraction_id, characteristic_id
-
searchable_tags 2 rows
searchable_id, tag
-
searchable_tags 2 rows
searchable_id, tag
-
id, content
-
simple_primary_key 5 rows
id, content
-
facetable 15 rows
pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n
-
facetable 15 rows
pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n
-
roadside_attractions 4 rows
pk, name, address, url, latitude, longitude
-
roadside_attractions 4 rows
pk, name, address, url, latitude, longitude
-
complex_foreign_keys 1 row
pk, f1, f2, f3
-
complex_foreign_keys 1 row
pk, f1, f2, f3
-
searchable 2 rows
pk, text1, text2, name with . and spaces
-
searchable 2 rows
pk, text1, text2, name with . and spaces
-
compound_primary_key 3 rows
pk1, pk2, content
-
compound_primary_key 3 rows
pk1, pk2, content
-
id, content, content2
-
id, content, content2
-
id, content, content2
-
id, content, content2
-
attraction_characteristic 2 rows
pk, name
-
attraction_characteristic 2 rows
pk, name
-
custom_foreign_key_label 1 row
pk, foreign_key_with_custom_label
-
custom_foreign_key_label 1 row
pk, foreign_key_with_custom_label
-
facet_cities 4 rows
id, name
-
facet_cities 4 rows
id, name
-
tags 2 rows
tag
-
tags 2 rows
tag