Post-merge fixups
[dbsrgits/DBIx-Class.git] / lib / DBIx / Class / Schema.pm
CommitLineData
a02675cd 1package DBIx::Class::Schema;
2
3use strict;
4use warnings;
aa562407 5
701da8c4 6use Carp::Clan qw/^DBIx::Class/;
a02675cd 7
41a6f8c0 8use base qw/DBIx::Class/;
a02675cd 9
0dc79249 10__PACKAGE__->mk_classdata('class_mappings' => {});
11__PACKAGE__->mk_classdata('source_registrations' => {});
1e10a11d 12__PACKAGE__->mk_classdata('storage_type' => '::DBI');
d7156e50 13__PACKAGE__->mk_classdata('storage');
a02675cd 14
c2da098a 15=head1 NAME
16
17DBIx::Class::Schema - composable schemas
18
19=head1 SYNOPSIS
20
c2da098a 21 package My::Schema;
c2da098a 22 use base qw/DBIx::Class::Schema/;
a3d93194 23
24 # load My::Schema::Foo, My::Schema::Bar, My::Schema::Baz
c2da098a 25 __PACKAGE__->load_classes(qw/Foo Bar Baz/);
26
c2da098a 27 package My::Schema::Foo;
03312470 28 use base qw/DBIx::Class/;
54540863 29 __PACKAGE__->load_components(qw/PK::Auto::Pg Core/); # for example
c2da098a 30 __PACKAGE__->table('foo');
c2da098a 31
5d9076f2 32 # Elsewhere in your code:
a3d93194 33 my $schema1 = My::Schema->connect(
34 $dsn,
35 $user,
36 $password,
37 $attrs
38 );
90ec6cad 39
40 my $schema2 = My::Schema->connect($coderef_returning_dbh);
c2da098a 41
a3d93194 42 # fetch objects using My::Schema::Foo
43 my $resultset = $schema1->resultset('Foo')->search( ... );
44 my @objects = $schema2->resultset('Foo')->search( ... );
c2da098a 45
46=head1 DESCRIPTION
47
a3d93194 48Creates database classes based on a schema. This is the recommended way to
49use L<DBIx::Class> and allows you to use more than one concurrent connection
50with your classes.
429bd4f1 51
03312470 52NB: If you're used to L<Class::DBI> it's worth reading the L</SYNOPSIS>
53carefully as DBIx::Class does things a little differently. Note in
54particular which module inherits off which.
55
c2da098a 56=head1 METHODS
57
87c4e602 58=head2 register_class
59
60=head3 Arguments: <moniker> <component_class>
076652e8 61
80c90f5d 62Registers a class which isa ResultSourceProxy; equivalent to calling
66d9ef6b 63
181a28f4 64 $schema->register_source($moniker, $component_class->result_source_instance);
076652e8 65
c2da098a 66=cut
67
a02675cd 68sub register_class {
0dc79249 69 my ($self, $moniker, $to_register) = @_;
70 $self->register_source($moniker => $to_register->result_source_instance);
74b92d9a 71}
72
87c4e602 73=head2 register_source
74
75=head3 Arguments: <moniker> <result source>
076652e8 76
0dc79249 77Registers the result source in the schema with the given moniker
076652e8 78
79=cut
80
0dc79249 81sub register_source {
82 my ($self, $moniker, $source) = @_;
83 my %reg = %{$self->source_registrations};
84 $reg{$moniker} = $source;
85 $self->source_registrations(\%reg);
86 $source->schema($self);
87 if ($source->result_class) {
88 my %map = %{$self->class_mappings};
89 $map{$source->result_class} = $moniker;
90 $self->class_mappings(\%map);
91 }
92}
a02675cd 93
bfb2bd4f 94=head2 class
95
96 my $class = $schema->class('Foo');
97
0dc79249 98Retrieves the result class name for a given result source
bfb2bd4f 99
100=cut
101
102sub class {
0dc79249 103 my ($self, $moniker) = @_;
104 return $self->source($moniker)->result_class;
bfb2bd4f 105}
106
ea20d0fd 107=head2 source
108
109 my $source = $schema->source('Foo');
110
111Returns the result source object for the registered name
112
113=cut
114
115sub source {
0dc79249 116 my ($self, $moniker) = @_;
117 my $sreg = $self->source_registrations;
118 return $sreg->{$moniker} if exists $sreg->{$moniker};
119
120 # if we got here, they probably passed a full class name
121 my $mapped = $self->class_mappings->{$moniker};
701da8c4 122 $self->throw_exception("Can't find source for ${moniker}")
0dc79249 123 unless $mapped && exists $sreg->{$mapped};
124 return $sreg->{$mapped};
ea20d0fd 125}
126
0dc79249 127=head2 sources
128
129 my @source_monikers = $schema->sources;
130
131Returns the source monikers of all source registrations on this schema
132
133=cut
134
135sub sources { return keys %{shift->source_registrations}; }
136
ea20d0fd 137=head2 resultset
138
139 my $rs = $schema->resultset('Foo');
140
0dc79249 141Returns the resultset for the registered moniker
ea20d0fd 142
143=cut
144
145sub resultset {
0dc79249 146 my ($self, $moniker) = @_;
147 return $self->source($moniker)->resultset;
ea20d0fd 148}
149
87c4e602 150=head2 load_classes
151
152=head3 Arguments: [<classes>, (<class>, <class>), {<namespace> => [<classes>]}]
076652e8 153
429bd4f1 154Uses L<Module::Find> to find all classes under the database class' namespace,
155or uses the classes you select. Then it loads the component (using L<use>),
156and registers them (using B<register_class>);
076652e8 157
5ce32fc1 158It is possible to comment out classes with a leading '#', but note that perl
159will think it's a mistake (trying to use a comment in a qw list) so you'll
160need to add "no warnings 'qw';" before your load_classes call.
161
076652e8 162=cut
163
a02675cd 164sub load_classes {
5ce32fc1 165 my ($class, @params) = @_;
166
167 my %comps_for;
168
169 if (@params) {
170 foreach my $param (@params) {
171 if (ref $param eq 'ARRAY') {
172 # filter out commented entries
173 my @modules = grep { $_ !~ /^#/ } @$param;
174
175 push (@{$comps_for{$class}}, @modules);
176 }
177 elsif (ref $param eq 'HASH') {
178 # more than one namespace possible
179 for my $comp ( keys %$param ) {
180 # filter out commented entries
181 my @modules = grep { $_ !~ /^#/ } @{$param->{$comp}};
182
183 push (@{$comps_for{$comp}}, @modules);
184 }
185 }
186 else {
187 # filter out commented entries
188 push (@{$comps_for{$class}}, $param) if $param !~ /^#/;
189 }
190 }
191 } else {
41a6f8c0 192 eval "require Module::Find;";
701da8c4 193 $class->throw_exception("No arguments to load_classes and couldn't load".
41a6f8c0 194 " Module::Find ($@)") if $@;
5ce32fc1 195 my @comp = map { substr $_, length "${class}::" } Module::Find::findallmod($class);
196 $comps_for{$class} = \@comp;
41a6f8c0 197 }
5ce32fc1 198
e6efde04 199 my @to_register;
200 {
201 no warnings qw/redefine/;
202 local *Class::C3::reinitialize = sub { };
203 foreach my $prefix (keys %comps_for) {
204 foreach my $comp (@{$comps_for{$prefix}||[]}) {
205 my $comp_class = "${prefix}::${comp}";
206 eval "use $comp_class"; # If it fails, assume the user fixed it
207 if ($@) {
3b24f6ea 208 $comp_class =~ s/::/\//g;
209 die $@ unless $@ =~ /Can't locate.+$comp_class\.pm\sin\s\@INC/;
210 warn $@ if $@;
e6efde04 211 }
212 push(@to_register, [ $comp, $comp_class ]);
bfb2bd4f 213 }
5ce32fc1 214 }
a02675cd 215 }
e6efde04 216 Class::C3->reinitialize;
217
218 foreach my $to (@to_register) {
219 $class->register_class(@$to);
220 # if $class->can('result_source_instance');
221 }
a02675cd 222}
223
87c4e602 224=head2 compose_connection
225
226=head3 Arguments: <target> <@db_info>
429bd4f1 227
228This is the most important method in this class. it takes a target namespace,
229as well as dbh connection info, and creates a L<DBIx::Class::DB> class as
230well as subclasses for each of your database classes in this namespace, using
231this connection.
076652e8 232
54540863 233It will also setup a ->class method on the target class, which lets you
8c130052 234resolve database classes based on the schema component name, for example
235
54540863 236 MyApp::DB->class('Foo') # returns MyApp::DB::Foo,
8c130052 237 # which ISA MyApp::Schema::Foo
238
239This is the recommended API for accessing Schema generated classes, and
240using it might give you instant advantages with future versions of DBIC.
241
54540863 242WARNING: Loading components into Schema classes after compose_connection
243may not cause them to be seen by the classes in your target namespace due
244to the dispatch table approach used by Class::C3. If you do this you may find
245you need to call Class::C3->reinitialize() afterwards to get the behaviour
246you expect.
247
076652e8 248=cut
249
a02675cd 250sub compose_connection {
ea20d0fd 251 my ($self, $target, @info) = @_;
80c90f5d 252 my $base = 'DBIx::Class::ResultSetProxy';
8ef144ff 253 eval "require ${base};";
254 $self->throw_exception("No arguments to load_classes and couldn't load".
255 " ${base} ($@)") if $@;
be381829 256
257 if ($self eq $target) {
258 # Pathological case, largely caused by the docs on early C::M::DBIC::Plain
259 foreach my $moniker ($self->sources) {
260 my $source = $self->source($moniker);
261 my $class = $source->result_class;
262 $self->inject_base($class, $base);
263 $class->mk_classdata(resultset_instance => $source->resultset);
264 $class->mk_classdata(class_resolver => $self);
265 }
50041f3c 266 $self->connection(@info);
be381829 267 return $self;
268 }
269
66d9ef6b 270 my $schema = $self->compose_namespace($target, $base);
ecceadff 271 {
272 no strict 'refs';
273 *{"${target}::schema"} = sub { $schema };
274 }
275
66d9ef6b 276 $schema->connection(@info);
0dc79249 277 foreach my $moniker ($schema->sources) {
278 my $source = $schema->source($moniker);
279 my $class = $source->result_class;
280 #warn "$moniker $class $source ".$source->storage;
8c49f629 281 $class->mk_classdata(result_source_instance => $source);
ea20d0fd 282 $class->mk_classdata(resultset_instance => $source->resultset);
66d9ef6b 283 $class->mk_classdata(class_resolver => $schema);
bfb2bd4f 284 }
285 return $schema;
e678398e 286}
287
288sub compose_namespace {
66d9ef6b 289 my ($self, $target, $base) = @_;
290 my %reg = %{ $self->source_registrations };
11b78bd6 291 my %target;
292 my %map;
66d9ef6b 293 my $schema = $self->clone;
e9100ff7 294 {
295 no warnings qw/redefine/;
296 local *Class::C3::reinitialize = sub { };
297 foreach my $moniker ($schema->sources) {
298 my $source = $schema->source($moniker);
299 my $target_class = "${target}::${moniker}";
300 $self->inject_base(
301 $target_class => $source->result_class, ($base ? $base : ())
302 );
303 $source->result_class($target_class);
304 }
b7951443 305 }
e9100ff7 306 Class::C3->reinitialize();
11b78bd6 307 {
308 no strict 'refs';
1edaf6fe 309 foreach my $meth (qw/class source resultset/) {
310 *{"${target}::${meth}"} =
311 sub { shift->schema->$meth(@_) };
312 }
11b78bd6 313 }
bfb2bd4f 314 return $schema;
b7951443 315}
316
87c4e602 317=head2 setup_connection_class
318
319=head3 Arguments: <$target> <@info>
076652e8 320
429bd4f1 321Sets up a database connection class to inject between the schema
322and the subclasses the schema creates.
323
076652e8 324=cut
325
b7951443 326sub setup_connection_class {
327 my ($class, $target, @info) = @_;
63e9583a 328 $class->inject_base($target => 'DBIx::Class::DB');
329 #$target->load_components('DB');
b7951443 330 $target->connection(@info);
331}
332
87c4e602 333=head2 connection
334
335=head3 Arguments: (@args)
66d9ef6b 336
337Instantiates a new Storage object of type storage_type and passes the
19feb86b 338arguments to $storage->connect_info. Sets the connection in-place on
66d9ef6b 339the schema.
340
341=cut
342
343sub connection {
344 my ($self, @info) = @_;
e59d3e5b 345 return $self if !@info && $self->storage;
1e10a11d 346 my $storage_class = $self->storage_type;
347 $storage_class = 'DBIx::Class::Storage'.$storage_class
348 if $storage_class =~ m/^::/;
8ef144ff 349 eval "require ${storage_class};";
350 $self->throw_exception("No arguments to load_classes and couldn't load".
351 " ${storage_class} ($@)") if $@;
66d9ef6b 352 my $storage = $storage_class->new;
353 $storage->connect_info(\@info);
354 $self->storage($storage);
355 return $self;
356}
357
87c4e602 358=head2 connect
359
360=head3 Arguments: (@info)
66d9ef6b 361
362Conveneience method, equivalent to $schema->clone->connection(@info)
363
364=cut
365
08b515f1 366sub connect { shift->clone->connection(@_) }
367
368=head2 txn_begin
369
370Begins a transaction (does nothing if AutoCommit is off).
371
372=cut
373
374sub txn_begin { shift->storage->txn_begin }
375
376=head2 txn_commit
377
378Commits the current transaction.
379
380=cut
381
382sub txn_commit { shift->storage->txn_commit }
383
384=head2 txn_rollback
385
386Rolls back the current transaction.
387
388=cut
389
390sub txn_rollback { shift->storage->txn_rollback }
66d9ef6b 391
a62cf8d4 392=head2 txn_do
393
3b24f6ea 394=head3 Arguments: <$coderef>, [@coderef_args]
a62cf8d4 395
3b24f6ea 396Executes C<$coderef> with (optional) arguments C<@coderef_args>
397transactionally, returning its result (if any). If an exception is
398caught, a rollback is issued and the exception is rethrown. If the
399rollback fails, (i.e. throws an exception) an exception is thrown that
400includes a "Rollback failed" message.
a62cf8d4 401
402For example,
403
404 my $foo = $schema->resultset('foo')->find(1);
405
406 my $coderef = sub {
407 my ($foo, @bars) = @_;
408
409 # If any one of these fails, the entire transaction fails
410 $foo->create_related('bars', {
411 col => $_
412 }) foreach (@bars);
413
414 return $foo->bars;
415 };
416
417 my $rs;
418 eval {
419 $rs = $schema->txn_do($coderef, $foo, qw/foo bar baz/);
420 };
421
422 if ($@) {
423 my $error = $@;
424 if ($error =~ /Rollback failed/) {
425 die "something terrible has happened!";
426 } else {
427 deal_with_failed_transaction();
428 die $error;
429 }
430 }
431
3b24f6ea 432Nested transactions work as expected (i.e. only the outermost
a62cf8d4 433transaction will issue a txn_commit on the Schema's storage)
434
435=cut
436
437sub txn_do {
438 my ($self, $coderef, @args) = @_;
439
171dadd7 440 ref $self or $self->throw_exception
441 ('Cannot execute txn_do as a class method');
442 ref $coderef eq 'CODE' or $self->throw_exception
443 ('$coderef must be a CODE reference');
a62cf8d4 444
445 my (@return_values, $return_value);
446
447 $self->txn_begin; # If this throws an exception, no rollback is needed
448
449 my $wantarray = wantarray; # Need to save this since it's reset in eval{}
450
451 eval {
452 # Need to differentiate between scalar/list context to allow for returning
453 # a list in scalar context to get the size of the list
454 if ($wantarray) {
455 @return_values = $coderef->(@args);
456 } else {
457 $return_value = $coderef->(@args);
458 }
459 $self->txn_commit;
460 };
461
462 if ($@) {
463 my $error = $@;
464
465 eval {
466 $self->txn_rollback;
467 };
468
469 if ($@) {
470 my $rollback_error = $@;
471 my $exception_class = "DBIx::Class::Storage::NESTED_ROLLBACK_EXCEPTION";
472 $self->throw_exception($error) # propagate nested rollback
473 if $rollback_error =~ /$exception_class/;
474
475 $self->throw_exception("Transaction aborted: $error. Rollback failed: ".
476 $rollback_error);
477 } else {
478 $self->throw_exception($error); # txn failed but rollback succeeded
479 }
480 }
481
482 return $wantarray ? @return_values : $return_value;
483}
484
66d9ef6b 485=head2 clone
486
487Clones the schema and its associated result_source objects and returns the
488copy.
489
490=cut
491
492sub clone {
493 my ($self) = @_;
494 my $clone = bless({ (ref $self ? %$self : ()) }, ref $self || $self);
495 foreach my $moniker ($self->sources) {
496 my $source = $self->source($moniker);
497 my $new = $source->new($source);
498 $clone->register_source($moniker => $new);
499 }
500 return $clone;
501}
502
87c4e602 503=head2 populate
504
505=head3 Arguments: ($moniker, \@data);
a37a4697 506
507Populates the source registered with the given moniker with the supplied data.
508@data should be a list of listrefs, the first containing column names, the
509second matching values - i.e.
510
a62cf8d4 511 $schema->populate('Foo', [
512 [ qw/foo_id foo_string/ ],
513 [ 1, 'One' ],
514 [ 2, 'Two' ],
515 ...
516 ]);
a37a4697 517
518=cut
519
520sub populate {
521 my ($self, $name, $data) = @_;
522 my $rs = $self->resultset($name);
523 my @names = @{shift(@$data)};
84e3c114 524 my @created;
a37a4697 525 foreach my $item (@$data) {
526 my %create;
527 @create{@names} = @$item;
84e3c114 528 push(@created, $rs->create(\%create));
a37a4697 529 }
84e3c114 530 return @created;
a37a4697 531}
532
5160b401 533=head2 throw_exception
701da8c4 534
535Defaults to using Carp::Clan to report errors from user perspective.
536
537=cut
538
539sub throw_exception {
540 my ($self) = shift;
541 croak @_;
542}
543
1c339d71 544=head2 deploy
545
546Attempts to deploy the schema to the current storage
547
548=cut
549
550sub deploy {
cb561d1a 551 my ($self, $sqltargs) = @_;
1c339d71 552 $self->throw_exception("Can't deploy without storage") unless $self->storage;
cb561d1a 553 $self->storage->deploy($self, undef, $sqltargs);
1c339d71 554}
555
a02675cd 5561;
c2da098a 557
c2da098a 558=head1 AUTHORS
559
daec44b8 560Matt S. Trout <mst@shadowcatsystems.co.uk>
c2da098a 561
562=head1 LICENSE
563
564You may distribute this code under the same terms as Perl itself.
565
566=cut
567