Changeset 7852
- Timestamp:
- 07/06/08 09:26:37 (5 months ago)
- Files:
-
- django/trunk/django/db/backends/__init__.py (modified) (1 diff)
- django/trunk/django/db/backends/mysql/base.py (modified) (1 diff)
- django/trunk/django/db/backends/mysql_old/base.py (modified) (1 diff)
- django/trunk/django/db/backends/oracle/base.py (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
- Modified
- Copied
- Moved
django/trunk/django/db/backends/__init__.py
r7790 r7852 162 162 return cursor.lastrowid 163 163 164 def limit_offset_sql(self, limit, offset=None):165 """166 Returns a LIMIT/OFFSET SQL clause, given a limit and optional offset.167 """168 # 'LIMIT 40 OFFSET 20'169 sql = "LIMIT %s" % limit170 if offset and offset != 0:171 sql += " OFFSET %s" % offset172 return sql173 174 164 def lookup_cast(self, lookup_type): 175 165 """ django/trunk/django/db/backends/mysql/base.py
r7798 r7852 89 89 def fulltext_search_sql(self, field_name): 90 90 return 'MATCH (%s) AGAINST (%%s IN BOOLEAN MODE)' % field_name 91 92 def limit_offset_sql(self, limit, offset=None):93 # 'LIMIT 20,40'94 sql = "LIMIT "95 if offset and offset != 0:96 sql += "%s," % offset97 return sql + str(limit)98 91 99 92 def no_limit_value(self): django/trunk/django/db/backends/mysql_old/base.py
r7798 r7852 93 93 def fulltext_search_sql(self, field_name): 94 94 return 'MATCH (%s) AGAINST (%%s IN BOOLEAN MODE)' % field_name 95 96 def limit_offset_sql(self, limit, offset=None):97 # 'LIMIT 20,40'98 sql = "LIMIT "99 if offset and offset != 0:100 sql += "%s," % offset101 return sql + str(limit)102 95 103 96 def no_limit_value(self): django/trunk/django/db/backends/oracle/base.py
r7833 r7852 87 87 cursor.execute('SELECT %s_sq.currval FROM dual' % sq_name) 88 88 return cursor.fetchone()[0] 89 90 def limit_offset_sql(self, limit, offset=None):91 # Limits and offset are too complicated to be handled here.92 # Instead, they are handled in django/db/backends/oracle/query.py.93 return ""94 89 95 90 def lookup_cast(self, lookup_type):
