On Nov 4, 2009, at 4:29 AM, Julian Scheid wrote:
> > On Wed, Nov 4, 2009 at 3:25 AM, Michael Bayer <[email protected] > > wrote: >> Assuming hsqldb supports case insensitive identifiers as UPPERCASE, >> use >> the same approach taken in the Firebird and Oracle dialects which >> both >> work the same way, that is, include "requires_name_normalize=True", >> and >> implement normalize_name() and denormalize_name(). > > It does, and that worked perfectly, many thanks. > > I've now got only a few more tests failing in test.engine: some caused > by the SELECT without FROM issue I described in the other mail, and an > issue where tables don't seem to get dropped in the right order: > > ERROR: > test.engine.test_reflection.SchemaTest.test_explicit_default_schema > ---snip--- > DBAPIError: (Error) Table is referenced by a constraint in table > SYS_REF_SYS_FK_228_232 table: TABLE2 in statement [ > DROP TABLE "PUBLIC".table1] > > I'm trying to figure out where in your code the drop order is > determined but so far I have some trouble pinpointing it. Could you > point me into the right direction or give a hint as to what might be > going wrong? the drop order is determined by the metadata.sorted_tables property, which in turn is determined by the presence of ForeignKey objects on tables. So if the FKs aren't reflected properly then you'll have problems like that. Also when developing you should make sure the test schema is completely empty before running the tests - failures within teardown methods can leave them lying around. > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
