Re: [sqlalchemy] Polyphormic class insertion by SA .vs. by database triggers

2010-10-15 Thread Cleber Rodrigues
What would it do , INSERT into the parent table, then the child row is created implicitly and then.do an UPDATE to the child table ? where does the stored procedure get the values to be set up for the child row ? The trigger is activated on INSERTS only, and creates the child row using

[sqlalchemy] Polyphormic class insertion by SA .vs. by database triggers

2010-10-14 Thread Cleber Rodrigues
Hi list, I've a sample application that makes use of polymorphism both with and without SQLAlchemy. On the non-SA side, I've implemented record insertion via stored procedures. Now, integrating new code based on SA, the ORM behaviour is to create both the base and the inherited record. SA fails

Re: [sqlalchemy] Polyphormic class insertion by SA .vs. by database triggers

2010-10-14 Thread Michael Bayer
On Oct 14, 2010, at 4:25 PM, Cleber Rodrigues wrote: Hi list, I've a sample application that makes use of polymorphism both with and without SQLAlchemy. On the non-SA side, I've implemented record insertion via stored procedures. Now, integrating new code based on SA, the ORM