Object User is mapped to a table with an HSTORE column of "prefs".
Is there a way to do an UPDATE of the column value adding a key?
Like -
session.query(User).\
filter(User.prefs.has_key('inboundBusStop')).\
update(
{User.prefs: User.prefs.update({'transitAvailable': 'true'}), }).\
synchronize_session('fetch')
Only that doesn't work.
This also fails
session.query(User).\
filter(User.prefs.has_key('inboundBusStop')).\
update({User.prefs: User.__table__.c.prefs + {'otherkey':
'fred'}, }).\
synchronize_session('fetch')
The catch is that I need, for the HSTORE type, to update the existing
value, not just assign a value to it.
--
Adam Tauno Williams <mailto:[email protected]> GPG D95ED383
Systems Administrator, Python Developer, LPI / NCLA
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/groups/opt_out.
