NAME
   DBIx::Class - Extensible and flexible object <-> relational mapper.

GETTING HELP/SUPPORT
   The community can be found via:

   *   Web Site: <http://www.dbix-class.org/>

   *   IRC: irc.perl.org#dbix-class

   *   Mailing list: <http://lists.scsys.co.uk/mailman/listinfo/dbix-class>

   *   RT Bug Tracker:
       <https://rt.cpan.org/Dist/Display.html?Queue=DBIx-Class>

   *   gitweb:
       <http://git.shadowcat.co.uk/gitweb/gitweb.cgi?p=dbsrgits/DBIx-Class.
       git>

   *   git: <git://git.shadowcat.co.uk/dbsrgits/DBIx-Class.git>

   *   twitter <http://www.twitter.com/dbix_class>

SYNOPSIS
   Create a schema class called MyDB/Schema.pm:

     package MyDB::Schema;
     use base qw/DBIx::Class::Schema/;

     __PACKAGE__->load_namespaces();

     1;

   Create a result class to represent artists, who have many CDs, in
   MyDB/Schema/Result/Artist.pm:

   See DBIx::Class::ResultSource for docs on defining result classes.

     package MyDB::Schema::Result::Artist;
     use base qw/DBIx::Class::Core/;

     __PACKAGE__->table('artist');
     __PACKAGE__->add_columns(qw/ artistid name /);
     __PACKAGE__->set_primary_key('artistid');
     __PACKAGE__->has_many(cds => 'MyDB::Schema::Result::CD');

     1;

   A result class to represent a CD, which belongs to an artist, in
   MyDB/Schema/Result/CD.pm:

     package MyDB::Schema::Result::CD;
     use base qw/DBIx::Class::Core/;

     __PACKAGE__->load_components(qw/InflateColumn::DateTime/);
     __PACKAGE__->table('cd');
     __PACKAGE__->add_columns(qw/ cdid artistid title year /);
     __PACKAGE__->set_primary_key('cdid');
     __PACKAGE__->belongs_to(artist => 'MyDB::Schema::Result::Artist', 'artistid');

     1;

   Then you can use these classes in your application's code:

     # Connect to your database.
     use MyDB::Schema;
     my $schema = MyDB::Schema->connect($dbi_dsn, $user, $pass, \%dbi_params);

     # Query for all artists and put them in an array,
     # or retrieve them as a result set object.
     # $schema->resultset returns a DBIx::Class::ResultSet
     my @all_artists = $schema->resultset('Artist')->all;
     my $all_artists_rs = $schema->resultset('Artist');

     # Output all artists names
     # $artist here is a DBIx::Class::Row, which has accessors
     # for all its columns. Rows are also subclasses of your Result class.
     foreach $artist (@all_artists) {
       print $artist->name, "\n";
     }

     # Create a result set to search for artists.
     # This does not query the DB.
     my $johns_rs = $schema->resultset('Artist')->search(
       # Build your WHERE using an SQL::Abstract structure:
       { name => { like => 'John%' } }
     );

     # Execute a joined query to get the cds.
     my @all_john_cds = $johns_rs->search_related('cds')->all;

     # Fetch the next available row.
     my $first_john = $johns_rs->next;

     # Specify ORDER BY on the query.
     my $first_john_cds_by_title_rs = $first_john->cds(
       undef,
       { order_by => 'title' }
     );

     # Create a result set that will fetch the artist data
     # at the same time as it fetches CDs, using only one query.
     my $millennium_cds_rs = $schema->resultset('CD')->search(
       { year => 2000 },
       { prefetch => 'artist' }
     );

     my $cd = $millennium_cds_rs->next; # SELECT ... FROM cds JOIN artists ...
     my $cd_artist_name = $cd->artist->name; # Already has the data so no 2nd query

     # new() makes a DBIx::Class::Row object but doesnt insert it into the DB.
     # create() is the same as new() then insert().
     my $new_cd = $schema->resultset('CD')->new({ title => 'Spoon' });
     $new_cd->artist($cd->artist);
     $new_cd->insert; # Auto-increment primary key filled in after INSERT
     $new_cd->title('Fork');

     $schema->txn_do(sub { $new_cd->update }); # Runs the update in a transaction

     # change the year of all the millennium CDs at once
     $millennium_cds_rs->update({ year => 2002 });

DESCRIPTION
   This is an SQL to OO mapper with an object API inspired by Class::DBI
   (with a compatibility layer as a springboard for porting) and a
   resultset API that allows abstract encapsulation of database operations.
   It aims to make representing queries in your code as perl-ish as
   possible while still providing access to as many of the capabilities of
   the database as possible, including retrieving related records from
   multiple tables in a single query, JOIN, LEFT JOIN, COUNT, DISTINCT,
   GROUP BY, ORDER BY and HAVING support.

   DBIx::Class can handle multi-column primary and foreign keys, complex
   queries and database-level paging, and does its best to only query the
   database in order to return something you've directly asked for. If a
   resultset is used as an iterator it only fetches rows off the statement
   handle as requested in order to minimise memory usage. It has
   auto-increment support for SQLite, MySQL, PostgreSQL, Oracle, SQL Server
   and DB2 and is known to be used in production on at least the first
   four, and is fork- and thread-safe out of the box (although your DBD may
   not be).

   This project is still under rapid development, so large new features may
   be marked EXPERIMENTAL - such APIs are still usable but may have edge
   bugs. Failing test cases are *always* welcome and point releases are put
   out rapidly as bugs are found and fixed.

   We do our best to maintain full backwards compatibility for published
   APIs, since DBIx::Class is used in production in many organisations, and
   even backwards incompatible changes to non-published APIs will be fixed
   if they're reported and doing so doesn't cost the codebase anything.

   The test suite is quite substantial, and several developer releases are
   generally made to CPAN before the branch for the next release is merged
   back to trunk for a major release.

