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.