9 my $schema = DBICTest->init_schema();
11 # Test various new() invocations - this is all about backcompat, making
12 # sure that insert() still works as expected by legacy code.
14 # What we essentially do is multi-instantiate objects, making sure nothing
15 # gets inserted. Then we add some more objects to the mix either via
16 # new_related() or by setting an accessor directly (or both) - again
17 # expecting no inserts. Then after calling insert() on the starter object
18 # we expect everything supplied to new() to get inserted, as well as any
19 # relations whose PK's are necessary to complete the objects supplied
20 # to new(). All other objects should be insert()able afterwards too.
24 my $new_artist = $schema->resultset("Artist")->new_result({ 'name' => 'Depeche Mode' });
25 my $new_related_cd = $new_artist->new_related('cds', { 'title' => 'Leave in Silence', 'year' => 1982});
28 $new_related_cd->insert;
30 is ($@, '', 'Staged insertion successful');
31 ok($new_artist->in_storage, 'artist inserted');
32 ok($new_related_cd->in_storage, 'new_related_cd inserted');
36 my $new_artist = $schema->resultset("Artist")->new_result({ 'name' => 'Depeche Mode' });
37 my $new_related_cd = $new_artist->new_related('cds', { 'title' => 'Leave Slightly Noisily', 'year' => 1982});
39 $new_related_cd->insert;
41 is ($@, '', 'CD insertion survives by finding artist');
42 ok($new_artist->in_storage, 'artist inserted');
43 ok($new_related_cd->in_storage, 'new_related_cd inserted');
47 my $new_cd = $schema->resultset('CD')->new ({ 'title' => 'Leave Loudly While Singing Off Key', 'year' => 1982});
48 my $new_artist = $schema->resultset("Artist")->new ({ 'name' => 'Depeche Mode 2: Insertion Boogaloo' });
49 $new_cd->artist ($new_artist);
54 is ($@, '', 'CD insertion survives by inserting artist');
55 ok($new_cd->in_storage, 'new_related_cd inserted');
56 ok($new_artist->in_storage, 'artist inserted');
58 my $retrieved_cd = $schema->resultset('CD')->find ({ 'title' => 'Leave Loudly While Singing Off Key'});
59 ok ($retrieved_cd, 'CD found in db');
60 is ($retrieved_cd->artist->name, 'Depeche Mode 2: Insertion Boogaloo', 'Correct artist attached to cd');
63 # test both sides of a 1:(1|0)
65 for my $reldir ('might_have', 'belongs_to') {
66 my $artist = $schema->resultset('Artist')->next;
68 my $new_track = $schema->resultset('Track')->new ({
69 title => "$reldir: First track of latest cd",
71 title => "$reldir: Latest cd",
77 my $new_single = $schema->resultset('CD')->new ({
79 title => "$reldir: Awesome first single",
83 if ($reldir eq 'might_have') {
84 $new_track->cd_single ($new_single);
88 $new_single->single_track ($new_track);
92 ok ($new_single->in_storage, "$reldir single inserted");
93 ok ($new_track->in_storage, "$reldir track inserted");
95 my $new_cds = $artist->search_related ('cds',
97 { prefetch => 'tracks', order_by => 'cdid' }
101 [$new_cds->search ({}, { result_class => 'DBIx::Class::ResultClass::HashRefInflator'})->all ],
107 single_track => undef,
108 title => "$reldir: Latest cd",
112 last_updated_at => undef,
113 last_updated_on => undef,
116 title => "$reldir: First track of latest cd",
127 title => "$reldir: Awesome first single",
132 'Expected rows created in database',
135 $new_cds->delete_all;
140 my $new_cd = $schema->resultset("CD")->new_result({});
141 my $new_related_artist = $new_cd->new_related('artist', { 'name' => 'Marillion',});
144 $new_related_artist->insert;
145 $new_cd->title( 'Misplaced Childhood' );
146 $new_cd->year ( 1985 );
147 $new_cd->artist( $new_related_artist ); # For exact backward compatibility
150 'Reversed staged insertion successful'
152 ok($new_related_artist->in_storage, 'related artist inserted');
153 ok($new_cd->in_storage, 'cd inserted');