On Wed, 4 Mar 2009, Dermot wrote:
2009/3/4 Jonathan Yu <[email protected]>:
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.
Thanx Jonathan. I did it the hackish way. I was a single table so the
structure was easy to store. This was for an SQLite3 db which doesn't
have a dump function quite yet. It does have a realitvely new backup
function (http://www.sqlite.org/backup.html).
Mine does, which sqlite3 are you using?
sqlite3 mydb.db ".dump"
IIRC, works in the CLI anyways..
Jess
_______________________________________________
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]
