From fb97a666bb6e352ae908d763d2d8ac3c087cd529 Mon Sep 17 00:00:00 2001
From: Mike Bayer <mike_mp@zzzcomputing.com>
Date: Sun, 10 Apr 2011 10:47:34 -0400
Subject: - Fixed bug where reflection of foreign key created as "REFERENCES
 <tablename>" without col name would fail.  [ticket:2115] (also in 0.6.7)

---
 lib/sqlalchemy/dialects/sqlite/base.py | 4 ++++
 1 file changed, 4 insertions(+)

(limited to 'lib/sqlalchemy/dialects/sqlite')

diff --git a/lib/sqlalchemy/dialects/sqlite/base.py b/lib/sqlalchemy/dialects/sqlite/base.py
index 43d8d708b..95f699f54 100644
--- a/lib/sqlalchemy/dialects/sqlite/base.py
+++ b/lib/sqlalchemy/dialects/sqlite/base.py
@@ -683,6 +683,10 @@ class SQLiteDialect(default.DefaultDialect):
             if row is None:
                 break
             (constraint_name, rtbl, lcol, rcol) = (row[0], row[2], row[3], row[4])
+            # sqlite won't return rcol if the table
+            # was created with REFERENCES <tablename>, no col
+            if rcol is None:
+                rcol = lcol
             rtbl = re.sub(r'^\"|\"$', '', rtbl)
             lcol = re.sub(r'^\"|\"$', '', lcol)
             rcol = re.sub(r'^\"|\"$', '', rcol)
-- 
cgit v1.2.1