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

4 rows

View and edit SQL

pk ▼ name address latitude longitude
1 The Mystery Spot 465 Mystery Spot Road, Santa Cruz, CA 95065 37.0167 -122.0024
2 Winchester Mystery House 525 South Winchester Boulevard, San Jose, CA 95128 37.3184 -121.9511
3 Burlingame Museum of PEZ Memorabilia 214 California Drive, Burlingame, CA 94010 37.5793 -122.3442
4 Bigfoot Discovery Museum 5497 Highway 9, Felton, CA 95018 37.0414 -122.0725

Advanced export

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

CSV options:

CREATE TABLE roadside_attractions (
    pk integer primary key,
    name text,
    address text,
    latitude real,
    longitude real
);
{
  "request_duration_ms": 32.29577001184225,
  "sum_trace_duration_ms": 13.042363862041384,
  "num_traces": 37,
  "traces": [
    {
      "type": "sql",
      "start": 349058.175409383,
      "end": 349058.176036549,
      "duration_ms": 0.6271659513004124,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 147, in view\n    return await self.dispatch_request(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 120, in dispatch_request\n    await self.ds.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 343, in refresh_schemas\n    for row in await internal_db.execute(\n"
      ],
      "database": "_internal",
      "sql": "select database_name, schema_version from databases",
      "params": null
    },
    {
      "type": "sql",
      "start": 349058.176270233,
      "end": 349058.176548009,
      "duration_ms": 0.27777598006650805,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 147, in view\n    return await self.dispatch_request(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 120, in dispatch_request\n    await self.ds.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 348, 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": 349058.176708049,
      "end": 349058.176911506,
      "duration_ms": 0.2034569624811411,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 147, in view\n    return await self.dispatch_request(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 120, in dispatch_request\n    await self.ds.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 348, in refresh_schemas\n    schema_version = (await db.execute(\"PRAGMA schema_version\")).first()[0]\n"
      ],
      "database": "_internal",
      "sql": "PRAGMA schema_version",
      "params": null
    },
    {
      "type": "sql",
      "start": 349058.177035897,
      "end": 349058.177371338,
      "duration_ms": 0.3354410291649401,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 147, in view\n    return await self.dispatch_request(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 120, in dispatch_request\n    await self.ds.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 348, 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": 349058.17753977,
      "end": 349058.177962967,
      "duration_ms": 0.42319699423387647,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 147, in view\n    return await self.dispatch_request(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 120, in dispatch_request\n    await self.ds.refresh_schemas()\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 348, 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": 349058.178287532,
      "end": 349058.178575075,
      "duration_ms": 0.28754299273714423,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 470, in get_canned_queries\n    more_queries = await await_me_maybe(more_queries)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/utils/__init__.py\", line 70, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 143, in inner\n    await datasette.get_database(database).execute(\"select 1 + 1\")\n"
      ],
      "database": "fixtures",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 349058.178839943,
      "end": 349058.179230702,
      "duration_ms": 0.39075897075235844,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 342, in data\n    is_view = bool(await db.get_view_definition(table))\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/database.py\", line 393, in get_view_definition\n    return await self.get_table_definition(view, \"view\")\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/database.py\", line 373, 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": "roadside_attractions",
        "t": "view"
      }
    },
    {
      "type": "sql",
      "start": 349058.179362237,
      "end": 349058.179628053,
      "duration_ms": 0.265815993770957,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 475, in view_get\n    response_or_template_contexts = await self.data(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 343, in data\n    table_exists = bool(await db.table_exists(table))\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/database.py\", line 258, in table_exists\n    results = await self.execute(\n"
      ],
      "database": "fixtures",
      "sql": "select 1 from sqlite_master where type='table' and name=?",
      "params": [
        "roadside_attractions"
      ]
    },
    {
      "type": "sql",
      "start": 349058.179921964,
      "end": 349058.180158417,
      "duration_ms": 0.23645296460017562,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 558, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/utils/__init__.py\", line 70, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 119, in inner\n    assert 2 == (await datasette.get_database().execute(\"select 1 + 1\")).first()[0]\n"
      ],
      "database": "_memory",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 349058.180361347,
      "end": 349058.180621102,
      "duration_ms": 0.2597550046630204,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 558, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/utils/__init__.py\", line 70, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 119, in inner\n    assert 2 == (await datasette.get_database().execute(\"select 1 + 1\")).first()[0]\n"
      ],
      "database": "_memory",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 349058.180935765,
      "end": 349058.181167258,
      "duration_ms": 0.23149303160607815,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 558, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/utils/__init__.py\", line 70, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 119, in inner\n    assert 2 == (await datasette.get_database().execute(\"select 1 + 1\")).first()[0]\n"
      ],
      "database": "_memory",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 349058.181351302,
      "end": 349058.181580004,
      "duration_ms": 0.22870197426527739,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 558, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/utils/__init__.py\", line 70, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 119, in inner\n    assert 2 == (await datasette.get_database().execute(\"select 1 + 1\")).first()[0]\n"
      ],
      "database": "_memory",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 349058.18383354,
      "end": 349058.184139996,
      "duration_ms": 0.3064560005441308,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 260, in get\n    return await self.view_get(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 475, in view_get\n    response_or_template_contexts = await self.data(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 691, in data\n    results = await db.execute(sql, params, truncate=True, **extra_args)\n"
      ],
      "database": "fixtures",
      "sql": "select pk, name, address, latitude, longitude from roadside_attractions order by pk limit 101",
      "params": {}
    },
    {
      "type": "sql",
      "start": 349058.184967006,
      "end": 349058.185266463,
      "duration_ms": 0.29945705318823457,
      "traceback": [
        "  File \"plugins/my_plugin.py\", line 147, in suggest\n    columns = await self.get_columns(self.sql, self.params)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 126, in get_columns\n    await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 587, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select * from (select pk, name, address, latitude, longitude from roadside_attractions order by pk) limit 0",
      "params": []
    },
    {
      "type": "sql",
      "start": 349058.185452626,
      "end": 349058.185876141,
      "duration_ms": 0.42351498268544674,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 148, in suggest\n    columns = await self.get_columns(self.sql, self.params)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 126, in get_columns\n    await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 587, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select * from (select pk, name, address, latitude, longitude from roadside_attractions order by pk) limit 0",
      "params": []
    },
    {
      "type": "sql",
      "start": 349058.186075298,
      "end": 349058.186391305,
      "duration_ms": 0.3160070045851171,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 842, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 166, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 587, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select pk, count(*) as n from (\n                    select pk, name, address, latitude, longitude from roadside_attractions order by pk\n                ) where pk is not null\n                group by pk\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 349058.186551441,
      "end": 349058.186923996,
      "duration_ms": 0.3725550486706197,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 842, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 166, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 587, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select name, count(*) as n from (\n                    select pk, name, address, latitude, longitude from roadside_attractions order by pk\n                ) where name is not null\n                group by name\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 349058.187085242,
      "end": 349058.187418131,
      "duration_ms": 0.33288897247985005,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 842, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 166, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 587, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select address, count(*) as n from (\n                    select pk, name, address, latitude, longitude from roadside_attractions order by pk\n                ) where address is not null\n                group by address\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 349058.187555164,
      "end": 349058.188041688,
      "duration_ms": 0.48652401892468333,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 842, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 166, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 587, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select latitude, count(*) as n from (\n                    select pk, name, address, latitude, longitude from roadside_attractions order by pk\n                ) where latitude is not null\n                group by latitude\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 349058.188345801,
      "end": 349058.188815779,
      "duration_ms": 0.469977967441082,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 842, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 166, in suggest\n    distinct_values = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 587, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select longitude, count(*) as n from (\n                    select pk, name, address, latitude, longitude from roadside_attractions order by pk\n                ) where longitude is not null\n                group by longitude\n                limit 31",
      "params": []
    },
    {
      "type": "sql",
      "start": 349058.188977372,
      "end": 349058.189352286,
      "duration_ms": 0.3749139723367989,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 417, in suggest\n    columns = await self.get_columns(self.sql, self.params)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 126, in get_columns\n    await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 587, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select * from (select pk, name, address, latitude, longitude from roadside_attractions order by pk) limit 0",
      "params": []
    },
    {
      "type": "sql",
      "start": 349058.189531272,
      "end": 349058.189815362,
      "duration_ms": 0.2840899978764355,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 842, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 432, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 587, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select date(pk) from (\n                    select pk, name, address, latitude, longitude from roadside_attractions order by pk\n                ) where pk glob \"????-??-*\" limit 100;",
      "params": []
    },
    {
      "type": "sql",
      "start": 349058.189963091,
      "end": 349058.190464534,
      "duration_ms": 0.5014429916627705,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 842, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 432, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 587, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select date(name) from (\n                    select pk, name, address, latitude, longitude from roadside_attractions order by pk\n                ) where name glob \"????-??-*\" limit 100;",
      "params": []
    },
    {
      "type": "sql",
      "start": 349058.190647148,
      "end": 349058.191031957,
      "duration_ms": 0.3848089836537838,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 842, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 432, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 587, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select date(address) from (\n                    select pk, name, address, latitude, longitude from roadside_attractions order by pk\n                ) where address glob \"????-??-*\" limit 100;",
      "params": []
    },
    {
      "type": "sql",
      "start": 349058.191186192,
      "end": 349058.191510192,
      "duration_ms": 0.32400002237409353,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 842, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 432, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 587, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select date(latitude) from (\n                    select pk, name, address, latitude, longitude from roadside_attractions order by pk\n                ) where latitude glob \"????-??-*\" limit 100;",
      "params": []
    },
    {
      "type": "sql",
      "start": 349058.191668262,
      "end": 349058.192059494,
      "duration_ms": 0.3912319662049413,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 842, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 432, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 587, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select date(longitude) from (\n                    select pk, name, address, latitude, longitude from roadside_attractions order by pk\n                ) where longitude glob \"????-??-*\" limit 100;",
      "params": []
    },
    {
      "type": "sql",
      "start": 349058.192259531,
      "end": 349058.192948837,
      "duration_ms": 0.6893060053698719,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 282, in suggest\n    columns = await self.get_columns(self.sql, self.params)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 126, in get_columns\n    await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 587, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select * from (select pk, name, address, latitude, longitude from roadside_attractions order by pk) limit 0",
      "params": []
    },
    {
      "type": "sql",
      "start": 349058.193169362,
      "end": 349058.193493682,
      "duration_ms": 0.32431998988613486,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 842, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 297, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 587, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select distinct json_type(pk)\n                from (select pk, name, address, latitude, longitude from roadside_attractions order by pk)\n                where pk is not null and pk != ''",
      "params": []
    },
    {
      "type": "sql",
      "start": 349058.194438723,
      "end": 349058.194793926,
      "duration_ms": 0.3552030539140105,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 842, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 297, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 587, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select distinct json_type(latitude)\n                from (select pk, name, address, latitude, longitude from roadside_attractions order by pk)\n                where latitude is not null and latitude != ''",
      "params": []
    },
    {
      "type": "sql",
      "start": 349058.194966136,
      "end": 349058.195317146,
      "duration_ms": 0.351010006852448,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 842, in data\n    suggested_facets.extend(await facet.suggest())\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/facets.py\", line 297, in suggest\n    results = await self.ds.execute(\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 587, in execute\n    return await self.databases[db_name].execute(\n"
      ],
      "database": "fixtures",
      "sql": "select distinct json_type(longitude)\n                from (select pk, name, address, latitude, longitude from roadside_attractions order by pk)\n                where longitude is not null and longitude != ''",
      "params": []
    },
    {
      "type": "sql",
      "start": 349058.195555478,
      "end": 349058.195851355,
      "duration_ms": 0.29587699100375175,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 558, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/utils/__init__.py\", line 70, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 119, in inner\n    assert 2 == (await datasette.get_database().execute(\"select 1 + 1\")).first()[0]\n"
      ],
      "database": "_memory",
      "sql": "select 1 + 1",
      "params": null
    },
    {
      "type": "sql",
      "start": 349058.198065406,
      "end": 349058.198498627,
      "duration_ms": 0.4332209937274456,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 935, in extra_template\n    \"view_definition\": await db.get_view_definition(table),\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/database.py\", line 393, in get_view_definition\n    return await self.get_table_definition(view, \"view\")\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/database.py\", line 373, 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": "roadside_attractions",
        "t": "view"
      }
    },
    {
      "type": "sql",
      "start": 349058.198647689,
      "end": 349058.198876043,
      "duration_ms": 0.22835400886833668,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 570, in view_get\n    extras = await extras\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 936, in extra_template\n    \"table_definition\": await db.get_table_definition(table),\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/database.py\", line 373, 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": "roadside_attractions",
        "t": "table"
      }
    },
    {
      "type": "sql",
      "start": 349058.199139936,
      "end": 349058.199485791,
      "duration_ms": 0.3458549617789686,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/base.py\", line 570, in view_get\n    extras = await extras\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/views/table.py\", line 936, in extra_template\n    \"table_definition\": await db.get_table_definition(table),\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/database.py\", line 383, 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": "roadside_attractions"
      }
    },
    {
      "type": "sql",
      "start": 349058.200331706,
      "end": 349058.200662365,
      "duration_ms": 0.3306590369902551,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 807, in render_template\n    extra_script = await await_me_maybe(extra_script)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/utils/__init__.py\", line 70, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin.py\", line 87, in inner\n    await datasette.get_database().execute(\"select 3 * 5\")\n"
      ],
      "database": "_memory",
      "sql": "select 3 * 5",
      "params": null
    },
    {
      "type": "sql",
      "start": 349058.201328475,
      "end": 349058.201550496,
      "duration_ms": 0.2220209571532905,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 891, in _asset_urls\n    hook = await await_me_maybe(hook)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/utils/__init__.py\", line 70, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin.py\", line 44, in inner\n    await datasette.get_database().execute(\"select 3 * 5\")\n"
      ],
      "database": "_memory",
      "sql": "select 3 * 5",
      "params": null
    },
    {
      "type": "sql",
      "start": 349058.202547644,
      "end": 349058.202978755,
      "duration_ms": 0.4311110242269933,
      "traceback": [
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/app.py\", line 558, in permission_allowed\n    check = await await_me_maybe(check)\n",
        "  File \"/usr/local/lib/python3.8/site-packages/datasette/utils/__init__.py\", line 70, in await_me_maybe\n    value = await value\n",
        "  File \"plugins/my_plugin_2.py\", line 119, in inner\n    assert 2 == (await datasette.get_database().execute(\"select 1 + 1\")).first()[0]\n"
      ],
      "database": "_memory",
      "sql": "select 1 + 1",
      "params": null
    }
  ]
}