How to get peewee result length

Question

I use peewee orm in python.

I have a query that :

userOrganizations = (UserOrganization
    .select(UserOrganization,Organization)
    .join(Organization)
    .where(UserOrganization.user==user.user_id)
    .aggregate_rows()
)

I want to get length of userOrganizations variable. Is there any method like userOrganizations.length() ?

Answer 1

According to the peewee documentation you can use the count() function, i.e.:

userOrganizations.count()

If you're worried about maybe running extra DB queries, you can convert your result to a list and get the length, like:

len(list(userOrganizations))

Source for second technique: this question.