sub run_tests {
+my $schema = shift;
plan tests => 3;
# add some rows inside a transaction and commit it
# XXX: Is storage->dbh the only way to get a dbh?
-DBICTest::Artist->storage->dbh->{AutoCommit} = 0;
+$schema->storage->txn_begin;
for (10..15) {
- DBICTest::Artist->create( {
+ $schema->resultset("Artist")->create( {
artistid => $_,
name => "artist number $_",
} );
}
-DBICTest::Artist->dbi_commit;
-my ($artist) = DBICTest::Artist->find(15);
+$schema->storage->txn_commit;
+my ($artist) = $schema->resultset("Artist")->find(15);
is($artist->name, 'artist number 15', "Commit ok");
-# repeat the test using AutoCommit = 1 to force the commit
-DBICTest::Artist->storage->dbh->{AutoCommit} = 0;
-for (16..20) {
- DBICTest::Artist->create( {
- artistid => $_,
- name => "artist number $_",
- } );
-}
-DBICTest::Artist->storage->dbh->{AutoCommit} = 1;
-($artist) = DBICTest::Artist->find(20);
-is($artist->name, 'artist number 20', "Commit using AutoCommit ok");
-
# add some rows inside a transaction and roll it back
-DBICTest::Artist->storage->dbh->{AutoCommit} = 0;
+$schema->storage->txn_begin;
for (21..30) {
- DBICTest::Artist->create( {
+ $schema->resultset("Artist")->create( {
artistid => $_,
name => "artist number $_",
} );
}
-DBICTest::Artist->dbi_rollback;
-($artist) = DBICTest::Artist->search( artistid => 25 );
+$schema->storage->txn_rollback;
+($artist) = $schema->resultset("Artist")->search( artistid => 25 );
is($artist, undef, "Rollback ok");
+my $type_info = $schema->storage->columns_info_for('artist');
+my $test_type_info = {
+ 'artistid' => {
+ 'data_type' => 'INTEGER'
+ },
+ 'name' => {
+ 'data_type' => 'varchar'
+ }
+};
+is_deeply($type_info, $test_type_info, 'columns_info_for - column data types');
+
}
1;