CODEWITHSUNDEEP
flaskflask-sqlalchemy
Ben Kilah
Ben Kilah

Reputation: 3475

Flask-SQLAlchemy number of results in query

I was wondering if anyone knows how to output the number of results from a query in a flask template.

Example view code:

products = Product.query.all()

In the template it would be handy to be able to just do:

{{ products.count() }}

Is there anyway to do this already, or does anyone have a filter written that does this?

Cheers,

Upvotes: 25

Views: 34786

Answers (2)

mohikan
mohikan

Reputation: 7

you can use len(products) , it is standart python function and works for me

Upvotes: -3

Miguel Grinberg
Miguel Grinberg

Reputation: 67479

Your products template variable is a regular list. You can use the length filter to gets its size:

{{ products|length }}

But if you are working with paginated results then this will give you the size of one page. If you want the size of the entire query then you have to call count() on the query object. For example:

product_count = Product.query.count()

Then pass this to the template as an additional argument. Or if you prefer you can pass the query object to the template and call count() from there:

{{ product_query.count() }}

Upvotes: 44

Related Questions