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