[sqlalchemy] Re: VIEW names? - Barry Hart - com.googlegroups.sqlalchemy

4 messages in com.googlegroups.sqlalchemy[sqlalchemy] Re: VIEW names?

From	Sent On	Attachments
Martin	25 Jan 2008 16:24
Michael Bayer	25 Jan 2008 16:41
Barry Hart	25 Jan 2008 17:38
Kevin Cole	26 Jan 2008 08:12

Subject:	[sqlalchemy] Re: VIEW names?
From:	Barry Hart (barr...@yahoo.com)
Date:	01/25/2008 05:38:54 PM
List:	com.googlegroups.sqlalchemy

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 <mike...@zzzcomputing.com> To: sqla...@googlegroups.com 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 ?).