1 package DBICTest::Schema::BasicRels;
3 use base 'DBIx::Class::Core';
5 DBICTest::Schema::Artist->add_relationship(
6 cds => 'DBICTest::Schema::CD',
7 { 'foreign.artist' => 'self.artistid' },
8 { order_by => 'year', join_type => 'LEFT', cascade_delete => 1 }
10 DBICTest::Schema::Artist->add_relationship(
11 twokeys => 'DBICTest::Schema::TwoKeys',
12 { 'foreign.artist' => 'self.artistid' }
14 DBICTest::Schema::Artist->add_relationship(
15 onekeys => 'DBICTest::Schema::OneKey',
16 { 'foreign.artist' => 'self.artistid' }
19 DBICTest::Schema::CD->add_relationship(
20 artist => 'DBICTest::Schema::Artist',
21 { 'foreign.artistid' => 'self.artist' },
23 DBICTest::Schema::CD->add_relationship(
24 tracks => 'DBICTest::Schema::Track',
25 { 'foreign.cd' => 'self.cdid' },
26 { join_type => 'LEFT', cascade_delete => 1 }
28 DBICTest::Schema::CD->add_relationship(
29 tags => 'DBICTest::Schema::Tag',
30 { 'foreign.cd' => 'self.cdid' },
31 { join_type => 'LEFT', cascade_delete => 1 }
33 #DBICTest::Schema::CD->might_have(liner_notes => 'DBICTest::Schema::LinerNotes' => qw/notes/);
34 DBICTest::Schema::CD->add_relationship(
35 liner_notes => 'DBICTest::Schema::LinerNotes',
36 { 'foreign.liner_id' => 'self.cdid' },
37 { join_type => 'LEFT' }
39 DBICTest::Schema::CD->add_relationship(
40 cd_to_producer => 'DBICTest::Schema::CD_to_Producer',
41 { 'foreign.cd' => 'self.cdid' },
42 { join_type => 'LEFT', cascade_delete => 1 }
45 DBICTest::Schema::SelfRefAlias->add_relationship(
46 self_ref => 'DBICTest::Schema::SelfRef',
47 { 'foreign.id' => 'self.self_ref' },
48 { accessor => 'single' }
51 DBICTest::Schema::SelfRefAlias->add_relationship(
52 alias => 'DBICTest::Schema::SelfRef',
53 { 'foreign.id' => 'self.alias' },
54 { accessor => 'single' }
57 DBICTest::Schema::SelfRef->add_relationship(
58 aliases => 'DBICTest::Schema::SelfRefAlias',
59 { 'foreign.self_ref' => 'self.id' },
60 { accessor => 'multi' }
63 DBICTest::Schema::Tag->add_relationship(
64 cd => 'DBICTest::Schema::CD',
65 { 'foreign.cdid' => 'self.cd' }
68 DBICTest::Schema::Track->add_relationship(
69 cd => 'DBICTest::Schema::CD',
70 { 'foreign.cdid' => 'self.cd' }
73 DBICTest::Schema::TwoKeys->add_relationship(
74 artist => 'DBICTest::Schema::Artist',
75 { 'foreign.artistid' => 'self.artist' }
77 DBICTest::Schema::TwoKeys->add_relationship(
78 cd => 'DBICTest::Schema::CD',
79 { 'foreign.cdid' => 'self.cd' }
82 DBICTest::Schema::CD_to_Producer->add_relationship(
83 cd => 'DBICTest::Schema::CD',
84 { 'foreign.cdid' => 'self.cd' }
86 DBICTest::Schema::CD_to_Producer->add_relationship(
87 producer => 'DBICTest::Schema::Producer',
88 { 'foreign.producerid' => 'self.producer' }
92 DBICTest::Schema::CD->many_to_many( 'producers', 'cd_to_producer', 'producer');