[SQLObject] Re: SQLObject Events

[Eduardo E. <eel...@na...>]

Oleg,

My mistake. I meant this:

def MyOnUpdate (sqlObj):
  	sqlObj.addColumn(StringCol("updateBy", "me");
  	sqlObj.addColumn(DateTimeCol("updateOn", now());

def MyOnInsert (sqlObj):
  	sqlObj.addColumn(StringCol("createdBy", "me");
  	sqlObj.addColumn(DateTimeCol("createdOn", now());
  	MyOnUpdate(sqlObj)

class MySQLObject1 (SQLObject):
  	myField = StringCol()
  	onInsert = MyOnInsert(self)
  	onUpdate = MyOnUpdate(self)

class MySQLObject2 (SQLObject):
  	myField = IntCol()
  	onInsert = MyOnInsert(self)
  	onUpdate = MyOnUpdate(self)

Ed.

Oleg Broytmann wrote:
> On Tue, May 11, 2004 at 04:56:33PM -0400, Eduardo Elgueta wrote:
> 
>>What I would like to have is something like this:
>>
>>def MyOnUpdate (sqlObj):
>>	sqlObj.addColumn(StringCol("updateBy", "me");
>>	sqlObj.addColumn(DateTimeCol("updateOn", now());
>>
>>def MyOnInsert (sqlObj):
>>	sqlObj.addColumn(StringCol("createdBy", "me");
>>	sqlObj.addColumn(DateTimeCol("createdOn", now());
>>	MyOnUpdate(sqlObj)
>>
>>def MySQLObject1 (SQLObject):
>>	myField = StringCol()
>>	onInsert = MyOnInsert(self)
>>	onUpdate = MyOnUpdate(self)
>>
>>def MySQLObject2 (SQLObject):
>>	myField = IntCol()
>>	onInsert = MyOnInsert(self)
>>	onUpdate = MyOnUpdate(self)
>>
>>What I need is to find the place to insert the self.onUpdate(self) call. 
>>
>>PS: In other words, I need triggers which MySQL (my database backend) 
>>does not provide.
> 
> 
>    I do not understand what you really want. May be all you need is jsut
> an accessor?
> 
> Oleg.