Michael Bayer schrieb:
> use the "prefixes" argument to select() for this.
>
thanks very much.
it it possible to use this somehow with session.query?
I do not use select at all, but do construct the queries dynamically like so:
q = session.query(tblNewsletteremail)
c = tblNewsletteremail.__table__.c
for k,v in info.items():
if isinstance(v, tuple):
op, v = v
if op == 'like':
q = q.filter(c[k].like('%' + v + '%'))
if op == 'in':
q = q.filter(c[k].in_(v))
else:
q = q.filter(c[k] == v)
if order_by:
for e in order_by:
q = q.order_by(c[e])
if limit:
q = q.limit(limit)
result = q.all()
now I would like to "apply" SQL_CALC_FOUND_ROWS to the query object before
executing it. is this possible?
thanks again
robert
>
> On Aug 23, 2009, at 4:23 PM, robert rottermann wrote:
>
>> Hi there,
>>
>> I would like to create a batching functionality for a web based
>> aplication that
>> uses a mysql database.
>>
>> mysql offeres SQL_CALC_FOUND_ROWS for this purpose.
>> how can I use it, or is there a generic way to have sqlalchemy
>> return the number
>> of rows a query would have returned without limit.
>>
>> thanks
>> robert
>>
>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
