Sqlalchemy get integer from text query

Question

I am fighting with some legacy code and the correct way to get an integer value from the database. I am trying to get it like this:

db = make_session() # this returns a session
q = db.query('count').from_statement(text("""
    SELECT count(1) as count FROM mytable
    WHERE somevar=:somevar;
""")).params(somevar=1)
return [p[0] for p in q]

This returns [81L]. I would also think that the value is q[0] but that raises and Exception. What is the correct way to use Sqlalchemy in this case and get only an integer here.

Possibly q.one().count

Paulo Scardine
– Paulo Scardine

2015-12-01 04:48:53 +00:00
Commented Dec 1, 2015 at 4:48 — Paulo Scardine
– Paulo Scardine, Commented Dec 1, 2015 at 4:48

ShadowRanger · Accepted Answer · 2015-12-01 05:07:43Z

3

Presumably you'd want .scalar(). For example, something like this might be what you're looking for:

db.query(func.count(mytable.id).filter(mytable.somevar == 1)).scalar()

answered Dec 1, 2015 at 5:07

ShadowRanger

158k12 gold badges222 silver badges317 bronze badges

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

Collectives™ on Stack Overflow

Sqlalchemy get integer from text query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related