X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FCatalyst%2FModel%2FDBIC%2FSchema.pm;h=e44324e875bd4cd4b7668506a2acbd557e22dafc;hb=d52bc376e64d1ef6a50d0356290a55804f766ce1;hp=24a7ea0b1c4aab0c8af9d0bdd408c163ce95a1b3;hpb=f1613faa51dc989e288215e6fd452a67ff8b700e;p=catagits%2FCatalyst-Model-DBIC-Schema.git diff --git a/lib/Catalyst/Model/DBIC/Schema.pm b/lib/Catalyst/Model/DBIC/Schema.pm index 24a7ea0..e44324e 100644 --- a/lib/Catalyst/Model/DBIC/Schema.pm +++ b/lib/Catalyst/Model/DBIC/Schema.pm @@ -1,6 +1,10 @@ package Catalyst::Model::DBIC::Schema; use strict; +use warnings; + +our $VERSION = '0.22'; + use base qw/Catalyst::Model Class::Accessor::Fast Class::Data::Accessor/; use NEXT; use UNIVERSAL::require; @@ -8,8 +12,6 @@ use Carp; use Data::Dumper; require DBIx::Class; -our $VERSION = '0.17_01'; - __PACKAGE__->mk_classaccessor('composed_schema'); __PACKAGE__->mk_accessors('schema'); @@ -45,7 +47,7 @@ Actor in MyApp/Schema/FilmDB/Actor.pm: ... -and a Role in MyApp/Schema/Role.pm: +and a Role in MyApp/Schema/FilmDB/Role.pm: package MyApp::Schema::FilmDB::Role; use base qw/DBIx::Class/ @@ -100,10 +102,10 @@ Authentication::Store::DBIC in MyApp.pm: password_field => 'password' } -C<< $c->model() >> returns a L for the source name -parameter passed. To find out more about which methods can be called on a -ResultSet, or how to add your own methods to it, please see the ResultSet -documentation in the L distribution. +C<< $c->model('Schema::Source') >> returns a L for +the source name parameter passed. To find out more about which methods can +be called on a ResultSet, or how to add your own methods to it, please see +the ResultSet documentation in the L distribution. Some examples are given below: @@ -141,6 +143,38 @@ This is a Catalyst Model for L-based Models. See the documentation for L for information on generating these Models via Helper scripts. +When your Catalyst app starts up, a thin Model layer is created as an +interface to your DBIC Schema. It should be clearly noted that the model +object returned by C<< $c->model('FilmDB') >> is NOT itself a DBIC schema or +resultset object, but merely a wrapper proving L to access +the underlying schema. + +In addition to this model class, a shortcut class is generated for each +source in the schema, allowing easy and direct access to a resultset of the +corresponding type. These generated classes are even thinner than the model +class, providing no public methods but simply hooking into Catalyst's +model() accessor via the +L mechanism. The complete +contents of each generated class is roughly equivalent to the following: + + package MyApp::Model::FilmDB::Actor + sub ACCEPT_CONTEXT { + my ($self, $c) = @_; + $c->model('FilmDB')->resultset('Actor'); + } + +In short, there are three techniques available for obtaining a DBIC +resultset object: + + # the long way + my $rs = $c->model('FilmDB')->schema->resultset('Actor'); + + # using the shortcut method on the model object + my $rs = $c->model('FilmDB')->resultset('Actor'); + + # using the generated class directly + my $rs = $c->model('FilmDB::Actor'); + =head1 CONFIG PARAMETERS =over 4 @@ -154,7 +188,9 @@ C namespace. This parameter is required. =item connect_info This is an arrayref of connection parameters, which are specific to your -C (see your storage type documentation for more details). +C (see your storage type documentation for more details). +If you only need one parameter (e.g. the DSN), you can just pass a string +instead of an arrayref. This is not required if C already has connection information defined inside itself (which isn't highly recommended, but can be done) @@ -163,11 +199,8 @@ For L, which is the only supported C in L at the time of this writing, the parameters are your dsn, username, password, and connect options hashref. -If you need to specify the L specific parameter -C, or the related C options C, -C, or C, you can place these options into a hashref -as the final element of the C arrayref. If in doubt, don't -specify these options. You would know it if you needed them. +See L for a detailed explanation +of the arguments supported. Examples: @@ -195,6 +228,28 @@ Examples: } ], +Or using L: + + + schema_class MyApp::Schema::FilmDB + connect_info dbi:Pg:dbname=mypgdb + connect_info postgres + connect_info + + AutoCommit 0 + on_connect_do some SQL statement + on_connect_do another SQL statement + + + +or + + + schema_class MyApp::Schema::FilmDB + connect_info dbi:SQLite:dbname=foo.db + + + =item storage_type Allows the use of a different C than what is set in your @@ -278,8 +333,8 @@ sub new { } else { croak "Either ->config->{connect_info} must be defined for $class" - . " or $schema_class must have connect info defined on it" - . "Here's what we got:\n" + . " or $schema_class must have connect info defined on it." + . " Here's what we got:\n" . Dumper($self); } } @@ -290,7 +345,11 @@ sub new { $self->schema->storage_type($self->{storage_type}) if $self->{storage_type}; - $self->schema->connection(@{$self->{connect_info}}); + $self->schema->connection( + ref $self->{connect_info} eq 'ARRAY' ? + @{$self->{connect_info}} : + $self->{connect_info} + ); no strict 'refs'; foreach my $moniker ($self->schema->sources) {