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

[sqlalchemy] Multiple names/column_property for the same column

2008-10-02 Thread Cleber
Hi there, Sorry if this has come before, but I did not manage to find a specific answer on the mailing list archives. I'm porting an application to SA, and because of legacy code, I need to maintain nicknames (for now) for some attribute names. The database structure itself has column names

[sqlalchemy] Re: Multiple names/column_property for the same column

2008-10-02 Thread Cleber
? first is done by changing key in the mapper.properties dict. the other... synonim()? On Thursday 02 October 2008 16:41:05 Cleber wrote: Hi there, Sorry if this has come before, but I did not manage to find a specific answer on the mailing list archives. I'm porting an application to SA