Hi there: You can dump the Schema object into SQL, but I'm not sure if it also dumps the appropriate INSERTs... Look in SQL::Translator, that's where you're most likely to find something like that (SQLT is the backend that does some of the nitty-gritty on behalf of DBIC)
Storable seems like a hackish way to do things. Personally I would suggest you dump SQL. Cheers, Jonathan On Mon, Mar 2, 2009 at 12:11 PM, Dermot <[email protected]> wrote: > Hi, > > Are there an short-hand methods I can use to dump the contents of a > table (SQLite3) to disk. I was going to use $rs->next and stick the > results in a Storable file, then drop the table, re-create the table > structure I want and populate the data back. I suspect there might be > a means to do this but I can't see it in ::Storage or the Cookbook. > > Thanx, > Dp. > > _______________________________________________ > List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class > IRC: irc.perl.org#dbix-class > SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ > Searchable Archive: http://www.grokbase.com/group/[email protected] > _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[email protected]
