So here's the problem. I am faced with two legacy systems outside my control. One is SQL Server and the other is Oracle. In both only views are exposed to me and I don't anticipate that changing.
I'd like to map these views to objects. Of course, it's read-only so I'm not concerned with the other three CRUD ops; I just need to provide OO interfaces for downstream web apps. I can connect to both through sqlalchemy but am having some trouble getting reflection to work. Oracle, in particular, complains that it can't find the views. I peeked into the oracle.py code and it appears to me that the reflection operations always refer to the all_tables entity. I presume something similar is going on in SQL Server. So before I start mangling the SA code myself, I thought I'd check in to see whether someone has already solved these problems. Anyone? I'll be your best friend. Thanks, J --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---