From 4add9d3a0d9b660c9a267827ad3dd4ceceb0bfb5 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Sat, 6 Jan 2007 19:28:21 +0000 Subject: [PATCH] tweak to support reflecting eqlite columns that didnt specify a type --- lib/sqlalchemy/databases/sqlite.py | 8 ++++++-- 1 file changed, 6 insertions(+), 2 deletions(-) diff --git a/lib/sqlalchemy/databases/sqlite.py b/lib/sqlalchemy/databases/sqlite.py index e20b35de0f..6d1e56a7c7 100644 --- a/lib/sqlalchemy/databases/sqlite.py +++ b/lib/sqlalchemy/databases/sqlite.py @@ -192,8 +192,12 @@ class SQLiteDialect(ansisql.ANSIDialect): (name, type, nullable, has_default, primary_key) = (row[1], row[2].upper(), not row[3], row[4] is not None, row[5]) name = re.sub(r'^\"|\"$', '', name) match = re.match(r'(\w+)(\(.*?\))?', type) - coltype = match.group(1) - args = match.group(2) + if match: + coltype = match.group(1) + args = match.group(2) + else: + coltype = "VARCHAR" + args = '' #print "coltype: " + repr(coltype) + " args: " + repr(args) coltype = pragma_names.get(coltype, SLString) -- 2.47.2