diff options
| author | Dobes Vandermeer <dvandermeer@roovy.com> | 2014-04-25 10:22:50 -0700 |
|---|---|---|
| committer | Dobes Vandermeer <dvandermeer@roovy.com> | 2014-04-25 10:22:50 -0700 |
| commit | e9b398f8a6ecd5b68142ab334a81683eff966e09 (patch) | |
| tree | 90807d31e1f3f5d79c56a3765244d79bda967f94 /lib/sqlalchemy/dialects/sybase/base.py | |
| parent | 624924d5e75705fb2a7390d36a766cd771b354bd (diff) | |
| download | sqlalchemy-e9b398f8a6ecd5b68142ab334a81683eff966e09.tar.gz | |
Extract limit/offset to variables
Diffstat (limited to 'lib/sqlalchemy/dialects/sybase/base.py')
| -rw-r--r-- | lib/sqlalchemy/dialects/sybase/base.py | 12 |
1 files changed, 7 insertions, 5 deletions
diff --git a/lib/sqlalchemy/dialects/sybase/base.py b/lib/sqlalchemy/dialects/sybase/base.py index 501270778..3e61b5ba6 100644 --- a/lib/sqlalchemy/dialects/sybase/base.py +++ b/lib/sqlalchemy/dialects/sybase/base.py @@ -325,18 +325,20 @@ class SybaseSQLCompiler(compiler.SQLCompiler): s = select._distinct and "DISTINCT " or "" # TODO: don't think Sybase supports # bind params for FIRST / TOP - if select._limit: + limit = select._limit + if limit: #if select._limit == 1: #s += "FIRST " #else: #s += "TOP %s " % (select._limit,) - s += "TOP %s " % (select._limit,) - if select._offset: - if not select._limit: + s += "TOP %s " % (limit,) + offset = select._offset + if offset: + if not limit: # FIXME: sybase doesn't allow an offset without a limit # so use a huge value for TOP here s += "TOP 1000000 " - s += "START AT %s " % (select._offset + 1,) + s += "START AT %s " % (offset + 1,) return s def get_from_hint_text(self, table, text): |