Hello,
I have got a query of the following type:
rows = session.query(*[func.count().over().label(count)]+map(lambda column:
MyClass.__dict__[columns],columns)).filter(...).limit(n).offset(m).all()
it returns the number of results together with values of selected columns. The
problem is when
I've got a fairly simple query in postgres... any idea how I do this in
sqlalchemy - I couldn't find any info about this
select
count(distinct device_id)
from
externalbuild
join
build
on
build.id = externalbuild.build_id
where
external_id = '1'
and not
is_known
BTW,