#!/usr/bin/perl -w use strict; use Test::More tests => 4; BEGIN { require 't/test-lib.pl'; use_ok('Rose::DB::Object'); } our %Have; # # Tests # foreach my $db_type (qw(mysql)) { SKIP: { skip("$db_type tests", 3) unless($Have{$db_type}); } next unless($Have{$db_type}); Rose::DB->default_type($db_type); my $class = ucfirst($db_type) . 'Foo'; my $o = $class->new(name => 'f1: ' . localtime(), children => [ { name => 'c1: ' . localtime() }, { name => 'c2: ' . localtime() }, ]); $o->save; my $p = $class->new(id => $o->id); ok($p->load, "parent - $db_type"); my $c1 = $class->new(id => $o->children->[0]->id); ok($c1->load, "child 1 - $db_type"); my $c2 = $class->new(id => $o->children->[1]->id); ok($c2->load, "child 2 - $db_type"); } BEGIN { our %Have; # # MySQL # my $dbh; eval { my $db = Rose::DB->new('mysql_admin'); $dbh = $db->retain_dbh or die Rose::DB->error; # Drop existing tables, ignoring errors { local $dbh->{'RaiseError'} = 0; local $dbh->{'PrintError'} = 0; $dbh->do('DROP TABLE rose_db_object_test_foo'); $dbh->do('DROP TABLE rose_db_object_test_foo_parent'); } }; if(!$@ && $dbh) { $Have{'mysql'} = 1; $dbh->do(<<"EOF"); CREATE TABLE rose_db_object_test_foo ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255) NOT NULL, UNIQUE(name) ) EOF $dbh->do(<<"EOF"); CREATE TABLE rose_db_object_test_foo_parent ( parent_id INT UNSIGNED NOT NULL REFERENCES rose_db_object_test_foo (id), child_id INT UNSIGNED NOT NULL REFERENCES rose_db_object_test_foo (id), PRIMARY KEY(parent_id, child_id) ) EOF $dbh->disconnect; Rose::DB->default_type('mysql'); package MysqlFoo; our @ISA = qw(Rose::DB::Object); MysqlFoo->meta->table('rose_db_object_test_foo'); MysqlFoo->meta->columns(qw(id name)); MysqlFoo->meta->primary_key_columns('id'); MysqlFoo->meta->add_unique_key('name'); MysqlFoo->meta->relationships ( parents => { type => 'many to many', map_class => 'MysqlFooParent', map_from => 'child', map_to => 'parent', }, children => { type => 'many to many', map_class => 'MysqlFooParent', map_from => 'parent', map_to => 'child', }, ); MysqlFoo->meta->initialize; package MysqlFooParent; our @ISA = qw(Rose::DB::Object); MysqlFooParent->meta->table('rose_db_object_test_foo_parent'); MysqlFooParent->meta->columns(qw(parent_id child_id)); MysqlFooParent->meta->primary_key_columns(qw(parent_id child_id)); MysqlFooParent->meta->foreign_keys ( parent => { class => 'MysqlFoo', key_columns => { parent_id => 'id' } }, child => { class => 'MysqlFoo', key_columns => { child_id => 'id' } }, ); MysqlFooParent->meta->initialize; } } END { # Delete test tables if($Have{'mysql'}) { # MySQL my $dbh = Rose::DB->new('mysql_admin')->retain_dbh() or die Rose::DB->error; $dbh->do('DROP TABLE rose_db_object_test_foo'); $dbh->do('DROP TABLE rose_db_object_test_foo_parent'); $dbh->disconnect; } }