Datasette Fixtures

Tables and views

• foreign_key_references links to 3 tables

  pkforeign_key_with_labelforeign_key_with_blank_labelforeign_key_with_no_labelforeign_key_compound_pk1foreign_key_compound_pk2

  2 rows

• roadside_attraction_characteristics links to 2 tables

  attraction_idcharacteristic_id

  5 rows

• searchable_tags links to 2 tables

  searchable_idtag

  2 rows

• simple_primary_key links to 2 tables

  idcontent

  5 rows

• facetable links to 1 table

  pkcreatedplanet_inton_earthstate_city_id_neighborhoodtags+3 more

  15 rows

• roadside_attractions links to 1 table

  pknameaddressurllatitudelongitude

  4 rows

• complex_foreign_keys links to 1 table

  pkf1f2f3

  1 row

• searchable links to 1 table

  pktext1text2name with . and spaces

  2 rowsfull-text search

• compound_primary_key links to 1 table

  pk1pk2content

  3 rows

• primary_key_multiple_columns links to 1 table

  idcontentcontent2

  1 row

• primary_key_multiple_columns_explicit_label links to 1 table

  idcontentcontent2

  1 row

• attraction_characteristic links to 1 table

  pkname

  2 rows

• custom_foreign_key_label links to 1 table

  pkforeign_key_with_custom_label

  1 row

• facet_cities links to 1 table

  idname

  4 rows

• tags links to 1 table

  tag

  2 rows

• sortable

  pk1pk2contentsortablesortable_with_nullssortable_with_nulls_2text

  201 rows

• compound_three_primary_keys

  pk1pk2pk3content

  1,001 rows

• no_primary_key

  contentabc

  202 rows

• select

  grouphavingandjson

  1 row

• Table With Space In Name

  pkcontent

  0 rows

• table/with/slashes.csv

  pkcontent

  1 row

• 123_starts_with_digits

  content

  0 rows

• binary_data

  data

  3 rows

• infinity

  value

  3 rows

• binary_data_view view

  data

  3 rows

• paginated_view view

  contentcontent_extra

  202 rows

• searchable_view view

  pktext1text2name with . and spaces

  2 rows

• searchable_view_configured_by_metadata view

  pktext1text2name with . and spaces

  2 rows

• simple_view view

  contentupper_content

  5 rows