{
    "databases": [
        {
            "name": "fixtures",
            "hash": "31a82994e337859d1c00f138628edbdd44ad4fb26b7d79b4a1dbab6b810006a2",
            "color": "31a829",
            "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
                },
                {
                    "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
                },
                {
                    "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
                },
                {
                    "name": "roadside_attraction_characteristics",
                    "columns": [
                        "attraction_id",
                        "characteristic_id"
                    ],
                    "primary_keys": [],
                    "count": 5,
                    "hidden": false,
                    "fts_table": null,
                    "num_relationships_for_sorting": 0
                },
                {
                    "name": "simple_primary_key",
                    "columns": [
                        "id",
                        "content"
                    ],
                    "primary_keys": [
                        "id"
                    ],
                    "count": 4,
                    "hidden": false,
                    "fts_table": null,
                    "num_relationships_for_sorting": 0
                }
            ],
            "tables_and_views_more": true,
            "tables_count": 24,
            "table_rows_sum": 1258,
            "show_table_row_counts": true,
            "hidden_table_rows_sum": 206,
            "hidden_tables_count": 5,
            "views_count": 4
        }
    ],
    "metadata": {
        "title": "Datasette Fixtures",
        "description": "An example SQLite database demonstrating Datasette",
        "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",
        "plugins": {
            "name-of-plugin": {
                "depth": "root"
            },
            "env-plugin": {
                "foo": {
                    "$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"
                            }
                        },
                        "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"
                    },
                    "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,
                        "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"
                    },
                    "units": {
                        "units": {
                            "distance": "m",
                            "frequency": "Hz"
                        },
                        "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"
                    },
                    "primary_key_multiple_columns_explicit_label": {
                        "label_column": "content2",
                        "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"
                    },
                    "simple_view": {
                        "sortable_columns": [
                            "content"
                        ],
                        "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"
                    },
                    "searchable_view_configured_by_metadata": {
                        "fts_table": "searchable_fts",
                        "fts_pk": "pk",
                        "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"
                    }
                },
                "queries": {
                    "\ud835\udc1c\ud835\udc22\ud835\udc2d\ud835\udc22\ud835\udc1e\ud835\udc2c": "select id, name from facet_cities order by id limit 1;",
                    "pragma_cache_size": "PRAGMA cache_size;",
                    "neighborhood_search": {
                        "sql": "\n                        select neighborhood, facet_cities.name, state\n                        from facetable\n                            join facet_cities\n                                on facetable.city_id = facet_cities.id\n                        where neighborhood like '%' || :text || '%'\n                        order by neighborhood;\n                    ",
                        "title": "Search neighborhoods",
                        "description_html": "<b>Demonstrating</b> simple like search",
                        "name": "neighborhood_search"
                    }
                },
                "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+unknown",
    "app_css_hash": "ffa51a",
    "select_templates": [
        "*index.html"
    ],
    "zip": "<class 'zip'>",
    "body_scripts": [],
    "extra_css_urls": "<generator object BaseView._asset_urls at 0x7fcc1d2a92e0>",
    "extra_js_urls": "<generator object BaseView._asset_urls at 0x7fcc1d2a9040>",
    "format_bytes": "<function format_bytes at 0x7fcc1d7ae5e0>",
    "database_url": "<bound method BaseView.database_url of <datasette.views.index.IndexView object at 0x7fcc1d422310>>",
    "database_color": "<bound method BaseView.database_color of <datasette.views.index.IndexView object at 0x7fcc1d422310>>"
}