The database consists of the following:
table 'artist' with columns: artistid, name
- table 'cd' with columns: cdid, artist, title
+ table 'cd' with columns: cdid, artist, title, year
table 'track' with columns: trackid, cd, title
CREATE TABLE cd (
cdid INTEGER PRIMARY KEY,
artist INTEGER NOT NULL REFERENCES artist(artistid),
- title TEXT NOT NULL
+ title TEXT NOT NULL,
+ year TEXT
);
CREATE TABLE track (
use base qw/DBIx::Class::Core/;
__PACKAGE__->load_components(qw/InflateColumn::DateTime/);
__PACKAGE__->table('cd');
- __PACKAGE__->add_columns(qw/ cdid artist title/);
+ __PACKAGE__->add_columns(qw/ cdid artist title year/);
__PACKAGE__->set_primary_key('cdid');
__PACKAGE__->belongs_to('artist' => 'MyApp::Schema::Result::Artist');
__PACKAGE__->has_many('tracks' => 'MyApp::Schema::Result::Track');
my $schema = MyApp::Schema->connect('dbi:SQLite:db/example.db');
- # here's some of the SQL that is going to be generated by the schema
- # INSERT INTO artist VALUES (NULL,'Michael Jackson');
- # INSERT INTO artist VALUES (NULL,'Eminem');
-
my @artists = (['Michael Jackson'], ['Eminem']);
$schema->populate('Artist', [
[qw/name/],
A reference implementation of the database and scripts in this example
are available in the main distribution for DBIx::Class under the
-directory F<t/examples/Schema>.
+directory F<examples/Schema>.
With these scripts we're relying on @INC looking in the current
working directory. You may want to add the MyApp namespaces to
model.
This example uses L<DBIx::Class::Schema/load_namespaces> to load in the
-appropriate L<Row|DBIx::Class::Row> classes from the MyApp::Schema::Result namespace,
-and any required resultset classes from the MyApp::Schema::ResultSet
-namespace (although we created the directory in the directions above we
-did not add, or need to add, any resultset classes).
+appropriate L<Result|DBIx::Class::Manual::ResultClass> classes from the
+C<MyApp::Schema::Result> namespace, and any required
+L<ResultSet|DBIx::Class::ResultSet> classes from the
+C<MyApp::Schema::ResultSet> namespace (although we created the directory
+in the directions above we did not add, or need to add, any resultset
+classes).
+
+=head1 FURTHER QUESTIONS?
-=head1 TODO
+Check the list of L<additional DBIC resources|DBIx::Class/GETTING HELP/SUPPORT>.
-=head1 AUTHOR
+=head1 COPYRIGHT AND LICENSE
- sc_ from irc.perl.org#dbix-class
- Kieren Diment <kd@totaldatasolution.com>
- Nigel Metheringham <nigelm@cpan.org>
+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