Morning all,
I'm just about to embark on an exercise that's a sync of sorts from a Pg
database to a mysql database (backend app to public website).
The table(s) I'm interested in do not comprise the whole database, I'm
just pushing data (on demand) for a record and relevant join data.
The table schemas match on both sides, so no evil column mapping to
worry about.
With this in mind, I was wondering if there was some way of doing
something like the psudo-ish code below:
$record = $schema_pg->resultset('MainTable')->find($id);
$coldata_hashref = $record->MAGIC_FUNCTION();
$schema_mysql->create_or_update($coldata_hashref);
I've had a quick run through the docs for ::ResultSet and
::Manual::Cookbook but nothing leaps out as being MAGIC_FUNCTION()
Cheers,
Chisel
--
Chisel Wright
e: [EMAIL PROTECTED]
w: http://www.herlpacker.co.uk/
I would love to change the world but
they won't give me the source code.
_______________________________________________
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]