1 package ExtraTest::Schema::Result::Photo;
6 use base 'DBIx::Class::Core';
8 __PACKAGE__->load_components(qw/InflateColumn::FS/);
9 __PACKAGE__->table('photo');
11 __PACKAGE__->add_columns(
13 data_type => 'integer',
14 is_auto_increment => 1,
17 data_type => 'varchar',
21 data_type => 'varchar',
24 fs_column_path =>'./t/var/files',
27 __PACKAGE__->set_primary_key('photo_id');
29 package ExtraTest::Schema;
34 use base 'DBIx::Class::Schema';
36 __PACKAGE__->register_class(
37 Photo => 'ExtraTest::Schema::Result::Photo');
45 my $sql = (my $schema = shift)
48 ($schema->storage->dbh->do($_) ||
49 die "Error on SQL: $_\n")
50 for split(/;\n/, $sql);
57 photo_id INTEGER PRIMARY KEY NOT NULL,
58 photographer varchar(40) NOT NULL,
59 file varchar(255) NOT NULL