.\" Automatically generated by Pod::Man 4.09 (Pod::Simple 3.35)
.\"
.\" Standard preamble:
.\" ========================================================================
.de Sp \" Vertical space (when we can't use .PP)
.if t .sp .5v
.if n .sp
..
.de Vb \" Begin verbatim text
.ft CW
.nf
.ne \\$1
..
.de Ve \" End verbatim text
.ft R
.fi
..
.\" Set up some character translations and predefined strings.  \*(-- will
.\" give an unbreakable dash, \*(PI will give pi, \*(L" will give a left
.\" double quote, and \*(R" will give a right double quote.  \*(C+ will
.\" give a nicer C++.  Capital omega is used to do unbreakable dashes and
.\" therefore won't be available.  \*(C` and \*(C' expand to `' in nroff,
.\" nothing in troff, for use with C<>.
.tr \(*W-
.ds C+ C\v'-.1v'\h'-1p'\s-2+\h'-1p'+\s0\v'.1v'\h'-1p'
.ie n \{\
.    ds -- \(*W-
.    ds PI pi
.    if (\n(.H=4u)&(1m=24u) .ds -- \(*W\h'-12u'\(*W\h'-12u'-\" diablo 10 pitch
.    if (\n(.H=4u)&(1m=20u) .ds -- \(*W\h'-12u'\(*W\h'-8u'-\"  diablo 12 pitch
.    ds L" ""
.    ds R" ""
.    ds C` ""
.    ds C' ""
'br\}
.el\{\
.    ds -- \|\(em\|
.    ds PI \(*p
.    ds L" ``
.    ds R" ''
.    ds C`
.    ds C'
'br\}
.\"
.\" Escape single quotes in literal strings from groff's Unicode transform.
.ie \n(.g .ds Aq \(aq
.el       .ds Aq '
.\"
.\" If the F register is >0, we'll generate index entries on stderr for
.\" titles (.TH), headers (.SH), subsections (.SS), items (.Ip), and index
.\" entries marked with X<> in POD.  Of course, you'll have to process the
.\" output yourself in some meaningful fashion.
.\"
.\" Avoid warning from groff about undefined register 'F'.
.de IX
..
.if !\nF .nr F 0
.if \nF>0 \{\
.    de IX
.    tm Index:\\$1\t\\n%\t"\\$2"
..
.    if !\nF==2 \{\
.        nr % 0
.        nr F 2
.    \}
.\}
.\" ========================================================================
.\"
.IX Title "Relationship 3pm"
.TH Relationship 3pm "2018-06-25" "perl v5.26.2" "User Contributed Perl Documentation"
.\" For nroff, turn off justification.  Always turn off hyphenation; it makes
.\" way too many mistakes in technical documents.
.if n .ad l
.nh
.SH "NAME"
Class::DBI::Loader::Relationship \- Easier relationship specification in CDBI::L
.SH "SYNOPSIS"
.IX Header "SYNOPSIS"
.Vb 1
\&  use Class::DBI::Loader::Relationship;
\&
\&  my $loader = Class::DBI::Loader\->new( dsn => "mysql:beerdb",
\&                                        namespace => "BeerDB");
.Ve
.PP
Now instead of saying
.PP
.Vb 2
\&    BeerDB::Brewery\->has_many(beers => "BeerDB::Beer");
\&    BeerDB::Beer\->has_a(brewery => "BeerDB::Brewery");
\&
\&    BeerDB::Handpump\->has_a(beer => "BeerDB::Beer"); 
\&    BeerDB::Handpump\->has_a(pub => "BeerDB::Pub");
\&    BeerDB::Pub\->has_many(beers => [ BeerDB::Handpump => \*(Aqbeer\*(Aq ]);
\&    BeerDB::Beer\->has_many(pubs => [ BeerDB::Handpump => \*(Aqpub\*(Aq ]);
.Ve
.PP
Just say
.PP
.Vb 2
\&    $loader\->relationship( "a brewery produces beers" );
\&    $loader\->relationship( "a pub has beers on handpumps" );
.Ve
.SH "DESCRIPTION"
.IX Header "DESCRIPTION"
This module acts as a mix-in, adding the \f(CW\*(C`relationship\*(C'\fR method to 
\&\f(CW\*(C`Class::DBI::Loader\*(C'\fR. Since \f(CW\*(C`Class::DBI::Loader\*(C'\fR knows how to map
between table names and class names, there ought to be no need to 
replicate the names.
.PP
In addition, it is common (but not universal) to want reverse relationships
defined for has-many relationships, and for has-a relationships to be
defined for the linkages surrounding a many-to-many table.
.PP
The aim of \f(CW\*(C`CDBIL::Relationship\*(C'\fR is to simplify the declaration of 
common database relationships by providing both of these features.
.PP
The \f(CW\*(C`relationship\*(C'\fR takes a string. It recognises table names (singular
or plural, for convenience) and extracts them from the \*(L"sentence\*(R".
.SH "AUTHOR"
.IX Header "AUTHOR"
Simon Cozens, \f(CW\*(C`simon@cpan.org\*(C'\fR
.SH "SEE ALSO"
.IX Header "SEE ALSO"
Class::DBI::Loader.