fixtures: facetable: 1 row where _city

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

1 row where _city_id = 4

descending

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

pk ▼	created	planet_int	on_earth	state	_city_id	_neighborhood	tags	complex_array	distinct_some_null	n
15	2019-01-17 08:00:00	2	0	MC	Memnonia 4	Arcadia Planitia	[]	[]

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": 69.02866798918694, "sum_trace_duration_ms": 47.60852619074285, "num_traces": 75, "traces": [ { "type": "sql", "start": 524394.144829507, "end": 524394.14541125, "duration_ms": 0.5817429628223181, "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": 524394.145644266, "end": 524394.147336788, "duration_ms": 1.6925219679251313, "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": 524394.14754728, "end": 524394.147936319, "duration_ms": 0.3890390507876873, "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": 524394.148308922, "end": 524394.148827424, "duration_ms": 0.5185020854696631, "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": 524394.148978086, "end": 524394.149337622, "duration_ms": 0.35953603219240904, "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": 524394.149670548, "end": 524394.150161914, "duration_ms": 0.4913659067824483, "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": 524394.150362941, "end": 524394.151344339, "duration_ms": 0.9813980432227254, "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": 524394.151825055, "end": 524394.152222451, "duration_ms": 0.39739604108035564, "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": 524394.152541469, "end": 524394.15296898, "duration_ms": 0.4275110550224781, "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": 524394.153316026, "end": 524394.153727513, "duration_ms": 0.41148706804960966, "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": 524394.153931014, "end": 524394.154203624, "duration_ms": 0.2726099919527769, "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": 524394.15444854, "end": 524394.154733958, "duration_ms": 0.2854180056601763, "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": 524394.154975013, "end": 524394.155632718, "duration_ms": 0.6577050080522895, "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": 524394.155837005, "end": 524394.156278541, "duration_ms": 0.4415359580889344, "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": 524394.159388189, "end": 524394.159996121, "duration_ms": 0.607931986451149, "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": "4" } }, { "type": "sql", "start": 524394.161527205, "end": 524394.161813665, "duration_ms": 0.28645992279052734, "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": 524394.16203065, "end": 524394.162349202, "duration_ms": 0.31855201814323664, "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": 524394.162564643, "end": 524394.1628723, "duration_ms": 0.3076570574194193, "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": 524394.163121686, "end": 524394.163489417, "duration_ms": 0.3677310887724161, "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": 524394.163713124, "end": 524394.164042471, "duration_ms": 0.32934697810560465, "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": 524394.164300219, "end": 524394.164569982, "duration_ms": 0.2697629388421774, "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": 524394.167046343, "end": 524394.167401971, "duration_ms": 0.35562796983867884, "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": [ 4 ] }, { "type": "sql", "start": 524394.16875337, "end": 524394.169986215, "duration_ms": 1.2328450102359056, "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": 524394.169144971, "end": 524394.170314522, "duration_ms": 1.1695510474964976, "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": 524394.168892016, "end": 524394.171236195, "duration_ms": 2.344178967177868, "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": "4" } }, { "type": "sql", "start": 524394.170173449, "end": 524394.171533667, "duration_ms": 1.3602180406451225, "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": 524394.172996631, "end": 524394.174468956, "duration_ms": 1.4723249478265643, "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": "4" } }, { "type": "sql", "start": 524394.172829837, "end": 524394.175049034, "duration_ms": 2.2191969910636544, "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": "4" } }, { "type": "sql", "start": 524394.175358176, "end": 524394.175929228, "duration_ms": 0.5710519617423415, "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": "4" } }, { "type": "sql", "start": 524394.176477667, "end": 524394.177004668, "duration_ms": 0.5270011024549603, "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": 524394.176163632, "end": 524394.177521751, "duration_ms": 1.358119072392583, "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": "4" } }, { "type": "sql", "start": 524394.177303007, "end": 524394.177935454, "duration_ms": 0.6324469577521086, "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": 524394.177805356, "end": 524394.178887754, "duration_ms": 1.082397997379303, "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": "4" } }, { "type": "sql", "start": 524394.178243363, "end": 524394.179156685, "duration_ms": 0.9133219718933105, "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": 524394.179054708, "end": 524394.179873432, "duration_ms": 0.8187240455299616, "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": "4" } }, { "type": "sql", "start": 524394.179391927, "end": 524394.180173352, "duration_ms": 0.781425042077899, "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": 524394.180031984, "end": 524394.180900721, "duration_ms": 0.8687369991093874, "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": "4" } }, { "type": "sql", "start": 524394.180411463, "end": 524394.181153566, "duration_ms": 0.7421029731631279, "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": 524394.181331169, "end": 524394.181654651, "duration_ms": 0.3234819741919637, "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": 524394.181110814, "end": 524394.18353888, "duration_ms": 2.428065985441208, "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": "4" } }, { "type": "sql", "start": 524394.18377314, "end": 524394.184389559, "duration_ms": 0.616419012658298, "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": "4" } }, { "type": "sql", "start": 524394.184599143, "end": 524394.186213687, "duration_ms": 1.6145439585670829, "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": "4" } }, { "type": "sql", "start": 524394.185907202, "end": 524394.187019044, "duration_ms": 1.111841993406415, "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": [ 4 ] }, { "type": "sql", "start": 524394.187451377, "end": 524394.188926887, "duration_ms": 1.4755099546164274, "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 planet_int 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 planet_int is not null\n group by planet_int order by count desc, value limit 31", "params": { "p0": "4" } }, { "type": "sql", "start": 524394.186423904, "end": 524394.190101075, "duration_ms": 3.677170956507325, "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": "4" } }, { "type": "sql", "start": 524394.190277604, "end": 524394.190549986, "duration_ms": 0.27238193433731794, "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": "4" } }, { "type": "sql", "start": 524394.19070472, "end": 524394.190944897, "duration_ms": 0.24017703253775835, "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": "4" } }, { "type": "sql", "start": 524394.191116025, "end": 524394.191345371, "duration_ms": 0.229345983825624, "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": "4" } }, { "type": "sql", "start": 524394.191507818, "end": 524394.191739493, "duration_ms": 0.23167510516941547, "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": "4" } }, { "type": "sql", "start": 524394.192152757, "end": 524394.192396747, "duration_ms": 0.24398998357355595, "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": "4" } }, { "type": "sql", "start": 524394.192557065, "end": 524394.192776017, "duration_ms": 0.21895195823162794, "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": "4" } }, { "type": "sql", "start": 524394.19292556, "end": 524394.193133823, "duration_ms": 0.20826293621212244, "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": "4" } }, { "type": "sql", "start": 524394.19327915, "end": 524394.193504374, "duration_ms": 0.2252240665256977, "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": "4" } }, { "type": "sql", "start": 524394.193652473, "end": 524394.193878407, "duration_ms": 0.22593396715819836, "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": "4" } }, { "type": "sql", "start": 524394.19403379, "end": 524394.194250687, "duration_ms": 0.2168969949707389, "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": "4" } }, { "type": "sql", "start": 524394.194405196, "end": 524394.194615518, "duration_ms": 0.21032197400927544, "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": "4" } }, { "type": "sql", "start": 524394.194762312, "end": 524394.194967745, "duration_ms": 0.20543299615383148, "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": "4" } }, { "type": "sql", "start": 524394.1951088, "end": 524394.195317268, "duration_ms": 0.2084680600091815, "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": "4" } }, { "type": "sql", "start": 524394.195474037, "end": 524394.195620286, "duration_ms": 0.1462490763515234, "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": "4" } }, { "type": "sql", "start": 524394.195785346, "end": 524394.196038162, "duration_ms": 0.252816011197865, "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": "4" } }, { "type": "sql", "start": 524394.196476021, "end": 524394.196692743, "duration_ms": 0.216722022742033, "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": "4" } }, { "type": "sql", "start": 524394.19685031, "end": 524394.197092489, "duration_ms": 0.24217902682721615, "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": "4" } }, { "type": "sql", "start": 524394.19751413, "end": 524394.197732261, "duration_ms": 0.2181309973821044, "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": "4" } }, { "type": "sql", "start": 524394.198147366, "end": 524394.198359469, "duration_ms": 0.21210289560258389, "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": "4" } }, { "type": "sql", "start": 524394.198522942, "end": 524394.198778194, "duration_ms": 0.2552520018070936, "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": "4" } }, { "type": "sql", "start": 524394.198925973, "end": 524394.199185739, "duration_ms": 0.259766005910933, "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": "4" } }, { "type": "sql", "start": 524394.199333616, "end": 524394.199746108, "duration_ms": 0.4124920815229416, "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": "4" } }, { "type": "sql", "start": 524394.199899429, "end": 524394.200133019, "duration_ms": 0.23359002079814672, "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": "4" } }, { "type": "sql", "start": 524394.200281994, "end": 524394.200852122, "duration_ms": 0.570128089748323, "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": "4" } }, { "type": "sql", "start": 524394.201858137, "end": 524394.202065437, "duration_ms": 0.20729994866997004, "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": 524394.202330296, "end": 524394.20266155, "duration_ms": 0.33125397749245167, "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": 524394.202987058, "end": 524394.203192594, "duration_ms": 0.20553602371364832, "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": 524394.204123872, "end": 524394.204449522, "duration_ms": 0.3256499767303467, "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": 524394.204666565, "end": 524394.204846091, "duration_ms": 0.1795259304344654, "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": 524394.205163244, "end": 524394.205474497, "duration_ms": 0.3112530102953315, "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 } ] }