[Catalyst] many to many join with multicolumn primary key

bill hauck wbhauck at yahoo.com
Thu Aug 23 17:28:58 GMT 2012

Hi, Jon.

I tried that and it worked perfectly.

I'll make a small, simple but fully functional example and add it to the wi=
ki this weekend.




> From: jmo mlists <jmo.mlists at gmail.com>
>To: The elegant MVC web framework <catalyst at lists.scsys.co.uk> =

>Sent: Wednesday, August 22, 2012 1:12 PM
>Subject: Re: [Catalyst] many to many join with multicolumn primary key
> =

>On Tue, Aug 21, 2012 at 5:10 PM, bill hauck <wbhauck at yahoo.com> wrote:
>>Posted this to the DBIx::Class maillist, but not getting an traction ther=
e. =A0Perhaps someone else has run into this issue on a Catalyst app.
>>I need to connect two tables through a relation table for a many_to_many.=
 =A0The issue I'm running into is that one of the tables has a composite pr=
imary key. =A0I'm using this in a Catalyst application through a Template T=
oolkit template.
>>So, before going through the whole thing, is it possible to have a compos=
ite primary key used in many to many? =A0If not, any suggestions on a worka=
>>If it is possible, here's my setup. =A0The user will submit issues into c=
omplexity_submission. =A0A trigger will create a duplicate entry in table c=
omplexity giving the unique post id and then a version of the post.
>>Tables, trigger, Schema::Result relations listed, and template below.
>Did you try the way suggested here? http://grokbase.com/t/sc/dbix-class/07=
1g80741a/multi-column-primary-foreign-key =

>List: Catalyst at lists.scsys.co.uk
>Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
>Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
>Dev site: http://dev.catalyst.perl.org/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/catalyst/attachments/20120823/68db0=

More information about the Catalyst mailing list