diff options
| author | Jason Kirtland <jek@discorporate.us> | 2007-08-12 22:05:30 +0000 |
|---|---|---|
| committer | Jason Kirtland <jek@discorporate.us> | 2007-08-12 22:05:30 +0000 |
| commit | 872a882d0d93da79797a0cde70cbb2379f2e42d8 (patch) | |
| tree | 23b1932f4731924c35ac96c0668ee2842651df18 /lib/sqlalchemy/databases/sqlite.py | |
| parent | 6e477b750eb432e91f933abae3aff3cb58b27362 (diff) | |
| download | sqlalchemy-872a882d0d93da79797a0cde70cbb2379f2e42d8.tar.gz | |
auto-commit after LOAD DATA INFILE for mysql
caught a couple more uncompiled regexps
Diffstat (limited to 'lib/sqlalchemy/databases/sqlite.py')
| -rw-r--r-- | lib/sqlalchemy/databases/sqlite.py | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/lib/sqlalchemy/databases/sqlite.py b/lib/sqlalchemy/databases/sqlite.py index 15f6a2065..7999cc403 100644 --- a/lib/sqlalchemy/databases/sqlite.py +++ b/lib/sqlalchemy/databases/sqlite.py @@ -13,6 +13,8 @@ import sqlalchemy.types as sqltypes import datetime,time, warnings import sqlalchemy.util as util + +SELECT_REGEXP = re.compile(r'\s*(?:SELECT|PRAGMA)', re.I | re.UNICODE) class SLNumeric(sqltypes.Numeric): def get_col_spec(self): @@ -153,7 +155,7 @@ class SQLiteExecutionContext(default.DefaultExecutionContext): self._last_inserted_ids = [self.cursor.lastrowid] + self._last_inserted_ids[1:] def is_select(self): - return re.match(r'SELECT|PRAGMA', self.statement.lstrip(), re.I) is not None + return SELECT_REGEXP.match(self.statement) class SQLiteDialect(ansisql.ANSIDialect): |