{
"request_duration_ms": 32.014112977776676,
"sum_trace_duration_ms": 17.098234849981964,
"num_traces": 38,
"traces": [
{
"type": "sql",
"start": 301371.452924343,
"end": 301371.453378902,
"duration_ms": 0.45455899089574814,
"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": 301371.45362093,
"end": 301371.453985568,
"duration_ms": 0.36463799187913537,
"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": 301371.454221518,
"end": 301371.45450481,
"duration_ms": 0.2832919708453119,
"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": 301371.454855637,
"end": 301371.455920226,
"duration_ms": 1.0645890142768621,
"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": 301371.456082568,
"end": 301371.456425467,
"duration_ms": 0.34289900213479996,
"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": 301371.457447572,
"end": 301371.457692573,
"duration_ms": 0.24500105064362288,
"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": 301371.457834677,
"end": 301371.458070975,
"duration_ms": 0.23629795759916306,
"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": 301371.458388542,
"end": 301371.45866523,
"duration_ms": 0.27668802067637444,
"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": 301371.45887817,
"end": 301371.459095527,
"duration_ms": 0.21735701011493802,
"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": 301371.459346842,
"end": 301371.459632195,
"duration_ms": 0.28535298770293593,
"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": 301371.459887294,
"end": 301371.460112631,
"duration_ms": 0.22533698938786983,
"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": 301371.460335191,
"end": 301371.460587278,
"duration_ms": 0.25208701845258474,
"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": 301371.460776053,
"end": 301371.461004401,
"duration_ms": 0.22834795527160168,
"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": 301371.461198631,
"end": 301371.461393102,
"duration_ms": 0.19447103841230273,
"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": 301371.463184762,
"end": 301371.463545564,
"duration_ms": 0.36080199060961604,
"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 text2 limit 101",
"params": {
"search": "bar*"
}
},
{
"type": "sql",
"start": 301371.465386773,
"end": 301371.46628848,
"duration_ms": 0.9017069824039936,
"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": 301371.465441637,
"end": 301371.466517636,
"duration_ms": 1.0759990545921028,
"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": 301371.465536285,
"end": 301371.466646903,
"duration_ms": 1.1106180027127266,
"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": 301371.466763998,
"end": 301371.468096884,
"duration_ms": 1.3328860513865948,
"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": 301371.467547201,
"end": 301371.4682691,
"duration_ms": 0.7218989776447415,
"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": 301371.468446112,
"end": 301371.468900539,
"duration_ms": 0.4544269759207964,
"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": 301371.469117583,
"end": 301371.469640347,
"duration_ms": 0.5227639921940863,
"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": 301371.469815739,
"end": 301371.470138482,
"duration_ms": 0.3227429697290063,
"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": 301371.470290404,
"end": 301371.470567637,
"duration_ms": 0.27723301900550723,
"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": 301371.470715853,
"end": 301371.470983742,
"duration_ms": 0.2678890014067292,
"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": 301371.471126458,
"end": 301371.471337069,
"duration_ms": 0.2106109750457108,
"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": 301371.471517907,
"end": 301371.47178533,
"duration_ms": 0.267422990873456,
"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": 301371.471943144,
"end": 301371.472203899,
"duration_ms": 0.26075501227751374,
"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": 301371.472366513,
"end": 301371.472616586,
"duration_ms": 0.25007303338497877,
"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": 301371.472764505,
"end": 301371.473017993,
"duration_ms": 0.2534879604354501,
"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": 301371.473163166,
"end": 301371.473311629,
"duration_ms": 0.14846294652670622,
"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": 301371.473478579,
"end": 301371.47375267,
"duration_ms": 0.27409096946939826,
"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": 301371.475437263,
"end": 301371.475627882,
"duration_ms": 0.1906189718283713,
"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": 301371.475887224,
"end": 301371.476039147,
"duration_ms": 0.15192298451438546,
"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": 301371.476321428,
"end": 301371.476483007,
"duration_ms": 0.16157899517565966,
"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": 301371.477313376,
"end": 301371.478351715,
"duration_ms": 1.0383390472270548,
"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": 301371.478654736,
"end": 301371.480161555,
"duration_ms": 1.5068189823068678,
"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": 301371.480661405,
"end": 301371.481025573,
"duration_ms": 0.3641679650172591,
"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
}
]
}