{% extends "base.html" %} {% block title %}Write to this database{% endblock %} {% block extra_head %} {{- super() -}} {% include "_codemirror.html" %} {% include "_execute_write_analysis_styles.html" %} {% include "_sql_parameter_styles.html" %} {% endblock %} {% block body_class %}execute-write db-{{ database|to_css_class }}{% endblock %} {% block crumbs %} {{ crumbs.nav(request=request, database=database) }} {% endblock %} {% block content %}

Write to this database

Execute SQL to insert, update or delete rows in this database.

{% if execution_message %}

{{ execution_message }}{% for link in execution_links %} {{ link.label }}{% endfor %}

{% endif %}
{% if write_template_tables %}
Start with a template

{% for operation in write_template_operations %} {% endfor %}

{% else %}

You don't currently have permission to insert, edit or delete from any tables.

{% endif %}

{% set sql_parameters_section_id = "execute-write-parameters-section" %} {% set sql_parameters_allow_expand = true %} {% include "_sql_parameters.html" %}

Query operations

{% if analysis_error %}

{{ analysis_error }}

{% elif analysis_rows %}
{% for row in analysis_rows %} {% endfor %}
Operation Database Table Required permission Allowed
{{ row.operation }} {{ row.database }} {{ row.table }} {% if row.required_permission %}{{ row.required_permission }}{% endif %} {% if row.allowed is none %}{% elif row.allowed %}yes{% else %}no{% endif %}
{% else %}

Analysis will show each affected table and required permission.

{% endif %}

{{ execute_disabled_reason or "" }} {% if save_query_url %}Save this query{% endif %}

{% include "_codemirror_foot.html" %} {% include "_sql_parameter_scripts.html" %} {% include "_execute_write_analysis_scripts.html" %} {% if write_template_tables %} {% endif %} {% endblock %}