[sqlalchemy] Re: Cascade-Delete causes AssertionError (Tries to blank-out primary key ...)

2007-02-14 Thread Nebur
On 14 Feb., 01:02, Michael Bayer [EMAIL PROTECTED] wrote: OK its fixed in r2314. the cascade from User.meta does take effect, This was fast ! I checked out r2314, and my old code (without delete-orphan) is working now. The only problem: I started to write a little beginners manual for the

[sqlalchemy] Re: query on table-inheritance, self-referencing mappers

2007-02-14 Thread svilen
taking a look, i think what you should do is use an alias of the table_Employee in your queries. since the engineer mapper is using joined table inheritance, the default table_Employee is already going to be involved in the query, so your external join condition needs to be off a distinct

[sqlalchemy] Help get Wikipedia entry through review

2007-02-14 Thread Hamish Lawson
I recently created a basic Wikipedia entry for SQLAlchemy: http://en.wikipedia.org/wiki/SQLAlchemy However it has been marked as being non-notable: An editor has expressed a concern that the subject of the article does not satisfy the notability guideline or one of the following guidelines

[sqlalchemy] Re: query on table-inheritance, self-referencing mappers

2007-02-14 Thread svilen
on the way of programaticaly constructing (2) - actualy like (4) is done internaly, it looks to me maybe Property.get_join( parent) can be hinted somehow.. e.g. in case of only-table_inheritance, using the base table would be enough. Maybe i can just change the parent mapper to the simple

[sqlalchemy] Re: MS-SQL: specifying COLUMNS_TABLE_SCHEMA, using table_iterator()

2007-02-14 Thread metaperl
On Feb 13, 4:23 pm, Paul Johnston [EMAIL PROTECTED] wrote: Hi, I'm wondering where I can specify that the tables that I want are in the schema DataTables instead of 'dbo'. The engine.echo outuput shows It's an argument to Table() e.g. ke_contracts = Table('KEContracts', sa.metadata,

[sqlalchemy] Re: MS-SQL: specifying COLUMNS_TABLE_SCHEMA, using table_iterator()

2007-02-14 Thread metaperl
On Feb 13, 4:23 pm, Paul Johnston [EMAIL PROTECTED] wrote: Hi, I'm wondering where I can specify that the tables that I want are in the schema DataTables instead of 'dbo'. The engine.echo outuput shows It's an argument to Table() e.g. ke_contracts = Table('KEContracts', sa.metadata,

[sqlalchemy] Re: MS-SQL: specifying COLUMNS_TABLE_SCHEMA, using table_iterator()

2007-02-14 Thread metaperl
On Feb 13, 4:23 pm, Paul Johnston [EMAIL PROTECTED] wrote: Hi, I'm wondering where I can specify that the tables that I want are in the schema DataTables instead of 'dbo'. The engine.echo outuput shows It's an argument to Table() e.g. oh my bad an argument to _Table_ not create_engine()!

[sqlalchemy] Re: Newbie question about select statement

2007-02-14 Thread Cristiano Paris
Cristiano Paris wrote: I everyone. I'm pretty new to SQLAlchemy and never done much sql-related work in the past as well so this could possibly be a silly question. ... I ended up discovering SearchResult which does mostly of the things I need. Cristiano

[sqlalchemy] Re: Newbie question about select statement

2007-02-14 Thread Cristiano Paris
Michael Bayer wrote: also look into the SelectResults extension which will do the somelist[90] == SELECT ... OFFSET 90 LIMIT 1 thing. its in the plugins section of the docs. Thanks to all. I don't why but I haven't received these two emails until now. Cristiano

[sqlalchemy] Adding a BLOB column to my Oracle database breaks my app

2007-02-14 Thread shday
I've been using an Oracle database and reflection (i.e., autoload=True). I recently added a BLOB column to the database. I never did any modification to the Python application code yet. The application was made using Turbogears and it just serves two forms, one for inserting records and one for