Re: [SQLObject] bug report: limit(num) method for Firebird

[Oleg B. <ph...@ph...>]

Hi!

On Fri, Dec 18, 2009 at 01:19:25AM +0100, Petr Jake?? wrote:
>   File
> "/usr/lib/python2.5/site-packages/SQLObject-0.10.1-py2.5.egg/sqlobject/firebird/firebirdconnection.py",
> line 120, in _queryAddLimitOffset
>     match = cls.limit_re.match(query)
> AttributeError: class FirebirdConnection has no attribute 'limit_re'

   This is the patch that I think fixes the problem:

Index: firebirdconnection.py
===================================================================
--- firebirdconnection.py       (revision 4047)
+++ firebirdconnection.py       (working copy)
@@ -10,6 +10,8 @@
     dbName = 'firebird'
     schemes = [dbName]
 
+    limit_re = re.compile('^\s*(select )(.*)', re.IGNORECASE)
+
     def __init__(self, host, db, user='sysdba',
                  password='masterkey', autoCommit=1,
                  dialect=None, role=None, charset=None, **kw):
@@ -18,8 +20,6 @@
             import kinterbasdb
         self.module = kinterbasdb
 
-        self.limit_re = re.compile('^\s*(select )(.*)', re.IGNORECASE)
-
         self.host = host
         self.db = db
         self.user = user

Oleg.
-- 
     Oleg Broytman            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.