SQLAlchemy get every row the matches query and loop through them

Question

I'm new to Python and SQLAlchemy. I've been playing about with retrieving things from the database, and it's worked every time, but im a little unsure what to do when the select statement will return multiple rows. I tried using some older code that worked before I started SQLAlchemy, but db is a SQLAlchemy object and doesn't have the execute() method.

application = Applications.query.filter_by(brochureID=brochure.id)
cur = db.execute(application)
entries = cur.fetchall()

and then in my HTML file

      {% for entry in entries %}
      var getEmail = {{entry.2|tojson|safe}}
      emailArray.push(getEmail);

I looked in the SQLAlchemy documentation and I couldn't find a .first() equivalent to getting all the rows. Can anyone point me in the right direction? No doubt it's something very small.

dirn · Accepted Answer · 2014-02-24 22:20:05Z

4

Your query is correct, you just need to change the way you interact with the result. The method you are looking for is all().

application = Applications.query.filter_by(brochureID=brochure.id)
entries = application.all()

answered Feb 24, 2014 at 22:20

dirn

21k7 gold badges75 silver badges76 bronze badges

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

4 Comments

Killian Over a year ago

that works great pulling from the database, I can see Application objects in entries by using dump(), however when I pass entries to my HTML file, it's saying it's undefined. Any ideas why that might be the case?

Killian Over a year ago

Just to clarify (edit button seems to have disappeared). Entries in my HTML file has the correct number of objects, but each entry is undefined. I'm using the same code as I posted from my HTML file above

Killian Over a year ago

Sorry, I actually just got it sorted, I was accessing properties of the entry like this entry.1 when I should have been using column names i.e. entry.id or entry.brochureName Thanks for your help!

dirn Over a year ago

That was going to be my next question. Glad you got it working.

SingleNegationElimination · Accepted Answer · 2014-02-24 22:17:27Z

2

the Usual way to work with orm queries is through the Session class, somewhere you should have a

engine = sqlalchemy.create_engine("sqlite:///...")
Session = sqlalchemy.orm.sessionmaker(bind=engine)

I'm not familiar with flask, but it likely does some of this work for you.

With a Session factory, your application is instead

session = Session()
entries = session.query(Application) \
          .filter_by(...) \
          .all()

answered Feb 24, 2014 at 22:17

SingleNegationElimination

157k35 gold badges269 silver badges306 bronze badges

Collectives™ on Stack Overflow

SQLAlchemy get every row the matches query and loop through them

2 Answers 2

4 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Linked

Related