X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F71mysql.t;h=a326dda7c7d841a3cfe2381d906bae64ec8f287d;hb=2bf79155a8be1532cce2538e967f32c4ff22a87b;hp=3d538202aa1506713ff35a534f313aacc3df2b62;hpb=adb3554a3f72bf9c9b267c5eb84a8401da64bf37;p=dbsrgits%2FDBIx-Class.git diff --git a/t/71mysql.t b/t/71mysql.t index 3d53820..a326dda 100644 --- a/t/71mysql.t +++ b/t/71mysql.t @@ -5,7 +5,6 @@ use Test::More; use lib qw(t/lib); use DBICTest; use DBI::Const::GetInfoType; -use DBICTest::Stats; my ($dsn, $user, $pass) = @ENV{map { "DBICTEST_MYSQL_${_}" } qw/DSN USER PASS/}; @@ -14,18 +13,15 @@ my ($dsn, $user, $pass) = @ENV{map { "DBICTEST_MYSQL_${_}" } qw/DSN USER PASS/}; plan skip_all => 'Set $ENV{DBICTEST_MYSQL_DSN}, _USER and _PASS to run this test' unless ($dsn && $user); -plan tests => 9; +plan tests => 5; my $schema = DBICTest::Schema->connect($dsn, $user, $pass); my $dbh = $schema->storage->dbh; -my $stats = new DBICTest::Stats(); -$schema->storage->debugobj($stats); -$schema->storage->debug(1); $dbh->do("DROP TABLE IF EXISTS artist;"); -$dbh->do("CREATE TABLE artist (artistid INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255), charfield CHAR(10)) ENGINE=InnoDB;"); +$dbh->do("CREATE TABLE artist (artistid INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255), charfield CHAR(10));"); #'dbi:mysql:host=localhost;database=dbic_test', 'dbic_test', ''); @@ -72,32 +68,6 @@ my $test_type_info = { }, }; -$schema->txn_begin(); - -my $arty = $schema->resultset('Artist')->find(1); - -my $name = $arty->name(); - -$schema->svp_begin('savepoint1'); - -cmp_ok($stats->{'SVP_BEGIN'}, '==', 1, 'Statistics svp_begin tickled'); - -$arty->update({ name => 'Jheephizzy' }); - -$arty->discard_changes(); - -cmp_ok($arty->name(), 'eq', 'Jheephizzy', 'Name changed'); - -$schema->svp_rollback('savepoint1'); - -cmp_ok($stats->{'SVP_ROLLBACK'}, '==', 1, 'Statistics svp_rollback tickled'); - -$arty->discard_changes(); - -cmp_ok($arty->name(), 'eq', $name, 'Name rolled back'); - -$schema->txn_commit(); - SKIP: { my $mysql_version = $dbh->get_info( $GetInfoType{SQL_DBMS_VER} ); skip "Cannot determine MySQL server version", 1 if !$mysql_version;