On Feb 12, 3:45 pm, "vkuznet" <[EMAIL PROTECTED]> wrote: > No, here is real problem: > > schema had the following: > > create table Foo (int id); > > in MySQL it creates table 'Foo' and column 'id'. > in ORACLE it creates table 'FOO' and column 'ID' > > That's create a problem in sqlalchemy, when I access columns. I can > make an alias for table names, e.g. tf, > but then for MySQL I end up using tf.c.id and for ORACLE I need > tf.c.ID. > and I cannot use tf.c.ID in MySQL (or tf.c.id in ORACLE) since such > columns doesn't exists in sqlalchemy > table object.
look at the echoed SQL. is SQLAlchemy putting quotes around the identifier names ? if not, then you are accessing in a case- insensitive fashion - the id/ID case doesnt matter. put the "case_sensitive=False" flag on your MetaData and see if that works. id also advise not using any MixedCase identifier names (which Foo is). --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
