[sqlalchemy] Re: Nested joins duplication

2010-08-11 Thread Michael Brickenstein
Hi Mike! Thank you very much for your help. It hasn indeed solved my problem. On Aug 10, 4:23 pm, Michael Bayer mike...@zzzcomputing.com wrote: query=session.query(Address) query=query.join((User, Address.user)) query=query.join((Group, User.group)) Yes, and I indeed need this form to

[sqlalchemy] Re: Nested joins duplication

2010-08-11 Thread Michael Brickenstein
just for the typo It hasn indeed  solved my problem. It has solved my problem. Everything works fine now :-). Cheers, Michael -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalch...@googlegroups.com. To

[sqlalchemy] Nested joins duplication

2010-08-10 Thread Michael Brickenstein
--- Michael Brickenstein Mathematisches Forschungsinstitut Oberwolfach gGmbH Schwarzwaldstr. 9 - 11 77709 Oberwolfach Tel.: 07834/979-31 Fax: 07834/979-38 from sqlalchemy import * from sqlalchemy.ext.declarative import declarative_base from sqlalchemy import ForeignKey from sqlalchemy.orm import

[sqlalchemy] postgresql column default

2010-04-15 Thread Michael Brickenstein
Hi! I have reflected my table from the db (Postgresql 8.4.2, tried psyco 2.0.12 and 2.0.14) using Table(name, metadata, autoload=True, autoload_with=engine) After that I map the table. When later in my app, I try to access the default values from the DB, I use the columnproperty: from

[sqlalchemy] Re: postgresql column default

2010-04-15 Thread Michael Brickenstein
Sorry, forgot to mention, I had the same behaviour with SA 0.5.6 and 0.5.8. Cheers, Michael On 15 Apr., 12:27, Michael Brickenstein brickenst...@mfo.de wrote: Hi! I have reflected my table from the db (Postgresql 8.4.2, tried psyco 2.0.12 and 2.0.14) using Table(name, metadata, autoload

[sqlalchemy] Re: postgresql column default

2010-04-15 Thread Michael Brickenstein
On 15 Apr., 13:03, Michael Brickenstein brickenst...@mfo.de wrote: Sorry, forgot to mention, I had the same behaviour with SA 0.5.6 and 0.5.8. Cheers, In former times, I used prop.server_default to find out, that there is an default of ''. Sorry, that's wrong it has always been

Re: [sqlalchemy] Re: postgresql column default

2010-04-15 Thread Michael Brickenstein
for the reflection code. Cheers, Michael Am 15.04.2010 um 15:19 schrieb Michael Bayer: On Apr 15, 2010, at 7:26 AM, Michael Brickenstein wrote: On 15 Apr., 13:03, Michael Brickenstein brickenst...@mfo.de wrote: Sorry, forgot to mention, I had the same behaviour with SA 0.5.6 and 0.5.8

Re: [sqlalchemy] Re: postgresql column default

2010-04-15 Thread Michael Brickenstein
Hi! Thanks, that was very helpful for me. Cheers, Michael Am 15.04.2010 um 18:17 schrieb Michael Bayer: this column is against an alias, which suggests you've mapped to an alias() or select() of some kind. To get at full table metadata you need to be talking to Column objects that are

[sqlalchemy] Re: Orphans not deleted using cascade parameter

2008-09-04 Thread Michael Brickenstein
and here is the new traceback ;-) Traceback (most recent call last): File foo.py, line 38, in module DBSession.flush() File /Users/michael/programming/rumdemo3/lib/python2.5/site- packages/SQLAlchemy-0.5.0beta3-py2.5.egg/sqlalchemy/orm/scoping.py, line 106, in do return

[sqlalchemy] Re: Orphans not deleted using cascade parameter

2008-09-04 Thread Michael Brickenstein
Dear Michael! Thanks, I got it and understand the difference now. Thank you very much for your help and your time. Michael Am 04.09.2008 um 14:35 schrieb Michael Bayer: On Sep 4, 2008, at 4:15 AM, Michael Brickenstein wrote: AssertionError: Dependency rule tried to blank-out primary key

[sqlalchemy] Re: Orphans not deleted using cascade parameter

2008-09-01 Thread Michael Brickenstein
) sess.commit() assert engine.execute(select count(1) from publication).scalar() == 0 assert engine.execute(select count(1) from section).scalar() == 0 On Aug 29, 2008, at 1:44 AM, Michael Brickenstein wrote: Hi! Hi have a similar problem using table reflection a la sqlsoup. My DB

[sqlalchemy] Re: Orphans not deleted using cascade parameter

2008-08-29 Thread Michael Brickenstein
Hi! Hi have a similar problem using table reflection a la sqlsoup. My DB Backend ist postgresql 8.3. I have a many to many relation: orms5=# \d project_programming_language Table public.project_programming_language Column | Type | Modifiers

[sqlalchemy] Re: Orphans not deleted using cascade parameter

2008-08-29 Thread Michael Brickenstein
I forgot to mention, that I use 0.5.0beta 3. --~--~-~--~~~---~--~~ 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