X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2Flib%2FDBICTest.pm;h=cb3ae57cb6ead904289ceb74ff77e6b6d9ad4de9;hb=7036ea600aa0fe23664b5a7e085eca335b76576c;hp=e691999342ebd37fcf46c11a1860107588a72f33;hpb=ab8481f509e0c74b2dbe61441564c250b457193e;p=dbsrgits%2FDBIx-Class-Historic.git diff --git a/t/lib/DBICTest.pm b/t/lib/DBICTest.pm index e691999..cb3ae57 100755 --- a/t/lib/DBICTest.pm +++ b/t/lib/DBICTest.pm @@ -55,7 +55,8 @@ sub init_schema { my $dbuser = $ENV{"DBICTEST_DBUSER"} || ''; my $dbpass = $ENV{"DBICTEST_DBPASS"} || ''; - my $schema = DBICTest::Schema->compose_connection('DBICTest' => $dsn, $dbuser, $dbpass); + my $schema = DBICTest::Schema->compose_namespace('DBICTest') + ->connect($dsn, $dbuser, $dbpass); $schema->storage->on_connect_do(['PRAGMA synchronous = OFF']); if ( !$args{no_deploy} ) { __PACKAGE__->deploy_schema( $schema ); @@ -87,7 +88,7 @@ sub deploy_schema { my $sql; { local $/ = undef; $sql = ; } close IN; - $schema->storage->dbh->do($_) for split(/;\n/, $sql); + ($schema->storage->dbh->do($_) || print "Error on SQL: $_\n") for split(/;\n/, $sql); } } @@ -104,21 +105,11 @@ sub populate_schema { my $self = shift; my $schema = shift; - $schema->populate('Label', [ - [ qw/labelid name/ ], - [ 1, 'Acme Records' ], - ]); - - $schema->populate('Agent', [ - [ qw/agentid label name/ ], - [ 1, 1, 'Ted' ], - ]); - $schema->populate('Artist', [ - [ qw/artistid agent name/ ], - [ 1, 1, 'Caterwauler McCrae' ], - [ 2, 1, 'Random Boy Band' ], - [ 3, 1, 'We Are Goth' ], + [ qw/artistid name/ ], + [ 1, 'Caterwauler McCrae' ], + [ 2, 'Random Boy Band' ], + [ 3, 'We Are Goth' ], ]); $schema->populate('CD', [ @@ -235,14 +226,51 @@ sub populate_schema { ]); $schema->populate('Link', [ - [ qw/id title/ ], - [ 1, 'aaa' ] + [ qw/id url title/ ], + [ 1, '', 'aaa' ] ]); $schema->populate('Bookmark', [ [ qw/id link/ ], [ 1, 1 ] ]); + + $schema->populate('Collection', [ + [ qw/collectionid name/ ], + [ 1, "Tools" ], + [ 2, "Body Parts" ], + ]); + + $schema->populate('CollectionObject', [ + [ qw/collection object/ ], + [ 1, 1 ], + [ 1, 2 ], + [ 1, 3 ], + [ 2, 4 ], + [ 2, 5 ], + ]); + + $schema->populate('TypedObject', [ + [ qw/objectid type value/ ], + [ 1, "pointy", "Awl" ], + [ 2, "round", "Bearing" ], + [ 3, "pointy", "Knife" ], + [ 4, "pointy", "Tooth" ], + [ 5, "round", "Head" ], + ]); + + $schema->populate('Owners', [ + [ qw/ownerid name/ ], + [ 1, "Newton" ], + [ 2, "Waltham" ], + ]); + + $schema->populate('BooksInLibrary', [ + [ qw/id owner title source/ ], + [ 1, 1, "Programming Perl", "Library" ], + [ 2, 1, "Dynamical Systems", "Library" ], + [ 3, 2, "Best Recipe Cookbook", "Library" ], + ]); } 1;