Oleg Broytmann wrote:
On Tue, May 13, 2008 at 10:48:24AM -0500, Jim Steil wrote:
Ok, I've gotten my events to work, but now have another newb question
that I can't seem to find the answer to. In the update listener I get
the kwargs sent in to find which columns have been changed. I can
reference them as a dictionary. I want to compare the fields sent in to
see if they've changed and to get the previous value of them, but cannot
find how to reference the specific column using a variable. What I'd
like to do is the following:
def updateListener(currentValues, newValues):
for columnName in newValues:
newValue = newValues[columnName]
currentValue = currentValues[columnName] ----- This is what
doesn't work
# log changes here
The currentValues[columnName] doesn't work. How can I get the old value
of the changed column?
I believe 'currentValues' is the object (SQLObject) to be changed, not
a dictionary. Get the values by calling getattr(currentValues, columnName).
Oleg.
I've been trying to get my logging working now for the
RowCreatedSignal. I was having some issues with the kwargs parm.
Instead of returning a dict with the values of my table, it is returning
a dict with the class, and the keyfield value of the new record. Ex:
{'class': <class 'motion.model.Contact'>, 'id': 11L}
When I changed the event from RowCreatedSignal to RowCreateSignal,
everything worked as expected, with the kwargs argument giving me the
values of the new record. Ex: {'changedOn': datetime.datetime(2008, 5,
13, 16, 44, 57, 73000), 'county': '', 'distributor': None, 'city': '',
'district': 58, 'title': '', 'state': '', 'address1': '', 'email': '',
'fax': None, 'mobilePhone': None, 'companyName': '', 'phone2': None,
'phone3': None, 'address2': '', 'phone1': None, 'zipCode': '',
'hardcopyPriceLists': False, 'createdOn': datetime.datetime(2008, 5, 13,
16, 44, 57, 73000), 'pager': None, 'homePhone': None, 'firstName':
u'Lou', 'lastName': u'Reichers', 'notes': None, 'customerNumber': None,
'coopId': None, 'emailPriceLists': False}
I was expecting these two events to function the same. Is this a bug in
the code, or something that I'm not understanding correctly?
-Jim
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
