On Jul 24, 2013, at 7:34 PM, mdob <mike.dobrzan...@gmail.com> wrote:
> Hi, > > I got into an interesting issue where I receive duplicated tables if I use > capital letters schema in reflect method. you wouldn't want to do that unless the table were actually created using a case-sensitive name, which is pretty unusual in Oracle. If Oracle's own system views show the names as ALL_UPPERCASE, that's a case-insensitive name. On the SQLAlchemy side, you should use all lower case names which will be similarly treated as case insensitive. Otherwise it will see a case-insensitive and a locally case-sensitive name as different, leading to the kinds of issues you're seeing. > > > Tables were created like: CREATE TABLE "MIKE"."CUSTOMER" ... so they should > be case insensitive. I see there are quotes here, but Oracle will still log these as case insensitive (I just tried). So use all lower case on the SQLAlchemy side. > > What I found in sqlalchemy code is that table mike.address is mapped and > added to Base.metadata.tables dictionary when table MIKE.customer is being > mapped. I guess that's because mike.address parent table to MIKE.customer. > The thing is it's added lowercase. Next, MIKE.address is added in a normal > way. it sees "mike.address" in two different ways. One, as the table MIKE.address, because you asked for the schema "MIKE", and the other, as the table "mike.address", which is what "MIKE.customer" says it foreign keys out to. "MIKE" is not the same as "mike", the former is case-sensitive on SQLA's side. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/groups/opt_out.
