10 messages in com.googlegroups.sqlalchemy[sqlalchemy] Re: Reflecting tables wi...
FromSent OnAttachments
Don Dwiggins22 Feb 2008 18:05 
Michael Bayer22 Feb 2008 18:17 
Don Dwiggins25 Feb 2008 10:08 
Rick Morrison25 Feb 2008 10:53 
Don Dwiggins25 Feb 2008 12:10 
Rick Morrison25 Feb 2008 12:42 
Waldemar Osuch26 Feb 2008 11:45 
Rick Morrison28 Feb 2008 16:57.patch
Don Dwiggins29 Feb 2008 11:35 
Michael Bayer29 Feb 2008 12:44 
Subject:[sqlalchemy] Re: Reflecting tables with foreign keys
From:Rick Morrison (rick@gmail.com)
Date:02/28/2008 04:57:36 PM
List:com.googlegroups.sqlalchemy
Attachments:

Well here's a patch against trunk that should autoload referenced tables as well. It's only lightly tested, and I'm out of town for a few days, so I didn't want to commit it just yet. Give it a try if you'd like. Note that the metadata.reflect() line in Mike's test script won't work in case-sensitive databases in mssql, as it issues the fetch queries in lowercase.

I'm going to pass on the reflection speed-up patch. It handles column loads only, ignored case-sensitivity issues, and the FK check hits the information schema views anyway, so I really doubt we'd see much of a boost.