[sqlalchemy] SQLite schema select bug?

2008-01-25 Thread Nick Joyce
Hi, I am developing a web app using SQLite (which I will switch to PostgreSQL in production) and came across a weird select error when using schema. The attached file test.py reproduces the error and output.txt is the output from running the script. I have tested with 0.4.2p3 and trunk r4097.

[sqlalchemy] Re: VIEW names?

2008-01-25 Thread Michael Bayer
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

[sqlalchemy] Re: VIEW names?

2008-01-25 Thread Barry Hart
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,

[sqlalchemy] Re: msqsql and sqlalchemy on linux -was Re: mssql connection uri

2008-01-25 Thread Lukasz Szybalski
On Jan 17, 2008 3:27 PM, Rick Morrison [EMAIL PROTECTED] wrote: Adodbapi is Windows-only, you're definitely barking up the wrong tree with that one. Pyodbc on Linux is theoretically possible, but I know of no users and have very little experience myself with it. Pymssql is supported on

[sqlalchemy] Re: a way to share Session.mapper(SomeObject) across two scoped sessions?

2008-01-25 Thread Kumar McMillan
On Jan 25, 2008 11:58 AM, Michael Bayer [EMAIL PROTECTED] wrote: ...so this test will pass if you change setUp to read: Session.mapper(SomeObject, table, properties={ 'options':relation(SomeOtherObject) }, save_on_init=False)

[sqlalchemy] Re: a way to share Session.mapper(SomeObject) across two scoped sessions?

2008-01-25 Thread Michael Bayer
On Jan 25, 2008, at 12:16 PM, Kumar McMillan wrote: class ScopedMapperTest(PersistTest): @@ -1027,6 +1046,21 @@ pass Session.mapper(Baz, table2, extension=ext) assert hasattr(Baz, 'query') + +def test_attach_assigned_objects_to_multiple_sess(self): +

[sqlalchemy] Re: a way to share Session.mapper(SomeObject) across two scoped sessions?

2008-01-25 Thread Michael Bayer
On Jan 25, 2008, at 2:02 PM, Kumar McMillan wrote: On Jan 25, 2008 11:58 AM, Michael Bayer [EMAIL PROTECTED] wrote: ...so this test will pass if you change setUp to read: Session.mapper(SomeObject, table, properties={ 'options':relation(SomeOtherObject) },

[sqlalchemy] Re: a way to share Session.mapper(SomeObject) across two scoped sessions?

2008-01-25 Thread Kumar McMillan
On Jan 24, 2008 2:46 PM, Kumar McMillan [EMAIL PROTECTED] wrote: but, since I am explicitly saving it to a new session and the session has a different scope, shouldn't this be possible? Maybe I'm not fully understanding scoped sessions. I am hesitant to file this as a bug because I'm not sure

[sqlalchemy] Re: SQLite schema select bug?

2008-01-25 Thread jason kirtland
Nick Joyce wrote: Hi, I am developing a web app using SQLite (which I will switch to PostgreSQL in production) and came across a weird select error when using schema. The attached file test.py reproduces the error and output.txt is the output from running the script. I have tested