Updating Multiple Database Records
Is there a resource that explains how to update multiple ZODB records without have to edit each one individually? I've looked through the how-to's and did a search on Google, but can't seem to turn anything up. Michael
Michael wrote:
Is there a resource that explains how to update multiple ZODB records without have to edit each one individually? I've looked through the how-to's and did a search on Google, but can't seem to turn anything up.
It depends on what you mean by 'update'. You can probably use a Python Script. At worst you can do it using an external method. cheers, Chris
Hi Chris, thanks for responding. By updating I mean for example, I have numerous ZODB records that all contain email address. If the address changes, I would have to update or edit each one individually and it would be nice to have the capability to do multiple records with one action. Does this make more sense? Thanks, Michael On Tuesday 20 August 2002 02:01 am, Chris Withers wrote:
It depends on what you mean by 'update'. You can probably use a Python Script. At worst you can do it using an external method.
cheers,
Chris
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
the best solution would be "in sql-terminology": normalize your database. store each unique email-adress only once in your ZODB and fetch the properties with "walking up and down" your ZODB. if this is not possible: use ZopeFindAndApply. you can set this beast up to search for an specified objectProperty and take actions on the returned objects... so searching & replacing an email-adress is a python-snip! cheers, maik Michael wrote:
Hi Chris, thanks for responding. By updating I mean for example, I have numerous ZODB records that all contain email address. If the address changes, I would have to update or edit each one individually and it would be nice to have the capability to do multiple records with one action. Does this make more sense?
Thanks,
Michael
On Tuesday 20 August 2002 02:01 am, Chris Withers wrote:
It depends on what you mean by 'update'. You can probably use a Python Script. At worst you can do it using an external method.
cheers,
Chris
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )
-- Maik Jablonski __o www.zfl.uni-bielefeld.de _ \<_ Deutsche Zope User Group Bielefeld, Germany (_)/(_) www.dzug.org
participants (3)
-
Chris Withers -
Maik Jablonski -
Michael