{% extends "layout.html" %} {% block head %} {% endblock %} {% block body %}

Filter: {{table_name}}

{%for col in table.columns%}
  • Filter {{col.name}}

  • {% if filtered_columns %} {% if col.name in filtered_columns %}

    {% else %}

    {% endif %} {% else %}

    {% endif %} {% if col.name == 'id' %} Equals: Greater Than: Less Than:

    {% elif type(col.type)==sqlalchemy.types.INTEGER%} Equals: Greater Than: Less Than:

    {% elif type(col.type)==sqlalchemy.types.FLOAT%} Equals: Greater Than: Less Than:

    {% elif type(col.type)==sqlalchemy.types.DATE%} On: After: Before:

    {% elif type(col.type) == sqlalchemy.types.VARCHAR %}

    {% endif %} {% endfor %}

    reset

    {% if results %} {%if results%}

    Results:{{ num_items }}

    {% if page > 1 %} Previous {% endif %} {% if page < pages %} Next {% endif %} {%for col in table.columns%} {%endfor%} {%for row in results%} {%for key in row.keys()%} {% if key in ["price","cost"] %} {%else%} {%endif%} {%endfor%} {%endfor%}
    {{ col.name }}Commands
    ${{ locale.format("%0.2f",row[key]/100.0,grouping=True) }}{{ row[key] }}View Modify Delete
    {%endif%} {% endif %}
    {% endblock %}