use warnings;
use DBIx::Class::ResultSet;
-use Devel::Dwarn;
use base qw/DBIx::Class/;
__PACKAGE__->load_components(qw/ResultSource/);
=head1 SYNOPSIS
- package MyDB::Schema::Result::Year2000CDs;
+ package MyApp::Schema::Result::Year2000CDs;
use base qw/DBIx::Class::Core/;
=head1 EXAMPLES
-Having created the MyDB::Schema::Year2000CDs schema as shown in the SYNOPSIS
+Having created the MyApp::Schema::Year2000CDs schema as shown in the SYNOPSIS
above, you can then:
- $2000_cds = $schema->resultset('Year2000CDs')
- ->search()
- ->all();
- $count = $schema->resultset('Year2000CDs')
- ->search()
- ->count();
+ $y2000_cds = $schema->resultset('Year2000CDs')
+ ->search()
+ ->all();
+ $count = $schema->resultset('Year2000CDs')
+ ->search()
+ ->count();
If you modified the schema to include a placeholder
__PACKAGE__->result_source_instance->view_definition(
- "SELECT cdid, artist, title FROM cd WHERE year ='?'"
+ "SELECT cdid, artist, title FROM cd WHERE year = ?"
);
and ensuring you have is_virtual set to true:
You could now say:
- $2001_cds = $schema->resultset('Year2000CDs')
- ->search({}, { bind => [2001] })
- ->all();
- $count = $schema->resultset('Year2000CDs')
- ->search({}, { bind => [2001] })
- ->count();
+ $y2001_cds = $schema->resultset('Year2000CDs')
+ ->search({}, { bind => [2001] })
+ ->all();
+ $count = $schema->resultset('Year2000CDs')
+ ->search({}, { bind => [2001] })
+ ->count();
=head1 SQL EXAMPLES
$schema->resultset('Year2000CDs')->all();
- SELECT cdid, artist, title FROM
+ SELECT cdid, artist, title FROM
(SELECT cdid, artist, title FROM cd WHERE year ='2000') me
=back
An SQL query for your view. Will not be translated across database
syntaxes.
-=head2 deploy_depends_on
+=head2 deploy_depends_on
__PACKAGE__->result_source_instance->deploy_depends_on(
- ["Year","CD"]
+ ["MyApp::Schema::Result::Year","MyApp::Schema::Result::CD"]
);
Specify the views (and only the views) that this view depends on.
-Pass this an array reference of source names.
+Pass this an array reference of fully qualified result classes.
=head1 OVERRIDDEN METHODS
return $new;
}
-1;
-
-=head1 AUTHORS
+=head1 FURTHER QUESTIONS?
-See L<DBIx::Class/CONTRIBUTORS>.
+Check the list of L<additional DBIC resources|DBIx::Class/GETTING HELP/SUPPORT>.
-=head1 LICENSE
+=head1 COPYRIGHT AND LICENSE
-You may distribute this code under the same terms as Perl itself.
+This module is free software L<copyright|DBIx::Class/COPYRIGHT AND LICENSE>
+by the L<DBIx::Class (DBIC) authors|DBIx::Class/AUTHORS>. You can
+redistribute it and/or modify it under the same terms as the
+L<DBIx::Class library|DBIx::Class/COPYRIGHT AND LICENSE>.
=cut
+1;