perrin,

Thanks for the solution.. I really failed to consider the fact that Class::DBI allows you to add your own methods, but I was really hoping that the relationships could be setup programatically through the interface and have everything work together very nicely. The lack of multiple column foreign keys really smacks me as a shortcoming, as it's an idiom I use pretty frequently.

I'm not sure what you mean about the two-thirds many-to-many mapping. I'm writing this database for a store of sorts, as a way to help them track inventory and other items of interest. The idea of the baseitems table is that it tracks the basic item information, it's name, weight, supplier and wholesale price. The items table turns the baseitems into "packages" of items, so to speak.

So, you have an item in the baseitems table like a "#5 bolt" and all it's information, then you have a retail package in the items table like "package of 10 #5 bolts" or "package of 50 #5 bolts" that contains pricing and and unit count information.

So, each baseitem relates to several members in the item table, and each member of the item table relates back to exactly one baseitem.

In reply to Re: Re: Class::DBI multiple column primary and foreign keys by hangareighteen
in thread Class::DBI multiple column primary and foreign keys by hangareighteen

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.