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
|
package MyFoo;
BEGIN { unshift @INC, './t/testlib'; }
use base 'MyBase';
use strict;
use Class::DBI::Column;
__PACKAGE__->set_table();
__PACKAGE__->columns(
All => qw/myid name val/,
Class::DBI::Column->new(tdate => { placeholder => 'IF(1, CURDATE(), ?)' })
);
__PACKAGE__->has_a(
tdate => 'Date::Simple',
inflate => sub { Date::Simple->new(shift) },
deflate => 'format',
);
sub create_sql {
return qq{
myid mediumint not null auto_increment primary key,
name varchar(50) not null default '',
val char(1) default 'A',
tdate date not null
};
}
1;
|
