[sqlalchemy] declarative commit hook - onCommit()?

2010-04-28 Thread Daniel Robbins
Hi All,

Let's say that when a database record is added or updated, I need to
perform some arbitrary action (in my case, ensuring that data in other
tables is consistent with what is being committed.)

What mechanisms are suggested for this? I could add a save() method to
my declarative class that I need to explicitly call but in an ideal
world, there would be a way for me to specify a method such as
onCommit() that would automatically get called if it exists.

-Daniel

-- 
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 unsubscribe from this group, send email to 
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.



Re: [sqlalchemy] declarative commit hook - onCommit()?

2010-04-28 Thread Chris Withers

Daniel Robbins wrote:

Let's say that when a database record is added or updated, I need to
perform some arbitrary action (in my case, ensuring that data in other
tables is consistent with what is being committed.)

What mechanisms are suggested for this? 


Mapper extesions:

http://www.sqlalchemy.org/docs/05/reference/orm/interfaces.html#sqlalchemy.orm.interfaces.MapperExtension

cheers,

Chris

--
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 unsubscribe from this group, send email to 
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.



Re: [sqlalchemy] declarative commit hook - onCommit()?

2010-04-28 Thread Daniel Robbins
On Wed, Apr 28, 2010 at 10:04 AM, Chris Withers ch...@simplistix.co.uk wrote:
 Daniel Robbins wrote:

 Let's say that when a database record is added or updated, I need to
 perform some arbitrary action (in my case, ensuring that data in other
 tables is consistent with what is being committed.)

 What mechanisms are suggested for this?

 Mapper extesions:

 http://www.sqlalchemy.org/docs/05/reference/orm/interfaces.html#sqlalchemy.orm.interfaces.MapperExtension

Thanks, Chris. Right now I am not defining a mapper, just a bunch of
declarative classes. Can I still use MapperExtensions?

Or should I move away from pure declarative and use mappers directly?
I might be leaning in that direction anyway...

Regards,

Daniel

-- 
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 unsubscribe from this group, send email to 
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.



RE: [sqlalchemy] declarative commit hook - onCommit()?

2010-04-28 Thread King Simon-NFHD78
Daniel Robbins wrote:
 On Wed, Apr 28, 2010 at 10:04 AM, Chris Withers 
 ch...@simplistix.co.uk wrote:
  Daniel Robbins wrote:
 
  Let's say that when a database record is added or updated, 
 I need to
  perform some arbitrary action (in my case, ensuring that 
 data in other
  tables is consistent with what is being committed.)
 
  What mechanisms are suggested for this?
 
  Mapper extesions:
 
  
 http://www.sqlalchemy.org/docs/05/reference/orm/interfaces.htm
 l#sqlalchemy.orm.interfaces.MapperExtension
 
 Thanks, Chris. Right now I am not defining a mapper, just a bunch of
 declarative classes. Can I still use MapperExtensions?
 

The declarative docs include an example of using a MapperExtension:

http://www.sqlalchemy.org/docs/reference/ext/declarative.html#mapper-con
figuration

Simon

-- 
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 unsubscribe from this group, send email to 
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.



Re: [sqlalchemy] declarative commit hook - onCommit()?

2010-04-28 Thread Daniel Robbins
On Wed, Apr 28, 2010 at 10:25 AM, King Simon-NFHD78
simon.k...@motorola.com wrote:

 The declarative docs include an example of using a MapperExtension:

 http://www.sqlalchemy.org/docs/reference/ext/declarative.html#mapper-con
 figuration

Great, thanks for everyone's help. This is exactly the info and
functionality I need.

Best Regards,

Daniel

-- 
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 unsubscribe from this group, send email to 
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/sqlalchemy?hl=en.