Just a quick warning to others:
I noticed this warning when running a maintenance script that used the
Windowed Range Query example:
/sqlalchemy/sql/elements.py:3736: SAWarning: Textual SQL expression
'rownum % 100=1' should be explicitly declared as text('rownum % 100=1')
(this warning may be suppressed after 10 occurrences)
The fix was simple, and I've updated the wiki:
- q = q.filter("rownum %% %d=1" % windowsize)
<https://bitbucket.org/zzzeek/sqlalchemy/wiki/commits/f165e0cb07038d9fd07abc72328accf0fb5d8b94#LUsageRecipes/WindowedRangeQuery.mdT42>
+ q = q.filter(sqlalchemy.text("rownum %% %d=1" % windowsize))
https://bitbucket.org/zzzeek/sqlalchemy/wiki/history/UsageRecipes/WindowedRangeQuery
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
