1 package Schema3::Result::Person;
6 use base 'DBIx::Class::Core';
8 __PACKAGE__->table('person');
10 __PACKAGE__->add_columns(
12 data_type => 'integer',
13 is_auto_increment => 1,
16 data_type => 'varchar',
27 __PACKAGE__->set_primary_key('id');
30 __PACKAGE__->resultset_attributes({
31 '+select' => [ \'weight/height' ],
32 '+as' => [ 'weight_to_height_ratio' ],
40 use base 'DBIx::Class::Schema';
42 __PACKAGE__->register_class(Person => 'Schema3::Result::Person');
50 my $sql = (my $schema = shift)
53 ($schema->storage->dbh->do($_) ||
54 die "Error on SQL: $_\n")
55 for split(/;\n/, $sql);
62 id INTEGER PRIMARY KEY NOT NULL,
63 name varchar(255) NOT NULL,
64 weight FLOAT NOT NULL,
68 INSERT INTO person (name, weight, height)
70 ('Fred Flintstone', 220, 5.2),
71 ('Barney Rubble', 190, 4.8)