[sqlalchemy] Two bugs or different behaviors between 0.6 and 0.7

2011-08-07 Thread Arturo Sevilla
Hi, I think I have detected two bugs for PostgreSQL databases. I don't think is a different behavior between 0.6 and 0.7 as there is no problem with sqlite. In the following code I have a very simple model, which contains a helper pre-process list class, which just transforms strings into the

[sqlalchemy] Fwd: [Gnukhata-devel] not able to put in account name field

2011-08-07 Thread Krishnakant Mane
Hello all. This might be interesting. I don't know if we are doing some thing wrong. We use session.query on a table and for adding records we use the orm. But look at the forwarded email, I don't know what's wrong. happy hacking. Krishnakant. Original Message Subject:

Re: [sqlalchemy] Re: Cascade Deletes

2011-08-07 Thread Stefano Fontanelli
Il 07/08/11 00.35, Aviv Giladi ha scritto: Everything works great when I create and assign all 3 subratings to the rating object before I add it to the session. However, I need to be able to create a Rating that only has 1 or 2 subratings, and the other subratings absent. When I do that,

Re: [sqlalchemy] Two bugs or different behaviors between 0.6 and 0.7

2011-08-07 Thread Michael Bayer
On Aug 7, 2011, at 4:54 AM, Arturo Sevilla wrote: Hi, I think I have detected two bugs for PostgreSQL databases. I don't think is a different behavior between 0.6 and 0.7 as there is no problem with sqlite. In the following code I have a very simple model, which contains a helper

Re: [sqlalchemy] Fwd: [Gnukhata-devel] not able to put in account name field

2011-08-07 Thread Michael Bayer
On Aug 7, 2011, at 8:19 AM, Krishnakant Mane wrote: Hello all. This might be interesting. I don't know if we are doing some thing wrong. We use session.query on a table and for adding records we use the orm. But look at the forwarded email, I don't know what's wrong. happy hacking. you'd

[sqlalchemy] Re: Cascade Deletes

2011-08-07 Thread Aviv Giladi
I see. Where can I start looking for such an error? What could possibly be causing this? On Aug 7, 6:51 am, Stefano Fontanelli s.fontane...@asidev.com wrote: Il 07/08/11 00.35, Aviv Giladi ha scritto: Everything works great when I create and assign all 3 subratings to the rating object

Re: [sqlalchemy] Fwd: [Gnukhata-devel] not able to put in account name field

2011-08-07 Thread Krishnakant Mane
I really don't think that's the issue. no eval is used. Secondly it did work through psycopg2 directly with postgresql If some would have the kindness to look at the code I am paisting it here. Sorry for making it long, it contains comments to explain the situation. def

Re: [sqlalchemy] Fwd: [Gnukhata-devel] not able to put in account name field

2011-08-07 Thread Michael Bayer
There's not much information there which says much about the ultimate issue. Suffice to say SQLAlchemy itself has no issue with psycopg2 and the string A B, attached is a demonstration inserting, querying, updating this value and similar in many ways. Only with a specific test case that

Re: [sqlalchemy] Need for ImplicitForeignKeyConstraint

2011-08-07 Thread Michael Bayer
Sorry I didn't look closely. Yes when you subclass FKC overriding _set_parent() to perform additional steps is one way to establish on-connect details. Another is to use event.listen(ImplicitForeignKeyConstraint, after_parent_attach), it would be a little more of the public API. On Aug 6,

Re: [sqlalchemy] Re: Cascade Deletes

2011-08-07 Thread Stefano Fontanelli
Il 07/08/11 20.08, Aviv Giladi ha scritto: I see. Where can I start looking for such an error? What could possibly be causing this? I'm sorry but I cannot help you without your code... not a similar code but THE code which produce that error. Regards, Stefano. -- Ing. Stefano