From 23b744807599d01e6652a83d82e29da95695c814 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Sun, 8 Jan 2006 18:11:52 +0000 Subject: sqlite/postgres reflection will properly add foreign keys added append_item() method to column to work similarly to table.append_item(), used to append foreign keys to the column (required in mysql) appending new foreign keys will properly replace the old one, so explicitly appending foreign keys to tables will replace those loaded via table reflection (instead of doubling them up) --- lib/sqlalchemy/databases/sqlite.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'lib/sqlalchemy/databases/sqlite.py') diff --git a/lib/sqlalchemy/databases/sqlite.py b/lib/sqlalchemy/databases/sqlite.py index 3c15d48b5..49630b9ed 100644 --- a/lib/sqlalchemy/databases/sqlite.py +++ b/lib/sqlalchemy/databases/sqlite.py @@ -150,7 +150,7 @@ class SQLiteSQLEngine(ansisql.ANSISQLEngine): (tablename, localcol, remotecol) = (row[2], row[3], row[4]) #print "row! " + repr(row) remotetable = Table(tablename, self, autoload = True) - table.c[localcol].foreign_key = schema.ForeignKey(remotetable.c[remotecol]) + table.c[localcol].append_item(schema.ForeignKey(remotetable.c[remotecol])) # check for UNIQUE indexes c = self.execute("PRAGMA index_list(" + table.name + ")", {}) unique_indexes = [] -- cgit v1.2.1