Creating an HTML table with database values in Flask

Question

I want to display a table showing the values of three fields for each of the units in a table. Some assistance with creating the dictionary from the database and passing objects to the template would be greatly appreciated.

@app.route('/')
def index(row):
    unit_count = Units.query.count()
    unit = Units.query.filter_by(id=row).first()
    rows = [] # Unsure how to define rows from Units db table
    return render_template('table_overview.html', title='Overview', rows=rows, unit=unit)

{% for row in rows %}
<tr>
    <td>{{ row.unit.idnum }}</a></td>
    <td>{{ row.unit.product_code }}</td>
    <td bgcolor="{{ row.unit.stat_colour }}">{{ row.unit.unit_status }}</td>
</tr>
{% endfor %}

abigperson · Accepted Answer · 2017-02-04 13:43:32Z

7

First off your view function can't receive the row input you specify. If you're trying to show all rows in the table you can do it like this:

views.py:

@app.route('/')
def index():
    rows = Units.query.all()
    return render_template('table_overview.html',
                            title='Overview',
                            rows=rows)

table_overview.html (template)

    {% for row in rows %}
    <tr>
        <td>{{ row.idnum }}</a></td>
        <td>{{ row.product_code }}</td>
        <td bgcolor="{{ row.stat_colour }}">{{ row.unit_status }}</td>
    </tr>
    {% endfor %}

answered Feb 4, 2017 at 13:43

abigperson

5,3823 gold badges25 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

mycognosist Over a year ago

That did it! Far simpler than I'd expected. Thanks very much for helping me, I really appreciate it!

mycognosist Over a year ago

Thanks! It sure beats generating html in pure Python scripts ;) Flask has answered my prayers.

Collectives™ on Stack Overflow

Creating an HTML table with database values in Flask

1 Answer 1

views.py:

table_overview.html (template)

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

views.py:

table_overview.html (template)

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related