Hi,<br><br>I am new to Catalyst and DBIx::Class, trying to use many_to_many relationship.<br><br>I have 3 tables, users, user_groups, and group, table structure and relationship are setup as follows.<br><br>User.pm<br><br>
__PACKAGE__->add_columns(<br> "id",<br> { data_type => "integer", is_nullable => 0 },<br> "username",<br> { data_type => "text", is_nullable => 1 },<br> "password",<br>
{ data_type => "text", is_nullable => 1 },<br> "email_address",<br> { data_type => "text", is_nullable => 1 },<br> "first_name",<br> { data_type => "text", is_nullable => 1 },<br>
"last_name",<br> { data_type => "text", is_nullable => 1 },<br> "active",<br> { data_type => "integer", is_nullable => 1 },<br>);<br>__PACKAGE__->set_primary_key("id");<br>
<br>__PACKAGE__->has_many("usergroups", "Example::Schema::Result::UserGroup",{ "foreign.user_id" => "<a href="http://self.id">self.id</a>" },);<br>__PACKAGE__->many_to_many(group => 'usergroups', 'group');<br>
<br>UserGroup.pm<br><br>__PACKAGE__->add_columns(<br> "user_id",<br> { data_type => "integer", is_nullable => 0 },<br> "group_id",<br> { data_type => "integer", default_value => 0, is_nullable => 0 },<br>
);<br>__PACKAGE__->set_primary_key("user_id", "group_id");<br><br>__PACKAGE__->belongs_to("user", "Example::Schema::Result::User", { id => "user_id" },{ join_type => "LEFT" },);<br>
__PACKAGE__->belongs_to("group", "Example::Schema::Result::Group", { id => "group_id" },{ join_type => "LEFT" },);<br><br>Group.pm<br><br>__PACKAGE__->add_columns(<br> "id",<br>
{ data_type => "integer", is_nullable => 0 },<br> "group",<br> { data_type => "text", is_nullable => 0 },<br>);<br>__PACKAGE__->set_primary_key("id");<br><br>__PACKAGE__->has_many("usergroup","Example::Schema::Result::UserGroup",{ "foreign.group_id" => "<a href="http://self.id">self.id</a>" },);<br>
<br>Can anyone tell me how I can retrieve all the users who are member of a group called 'manager'?<br><br>Thanks <br>