| 1 | Index: meta.py
|
|---|
| 2 | ===================================================================
|
|---|
| 3 | --- meta.py (revision 321)
|
|---|
| 4 | +++ meta.py (working copy)
|
|---|
| 5 | @@ -1268,12 +1268,22 @@
|
|---|
| 6 | order_by = ", ".join(order_by)
|
|---|
| 7 |
|
|---|
| 8 | # LIMIT and OFFSET clauses
|
|---|
| 9 | - if kwargs.get('limit') is not None:
|
|---|
| 10 | - limit_sql = " LIMIT %s " % kwargs['limit']
|
|---|
| 11 | - if kwargs.get('offset') is not None and kwargs['offset'] != 0:
|
|---|
| 12 | - limit_sql += "OFFSET %s " % kwargs['offset']
|
|---|
| 13 | + #gheorghe:
|
|---|
| 14 | + from django.conf.settings import DATABASE_ENGINE
|
|---|
| 15 | + limit_sql = ""
|
|---|
| 16 | + if DATABASE_ENGINE=="ado_mssql":
|
|---|
| 17 | + if kwargs.get('limit') is not None:
|
|---|
| 18 | + select[0] = 'TOP %s %s' % (kwargs['limit'], select[0])
|
|---|
| 19 | + if kwargs.get('offset') is not None and kwargs['offset'] != 0:
|
|---|
| 20 | + #the problem is if PK is not ID and also if user adds GROUP BY, HAVING etc (can a user do that?),
|
|---|
| 21 | + #those should be added to the subquery too and they can't be
|
|---|
| 22 | + #or at least I don't know how
|
|---|
| 23 | + where.append("id NOT IN (SELECT TOP %s id FROM %s%s)" % (kwargs['offset'], opts.db_table, (order_by and " ORDER BY " + order_by or "")))
|
|---|
| 24 | else:
|
|---|
| 25 | - limit_sql = ""
|
|---|
| 26 | + if kwargs.get('limit') is not None:
|
|---|
| 27 | + limit_sql = " LIMIT %s " % kwargs['limit']
|
|---|
| 28 | + if kwargs.get('offset') is not None and kwargs['offset'] != 0:
|
|---|
| 29 | + limit_sql += "OFFSET %s " % kwargs['offset']
|
|---|
| 30 |
|
|---|
| 31 | return select, " FROM " + ",".join(tables) + (where and " WHERE " + " AND ".join(where) or "") + (order_by and " ORDER BY " + order_by or "") + limit_sql, params
|
|---|
| 32 |
|
|---|
| 33 | @@ -1302,7 +1312,15 @@
|
|---|
| 34 | if field.null:
|
|---|
| 35 | kwargs.setdefault('where', []).append('%s.%s IS NOT NULL' % (opts.db_table, field.name))
|
|---|
| 36 | select, sql, params = function_get_sql_clause(opts, **kwargs)
|
|---|
| 37 | - sql = 'SELECT %s %s GROUP BY 1 ORDER BY 1' % (db.get_date_trunc_sql(kind, '%s.%s' % (opts.db_table, field.name)), sql)
|
|---|
| 38 | +
|
|---|
| 39 | + #gheorghe
|
|---|
| 40 | + from django.conf.settings import DATABASE_ENGINE
|
|---|
| 41 | + if DATABASE_ENGINE=="ado_mssql":
|
|---|
| 42 | + datepart = db.get_date_trunc_sql(kind, '%s.%s' % (opts.db_table, field.name))
|
|---|
| 43 | + sql = 'SELECT %s %s GROUP BY %s ORDER BY %s' % (datepart, sql, datepart, datepart)
|
|---|
| 44 | + else:
|
|---|
| 45 | + sql = 'SELECT %s %s GROUP BY 1 ORDER BY 1' % (db.get_date_trunc_sql(kind, '%s.%s' % (opts.db_table, field.name)), sql)
|
|---|
| 46 | +
|
|---|
| 47 | cursor = db.db.cursor()
|
|---|
| 48 | cursor.execute(sql, params)
|
|---|
| 49 | # We have to manually run typecast_timestamp(str()) on the results, because
|
|---|