| 1 |
package Film; |
| 2 |
|
| 3 |
BEGIN { unshift @INC, './t/cdbi-t/testlib'; } |
| 4 |
use base 'Class::DBI::Test::SQLite'; |
| 5 |
use strict; |
| 6 |
|
| 7 |
__PACKAGE__->set_table('Movies'); |
| 8 |
__PACKAGE__->columns('Primary', 'Title'); |
| 9 |
__PACKAGE__->columns('Essential', qw( Title )); |
| 10 |
__PACKAGE__->columns('Directors', qw( Director CoDirector )); |
| 11 |
__PACKAGE__->columns('Other', qw( Rating NumExplodingSheep HasVomit )); |
| 12 |
|
| 13 |
sub create_sql { |
| 14 |
return qq{ |
| 15 |
title VARCHAR(255), |
| 16 |
director VARCHAR(80), |
| 17 |
codirector VARCHAR(80), |
| 18 |
rating CHAR(5), |
| 19 |
numexplodingsheep INTEGER, |
| 20 |
hasvomit CHAR(1) |
| 21 |
} |
| 22 |
} |
| 23 |
|
| 24 |
sub create_test_film { |
| 25 |
return shift->insert( |
| 26 |
{ |
| 27 |
Title => 'Bad Taste', |
| 28 |
Director => 'Peter Jackson', |
| 29 |
Rating => 'R', |
| 30 |
NumExplodingSheep => 1, |
| 31 |
} |
| 32 |
); |
| 33 |
} |
| 34 |
|
| 35 |
package DeletingFilm; |
| 36 |
|
| 37 |
use base 'Film'; |
| 38 |
sub DESTROY { shift->delete } |
| 39 |
|
| 40 |
1; |
| 41 |
|