>SA to be (i.e. would View act read-only, etc.. though I guess VIEWs >aren't necessarily purely read-only in some cases ?).
Right. For example, I think SQL Server views are updateable to some extent (depending on whether there's a table primary key in the column list, whether there are joins, etc.) The rules for this are almost certainly DB-specific, too. Barry ----- Original Message ---- From: Michael Bayer <[EMAIL PROTECTED]> To: [email protected] Sent: Friday, January 25, 2008 7:42:10 PM Subject: [sqlalchemy] Re: VIEW names? On Jan 25, 2008, at 7:25 PM, Martin wrote: > > Hello, > > since I didn't find a direct way to create a VIEW within SQLalchemy > v0.4, I use the > "text"-feature to do that with a SQL/DDL statement, which is maybe not > elegant, but works... > > Is there a way to get information about Views? (Which Views exist and > which columns do they provide?) we dont provide a function for this currently. adding reflection for views is not a big deal, but the decision to be made is how it would be expressed in the API, either as Table(...., view=True), or View(...). we'd have to decide how view-aware we want SA to be (i.e. would View act read-only, etc.. though I guess VIEWs aren't necessarily purely read-only in some cases ?). ____________________________________________________________________________________ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
