Support multipart schema names

[Former user]

Please find attached some diffs which go towards supporting multipart schema names. Background discussion can be found on a thread on the sqlalchemy group:

http://groups.google.com/group/sqlalchemy/browse_frm/thread/e34ff8fed2c5be2a

I added a couple of new tests in test/dialect/mssql.py

[Mike Bayer]

can i put this towards 0.6 ? or are you looking at 0.5.xx ?

[Michael Trier]

I'm for moving it to 0.6.

[Paul Harrington]

Correction. These diffs do break the unit-tests .. I was not running the tests correctly so erroneously thought that they were passing.

pjjH

[Paul Harrington]

The attachment is a patch for schema.py so that foreign key columns can have more than three period-separated components. This allows us to refer to tables in other databases. Note that the compiler could will most likely have to be updated so that the schema names are correctly quoted.

[Paul Harrington]

Apologies for all the churn on this. The attachment is now a combined patch for schema.py and compiler.py with test cases developed against SQL Server 2008. Development is vastly easier when one is able to use the test-suite!

pjjH

[Michael Trier]

cleaned up patch

[Michael Trier]

Closed in 2a962802de28615f5c961b423e1a995b7bd691bc

[Mike Bayer]

Removing milestone: 0.5.4 (automated comment)