On 08/12/06, Diez B. Roggisch <[EMAIL PROTECTED]> wrote: > > BUT if you have a model, which you used to create the sqlite DB with, > > chances > > are that you could make things work. Because then you could try and create a > > pickle or something from a in-memory representation of your object graph, > > switch the DB-config, and store it away again. However, I'm not aware of an > > existing solution. > > After reading the thread on the TG list, I see that you _have_ the model. > > Hm. What about making the model picklable, and trying to dump it with > pickle when read from postgres, then reading the pickle into a model > that is configured with the postgres? > > I'm not sure though if the pickling stuff collides with the SO-magic. > Especially object creation, since there might be all kinds of state > being needed that isn't exactly reproducable with a pickle, as no > __init__ is called.
So far, writing something that iterates through all my tables, puts all the data in dictionaries, pickles them, reconnects to a different database, then writes them back out again, seems to be the 'eaiest' solution. But it also seems not that much better than using csv files. It just seems like it should be possible to tell SQLObject to write the sql to file, rather than execute it. Ed ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
