fixtures: facetable: 4 rows where _city

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

4 rows where _city_id = 3

descending

This data as json, testall, testnone, testresponse, CSV (advanced)

pk ▼	created	planet_int	on_earth	state	_city_id	_neighborhood	tags	complex_array
11	2019-01-16 08:00:00	1	1	MI	Detroit 3	Downtown	[]	[]
12	2019-01-17 08:00:00	1	1	MI	Detroit 3	Greektown	[]	[]
13	2019-01-17 08:00:00	1	1	MI	Detroit 3	Corktown	[]	[]
14	2019-01-17 08:00:00	1	1	MI	Detroit 3	Mexicantown	[]	[]

Advanced export

JSON shape: default, array, newline-delimited, object

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,
    n text,
    FOREIGN KEY ("_city_id") REFERENCES [facet_cities](id)
);

{ "request_duration_ms": 54.840446000525844, "sum_trace_duration_ms": 35.611370994956815, "num_traces": 75, "traces": [ { "type": "sql", "start": 14821.813515993, "end": 14821.813849114, "duration_ms": 0.33312099913018756, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 745, in table_view\n await datasette.refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 473, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 482, in _refresh_schemas\n for row in await internal_db.execute(\n" ], "database": "__INTERNAL__", "sql": "select database_name, schema_version from catalog_databases", "params": null }, { "type": "sql", "start": 14821.814088876, "end": 14821.81436551, "duration_ms": 0.2766339985100785, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 745, in table_view\n await datasette.refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 473, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 487, in _refresh_schemas\n schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n" ], "database": "_memory", "sql": "PRAGMA schema_version", "params": null }, { "type": "sql", "start": 14821.81454533, "end": 14821.814761351, "duration_ms": 0.21602099877782166, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 745, in table_view\n await datasette.refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 473, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 487, in _refresh_schemas\n schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n" ], "database": "fixtures", "sql": "PRAGMA schema_version", "params": null }, { "type": "sql", "start": 14821.814925502, "end": 14821.815121361, "duration_ms": 0.19585900008678436, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 745, in table_view\n await datasette.refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 473, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 487, in _refresh_schemas\n schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n" ], "database": "fixtures2", "sql": "PRAGMA schema_version", "params": null }, { "type": "sql", "start": 14821.815255637, "end": 14821.815429328, "duration_ms": 0.17369099987263326, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 745, in table_view\n await datasette.refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 473, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 487, in _refresh_schemas\n schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n" ], "database": "extra_database", "sql": "PRAGMA schema_version", "params": null }, { "type": "sql", "start": 14821.815558365, "end": 14821.815784099, "duration_ms": 0.22573400019609835, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 745, in table_view\n await datasette.refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 473, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 487, in _refresh_schemas\n schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n" ], "database": "counters", "sql": "PRAGMA schema_version", "params": null }, { "type": "sql", "start": 14821.815932832, "end": 14821.816152779, "duration_ms": 0.21994700000504963, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 745, in table_view\n await datasette.refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 473, in refresh_schemas\n await self._refresh_schemas()\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 487, in _refresh_schemas\n schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n" ], "database": "ephemeral", "sql": "PRAGMA schema_version", "params": null }, { "type": "sql", "start": 14821.816371573, "end": 14821.816646858, "duration_ms": 0.27528499958862085, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 776, in table_view_traced\n resolved = await datasette.resolve_table(request)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1564, in resolve_table\n table_exists = await db.table_exists(table_name)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/database.py\", line 405, in table_exists\n results = await self.execute(\n" ], "database": "fixtures", "sql": "select 1 from sqlite_master where type='table' and name=?", "params": [ "facetable" ] }, { "type": "sql", "start": 14821.816846384, "end": 14821.817073305, "duration_ms": 0.22692099992127623, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 14821.817357188, "end": 14821.817576574, "duration_ms": 0.21938600002613384, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 14821.81778123, "end": 14821.818034511, "duration_ms": 0.25328099945909344, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 14821.818243946, "end": 14821.818425308, "duration_ms": 0.18136200014851056, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 14821.818684609, "end": 14821.819100592, "duration_ms": 0.41598300049372483, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 14821.819338693, "end": 14821.819512828, "duration_ms": 0.17413500063412357, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 14821.821555481, "end": 14821.821902417, "duration_ms": 0.3469359999144217, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 747, in table_view\n response = await table_view_traced(datasette, request)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 800, in table_view_traced\n view_data = await table_view_data(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 1185, in table_view_data\n results = await db.execute(sql, params, truncate=True, **extra_args)\n" ], "database": "fixtures", "sql": "select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 order by pk limit 101", "params": { "p0": "3" } }, { "type": "sql", "start": 14821.823021949, "end": 14821.823233868, "duration_ms": 0.2119190012308536, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 14821.823470767, "end": 14821.823669709, "duration_ms": 0.19894199976988602, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 14821.823973556, "end": 14821.824163874, "duration_ms": 0.19031800002267119, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 14821.824359955, "end": 14821.824597616, "duration_ms": 0.2376609991188161, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 14821.824892292, "end": 14821.825080081, "duration_ms": 0.18778900084726047, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 14821.826001012, "end": 14821.826302231, "duration_ms": 0.30121900090307463, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 14821.826884944, "end": 14821.827190424, "duration_ms": 0.30547999995178543, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 1229, in table_view_data\n await datasette.expand_foreign_keys(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1068, in expand_foreign_keys\n results = await self.execute(database, sql, list(set(values)))\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select id, name\n from facet_cities\n where id in (?)", "params": [ 3 ] }, { "type": "sql", "start": 14821.828921513, "end": 14821.830069299, "duration_ms": 1.147785998909967, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 1532, in extra_view_definition\n return await db.get_view_definition(table_name)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/database.py\", line 550, in get_view_definition\n return await self.get_table_definition(view, \"view\")\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/database.py\", line 530, in get_table_definition\n await self.execute(\n" ], "database": "fixtures", "sql": "select sql from sqlite_master where name = :n and type=:t", "params": { "n": "facetable", "t": "view" } }, { "type": "sql", "start": 14821.828664524, "end": 14821.830634945, "duration_ms": 1.9704209989868104, "traceback": [ " File \"/usr/local/lib/python3.11/asyncio/events.py\", line 80, in _run\n self._context.run(self._callback, *self._args)\n", " File \"/usr/local/lib/python3.11/site-packages/asyncinject/__init__.py\", line 132, in worker\n res = await self._get_awaitable(name, results)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 1298, in extra_count\n count_rows = list(await db.execute(count_sql, from_sql_params))\n" ], "database": "fixtures", "sql": "select count(*) from facetable where \"_city_id\" = :p0", "params": { "p0": "3" } }, { "type": "sql", "start": 14821.828700416, "end": 14821.830844034, "duration_ms": 2.1436180013552075, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/asyncinject/__init__.py\", line 132, in worker\n res = await self._get_awaitable(name, results)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 1529, in extra_table_definition\n return await db.get_table_definition(table_name)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/database.py\", line 530, in get_table_definition\n await self.execute(\n" ], "database": "fixtures", "sql": "select sql from sqlite_master where name = :n and type=:t", "params": { "n": "facetable", "t": "table" } }, { "type": "sql", "start": 14821.830981318, "end": 14821.832566143, "duration_ms": 1.584825000463752, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/asyncinject/__init__.py\", line 132, in worker\n res = await self._get_awaitable(name, results)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 1529, in extra_table_definition\n return await db.get_table_definition(table_name)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/database.py\", line 540, in get_table_definition\n await self.execute(\n" ], "database": "fixtures", "sql": "select sql from sqlite_master where tbl_name = :n and type='index' and sql is not null", "params": { "n": "facetable" } }, { "type": "sql", "start": 14821.831966141, "end": 14821.834255779, "duration_ms": 2.2896379996382166, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 230, in facet_results\n facet_rows_results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select _city_id as value, count(*) as count from (\n select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n )\n where _city_id is not null\n group by _city_id order by count desc, value limit 31", "params": { "p0": "3" } }, { "type": "sql", "start": 14821.831833519, "end": 14821.834704049, "duration_ms": 2.8705300010187784, "traceback": [ " File \"plugins/my_plugin.py\", line 167, in suggest\n columns = await self.get_columns(self.sql, self.params)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 138, in get_columns\n await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 ) limit 0", "params": { "p0": "3" } }, { "type": "sql", "start": 14821.835193872, "end": 14821.835497421, "duration_ms": 0.3035489989997586, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 14821.834984018, "end": 14821.835774904, "duration_ms": 0.7908860006864415, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 160, in suggest\n columns = await self.get_columns(self.sql, self.params)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 138, in get_columns\n await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 ) limit 0", "params": { "p0": "3" } }, { "type": "sql", "start": 14821.835722257, "end": 14821.836349447, "duration_ms": 0.6271900001593167, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 14821.836602698, "end": 14821.83686108, "duration_ms": 0.2583820005384041, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 14821.836117968, "end": 14821.837337289, "duration_ms": 1.2193210004625143, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 178, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select pk as value, count(*) as n from (\n select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n ) where value is not null\n group by value\n limit 31", "params": { "p0": "3" } }, { "type": "sql", "start": 14821.83708578, "end": 14821.837536812, "duration_ms": 0.4510319995461032, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 14821.837768962, "end": 14821.838078465, "duration_ms": 0.3095030006079469, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 14821.837494429, "end": 14821.838376525, "duration_ms": 0.882095999259036, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 178, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select created as value, count(*) as n from (\n select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n ) where value is not null\n group by value\n limit 31", "params": { "p0": "3" } }, { "type": "sql", "start": 14821.838324726, "end": 14821.839268676, "duration_ms": 0.9439499990548939, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 14821.83894813, "end": 14821.839517804, "duration_ms": 0.5696739990526112, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 178, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select planet_int as value, count(*) as n from (\n select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n ) where value is not null\n group by value\n limit 31", "params": { "p0": "3" } }, { "type": "sql", "start": 14821.839656598, "end": 14821.840035552, "duration_ms": 0.37895400055276696, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 178, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select on_earth as value, count(*) as n from (\n select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n ) where value is not null\n group by value\n limit 31", "params": { "p0": "3" } }, { "type": "sql", "start": 14821.84000152, "end": 14821.840554367, "duration_ms": 0.552846999198664, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 254, in facet_results\n expanded = await self.ds.expand_foreign_keys(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1068, in expand_foreign_keys\n results = await self.execute(database, sql, list(set(values)))\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select id, name\n from facet_cities\n where id in (?)", "params": [ 3 ] }, { "type": "sql", "start": 14821.840389913, "end": 14821.841593542, "duration_ms": 1.2036289990646765, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 178, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select state as value, count(*) as n from (\n select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n ) where value is not null\n group by value\n limit 31", "params": { "p0": "3" } }, { "type": "sql", "start": 14821.841751937, "end": 14821.842005025, "duration_ms": 0.2530880010453984, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 178, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select _neighborhood as value, count(*) as n from (\n select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n ) where value is not null\n group by value\n limit 31", "params": { "p0": "3" } }, { "type": "sql", "start": 14821.842196294, "end": 14821.842453397, "duration_ms": 0.2571029999671737, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 178, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select tags as value, count(*) as n from (\n select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n ) where value is not null\n group by value\n limit 31", "params": { "p0": "3" } }, { "type": "sql", "start": 14821.842676162, "end": 14821.842989314, "duration_ms": 0.3131520006718347, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 178, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select complex_array as value, count(*) as n from (\n select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n ) where value is not null\n group by value\n limit 31", "params": { "p0": "3" } }, { "type": "sql", "start": 14821.843408333, "end": 14821.843752176, "duration_ms": 0.34384300124656875, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 178, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select distinct_some_null as value, count(*) as n from (\n select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n ) where value is not null\n group by value\n limit 31", "params": { "p0": "3" } }, { "type": "sql", "start": 14821.843910367, "end": 14821.844322683, "duration_ms": 0.41231599971069954, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 178, in suggest\n distinct_values = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select n as value, count(*) as n from (\n select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n ) where value is not null\n group by value\n limit 31", "params": { "p0": "3" } }, { "type": "sql", "start": 14821.844511617, "end": 14821.845006897, "duration_ms": 0.49527999908605125, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 459, in suggest\n columns = await self.get_columns(self.sql, self.params)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 138, in get_columns\n await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 ) limit 0", "params": { "p0": "3" } }, { "type": "sql", "start": 14821.845220136, "end": 14821.845584711, "duration_ms": 0.3645750002760906, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 474, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select date(pk) from (\n select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n ) where pk glob \"????-??-*\" limit 100;", "params": { "p0": "3" } }, { "type": "sql", "start": 14821.845760486, "end": 14821.846043724, "duration_ms": 0.28323799961071927, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 474, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select date(created) from (\n select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n ) where created glob \"????-??-*\" limit 100;", "params": { "p0": "3" } }, { "type": "sql", "start": 14821.84650582, "end": 14821.84676781, "duration_ms": 0.261990000581136, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 474, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select date(planet_int) from (\n select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n ) where planet_int glob \"????-??-*\" limit 100;", "params": { "p0": "3" } }, { "type": "sql", "start": 14821.84693065, "end": 14821.847166885, "duration_ms": 0.23623500055691693, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 474, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select date(on_earth) from (\n select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n ) where on_earth glob \"????-??-*\" limit 100;", "params": { "p0": "3" } }, { "type": "sql", "start": 14821.847342162, "end": 14821.847605278, "duration_ms": 0.26311600049666595, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 474, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select date(state) from (\n select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n ) where state glob \"????-??-*\" limit 100;", "params": { "p0": "3" } }, { "type": "sql", "start": 14821.847780919, "end": 14821.848041546, "duration_ms": 0.2606269990792498, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 474, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select date(_city_id) from (\n select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n ) where _city_id glob \"????-??-*\" limit 100;", "params": { "p0": "3" } }, { "type": "sql", "start": 14821.848201368, "end": 14821.848462197, "duration_ms": 0.26082899967150297, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 474, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select date(_neighborhood) from (\n select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n ) where _neighborhood glob \"????-??-*\" limit 100;", "params": { "p0": "3" } }, { "type": "sql", "start": 14821.848617601, "end": 14821.848889247, "duration_ms": 0.27164600032847375, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 474, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select date(tags) from (\n select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n ) where tags glob \"????-??-*\" limit 100;", "params": { "p0": "3" } }, { "type": "sql", "start": 14821.849061054, "end": 14821.849350431, "duration_ms": 0.28937700153619517, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 474, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select date(complex_array) from (\n select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n ) where complex_array glob \"????-??-*\" limit 100;", "params": { "p0": "3" } }, { "type": "sql", "start": 14821.849511736, "end": 14821.849837423, "duration_ms": 0.32568700044066645, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 474, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select date(distinct_some_null) from (\n select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n ) where distinct_some_null glob \"????-??-*\" limit 100;", "params": { "p0": "3" } }, { "type": "sql", "start": 14821.850045211, "end": 14821.850378326, "duration_ms": 0.33311500010313466, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 474, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select date(n) from (\n select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 \n ) where n glob \"????-??-*\" limit 100;", "params": { "p0": "3" } }, { "type": "sql", "start": 14821.850551788, "end": 14821.850747333, "duration_ms": 0.19554499885998666, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 303, in suggest\n columns = await self.get_columns(self.sql, self.params)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 138, in get_columns\n await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select * from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 ) limit 0", "params": { "p0": "3" } }, { "type": "sql", "start": 14821.850943582, "end": 14821.851306335, "duration_ms": 0.36275300044508185, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 318, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select distinct json_type(pk)\n from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 )\n where pk is not null and pk != ''", "params": { "p0": "3" } }, { "type": "sql", "start": 14821.851836316, "end": 14821.852116588, "duration_ms": 0.2802719991450431, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 318, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select distinct json_type(planet_int)\n from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 )\n where planet_int is not null and planet_int != ''", "params": { "p0": "3" } }, { "type": "sql", "start": 14821.852310039, "end": 14821.852770487, "duration_ms": 0.4604480000125477, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 318, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select distinct json_type(on_earth)\n from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 )\n where on_earth is not null and on_earth != ''", "params": { "p0": "3" } }, { "type": "sql", "start": 14821.853475419, "end": 14821.853878618, "duration_ms": 0.40319899926544167, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 318, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select distinct json_type(_city_id)\n from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 )\n where _city_id is not null and _city_id != ''", "params": { "p0": "3" } }, { "type": "sql", "start": 14821.854515347, "end": 14821.85478968, "duration_ms": 0.27433299874246586, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 318, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select distinct json_type(tags)\n from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 )\n where tags is not null and tags != ''", "params": { "p0": "3" } }, { "type": "sql", "start": 14821.854949229, "end": 14821.855217297, "duration_ms": 0.26806799905898515, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 331, in suggest\n for v in await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select tags from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 ) where tags is not null and tags != '' and json_array_length(tags) > 0 limit 100", "params": { "p0": "3" } }, { "type": "sql", "start": 14821.855389798, "end": 14821.855706542, "duration_ms": 0.31674399906478357, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 318, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select distinct json_type(complex_array)\n from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 )\n where complex_array is not null and complex_array != ''", "params": { "p0": "3" } }, { "type": "sql", "start": 14821.855899838, "end": 14821.856197795, "duration_ms": 0.29795699992973823, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 331, in suggest\n for v in await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select complex_array from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 ) where complex_array is not null and complex_array != '' and json_array_length(complex_array) > 0 limit 100", "params": { "p0": "3" } }, { "type": "sql", "start": 14821.856405564, "end": 14821.856767326, "duration_ms": 0.36176200046611484, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 318, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select distinct json_type(distinct_some_null)\n from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 )\n where distinct_some_null is not null and distinct_some_null != ''", "params": { "p0": "3" } }, { "type": "sql", "start": 14821.856942522, "end": 14821.857241323, "duration_ms": 0.2988010000990471, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/views/table.py\", line 90, in run_sequential\n results.append(await fn)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/facets.py\", line 318, in suggest\n results = await self.ds.execute(\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1017, in execute\n return await self.databases[db_name].execute(\n" ], "database": "fixtures", "sql": "select distinct json_type(n)\n from (select pk, created, planet_int, on_earth, state, _city_id, _neighborhood, tags, complex_array, distinct_some_null, n from facetable where \"_city_id\" = :p0 )\n where n is not null and n != ''", "params": { "p0": "3" } }, { "type": "sql", "start": 14821.858143536, "end": 14821.858322683, "duration_ms": 0.17914700038090814, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 14821.858577181, "end": 14821.858729653, "duration_ms": 0.1524720009911107, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1280, in render_template\n extra_script = await await_me_maybe(extra_script)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin.py\", line 90, in inner\n await datasette.get_database().execute(\"select 3 * 5\")\n" ], "database": "_memory", "sql": "select 3 * 5", "params": null }, { "type": "sql", "start": 14821.859012503, "end": 14821.859181441, "duration_ms": 0.16893799875106197, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 1367, in _asset_urls\n hook = await await_me_maybe(hook)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin.py\", line 47, in inner\n await datasette.get_database().execute(\"select 3 * 5\")\n" ], "database": "_memory", "sql": "select 3 * 5", "params": null }, { "type": "sql", "start": 14821.8600757, "end": 14821.860260564, "duration_ms": 0.1848640004027402, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 14821.86045587, "end": 14821.8606112, "duration_ms": 0.15532999896095134, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null }, { "type": "sql", "start": 14821.860898257, "end": 14821.861058323, "duration_ms": 0.1600659998075571, "traceback": [ " File \"/usr/local/lib/python3.11/site-packages/datasette/app.py\", line 914, in permission_allowed\n check = await await_me_maybe(check)\n", " File \"/usr/local/lib/python3.11/site-packages/datasette/utils/__init__.py\", line 116, in await_me_maybe\n value = await value\n", " File \"plugins/my_plugin_2.py\", line 123, in inner\n await datasette.get_internal_database().execute(\"select 1 + 1\")\n" ], "database": "__INTERNAL__", "sql": "select 1 + 1", "params": null } ] }