Patch for ? in NoBindVars data from Tom Hukins
[dbsrgits/DBIx-Class-Historic.git] / t / 64db.t
CommitLineData
70350518 1use strict;
2use warnings;
3
4use Test::More;
5use lib qw(t/lib);
6use DBICTest;
7
a47e1233 8my $schema = DBICTest->init_schema();
70350518 9
a953d8d9 10plan tests => 3;
0567538f 11
12# add some rows inside a transaction and commit it
13# XXX: Is storage->dbh the only way to get a dbh?
f9db5527 14$schema->storage->txn_begin;
0567538f 15for (10..15) {
f9db5527 16 $schema->resultset("Artist")->create( {
0567538f 17 artistid => $_,
18 name => "artist number $_",
19 } );
20}
f9db5527 21$schema->storage->txn_commit;
22my ($artist) = $schema->resultset("Artist")->find(15);
0567538f 23is($artist->name, 'artist number 15', "Commit ok");
24
0567538f 25# add some rows inside a transaction and roll it back
f9db5527 26$schema->storage->txn_begin;
0567538f 27for (21..30) {
f9db5527 28 $schema->resultset("Artist")->create( {
0567538f 29 artistid => $_,
30 name => "artist number $_",
31 } );
32}
f9db5527 33$schema->storage->txn_rollback;
34($artist) = $schema->resultset("Artist")->search( artistid => 25 );
0567538f 35is($artist, undef, "Rollback ok");
36
a953d8d9 37my $type_info = $schema->storage->columns_info_for('artist');
b3caf56c 38
39# I know this is gross but SQLite reports the size differently from release
40# to release. At least this way the test still passes.
41
42delete $type_info->{artistid}{size};
43delete $type_info->{name}{size};
44
a953d8d9 45my $test_type_info = {
46 'artistid' => {
fc22fbac 47 'data_type' => 'INTEGER',
48 'is_nullable' => 0,
a953d8d9 49 },
50 'name' => {
fc22fbac 51 'data_type' => 'varchar',
52 'is_nullable' => 0,
93cec8c3 53 },
a953d8d9 54};
55is_deeply($type_info, $test_type_info, 'columns_info_for - column data types');
56