Relationships:

Depends on what you want to be able to see from what other thing.. Do you want to be able to list images from a gallery? Do you want to be able to get the galleries an image is in? All that is is the reverse of the previous relationship, i.e.: 

  # in Images:
  __PACKAGE__->has_many('GalleryMaps' => 'Gallery::Model::DBIC::Galler
+yMap', 'iid');

  # in GalleryMap:
  __PACKAGE__->belongs_to('iid' => 'Gallery::Model::DBIC::Images');
  __PACKAGE__->belongs_to('gid' => 'Gallery::Model::DBIC::Galleries');

  # in Galleries
  __PACKAGE__->has_many('GalleryMap' => 'Gallery::Model::DBIC::Gallery
+Map', 'gid');

[download]
Now, using the latest release, which is 0.05, you can do: 
  # Get images in a gallery, assuming $g is a gallery:
my @images = $g->GalleryMaps->search_related('iid');

 # Get galleries an image is in, assuming $i is an image:
my @galleries = $i->GalleryMaps->search_releated('gid');

[download]

.. All code untested, but thats how it works.. The actual joins between the tables will be done behind the scenes. Try setting DBIX_CLASS_STORAGE_DBI_DEBUG=1 in your shell environment, to see the SQL queries it creates.

C.

In reply to Re: Help with joins in DBIx::Class by castaway
in thread Help with joins in DBIx::Class by suaveant

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.