Debian Codegraph @

t/cdbi-t-ocache/11-triggers.t

raw
1 use strict;
2 use Test::More;
3 use Class::DBI::Sweet;
4 Class::DBI::Sweet->default_search_attributes({ use_resultset_cache => 0 });
5 Class::DBI::Sweet->cache(Cache::MemoryCache->new(
6 { namespace => "SweetTest", default_expires_in => 60 } ) );
7
8 BEGIN {
9 eval "use Cache::MemoryCache";
10 plan skip_all => "needs Cache::Cache for testing" if $@;
11 eval "use DBD::SQLite";
12 plan $@ ? (skip_all => 'needs DBD::SQLite for testing') : (tests => 13);
13 }
14
15 use lib 't/cdbi-t/testlib';
16 use Film;
17
18 sub create_trigger2 { ::ok(1, "Running create trigger 2"); }
19 sub delete_trigger { ::ok(1, "Deleting " . shift->Title) }
20
21 sub pre_up_trigger {
22 $_[0]->_attribute_set(numexplodingsheep => 1);
23 ::ok(1, "Running pre-update trigger");
24 }
25 sub pst_up_trigger { ::ok(1, "Running post-update trigger"); }
26
27 sub default_rating { $_[0]->Rating(15); }
28
29 Film->add_trigger(
30 before_create => \&default_rating,
31 );
32 Film->add_trigger(
33 after_create => \&create_trigger2,
34 );
35 Film->add_trigger(
36 after_delete => \&delete_trigger,
37 );
38 Film->add_trigger(
39 before_update => \&pre_up_trigger,
40 );
41 Film->add_trigger(
42 after_update => \&pst_up_trigger,
43 );
44
45 ok(
46 my $ver = Film->insert(
47 {
48 title => 'La Double Vie De Veronique',
49 director => 'Kryzstof Kieslowski',
50
51 # rating => '15',
52 numexplodingsheep => 0,
53 }
54 ),
55 "Create Veronique"
56 );
57
58 is $ver->Rating, 15, "Default rating";
59 is $ver->NumExplodingSheep, 0, "Original sheep count";
60 ok $ver->Rating('12') && $ver->update, "Change the rating";
61 is $ver->NumExplodingSheep, 1, "Updated object's sheep count";
62 is + (
63 $ver->db_Main->selectall_arrayref(
64 'SELECT numexplodingsheep FROM '
65 . $ver->table
66 . ' WHERE '
67 . $ver->primary_column . ' = '
68 . $ver->db_Main->quote($ver->id)
69 )
70 )->[0]->[0], 1, "Updated database's sheep count";
71 ok $ver->delete, "Delete";
72
73 {
74 Film->add_trigger(
75 before_create => sub {
76 my $self = shift;
77 ok !$self->_attribute_exists('title'), "PK doesn't auto-vivify";
78 }
79 );
80 Film->insert({ director => "Me" });
81 }