Re: Migrating a substanceD zodb database to postgres

Jim Fulton <[email protected]> Fri, 2 Feb 2018 18:21:31 -0700
Newsgroups gmane.comp.web.zope.zodb
Message-ID <CAPDm-Fj-Rhmc-14VADXf8LppLYWASpeYkH8jGsTejs2S89QbNw@mail.gmail.com>
On Fri, Feb 2, 2018 at 1:57 PM, Jo Gilder <[email protected]>
wrote:

> Hi, so I have been tasked with migrating our data.fs to a postgres
> database,the file was created from a substanceD scaffold application.
>
> If I open it from within my substanceD application then I can see all the
> objects and I can see all the references using objectmap and a dump script
> is relatively trivial (!)
>
> I would however like to have a separate python application to open the
> data.fs, read out the properties of the objects and save them to postgres.
> I have my django app (department standard now:)) and I have zodb and
> substanced installed in the virtual environment.
>
>  I get objects with __Broken_state and that's all fine as I know the
> properties of the objects and I can just iterate through the folders and
> read them off. However - I am not easily able to sort out the references.
> In substanceD, the references are not stored on the objects they are
> connecting but on something called the objectmap. I can get an instance of
> objectmap class in my new code but none of the methods work as they are all
> expecting full information about the objects rather than broken ones.
>
> So, I probably need to install more of my original substanceD project -
> exactly how much do  you think I will need so the objects aren't actually
> broken?
>

I would install all of the packages. (You could install less, but then
you'd have to figure out which ones you could skip. Why work that hard?)

Jim

-- 
Jim Fulton
http://jimfulton.info

-- 
You received this message because you are subscribed to the Google Groups "zodb" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [email protected].
For more options, visit https://groups.google.com/d/optout.