Commit | Line | Data |
---|---|---|
8273e845 | 1 | package # hide from PAUSE |
b8b55c8e | 2 | DBICTest::Schema::CustomSql; |
3 | ||
4 | use base qw/DBICTest::Schema::Artist/; | |
5 | ||
6 | __PACKAGE__->table('dummy'); | |
7 | ||
8 | __PACKAGE__->result_source_instance->name(\<<SQL); | |
8273e845 | 9 | ( SELECT a.*, cd.cdid AS cdid, cd.title AS title, cd.year AS year |
b8b55c8e | 10 | FROM artist a |
11 | JOIN cd ON cd.artist = a.artistid | |
12 | WHERE cd.year = ?) | |
13 | SQL | |
14 | ||
39be4120 | 15 | sub sqlt_deploy_hook { $_[1]->schema->drop_table($_[1]) } |
16 | ||
b8b55c8e | 17 | 1; |