{% extends "base.html" %} {% import "_catalog_cards.html" as catalog_cards with context %} {% block title %}{{ database }}{% endblock %} {% block extra_head %} {{- super() -}} {% include "_codemirror.html" %} {% include "_sql_parameter_styles.html" %} {% if database_page_data.createTable %} {% endif %} {% endblock %} {% block body_class %}db db-{{ database|to_css_class }}{% endblock %} {% block crumbs %} {{ crumbs.nav(request=request, database=database) }} {% endblock %} {% block recent_item %}{% with recent_type="database", recent_name=database, recent_title=metadata.title, recent_url=urls.database(database) %}{% include "_recent_item.html" %}{% endwith %}{% endblock %} {% block content %} {% set shown_tables = (tables if show_hidden else tables|rejectattr("hidden"))|list %}
{{ "{:,}".format(shown_tables|length) }} table{% if shown_tables|length != 1 %}s{% endif %} {%- if views %}{{ "{:,}".format(views|length) }} view{% if views|length != 1 %}s{% endif %}{% endif -%} {%- if queries %}{{ "{:,}".format(queries_count) }} quer{% if queries_count != 1 %}ies{% else %}y{% endif %}{% endif -%} {%- if size %}{{ format_bytes(size) }}{% endif -%}
{% if allow_execute_sql %} {% endif %} {% if attached_databases %} {% endif %} {% if queries %}{{ query.sql|truncate(120) }}{% endif -%}
… and {{ "{:,}".format(hidden_count) }} hidden table{% if hidden_count == 1 %}{% else %}s{% endif %}
{% endif %} {% if allow_download %}Download SQLite DB: {{ database }}.db {{ format_bytes(size) }}
{% endif %}