{
    "databases": [
        {
            "name": "fixtures",
            "hash": "104f0dc09ddfbddada65416ab81997c17a8ce6d58cf83f4707603d89e4c27825",
            "color": "104f0d",
            "path": "/fixtures",
            "tables_and_views_truncated": [
                {
                    "name": "compound_three_primary_keys",
                    "columns": [
                        "pk1",
                        "pk2",
                        "pk3",
                        "content"
                    ],
                    "primary_keys": [
                        "pk1",
                        "pk2",
                        "pk3"
                    ],
                    "count": 1001,
                    "hidden": false,
                    "fts_table": null,
                    "num_relationships_for_sorting": 0,
                    "private": false
                },
                {
                    "name": "sortable",
                    "columns": [
                        "pk1",
                        "pk2",
                        "content",
                        "sortable",
                        "sortable_with_nulls",
                        "sortable_with_nulls_2",
                        "text"
                    ],
                    "primary_keys": [
                        "pk1",
                        "pk2"
                    ],
                    "count": 201,
                    "hidden": false,
                    "fts_table": null,
                    "num_relationships_for_sorting": 0,
                    "private": false
                },
                {
                    "name": "facetable",
                    "columns": [
                        "pk",
                        "created",
                        "planet_int",
                        "on_earth",
                        "state",
                        "city_id",
                        "neighborhood",
                        "tags",
                        "complex_array",
                        "distinct_some_null"
                    ],
                    "primary_keys": [
                        "pk"
                    ],
                    "count": 15,
                    "hidden": false,
                    "fts_table": null,
                    "num_relationships_for_sorting": 0,
                    "private": false
                },
                {
                    "name": "roadside_attraction_characteristics",
                    "columns": [
                        "attraction_id",
                        "characteristic_id"
                    ],
                    "primary_keys": [],
                    "count": 5,
                    "hidden": false,
                    "fts_table": null,
                    "num_relationships_for_sorting": 0,
                    "private": false
                },
                {
                    "name": "simple_primary_key",
                    "columns": [
                        "id",
                        "content"
                    ],
                    "primary_keys": [
                        "id"
                    ],
                    "count": 4,
                    "hidden": false,
                    "fts_table": null,
                    "num_relationships_for_sorting": 0,
                    "private": false
                }
            ],
            "tables_and_views_more": true,
            "tables_count": 24,
            "table_rows_sum": 1260,
            "show_table_row_counts": true,
            "hidden_table_rows_sum": 207,
            "hidden_tables_count": 6,
            "views_count": 4,
            "private": false
        }
    ],
    "metadata": {
        "title": "Datasette Fixtures",
        "description_html": "An example SQLite database demonstrating Datasette. <a href=\"/login-as-root\">Sign in as root user</a>",
        "license": "Apache License 2.0",
        "license_url": "https://github.com/simonw/datasette/blob/master/LICENSE",
        "source": "tests/fixtures.py",
        "source_url": "https://github.com/simonw/datasette/blob/master/tests/fixtures.py",
        "about": "About Datasette",
        "about_url": "https://github.com/simonw/datasette",
        "extra_css_urls": [
            "/static/extra-css-urls.css"
        ],
        "plugins": {
            "name-of-plugin": {
                "depth": "root"
            },
            "env-plugin": {
                "foo": {
                    "$env": "FOO_ENV"
                }
            },
            "env-plugin-list": [
                {
                    "in_a_list": {
                        "$env": "FOO_ENV"
                    }
                }
            ],
            "file-plugin": {
                "foo": {
                    "$file": "/tmp/plugin-secret"
                }
            }
        },
        "databases": {
            "fixtures": {
                "description": "Test tables description",
                "plugins": {
                    "name-of-plugin": {
                        "depth": "database"
                    }
                },
                "tables": {
                    "simple_primary_key": {
                        "description_html": "Simple <em>primary</em> key",
                        "title": "This <em>HTML</em> is escaped",
                        "plugins": {
                            "name-of-plugin": {
                                "depth": "table",
                                "special": "this-is-simple_primary_key"
                            }
                        }
                    },
                    "sortable": {
                        "sortable_columns": [
                            "sortable",
                            "sortable_with_nulls",
                            "sortable_with_nulls_2",
                            "text"
                        ],
                        "plugins": {
                            "name-of-plugin": {
                                "depth": "table"
                            }
                        },
                        "source": "tests/fixtures.py",
                        "source_url": "https://github.com/simonw/datasette/blob/master/tests/fixtures.py",
                        "license": "Apache License 2.0",
                        "license_url": "https://github.com/simonw/datasette/blob/master/LICENSE",
                        "about": "About Datasette",
                        "about_url": "https://github.com/simonw/datasette"
                    },
                    "no_primary_key": {
                        "sortable_columns": [],
                        "hidden": true
                    },
                    "units": {
                        "units": {
                            "distance": "m",
                            "frequency": "Hz"
                        }
                    },
                    "primary_key_multiple_columns_explicit_label": {
                        "label_column": "content2"
                    },
                    "simple_view": {
                        "sortable_columns": [
                            "content"
                        ]
                    },
                    "searchable_view_configured_by_metadata": {
                        "fts_table": "searchable_fts",
                        "fts_pk": "pk"
                    },
                    "attraction_characteristic": {
                        "sort_desc": "pk"
                    },
                    "facet_cities": {
                        "sort": "name"
                    },
                    "paginated_view": {
                        "size": 25
                    }
                },
                "queries": {
                    "\ud835\udc1c\ud835\udc22\ud835\udc2d\ud835\udc22\ud835\udc1e\ud835\udc2c": {
                        "sql": "select id, name from facet_cities order by id limit 1;",
                        "name": "\ud835\udc1c\ud835\udc22\ud835\udc2d\ud835\udc22\ud835\udc1e\ud835\udc2c"
                    },
                    "pragma_cache_size": {
                        "sql": "PRAGMA cache_size;",
                        "name": "pragma_cache_size"
                    },
                    "magic_parameters": {
                        "sql": "select :_header_user_agent as user_agent, :_now_datetime_utc as datetime",
                        "name": "magic_parameters"
                    },
                    "neighborhood_search": {
                        "sql": "\nselect neighborhood, facet_cities.name, state\nfrom facetable\n    join facet_cities\n        on facetable.city_id = facet_cities.id\nwhere neighborhood like '%' || :text || '%'\norder by neighborhood;\n",
                        "title": "Search neighborhoods",
                        "description_html": "<b>Demonstrating</b> simple like search",
                        "fragment": "fragment-goes-here",
                        "name": "neighborhood_search"
                    },
                    "from_async_hook": {
                        "sql": "select 2",
                        "name": "from_async_hook"
                    },
                    "from_hook": {
                        "sql": "select 1, 'null' as actor_id",
                        "name": "from_hook"
                    }
                },
                "source": "tests/fixtures.py",
                "source_url": "https://github.com/simonw/datasette/blob/master/tests/fixtures.py",
                "license": "Apache License 2.0",
                "license_url": "https://github.com/simonw/datasette/blob/master/LICENSE",
                "about": "About Datasette",
                "about_url": "https://github.com/simonw/datasette"
            }
        }
    },
    "datasette_version": "0.51.1",
    "private": false,
    "database_color": "<bound method BaseView.database_color of <datasette.views.index.IndexView object at 0x3e675e589a00>>",
    "select_templates": [
        "*index.html"
    ],
    "urls": "<datasette.url_builder.Urls object at 0x3e675ee54dc0>",
    "actor": null,
    "menu_links": "<function Datasette.render_template.<locals>.menu_links at 0x3e675ee22280>",
    "display_actor": "<function display_actor at 0x3e675f418670>",
    "show_logout": false,
    "app_css_hash": "f0a5c2",
    "zip": "<class 'zip'>",
    "body_scripts": [
        "var extra_body_script = {\"template\": \"index.html\", \"database\": null, \"table\": null, \"config\": {\"depth\": \"root\"}, \"view_name\": \"index\", \"request_path\": \"/\", \"added\": 15, \"columns\": null};"
    ],
    "format_bytes": "<function format_bytes at 0x3e675f417af0>",
    "show_messages": "<function Datasette.render_template.<locals>.<lambda> at 0x3e675ee22b80>",
    "extra_css_urls": [
        {
            "url": "https://plugin-example.datasette.io/eyJ0ZW1wbGF0ZSI6ICJpbmRleC5odG1sIiwgImRhdGFiYXNlIjogbnVsbCwgInRhYmxlIjogbnVsbCwgInZpZXdfbmFtZSI6ICJpbmRleCIsICJyZXF1ZXN0X3BhdGgiOiAiLyIsICJhZGRlZCI6IDE1LCAiY29sdW1ucyI6IG51bGx9/extra-css-urls-demo.css"
        },
        {
            "url": "/static/extra-css-urls.css"
        }
    ],
    "extra_js_urls": [
        {
            "url": "https://plugin-example.datasette.io/jquery.js",
            "sri": "SRIHASH"
        },
        {
            "url": "https://plugin-example.datasette.io/plugin2.js"
        },
        {
            "url": "https://plugin-example.datasette.io/plugin1.js"
        }
    ],
    "base_url": "/",
    "csrftoken": "<function asgi_csrf_decorator.<locals>._asgi_csrf_decorator.<locals>.app_wrapped_with_csrf.<locals>.get_csrftoken at 0x3e675e4973a0>",
    "view_name": "index",
    "request": "<datasette.utils.asgi.Request object at 0x3e675ee525b0>",
    "extra_template_vars_from_awaitable": "{\"template\": \"index.html\", \"scope_path\": \"/\", \"awaitable\": true}",
    "query_database": "<function extra_template_vars.<locals>.query_database at 0x3e675e497280>",
    "extra_template_vars": "{\"template\": \"index.html\", \"scope_path\": \"/\", \"columns\": null}"
}