DBIx::Class - Extensible and flexible object <-> relational mapper.
This is a sql to oop mapper, inspired by the Class::DBI framework, and meant to support compability with it, while restructuring the insides, and making it possible to support some new features like self-joins, distinct, group bys and more.
It's currently considered EXPERIMENTAL - bring this near a production database at your own risk! The API is *not* fixed yet, although most of the primitives should be good for the future and any API changes will be posted to the mailing list before they're committed.
The community can be found via -
Mailing list: http://lists.rawmode.org/mailman/listinfo/dbix-class/ SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/ Wiki: http://dbix-class.shadowcatsystems.co.uk/ IRC: irc.perl.org#dbix-class
If you're using Class::DBI, and want an easy and fast way of migrating to DBIx::Class look at DBIx::Class::CDBICompat.
There are two ways of using DBIx::Class, the 'simple' and the 'schema' one.
The 'simple' way of using DBIx::Class needs less classes than the 'schema' way but doesn't give you the ability to use different database connections.
Some examples where different database connections are useful are:
different users with different rights different databases with the same schema.
First you need to create a base class all other classes inherit from.
Look at DBIx::Class::DB how to do this
Next you need to create a class for every table you want to use with DBIx::Class.
Look at DBIx::Class::Table how to do this.
With this approach the table classes inherit directly from DBIx::Class::Core, although it might be a good idea to create a 'parent' class for all table classes which inherits from DBIx::Class::Core and adds additional methods needed by all table classes, e.g. reading a config file, loading auto primary key support.
Look at DBIx::Class::Schema how to do this.
If you need more hand-holding, check out the introduction in the manual below.
Matt S. Trout <firstname.lastname@example.org>
Andy Grundman <email@example.com>
Brian Cassidy <firstname.lastname@example.org>
Dan Kubb <email@example.com>
Dan Sully <firstname.lastname@example.org>
Marcus Ramberg <email@example.com>
You may distribute this code under the same terms as Perl itself.