{
"request_duration_ms": 34.776640008203685,
"sum_trace_duration_ms": 20.574093679897487,
"num_traces": 38,
"traces": [
{
"type": "sql",
"start": 298545.728875523,
"end": 298545.729324197,
"duration_ms": 0.44867396354675293,
"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": 298545.72954808,
"end": 298545.729832414,
"duration_ms": 0.2843340043909848,
"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": 298545.730043395,
"end": 298545.730267827,
"duration_ms": 0.22443197667598724,
"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": 298545.730416097,
"end": 298545.730596386,
"duration_ms": 0.18028903286904097,
"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": 298545.730723449,
"end": 298545.731031839,
"duration_ms": 0.30838995007798076,
"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": 298545.731205587,
"end": 298545.731444469,
"duration_ms": 0.23888202849775553,
"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": 298545.731624202,
"end": 298545.731797188,
"duration_ms": 0.17298600869253278,
"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": 298545.731995527,
"end": 298545.73223059,
"duration_ms": 0.23506302386522293,
"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": [
"searchable"
]
},
{
"type": "sql",
"start": 298545.732453528,
"end": 298545.732616441,
"duration_ms": 0.1629129983484745,
"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": 298545.732826583,
"end": 298545.733538256,
"duration_ms": 0.7116730557754636,
"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": 298545.733906382,
"end": 298545.734281195,
"duration_ms": 0.37481298204511404,
"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": 298545.734582945,
"end": 298545.734924757,
"duration_ms": 0.34181197406724095,
"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": 298545.735159651,
"end": 298545.735426534,
"duration_ms": 0.26688299840316176,
"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": 298545.735615984,
"end": 298545.735791762,
"duration_ms": 0.17577799735590816,
"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": 298545.737889481,
"end": 298545.738257946,
"duration_ms": 0.3684649709612131,
"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, text1, text2, [name with . and spaces] from searchable where rowid in (select rowid from searchable_fts where searchable_fts match escape_fts(:search)) order by [name with . and spaces] limit 101",
"params": {
"search": "bar*"
}
},
{
"type": "sql",
"start": 298545.740149429,
"end": 298545.740920287,
"duration_ms": 0.7708579651080072,
"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": "searchable",
"t": "view"
}
},
{
"type": "sql",
"start": 298545.74024239,
"end": 298545.742064052,
"duration_ms": 1.8216620082966983,
"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": "searchable",
"t": "table"
}
},
{
"type": "sql",
"start": 298545.74009815,
"end": 298545.742669246,
"duration_ms": 2.571096003521234,
"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 searchable where rowid in (select rowid from searchable_fts where searchable_fts match escape_fts(:search))",
"params": {
"search": "bar*"
}
},
{
"type": "sql",
"start": 298545.742621776,
"end": 298545.744534898,
"duration_ms": 1.9131220178678632,
"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": "searchable"
}
},
{
"type": "sql",
"start": 298545.743588729,
"end": 298545.744710635,
"duration_ms": 1.1219059815630317,
"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, text1, text2, [name with . and spaces] from searchable where rowid in (select rowid from searchable_fts where searchable_fts match escape_fts(:search)) ) limit 0",
"params": {
"search": "bar*"
}
},
{
"type": "sql",
"start": 298545.744889507,
"end": 298545.745657817,
"duration_ms": 0.7683099829591811,
"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, text1, text2, [name with . and spaces] from searchable where rowid in (select rowid from searchable_fts where searchable_fts match escape_fts(:search)) ) limit 0",
"params": {
"search": "bar*"
}
},
{
"type": "sql",
"start": 298545.745908659,
"end": 298545.74763228,
"duration_ms": 1.723620982374996,
"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, text1, text2, [name with . and spaces] from searchable where rowid in (select rowid from searchable_fts where searchable_fts match escape_fts(:search)) \n ) where value is not null\n group by value\n limit 31",
"params": {
"search": "bar*"
}
},
{
"type": "sql",
"start": 298545.747926057,
"end": 298545.74840599,
"duration_ms": 0.4799329908564687,
"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 text1 as value, count(*) as n from (\n select pk, text1, text2, [name with . and spaces] from searchable where rowid in (select rowid from searchable_fts where searchable_fts match escape_fts(:search)) \n ) where value is not null\n group by value\n limit 31",
"params": {
"search": "bar*"
}
},
{
"type": "sql",
"start": 298545.748627418,
"end": 298545.749213737,
"duration_ms": 0.5863190162926912,
"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 text2 as value, count(*) as n from (\n select pk, text1, text2, [name with . and spaces] from searchable where rowid in (select rowid from searchable_fts where searchable_fts match escape_fts(:search)) \n ) where value is not null\n group by value\n limit 31",
"params": {
"search": "bar*"
}
},
{
"type": "sql",
"start": 298545.749398262,
"end": 298545.749759353,
"duration_ms": 0.3610909916460514,
"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 [name with . and spaces] as value, count(*) as n from (\n select pk, text1, text2, [name with . and spaces] from searchable where rowid in (select rowid from searchable_fts where searchable_fts match escape_fts(:search)) \n ) where value is not null\n group by value\n limit 31",
"params": {
"search": "bar*"
}
},
{
"type": "sql",
"start": 298545.74999608,
"end": 298545.750202622,
"duration_ms": 0.20654196850955486,
"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, text1, text2, [name with . and spaces] from searchable where rowid in (select rowid from searchable_fts where searchable_fts match escape_fts(:search)) ) limit 0",
"params": {
"search": "bar*"
}
},
{
"type": "sql",
"start": 298545.75037507,
"end": 298545.75069154,
"duration_ms": 0.3164699883200228,
"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, text1, text2, [name with . and spaces] from searchable where rowid in (select rowid from searchable_fts where searchable_fts match escape_fts(:search)) \n ) where pk glob \"????-??-*\" limit 100;",
"params": {
"search": "bar*"
}
},
{
"type": "sql",
"start": 298545.750884347,
"end": 298545.751226515,
"duration_ms": 0.3421679721213877,
"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(text1) from (\n select pk, text1, text2, [name with . and spaces] from searchable where rowid in (select rowid from searchable_fts where searchable_fts match escape_fts(:search)) \n ) where text1 glob \"????-??-*\" limit 100;",
"params": {
"search": "bar*"
}
},
{
"type": "sql",
"start": 298545.751383088,
"end": 298545.751705885,
"duration_ms": 0.322796986438334,
"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(text2) from (\n select pk, text1, text2, [name with . and spaces] from searchable where rowid in (select rowid from searchable_fts where searchable_fts match escape_fts(:search)) \n ) where text2 glob \"????-??-*\" limit 100;",
"params": {
"search": "bar*"
}
},
{
"type": "sql",
"start": 298545.751881194,
"end": 298545.752225956,
"duration_ms": 0.3447619965299964,
"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([name with . and spaces]) from (\n select pk, text1, text2, [name with . and spaces] from searchable where rowid in (select rowid from searchable_fts where searchable_fts match escape_fts(:search)) \n ) where [name with . and spaces] glob \"????-??-*\" limit 100;",
"params": {
"search": "bar*"
}
},
{
"type": "sql",
"start": 298545.752375786,
"end": 298545.752659356,
"duration_ms": 0.2835699706338346,
"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, text1, text2, [name with . and spaces] from searchable where rowid in (select rowid from searchable_fts where searchable_fts match escape_fts(:search)) ) limit 0",
"params": {
"search": "bar*"
}
},
{
"type": "sql",
"start": 298545.752854378,
"end": 298545.753604242,
"duration_ms": 0.7498639752157032,
"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, text1, text2, [name with . and spaces] from searchable where rowid in (select rowid from searchable_fts where searchable_fts match escape_fts(:search)) )\n where pk is not null and pk != ''",
"params": {
"search": "bar*"
}
},
{
"type": "sql",
"start": 298545.756157123,
"end": 298545.756416988,
"duration_ms": 0.2598649589344859,
"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": 298545.756699863,
"end": 298545.756922934,
"duration_ms": 0.22307096514850855,
"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": 298545.757257808,
"end": 298545.757436298,
"duration_ms": 0.17849000869318843,
"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": 298545.758286971,
"end": 298545.758486545,
"duration_ms": 0.1995739876292646,
"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": 298545.758695161,
"end": 298545.758860862,
"duration_ms": 0.16570097068324685,
"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": 298545.759184482,
"end": 298545.759552397,
"duration_ms": 0.36791502498090267,
"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
}
]
}