WHERE TO GO NEXT
   DBIx::Class::Manual::DocMap lists each task you might want help on, and
   the modules where you will find documentation.

AUTHOR
   mst: Matt S. Trout <[email protected]>

   (I mostly consider myself "project founder" these days but the AUTHOR
   heading is traditional :)

CONTRIBUTORS
   abraxxa: Alexander Hartmaier <[email protected]>

   aherzog: Adam Herzog <[email protected]>

   Alexander Keusch <[email protected]>

   alnewkirk: Al Newkirk <[email protected]>

   amiri: Amiri Barksdale <[email protected]>

   amoore: Andrew Moore <[email protected]>

   andyg: Andy Grundman <[email protected]>

   ank: Andres Kievsky

   arc: Aaron Crane <[email protected]>

   arcanez: Justin Hunter <[email protected]>

   ash: Ash Berlin <[email protected]>

   bert: Norbert Csongradi <[email protected]>

   blblack: Brandon L. Black <[email protected]>

   bluefeet: Aran Deltac <[email protected]>

   boghead: Bryan Beeley <[email protected]>

   bricas: Brian Cassidy <[email protected]>

   brunov: Bruno Vecchi <[email protected]>

   caelum: Rafael Kitover <[email protected]>

   castaway: Jess Robinson

   claco: Christopher H. Laco

   clkao: CL Kao

   da5id: David Jack Olrik <[email protected]>

   debolaz: Anders Nor Berle <[email protected]>

   dew: Dan Thomas <[email protected]>

   dkubb: Dan Kubb <[email protected]>

   dnm: Justin Wheeler <[email protected]>

   dpetrov: Dimitar Petrov <[email protected]>

   dwc: Daniel Westermann-Clark <[email protected]>

   dyfrgi: Michael Leuchtenburg <[email protected]>

   freetime: Bill Moseley <[email protected]>

   frew: Arthur Axel "fREW" Schmidt <[email protected]>

   goraxe: Gordon Irving <[email protected]>

   gphat: Cory G Watson <[email protected]>

   groditi: Guillermo Roditi <[email protected]>

   Haarg: Graham Knop <[email protected]>

   hobbs: Andrew Rodland <[email protected]>

   ilmari: Dagfinn Ilmari Manns�ker <[email protected]>

   initself: Mike Baas <[email protected]>

   jasonmay: Jason May <[email protected]>

   jesper: Jesper Krogh

   jgoulah: John Goulah <[email protected]>

   jguenther: Justin Guenther <[email protected]>

   jhannah: Jay Hannah <[email protected]>

   jnapiorkowski: John Napiorkowski <[email protected]>

   jon: Jon Schutz <[email protected]>

   jshirley: J. Shirley <[email protected]>

   kaare: Kaare Rasmussen

   konobi: Scott McWhirter

   lukes: Luke Saunders <[email protected]>

   marcus: Marcus Ramberg <[email protected]>

   mattlaw: Matt Lawrence

   michaelr: Michael Reddick <[email protected]>

   ned: Neil de Carteret

   nigel: Nigel Metheringham <[email protected]>

   ningu: David Kamholz <[email protected]>

   Nniuq: Ron "Quinn" Straight" <[email protected]>

   norbi: Norbert Buchmuller <[email protected]>

   nuba: Nuba Princigalli <[email protected]>

   Numa: Dan Sully <[email protected]>

   ovid: Curtis "Ovid" Poe <[email protected]>

   oyse: �ystein Torget <[email protected]>

   paulm: Paul Makepeace

   penguin: K J Cheetham

   perigrin: Chris Prather <[email protected]>

   peter: Peter Collingbourne <[email protected]>

   phaylon: Robert Sedlacek <[email protected]>

   plu: Johannes Plunien <[email protected]>

   Possum: Daniel LeWarne <[email protected]>

   quicksilver: Jules Bean

   rafl: Florian Ragwitz <[email protected]>

   rainboxx: Matthias Dietrich <[email protected]>

   rbo: Robert Bohne <[email protected]>

   rbuels: Robert Buels <[email protected]>

   rdj: Ryan D Johnson <[email protected]>

   ribasushi: Peter Rabbitson <[email protected]>

   rjbs: Ricardo Signes <[email protected]>

   robkinyon: Rob Kinyon <[email protected]>

   Roman: Roman Filippov <[email protected]>

   sc_: Just Another Perl Hacker

   scotty: Scotty Allen <[email protected]>

   semifor: Marc Mims <[email protected]>

   solomon: Jared Johnson <[email protected]>

   spb: Stephen Bennett <[email protected]>

   Squeeks <[email protected]>

   sszabo: Stephan Szabo <[email protected]>

   teejay : Aaron Trevena <[email protected]>

   Todd Lipcon

   Tom Hukins

   tonvoon: Ton Voon <[email protected]>

   triode: Pete Gamache <[email protected]>

   typester: Daisuke Murase <[email protected]>

   victori: Victor Igumnov <[email protected]>

   wdh: Will Hawes

   willert: Sebastian Willert <[email protected]>

   wreis: Wallace Reis <[email protected]>

   yrlnry: Mark Jason Dominus <[email protected]>

   zamolxes: Bogdan Lucaciu <[email protected]>

COPYRIGHT
   Copyright (c) 2005 - 2010 the DBIx::Class "AUTHOR" and "CONTRIBUTORS" as
   listed above.

LICENSE
   This library is free software and may be distributed under the same
   terms as perl itself.

You are viewing proxied material from ftp.icm.edu.pl. The copyright of proxied material belongs to its original authors. Any comments or complaints in relation to proxied material should be directed to the original authors of the content concerned. Please see the disclaimer for more details.