2 use Test::More tests => 65;
4 use t::common qw( new_fh );
8 my ($fh, $filename) = new_fh();
9 my $db1 = DBM::Deep->new(
15 my $db2 = DBM::Deep->new(
22 is( $db1->{x}, 'y', "Before transaction, DB1's X is Y" );
23 is( $db2->{x}, 'y', "Before transaction, DB2's X is Y" );
25 eval { $db1->rollback };
26 ok( $@, "Attempting to rollback without a transaction throws an error" );
28 eval { $db1->commit };
29 ok( $@, "Attempting to commit without a transaction throws an error" );
33 eval { $db1->begin_work };
34 ok( $@, "Attempting to begin_work within a transaction throws an error" );
36 is( $db1->{x}, 'y', "DB1 transaction started, no actions - DB1's X is Y" );
37 is( $db2->{x}, 'y', "DB1 transaction started, no actions - DB2's X is Y" );
40 is( $db1->{x}, 'z', "Within DB1 transaction, DB1's X is Z" );
41 is( $db2->{x}, 'y', "Within DB1 transaction, DB2's X is still Y" );
43 $db2->{other_x} = 'foo';
44 is( $db2->{other_x}, 'foo', "DB2 set other_x within DB1's transaction, so DB2 can see it" );
45 ok( !exists $db1->{other_x}, "Since other_x was added after the transaction began, DB1 doesn't see it." );
47 cmp_bag( [ keys %$db1 ], [qw( x )], "DB1 keys correct" );
48 cmp_bag( [ keys %$db2 ], [qw( x other_x )], "DB2 keys correct" );
52 is( $db1->{x}, 'y', "After rollback, DB1's X is Y" );
53 is( $db2->{x}, 'y', "After rollback, DB2's X is Y" );
55 is( $db1->{other_x}, 'foo', "After DB1 transaction is over, DB1 can see other_x" );
56 is( $db2->{other_x}, 'foo', "After DB1 transaction is over, DB2 can still see other_x" );
60 is( $db1->{x}, 'y', "DB1 transaction started, no actions - DB1's X is Y" );
61 is( $db2->{x}, 'y', "DB1 transaction started, no actions - DB2's X is Y" );
64 is( $db1->{x}, 'z', "Within DB1 transaction, DB1's X is Z" );
65 is( $db2->{x}, 'y', "Within DB1 transaction, DB2's X is still Y" );
67 $db2->{other_x} = 'bar';
68 is( $db2->{other_x}, 'bar', "DB2 set other_x within DB1's transaction, so DB2 can see it" );
69 is( $db1->{other_x}, 'foo', "Since other_x was modified after the transaction began, DB1 doesn't see the change." );
71 cmp_bag( [ keys %$db1 ], [qw( x other_x )], "DB1 keys correct" );
72 cmp_bag( [ keys %$db2 ], [qw( x other_x )], "DB2 keys correct" );
76 is( $db1->{x}, 'z', "After commit, DB1's X is Z" );
77 is( $db2->{x}, 'z', "After commit, DB2's X is Z" );
81 delete $db2->{other_x};
82 ok( !exists $db2->{other_x}, "DB2 deleted other_x in DB1's transaction, so it can't see it anymore" );
83 is( $db1->{other_x}, 'bar', "Since other_x was deleted after the transaction began, DB1 still sees it." );
85 cmp_bag( [ keys %$db1 ], [qw( x other_x )], "DB1 keys correct" );
86 cmp_bag( [ keys %$db2 ], [qw( x )], "DB2 keys correct" );
89 ok( !exists $db1->{x}, "DB1 deleted X in a transaction, so it can't see it anymore" );
90 is( $db2->{x}, 'z', "But, DB2 can still see it" );
92 cmp_bag( [ keys %$db1 ], [qw( other_x )], "DB1 keys correct" );
93 cmp_bag( [ keys %$db2 ], [qw( x )], "DB2 keys correct" );
97 ok( !exists $db2->{other_x}, "It's still deleted for DB2" );
98 ok( !exists $db1->{other_x}, "And now DB1 sees the deletion" );
100 is( $db1->{x}, 'z', "The transaction was rolled back, so DB1 can see X now" );
101 is( $db2->{x}, 'z', "DB2 can still see it" );
103 cmp_bag( [ keys %$db1 ], [qw( x )], "DB1 keys correct" );
104 cmp_bag( [ keys %$db2 ], [qw( x )], "DB2 keys correct" );
109 ok( !exists $db1->{x}, "DB1 deleted X in a transaction, so it can't see it anymore" );
111 is( $db2->{x}, 'z', "But, DB2 can still see it" );
113 cmp_bag( [ keys %$db1 ], [qw()], "DB1 keys correct" );
114 cmp_bag( [ keys %$db2 ], [qw( x )], "DB2 keys correct" );
118 ok( !exists $db1->{x}, "The transaction was committed, so DB1 still deleted X" );
119 ok( !exists $db2->{x}, "DB2 can now see the deletion of X" );
122 is( $db1->{foo}, 'bar', "Set foo to bar in DB1" );
123 is( $db2->{foo}, 'bar', "Set foo to bar in DB2" );
125 cmp_bag( [ keys %$db1 ], [qw( foo )], "DB1 keys correct" );
126 cmp_bag( [ keys %$db2 ], [qw( foo )], "DB2 keys correct" );
130 %$db1 = (); # clear()
131 ok( !exists $db1->{foo}, "Cleared foo" );
132 is( $db2->{foo}, 'bar', "But in DB2, we can still see it" );
134 cmp_bag( [ keys %$db1 ], [qw()], "DB1 keys correct" );
135 cmp_bag( [ keys %$db2 ], [qw( foo )], "DB2 keys correct" );
139 is( $db1->{foo}, 'bar', "Rollback means 'foo' is still there" );
140 is( $db2->{foo}, 'bar', "Rollback means 'foo' is still there" );
142 cmp_bag( [ keys %$db1 ], [qw( foo )], "DB1 keys correct" );
143 cmp_bag( [ keys %$db2 ], [qw( foo )], "DB2 keys correct" );
146 skip "Optimize tests skipped on Win32", 5
147 if $^O eq 'MSWin32' || $^O eq 'cygwin';
151 is( $db1->{foo}, 'bar', 'After optimize, everything is ok' );
152 is( $db2->{foo}, 'bar', 'After optimize, everything is ok' );
154 cmp_bag( [ keys %$db1 ], [qw( foo )], "DB1 keys correct" );
155 cmp_bag( [ keys %$db2 ], [qw( foo )], "DB2 keys correct" );
159 cmp_ok( $db1->_storage->transaction_id, '==', 1, "Transaction ID has been reset after optimize" );
167 * Two transactions running at the same time
168 * Doing a clear on the head while a transaction is running
169 # More than just two keys