[dbsrgits/DBIx-Class-Historic.git] / t / lib / DBICTest / Schema / CustomSql.pm

package # hide from PAUSE 
    DBICTest::Schema::CustomSql;

use base qw/DBICTest::Schema::Artist/;

__PACKAGE__->table('dummy');

__PACKAGE__->result_source_instance->name(\<<SQL);
  ( SELECT a.*, cd.cdid AS cdid, cd.title AS title, cd.year AS year 
  FROM artist a
  JOIN cd ON cd.artist = a.artistid
  WHERE cd.year = ?)
SQL

sub sqlt_deploy_hook { $_[1]->schema->drop_table($_[1]) }

1;
Commit	Line	Data
b8b55c8e	1	package # hide from PAUSE
	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);
	9	( SELECT a.*, cd.cdid AS cdid, cd.title AS title, cd.year AS year
	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]) }
39be4120	16
b8b55c8e	17	1;