looping through database results in python/flask

Question

I am getting the following result set from my database,

    {
  "workbases": [
    {
      "workbase": "WB 1"
    }, 
    {
      "workbase": "WB 2"
    }, 
    {
      "workbase": "WB 3"
    }, 
    {
      "workbase": "WB 4"
    }, 
    {
      "workbase": "WB 5"
    }, 
    {
      "workbase": "WB 6"
    }, 
    {
      "workbase": "WB 7"
    }, 
    {
      "workbase": "WB 8"
    }, 
    {
      "workbase": "WB 9"
    }, 
    {
      "workbase": "WB 10"
    }, 
    {
      "workbase": "WB 11"
    }, 
    {
      "workbase": "WB 12"
    }, 
    {
      "workbase": "WB 13"
    }, 
    {
      "workbase": "WB 14"
    }, 
    {
      "workbase": "WB 15"
    }, 
    {
      "workbase": "WB 16"
    }
  ]
}

These results come from this code,

staff = tables.staff_list

sel = select([staff.c.workbase]).distinct(staff.c.workbase).select_from(staff).where(staff.c.workbase != "")

workbases = FlaskApp.db_connect().execute(sel).fetchall()
workbases = [utils.rowdict(a) for a in workbases]

workbases = jsonify(workbases=workbases)

return render_template('leave_request.html', hours_left=100, workbases=workbases)

How do I go about looking through the workbases data in my template, I have tried,

{% for w in workbases %}
    <option value="">{{ w.workbase }}</option>
{% endfor %}

and also

{% for w in workbases.workbases %}
    <option value="">{{ w.workbase }}</option>
{% endfor %}

but niether of them render any option within my select inputs (the code is nested within select tags

Why did you jsonify your data structure? The jsonify() function in flask returns flask.Response() object. -- stackoverflow.com/questions/7907596/… — OneCricketeer
– OneCricketeer, Commented Nov 28, 2016 at 11:46

abigperson · Accepted Answer · 2016-11-28 14:42:26Z

1

If you remove the line workbases = jsonify(workbases=workbases) from your python file. As cricket007 states, jsonify is a flask.Response() object used to send JSON data from Flask to something like an XHR call or an API call. It's an HTTP Response and will include content headers, etc.

Once you remove this the second Jinja2 method you described should work.

{% for w in workbases.workbases %}
    <option value="">{{ w.workbase }}</option>
{% endfor %}

This would produce the same results as:

{% for w in workbases['workbases'] %}
    <option value="">{{ w['workbase'] }}</option>
{% endfor %}

Because Jinja2 is not Python. See the documentation for more detail:

http://jinja.pocoo.org/docs/dev/templates/#variables

answered Nov 28, 2016 at 14:42

abigperson

5,3823 gold badges25 silver badges25 bronze badges

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

Comments

ArunDhaJ · Accepted Answer · 2016-11-28 12:16:19Z

0

Have you tried

{% for w in workbases['workbases'] %}
    <option value="">{{ w['workbase'] }}</option>
{% endfor %}

answered Nov 28, 2016 at 12:16

ArunDhaJ

6316 silver badges18 bronze badges

1 Comment

abigperson Over a year ago

In jinja2 workbases['workbases'] and workbases.workbases is essentially the same thing jinja.pocoo.org/docs/dev/templates/#variables

Collectives™ on Stack Overflow

looping through database results in python/flask

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related