[ZODB-Dev] ZODB load/save tracing

[Adam Groszer]

Hello Win,

I think you'll have to write a script.
Have a look at
http://svn.zope.org/z3c.zodbbrowser/sandbox/src/z3c/zodbbrowser/
From plugin_fs.py you can extract how to open the ZODB without zope.
You can then traverse (access the properties) of the root and object
thereunder.

Matching an OODB with an RDB might not be a simple task as the OODB is
a tree or a graph of objects.

As Lennart already said on the list:
But the best way to export data from ZODB is to write a script which
outputs CSV values, which you then can import to MySQL.

(Note that ZODB is not a type of SQL database but an object oriented
database, and that a generic export therefore is not  possible, you
must write a dedicated script for your specific data set. This however
is usually quite easy).


Tuesday, March 6, 2007, 4:08:45 AM, you wrote:

WMA> Hello Adam,

WMA> I would like to request you to help me if possible. I am tryiny to 
WMA> export contents (text data) of objects in ZODB. But I am a newbie and 
WMA> no idea to do that. Could you please show some ways with exact 
WMA> instruction? I am a bit hurry to do that.

WMA> Thank you for your attention and time.

WMA> Kind regards,

WMA> Win Myint Aung
WMA> Quoting Adam Groszer <agroszer at gmail.com> on 03/06/07:

>> Hello Christian,
>>
>> It's mostly done. Available at z3c.zodbtracing as inbetween I figured
>> out that tracing the connection should be also possible.
>>
>> Saturday, February 24, 2007, 8:00:40 PM, you wrote:
>>
>>> Hi,
>>
>>> I'm pretty sure there are no hooks around that do what you need.
>>
>>> The methods you want to tap into would be
>>
>>> store()
>>> load*()
>>
>>> on the storages.
>>
>>> You might want to look into how the BlobStorage was created to make
>>> yourself a "tracing storage" that can be wrapped around an existing
>>> storage to allow usage with multiple other storages.
>>
>>> This could be a useful extensions to ZODB. If you go this way,  I'd be
>>> happy to help out with some of the packaging mechanics and getting the
>>> ZConfig parts fletched out.
>>
>>> Christian
>>
>>> Am Samstag, den 24.02.2007, 14:33 +0100 schrieb Adam Groszer:
>>>> Hello,
>>>>
>>>> I'm using ZODB in a GUI application, so outside of Zope.
>>>>
>>>> I'm having performance problems. I'm already on the way of figuring
>>>> out what causes a lot of object load. getTransferCounts helped in
>>>> that. But now I would need something more detailed.
>>>>
>>>> Are there any hooks or something to get detailed object load
>>>> statistics?
>>>> Worst case I could hook into some methods of ZODB temporarly to
>>>> collect the data, but into which methods?
>>>>
>>>> Any help or pointers are welcome.
>>>>
>>
>>
>>
>> --
>> Best regards,
>> Adam                            mailto:agroszer at gmail.com
>>
>> _______________________________________________
>> For more information about ZODB, see the ZODB Wiki:
>> http://www.zope.org/Wikis/ZODB/
>>
>> ZODB-Dev mailing list  -  ZODB-Dev at zope.org
>> http://mail.zope.org/mailman/listinfo/zodb-dev
>>

WMA> Master Student-Information Management
WMA> School of Engineering and Technology, AIT
WMA> Klong Luang, Pathumthani 12120,
WMA> Thailand
WMA> Mail Box 1272




-- 
Best regards,
 Groszer Adam                            mailto:adi at alco.co.hu
--
Quote of the day:
Love is a matter of chemistry, but Sex is a matter of physics.