[sqlalchemy] Re: Support for SQL views?
Views as normal tables work with mysql. view as a table (using autoload). The application I currently work on --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[sqlalchemy] Re: Support for SQL views?
Hi, But I was a bit disappointed when I found that I couldn't access a view as a table (using autoload). The application I currently work on is based on Oracle and uses views heavily. The good news is that it Views work ok for me using MSSQL, although I haven't tried autoload. My gut feel is that if you define an SQLAlchemy table manually that matches the view, this will work ok. I suspect it's just autoload that's broken. If you can confirm that, it's probably worth filing a bug report. Paul --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[sqlalchemy] Re: Support for SQL views?
On Feb 17, 2007, at 6:55 AM, [EMAIL PROTECTED] wrote: But I was a bit disappointed when I found that I couldn't access a view as a table (using autoload). The application I currently work on is based on Oracle and uses views heavily. The good news is that it uses a lot of materialized views, which do work with SA, but it would still be really nice if SA could treat SQL views as normal tables, just as the DBMS does. it does. however, reflecting those views would require people contribute reflection code to all the various DBAPIs. if the queries in oracle.py/reflecttable were enhanced to search for views as well, then your app would be able to reflect them. It is also common to use synonyms quite heavily on Oracle, but SA unfortunately doesn't seem to understand those either. theres a ticket for the issue of oracle reflection across synonyms, and a patch within the ticket that needs some reworking before it is commtted...the ticket poster marked it as low priority for now. but again, SA has no problem with synonyms, its just reflection youre having problems with. if you define your Tables explicitly (as is the only way available with most other ORM tools such as hibernate) you can point to any view or synonym you like. --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---
[sqlalchemy] Re: Support for SQL views?
ive committed the patch for synonym reflection in r2335, corresponding to ticket 379...so a table linked by a synonym should now be reflectable. --~--~-~--~~~---~--~~ 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 -~--~~~~--~~--~--~---