Fix updating multiple CLOB/BLOB columns on Oracle

[dbsrgits/DBIx-Class.git] / t / 82cascade_copy.t

use strict;
use warnings;

use Test::More;
use lib qw(t/lib);
use DBICTest;

my $schema = DBICTest->init_schema();

my $artist = $schema->resultset('Artist')->find(1);
my $artist_cds = $artist->search_related('cds');

my $cover_band = $artist->copy ({name => $artist->name . '_cover' });

my $cover_cds = $cover_band->search_related('cds');
cmp_ok($cover_band->id, '!=', $artist->id, 'ok got new column id...');
is($cover_cds->count, $artist_cds->count, 'duplicated rows count ok');

#check multi-keyed
is(
  $cover_band->search_related('twokeys')->count,
  $artist->search_related('twokeys')->count,
  'duplicated multiPK ok'
);

#and check copying a few relations away
cmp_ok($cover_cds->search_related('tags')->count, '==',
   $artist_cds->search_related('tags')->count , 'duplicated count ok');


# check from the other side
my $cd = $schema->resultset('CD')->find(1);
my $dup_cd = $cd->copy ({ title => 'ha!' });
is(
  $dup_cd->search_related('twokeys')->count,
  $cd->search_related('twokeys')->count,
  'duplicated multiPK ok'
);

done_testing;