{% extends "base_table.html" %}

{% block insert_tab_class %} active{% endblock %}

{% block inner_content %}
  <div class="d-flex justify-content-between align-items-center">
    <h3 class="mb-0">Insert row into {{ table }}</h3>
    <label class="small text-muted font-weight-normal mb-0" for="toggle-checkboxes">
      <input checked="checked" id="toggle-checkboxes" type="checkbox" /> include all columns
    </label>
  </div>
  <p class="small text-muted">Type NULL for SQL NULL. Uncheck a column to omit it.</p>
  <form action="{{ url_for('table_insert', table=table) }}" method="post" role="form">
    {% for column, field in columns_fields %}
      <div class="form-group row">
        <label for="id_{{ field.name }}" class="col-sm-2 col-form-label">{{ column.name }}</label>
        <div class="col-sm-10">
          <div class="input-group">
            <div class="input-group-prepend">
              <div class="input-group-text">
                <input {% if field.name in edited %}checked {% endif %}class="chk-enable-column" data-target-element="id_{{ field.name }}" tabindex="-1" type="checkbox" name="chk_{{ field.name }}" aria-label="Allow updating this column.">
              </div>
            </div>
            {% if column.data_type.lower() in ('text', 'blob') %}
              <textarea class="form-control remember-size{% if field.name in errors %} is-invalid{% endif %}" {% if field.name not in edited %}disabled {% endif %} id="id_{{ field.name }}" name="{{ field.name }}">{% if row[field.name] == None %}NULL{% else %}{{ row[field.name] }}{% endif %}</textarea>
            {% else %}
              <input class="form-control{% if field.name in errors %} is-invalid{% endif %}" {% if field.name not in edited %}disabled {% endif %} id="id_{{ field.name }}" name="{{ field.name }}" value="{% if row[field.name] == None %}NULL{% else %}{{ row[field.name] }}{% endif %}" />
            {% endif %}
            {% if field.name in errors %}
              <div class="invalid-feedback">{{ errors[field.name] }}</div>
            {% endif %}
          </div>
          <small class="form-text text-muted">
            {% if column.primary_key %}
              <strong>Primary key.</strong>
            {% endif %}
            {{ column.data_type|default('ANY') }}{% if not column.null %} NOT NULL{% endif %}
            {% if column.default %}(default {{ column.default }}){% endif %}
          </small>
        </div>
      </div>
    {% endfor %}
    <button class="btn btn-primary" type="submit">Insert</button>
    <a class="btn btn-secondary" href="{{ back_url(table) }}">Cancel</a>
  </form>
{% endblock %}