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(query, ' union all ') |
|---|
| select '123_starts_with_digits' as _table, rowid from "123_starts_with_digits" where "content" like '%' || :search || '%' union all select 'Table With Space In Name' as _table, rowid from "Table With Space In Name" where "pk" like '%' || :search || '%' or "content" like '%' || :search || '%' union all select 'attraction_characteristic' as _table, rowid from "attraction_characteristic" where "pk" like '%' || :search || '%' or "name" like '%' || :search || '%' union all select 'binary_data' as _table, rowid from "binary_data" where "data" like '%' || :search || '%' union all select 'complex_foreign_keys' as _table, rowid from "complex_foreign_keys" where "pk" like '%' || :search || '%' or "f1" like '%' || :search || '%' or "f2" like '%' || :search || '%' or "f3" like '%' || :search || '%' union all select 'compound_primary_key' as _table, rowid from "compound_primary_key" where "pk1" like '%' || :search || '%' or "pk2" like '%' || :search || '%' or "content" like '%' || :search || '%' union all select 'compound_three_primary_keys' as _table, rowid from "compound_three_primary_keys" where "pk1" like '%' || :search || '%' or "pk2" like '%' || :search || '%' or "pk3" like '%' || :search || '%' or "content" like '%' || :search || '%' union all select 'custom_foreign_key_label' as _table, rowid from "custom_foreign_key_label" where "pk" like '%' || :search || '%' or "foreign_key_with_custom_label" like '%' || :search || '%' union all select 'facet_cities' as _table, rowid from "facet_cities" where "id" like '%' || :search || '%' or "name" like '%' || :search || '%' union all select 'facetable' as _table, rowid from "facetable" where "pk" like '%' || :search || '%' or "created" like '%' || :search || '%' or "planet_int" like '%' || :search || '%' or "on_earth" like '%' || :search || '%' or "state" like '%' || :search || '%' or "_city_id" like '%' || :search || '%' or "_neighborhood" like '%' || :search || '%' or "tags" like '%' || :search || '%' or "complex_array" like '%' || :search || '%' or "distinct_some_null" like '… |