[Zope] Finding unused products

[Jonathan (dev101)]

----- Original Message ----- 
From: "Tres Seaver" <tseaver at palladion.com>
To: <zope at zope.org>
Sent: Sunday, November 29, 2009 4:05 PM
Subject: Re: [Zope] Finding unused products


> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Gaute Amundsen wrote:
>> On Sun, 2009-11-29 at 12:32 +0100, Jens Vagelpohl wrote:
>>> On Nov 29, 2009, at 11:59 , Gaute Amundsen wrote:
>>>
>>>> Quick question before I reinvent.
>>>>
>>>> Is there some established way of finding products which have no
>>>> instances in zodb, and can be safely removed?
>>> No there isn't. You may have to invest some time writing a script that
>>>  visits all objects to find out what products they belong to. It may
>>>  not be worth the effort.
>>>
>>> jens
>>
>> Unfortunately it has "not been worth the effort" for a number of years,
>> but now it has become unavoidable.
>> Walking the tree it is then.
>
> You could probably work directly with the pickles way faster than
> activating every object in a large site:  look at the 'fsdump' script
> for clues.

You could also write a stand-alone python routine to access the zodb (.fs 
file) directly (should be faster than running a script through a running 
zope instance and maybe easier than working with pickles).

Jonathan