Datasette Fixtures

An example SQLite database demonstrating Datasette. Sign in as root user

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

6 databases49 tables11 views10 queries

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

sortable fixtures

pk1pk2contentsortablesortable_with_nullssortable_with_nulls_2text

201 rows
sortable fixtures2

pk1pk2contentsortablesortable_with_nullssortable_with_nulls_2text

201 rows
compound_three_primary_keys fixtures

pk1pk2pk3content

1,001 rows
compound_three_primary_keys fixtures2

pk1pk2pk3content

1,001 rows
no_primary_key fixtures2

contentabc

202 rows
select fixtures

grouphavingandjson

1 row
select fixtures2

grouphavingandjson

1 row
searchable extra_database

pktext1text2

2 rowsfull-text search
Table With Space In Name fixtures

pkcontent

0 rows
Table With Space In Name fixtures2

pkcontent

0 rows
counters counters

namevalue

3 rows
table/with/slashes.csv fixtures

pkcontent

1 row
table/with/slashes.csv fixtures2

pkcontent

1 row
123_starts_with_digits fixtures

content

0 rows
123_starts_with_digits fixtures2

content

0 rows
binary_data fixtures

data

3 rows
binary_data fixtures2

data

3 rows
infinity fixtures

value

3 rows
infinity fixtures2

value

3 rows
binary_data_view view fixtures

data

3 rows
binary_data_view view fixtures2

data

3 rows
paginated_view view fixtures

contentcontent_extra

202 rows
paginated_view view fixtures2

contentcontent_extra

202 rows
searchable_view view extra_database

pktext1text2

2 rows
searchable_view view fixtures

pktext1text2name with . and spaces

2 rows
searchable_view view fixtures2

pktext1text2name with . and spaces

2 rows
searchable_view_configured_by_metadata view fixtures

pktext1text2name with . and spaces

2 rows
searchable_view_configured_by_metadata view fixtures2

pktext1text2name with . and spaces

2 rows
simple_view view fixtures

contentupper_content

5 rows
simple_view view fixtures2

contentupper_content

5 rows

Recently visited

Queries

Tables and views