TypeError: 'BaseQuery' object is not callable Flask

Question

I am getting this error:

TypeError: 'BaseQuery' object is not callable

Here is my code:

companies = Company.query.all()
return Company.query(func.count(Company.id))

I need to find out number of rows in Company model. Please help!

score 3 · Accepted Answer · answered Aug 05 '13 at 12:51

3

Company.query isnt callable there. If you've already selected all your companies with companies = Company.query.all(), why not simply use len(companies)?

If you dont want/need to retrieve the data, you can get just the count with Company.query.count()

answered Aug 05 '13 at 12:51

DazWorrall

13,682
5
43
37

Thanks YOu DazWorrall for the solutions! – Rohit Dhiman Aug 05 '13 at 13:10
1

Using `query.count()` could be a big performance issue (see http://stackoverflow.com/questions/14754994/why-is-sqlalchemy-count-much-slower-than-the-raw-query). – tothemario Mar 14 '14 at 03:54

TypeError: 'BaseQuery' object is not callable Flask

1 Answers1

Linked