{
"request_duration_ms": 40.991285000927746,
"sum_trace_duration_ms": 22.728415962774307,
"num_traces": 38,
"traces": [
{
"type": "sql",
"start": 303479.405032378,
"end": 303479.405623177,
"duration_ms": 0.5907990271225572,
"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": 303479.405828282,
"end": 303479.406135039,
"duration_ms": 0.30675699235871434,
"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": 303479.406305251,
"end": 303479.40654744,
"duration_ms": 0.24218898033723235,
"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": 303479.406684707,
"end": 303479.406961852,
"duration_ms": 0.27714500902220607,
"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": 303479.407136411,
"end": 303479.407322107,
"duration_ms": 0.18569600069895387,
"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": 303479.407462957,
"end": 303479.407636663,
"duration_ms": 0.17370597925037146,
"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": 303479.407765501,
"end": 303479.407941597,
"duration_ms": 0.17609598580747843,
"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": 303479.408133989,
"end": 303479.408360594,
"duration_ms": 0.2266049850732088,
"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": 303479.408630062,
"end": 303479.408829749,
"duration_ms": 0.19968696869909763,
"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": 303479.409110399,
"end": 303479.409300845,
"duration_ms": 0.19044597866013646,
"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": 303479.409578092,
"end": 303479.410137805,
"duration_ms": 0.5597129929810762,
"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": 303479.410394609,
"end": 303479.41060339,
"duration_ms": 0.2087810426019132,
"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": 303479.410796948,
"end": 303479.411053362,
"duration_ms": 0.25641400134190917,
"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": 303479.411269658,
"end": 303479.411519421,
"duration_ms": 0.24976296117529273,
"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": 303479.413536515,
"end": 303479.413856895,
"duration_ms": 0.32037997152656317,
"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 pk desc limit 101",
"params": {
"search": "bar*"
}
},
{
"type": "sql",
"start": 303479.415814697,
"end": 303479.417368378,
"duration_ms": 1.5536810387857258,
"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": 303479.415866931,
"end": 303479.417784675,
"duration_ms": 1.917743997182697,
"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": 303479.415965696,
"end": 303479.418035924,
"duration_ms": 2.0702280453406274,
"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": 303479.41826726,
"end": 303479.421533898,
"duration_ms": 3.266637970227748,
"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": 303479.421227599,
"end": 303479.42331639,
"duration_ms": 2.0887909922748804,
"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": 303479.423552842,
"end": 303479.423878445,
"duration_ms": 0.3256030031479895,
"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": 303479.424152674,
"end": 303479.424594575,
"duration_ms": 0.4419010365381837,
"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": 303479.424773643,
"end": 303479.425198236,
"duration_ms": 0.42459298856556416,
"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": 303479.425369798,
"end": 303479.425737324,
"duration_ms": 0.36752602318301797,
"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": 303479.425914292,
"end": 303479.426296628,
"duration_ms": 0.38233603117987514,
"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": 303479.426461273,
"end": 303479.426786088,
"duration_ms": 0.324814987834543,
"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": 303479.426996684,
"end": 303479.427826254,
"duration_ms": 0.8295699954032898,
"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": 303479.42808754,
"end": 303479.428493844,
"duration_ms": 0.40630396688356996,
"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": 303479.429490919,
"end": 303479.429853791,
"duration_ms": 0.3628720296546817,
"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": 303479.43008193,
"end": 303479.430437415,
"duration_ms": 0.35548501182347536,
"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": 303479.430770512,
"end": 303479.431430204,
"duration_ms": 0.6596920429728925,
"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": 303479.431683577,
"end": 303479.432241051,
"duration_ms": 0.5574739770963788,
"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": 303479.434675502,
"end": 303479.434881611,
"duration_ms": 0.2061090199276805,
"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": 303479.4351818,
"end": 303479.435420456,
"duration_ms": 0.23865600815042853,
"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": 303479.435761252,
"end": 303479.435968125,
"duration_ms": 0.20687299547716975,
"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": 303479.437858209,
"end": 303479.438351681,
"duration_ms": 0.49347197636961937,
"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": 303479.439719068,
"end": 303479.440408533,
"duration_ms": 0.6894649704918265,
"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": 303479.441076597,
"end": 303479.441471008,
"duration_ms": 0.3944109776057303,
"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
}
]
}