1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
|
use strict;
use warnings;
use Test::More;
use Test::Deep;
use lib qw(t/lib);
use DBICTest;
my $schema = DBICTest->init_schema();
plan tests => 4;
# add some rows inside a transaction and commit it
# XXX: Is storage->dbh the only way to get a dbh?
$schema->storage->txn_begin;
for (10..15) {
$schema->resultset("Artist")->create( {
artistid => $_,
name => "artist number $_",
} );
}
$schema->storage->txn_commit;
my ($artist) = $schema->resultset("Artist")->find(15);
is($artist->name, 'artist number 15', "Commit ok");
# add some rows inside a transaction and roll it back
$schema->storage->txn_begin;
for (21..30) {
$schema->resultset("Artist")->create( {
artistid => $_,
name => "artist number $_",
} );
}
$schema->storage->txn_rollback;
($artist) = $schema->resultset("Artist")->search({ artistid => 25 });
is($artist, undef, "Rollback ok");
is_deeply (
get_storage_column_info ($schema->storage, 'collection', qw/size is_nullable/),
{
collectionid => {
data_type => 'INTEGER',
},
name => {
data_type => 'varchar',
},
},
'Correctly retrieve column info (no size or is_nullable)'
);
{
cmp_deeply (
get_storage_column_info ($schema->storage, 'artist', qw/size/),
{
'artistid' => {
'data_type' => 'INTEGER',
'is_nullable' => 0,
},
'name' => {
'data_type' => 'varchar',
'is_nullable' => 1,
},
'rank' => {
'data_type' => re(qr/^integer$/i),
'is_nullable' => 0,
'default_value' => '13',
},
'charfield' => {
'data_type' => 'char',
'is_nullable' => 1,
},
},
'Correctly retrieve column info (mixed null and non-null columns)'
);
};
# Depending on test we need to strip away certain column info.
# - SQLite is known to report the size differently from release to release
# - Current DBD::SQLite versions do not implement NULLABLE
# - Some SQLite releases report stuff that isn't there as undef
sub get_storage_column_info {
my ($storage, $table, @ignore) = @_;
my $type_info = $storage->columns_info_for($table);
for my $col (keys %$type_info) {
for my $type (keys %{$type_info->{$col}}) {
if (
grep { $type eq $_ } (@ignore)
or
not defined $type_info->{$col}{$type}
) {
delete $type_info->{$col}{$type};
}
}
}
return $type_info;
}
|
