Hi DBIx::Class hackers
Let's say we have two unrelated tables, "tag" and "asset", each with their own
sequence of auto-incrementing IDs (so of course the same ID may occur in
both, for records unrelated to each other).
Now suppose there is a third table, "edits", set up with a record to allow users
to log edits to records in either of the above tables. So we define this table
by:
CREATE TABLE `edit_log`
(
`id` int(11) NOT NULL auto_increment,
object_type ENUM('tag', 'asset'),
object_id int(11) NOT NULL,
`comment` text,
:::
);
My question is how does one represent the extra condition on object type
to define this "one or other" relationship in the DBIx::Class module for
the edit_log table, and for that matter in the "tag" and "asset" tables?
Presumably in EditLog.pm it needs to be something along the lines of:
__PACKAGE__->has_one (asset => 'Ethel::Schema::Asset',
{ 'self.object_id' => 'foreign.id' },
{ -is => { 'self.object_type' => 'asset' } );
__PACKAGE__->has_one (tag => 'Ethel::Schema::Tag',
{ 'self.object_id' => 'foreign.id'
{ -is => { 'self.object_type' => 'tag' } );
I'm fairly sure the "-is" syntax is wrong, but that is basically
my question. How should this condition be expressed?
I did check the documentation, but found no examples of how
to express extra conditions.
Many thanks in anticipation for any replies.
Regards
John Ramsden
_______________________________________________
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]
