ZODB (and OODB) question
chris
nadsinoz at hotmail.com
Mon Jan 7 16:19:55 EST 2002
I am writing an application using zope and I am saving my objects
(customers, transactions, etc.) in the ZODB rather than using a RDBMS
such as MySQL.
In a RDBMS I can easily run batch update jobs, for example, running
nightly jobs to update customer's status depending on whether or not
the customer pays an invoice on-time.
In the RDBMS, I would perform something like the following to do this:
UPDATE customer SET status = 'stopped' WHERE ...
How can I perform the same update using an OODB? The only way I can
think of doing this at the moment is to traverse through each and
every customer object and set their status individually depending on
my criteria - not very efficient!
I would appreciate any help on this, even if I just get pointed to
relevant documentation that would help me.
Thanks in advance,
Chris Snow
More information about the Python-list
mailing list