added with_deferred_fk_checks functionality to storage
[dbsrgits/DBIx-Class.git] / lib / DBIx / Class / Schema.pm
CommitLineData
a02675cd 1package DBIx::Class::Schema;
2
3use strict;
4use warnings;
aa562407 5
4981dc70 6use DBIx::Class::Exception;
701da8c4 7use Carp::Clan qw/^DBIx::Class/;
a917fb06 8use Scalar::Util qw/weaken/;
c9d2e0a2 9use File::Spec;
ddc0a6c8 10use Sub::Name ();
7cb86b38 11require Module::Find;
a02675cd 12
41a6f8c0 13use base qw/DBIx::Class/;
a02675cd 14
0dc79249 15__PACKAGE__->mk_classdata('class_mappings' => {});
16__PACKAGE__->mk_classdata('source_registrations' => {});
1e10a11d 17__PACKAGE__->mk_classdata('storage_type' => '::DBI');
d7156e50 18__PACKAGE__->mk_classdata('storage');
82cc0386 19__PACKAGE__->mk_classdata('exception_action');
4b946902 20__PACKAGE__->mk_classdata('stacktrace' => $ENV{DBIC_TRACE} || 0);
e6c747fd 21__PACKAGE__->mk_classdata('default_resultset_attributes' => {});
a02675cd 22
c2da098a 23=head1 NAME
24
25DBIx::Class::Schema - composable schemas
26
27=head1 SYNOPSIS
28
24d67825 29 package Library::Schema;
c2da098a 30 use base qw/DBIx::Class::Schema/;
bab77431 31
24d67825 32 # load Library::Schema::CD, Library::Schema::Book, Library::Schema::DVD
33 __PACKAGE__->load_classes(qw/CD Book DVD/);
c2da098a 34
24d67825 35 package Library::Schema::CD;
03312470 36 use base qw/DBIx::Class/;
77254782 37 __PACKAGE__->load_components(qw/PK::Auto Core/); # for example
24d67825 38 __PACKAGE__->table('cd');
c2da098a 39
5d9076f2 40 # Elsewhere in your code:
24d67825 41 my $schema1 = Library::Schema->connect(
a3d93194 42 $dsn,
43 $user,
44 $password,
24d67825 45 { AutoCommit => 0 },
a3d93194 46 );
bab77431 47
24d67825 48 my $schema2 = Library::Schema->connect($coderef_returning_dbh);
c2da098a 49
24d67825 50 # fetch objects using Library::Schema::DVD
51 my $resultset = $schema1->resultset('DVD')->search( ... );
52 my @dvd_objects = $schema2->resultset('DVD')->search( ... );
c2da098a 53
54=head1 DESCRIPTION
55
a3d93194 56Creates database classes based on a schema. This is the recommended way to
57use L<DBIx::Class> and allows you to use more than one concurrent connection
58with your classes.
429bd4f1 59
03312470 60NB: If you're used to L<Class::DBI> it's worth reading the L</SYNOPSIS>
2053ab2a 61carefully, as DBIx::Class does things a little differently. Note in
03312470 62particular which module inherits off which.
63
c2da098a 64=head1 METHODS
65
87c4e602 66=head2 register_class
67
27f01d1f 68=over 4
69
ebc77b53 70=item Arguments: $moniker, $component_class
27f01d1f 71
72=back
076652e8 73
71f9df37 74Registers a class which isa DBIx::Class::ResultSourceProxy. Equivalent to
2053ab2a 75calling:
66d9ef6b 76
181a28f4 77 $schema->register_source($moniker, $component_class->result_source_instance);
076652e8 78
c2da098a 79=cut
80
a02675cd 81sub register_class {
0dc79249 82 my ($self, $moniker, $to_register) = @_;
83 $self->register_source($moniker => $to_register->result_source_instance);
74b92d9a 84}
85
87c4e602 86=head2 register_source
87
27f01d1f 88=over 4
89
ebc77b53 90=item Arguments: $moniker, $result_source
27f01d1f 91
92=back
076652e8 93
82b01c38 94Registers the L<DBIx::Class::ResultSource> in the schema with the given
95moniker.
076652e8 96
97=cut
98
0dc79249 99sub register_source {
2a4d9487 100 my $self = shift;
101
102 $self->_register_source(@_);
103}
104
105=head2 register_extra_source
106
107=over 4
108
109=item Arguments: $moniker, $result_source
110
111=back
112
113As L</register_source> but should be used if the result class already
114has a source and you want to register an extra one.
115
116=cut
117
118sub register_extra_source {
119 my $self = shift;
120
121 $self->_register_source(@_, { extra => 1 });
122}
123
124sub _register_source {
125 my ($self, $moniker, $source, $params) = @_;
93405cf0 126
127 %$source = %{ $source->new( { %$source, source_name => $moniker }) };
128
96c95414 129 my %reg = %{$self->source_registrations};
130 $reg{$moniker} = $source;
131 $self->source_registrations(\%reg);
93405cf0 132
0dc79249 133 $source->schema($self);
93405cf0 134
a917fb06 135 weaken($source->{schema}) if ref($self);
0dc79249 136 if ($source->result_class) {
96c95414 137 my %map = %{$self->class_mappings};
2a4d9487 138 if (exists $map{$source->result_class}) {
96f8959e 139 return if ($params->{extra});
2a4d9487 140 warn $source->result_class . ' already has a source, use register_extra_source for additional sources';
141 }
96c95414 142 $map{$source->result_class} = $moniker;
143 $self->class_mappings(\%map);
0dc79249 144 }
75d07914 145}
a02675cd 146
93405cf0 147sub _unregister_source {
148 my ($self, $moniker) = @_;
149 my %reg = %{$self->source_registrations};
150
151 my $source = delete $reg{$moniker};
152 $self->source_registrations(\%reg);
153 if ($source->result_class) {
154 my %map = %{$self->class_mappings};
155 delete $map{$source->result_class};
156 $self->class_mappings(\%map);
157 }
158}
159
bfb2bd4f 160=head2 class
161
27f01d1f 162=over 4
82b01c38 163
ebc77b53 164=item Arguments: $moniker
27f01d1f 165
d601dc88 166=item Return Value: $classname
27f01d1f 167
168=back
82b01c38 169
2053ab2a 170Retrieves the result class name for the given moniker. For example:
82b01c38 171
172 my $class = $schema->class('CD');
bfb2bd4f 173
174=cut
175
176sub class {
0dc79249 177 my ($self, $moniker) = @_;
178 return $self->source($moniker)->result_class;
bfb2bd4f 179}
180
ea20d0fd 181=head2 source
182
27f01d1f 183=over 4
184
ebc77b53 185=item Arguments: $moniker
27f01d1f 186
d601dc88 187=item Return Value: $result_source
82b01c38 188
27f01d1f 189=back
82b01c38 190
24d67825 191 my $source = $schema->source('Book');
ea20d0fd 192
82b01c38 193Returns the L<DBIx::Class::ResultSource> object for the registered moniker.
ea20d0fd 194
195=cut
196
197sub source {
0dc79249 198 my ($self, $moniker) = @_;
199 my $sreg = $self->source_registrations;
200 return $sreg->{$moniker} if exists $sreg->{$moniker};
201
202 # if we got here, they probably passed a full class name
203 my $mapped = $self->class_mappings->{$moniker};
701da8c4 204 $self->throw_exception("Can't find source for ${moniker}")
0dc79249 205 unless $mapped && exists $sreg->{$mapped};
206 return $sreg->{$mapped};
ea20d0fd 207}
208
0dc79249 209=head2 sources
210
27f01d1f 211=over 4
212
d601dc88 213=item Return Value: @source_monikers
27f01d1f 214
215=back
82b01c38 216
217Returns the source monikers of all source registrations on this schema.
2053ab2a 218For example:
82b01c38 219
220 my @source_monikers = $schema->sources;
0dc79249 221
222=cut
223
224sub sources { return keys %{shift->source_registrations}; }
225
9b1ba0f2 226=head2 storage
227
228 my $storage = $schema->storage;
229
230Returns the L<DBIx::Class::Storage> object for this Schema.
231
ea20d0fd 232=head2 resultset
233
27f01d1f 234=over 4
235
ebc77b53 236=item Arguments: $moniker
27f01d1f 237
d601dc88 238=item Return Value: $result_set
82b01c38 239
27f01d1f 240=back
82b01c38 241
24d67825 242 my $rs = $schema->resultset('DVD');
ea20d0fd 243
82b01c38 244Returns the L<DBIx::Class::ResultSet> object for the registered moniker.
ea20d0fd 245
246=cut
247
248sub resultset {
0dc79249 249 my ($self, $moniker) = @_;
250 return $self->source($moniker)->resultset;
ea20d0fd 251}
252
87c4e602 253=head2 load_classes
254
27f01d1f 255=over 4
256
257=item Arguments: @classes?, { $namespace => [ @classes ] }+
258
259=back
076652e8 260
82b01c38 261With no arguments, this method uses L<Module::Find> to find all classes under
262the schema's namespace. Otherwise, this method loads the classes you specify
263(using L<use>), and registers them (using L</"register_class">).
076652e8 264
2053ab2a 265It is possible to comment out classes with a leading C<#>, but note that perl
266will think it's a mistake (trying to use a comment in a qw list), so you'll
267need to add C<no warnings 'qw';> before your load_classes call.
5ce32fc1 268
2053ab2a 269Example:
82b01c38 270
271 My::Schema->load_classes(); # loads My::Schema::CD, My::Schema::Artist,
75d07914 272 # etc. (anything under the My::Schema namespace)
82b01c38 273
274 # loads My::Schema::CD, My::Schema::Artist, Other::Namespace::Producer but
275 # not Other::Namespace::LinerNotes nor My::Schema::Track
276 My::Schema->load_classes(qw/ CD Artist #Track /, {
277 Other::Namespace => [qw/ Producer #LinerNotes /],
278 });
279
076652e8 280=cut
281
a02675cd 282sub load_classes {
5ce32fc1 283 my ($class, @params) = @_;
bab77431 284
5ce32fc1 285 my %comps_for;
bab77431 286
5ce32fc1 287 if (@params) {
288 foreach my $param (@params) {
289 if (ref $param eq 'ARRAY') {
290 # filter out commented entries
291 my @modules = grep { $_ !~ /^#/ } @$param;
bab77431 292
5ce32fc1 293 push (@{$comps_for{$class}}, @modules);
294 }
295 elsif (ref $param eq 'HASH') {
296 # more than one namespace possible
297 for my $comp ( keys %$param ) {
298 # filter out commented entries
299 my @modules = grep { $_ !~ /^#/ } @{$param->{$comp}};
300
301 push (@{$comps_for{$comp}}, @modules);
302 }
303 }
304 else {
305 # filter out commented entries
306 push (@{$comps_for{$class}}, $param) if $param !~ /^#/;
307 }
308 }
309 } else {
bc0c9800 310 my @comp = map { substr $_, length "${class}::" }
311 Module::Find::findallmod($class);
5ce32fc1 312 $comps_for{$class} = \@comp;
41a6f8c0 313 }
5ce32fc1 314
e6efde04 315 my @to_register;
316 {
317 no warnings qw/redefine/;
318 local *Class::C3::reinitialize = sub { };
319 foreach my $prefix (keys %comps_for) {
320 foreach my $comp (@{$comps_for{$prefix}||[]}) {
321 my $comp_class = "${prefix}::${comp}";
83542a7d 322 { # try to untaint module name. mods where this fails
323 # are left alone so we don't have to change the old behavior
324 no locale; # localized \w doesn't untaint expression
325 if ( $comp_class =~ m/^( (?:\w+::)* \w+ )$/x ) {
326 $comp_class = $1;
327 }
328 }
c037c03a 329 $class->ensure_class_loaded($comp_class);
bab77431 330
93405cf0 331 $comp = $comp_class->source_name || $comp;
332# $DB::single = 1;
333 push(@to_register, [ $comp, $comp_class ]);
bfb2bd4f 334 }
5ce32fc1 335 }
a02675cd 336 }
e6efde04 337 Class::C3->reinitialize;
338
339 foreach my $to (@to_register) {
340 $class->register_class(@$to);
341 # if $class->can('result_source_instance');
342 }
a02675cd 343}
344
2374c5ff 345=head2 load_namespaces
346
347=over 4
348
85bd0538 349=item Arguments: %options?
2374c5ff 350
351=back
352
353This is an alternative to L</load_classes> above which assumes an alternative
c87014e8 354layout for automatic class loading. It assumes that all result
355classes are underneath a sub-namespace of the schema called C<Result>, any
7a58f051 356corresponding ResultSet classes are underneath a sub-namespace of the schema
46a05fd4 357called C<ResultSet>.
2374c5ff 358
46a05fd4 359Both of the sub-namespaces are configurable if you don't like the defaults,
c87014e8 360via the options C<result_namespace> and C<resultset_namespace>.
85bd0538 361
25fb14bd 362If (and only if) you specify the option C<default_resultset_class>, any found
c87014e8 363Result classes for which we do not find a corresponding
25fb14bd 364ResultSet class will have their C<resultset_class> set to
365C<default_resultset_class>.
0f4ec1d2 366
46a05fd4 367C<load_namespaces> takes care of calling C<resultset_class> for you where
368neccessary if you didn't do it for yourself.
f017c022 369
0f4ec1d2 370All of the namespace and classname options to this method are relative to
371the schema classname by default. To specify a fully-qualified name, prefix
372it with a literal C<+>.
2374c5ff 373
f017c022 374Examples:
2374c5ff 375
c87014e8 376 # load My::Schema::Result::CD, My::Schema::Result::Artist,
2374c5ff 377 # My::Schema::ResultSet::CD, etc...
0f4ec1d2 378 My::Schema->load_namespaces;
379
c87014e8 380 # Override everything to use ugly names.
381 # In this example, if there is a My::Schema::Res::Foo, but no matching
382 # My::Schema::RSets::Foo, then Foo will have its
383 # resultset_class set to My::Schema::RSetBase
0f4ec1d2 384 My::Schema->load_namespaces(
c87014e8 385 result_namespace => 'Res',
0f4ec1d2 386 resultset_namespace => 'RSets',
25fb14bd 387 default_resultset_class => 'RSetBase',
0f4ec1d2 388 );
2374c5ff 389
0f4ec1d2 390 # Put things in other namespaces
85bd0538 391 My::Schema->load_namespaces(
c87014e8 392 result_namespace => '+Some::Place::Results',
0f4ec1d2 393 resultset_namespace => '+Another::Place::RSets',
85bd0538 394 );
0f4ec1d2 395
f017c022 396If you'd like to use multiple namespaces of each type, simply use an arrayref
c87014e8 397of namespaces for that option. In the case that the same result
46a05fd4 398(or resultset) class exists in multiple namespaces, the latter entries in
399your list of namespaces will override earlier ones.
f017c022 400
401 My::Schema->load_namespaces(
c87014e8 402 # My::Schema::Results_C::Foo takes precedence over My::Schema::Results_B::Foo :
403 result_namespace => [ 'Results_A', 'Results_B', 'Results_C' ],
f017c022 404 resultset_namespace => [ '+Some::Place::RSets', 'RSets' ],
405 );
85bd0538 406
2374c5ff 407=cut
408
f017c022 409# Pre-pends our classname to the given relative classname or
410# class namespace, unless there is a '+' prefix, which will
7a58f051 411# be stripped.
f017c022 412sub _expand_relative_name {
7a58f051 413 my ($class, $name) = @_;
414 return if !$name;
415 $name = $class . '::' . $name if ! ($name =~ s/^\+//);
416 return $name;
f017c022 417}
418
419# returns a hash of $shortname => $fullname for every package
420# found in the given namespaces ($shortname is with the $fullname's
421# namespace stripped off)
422sub _map_namespaces {
423 my ($class, @namespaces) = @_;
424
425 my @results_hash;
426 foreach my $namespace (@namespaces) {
427 push(
428 @results_hash,
429 map { (substr($_, length "${namespace}::"), $_) }
430 Module::Find::findallmod($namespace)
431 );
432 }
433
434 @results_hash;
435}
436
2374c5ff 437sub load_namespaces {
85bd0538 438 my ($class, %args) = @_;
2374c5ff 439
c87014e8 440 my $result_namespace = delete $args{result_namespace} || 'Result';
25fb14bd 441 my $resultset_namespace = delete $args{resultset_namespace} || 'ResultSet';
25fb14bd 442 my $default_resultset_class = delete $args{default_resultset_class};
0f4ec1d2 443
25fb14bd 444 $class->throw_exception('load_namespaces: unknown option(s): '
445 . join(q{,}, map { qq{'$_'} } keys %args))
446 if scalar keys %args;
447
7a58f051 448 $default_resultset_class
449 = $class->_expand_relative_name($default_resultset_class);
f017c022 450
c87014e8 451 for my $arg ($result_namespace, $resultset_namespace) {
f017c022 452 $arg = [ $arg ] if !ref($arg) && $arg;
2374c5ff 453
f017c022 454 $class->throw_exception('load_namespaces: namespace arguments must be '
455 . 'a simple string or an arrayref')
456 if ref($arg) ne 'ARRAY';
2374c5ff 457
7a58f051 458 $_ = $class->_expand_relative_name($_) for (@$arg);
f017c022 459 }
2374c5ff 460
c87014e8 461 my %results = $class->_map_namespaces(@$result_namespace);
f017c022 462 my %resultsets = $class->_map_namespaces(@$resultset_namespace);
0f4ec1d2 463
2374c5ff 464 my @to_register;
465 {
25fb14bd 466 no warnings 'redefine';
2374c5ff 467 local *Class::C3::reinitialize = sub { };
25fb14bd 468 use warnings 'redefine';
0f4ec1d2 469
c87014e8 470 foreach my $result (keys %results) {
471 my $result_class = $results{$result};
472 $class->ensure_class_loaded($result_class);
473 $result_class->source_name($result) unless $result_class->source_name;
0f4ec1d2 474
c87014e8 475 my $rs_class = delete $resultsets{$result};
476 my $rs_set = $result_class->resultset_class;
25fb14bd 477 if($rs_set && $rs_set ne 'DBIx::Class::ResultSet') {
f017c022 478 if($rs_class && $rs_class ne $rs_set) {
c87014e8 479 warn "We found ResultSet class '$rs_class' for '$result', but it seems "
480 . "that you had already set '$result' to use '$rs_set' instead";
2374c5ff 481 }
482 }
25fb14bd 483 elsif($rs_class ||= $default_resultset_class) {
484 $class->ensure_class_loaded($rs_class);
c87014e8 485 $result_class->resultset_class($rs_class);
0f4ec1d2 486 }
2374c5ff 487
c87014e8 488 push(@to_register, [ $result_class->source_name, $result_class ]);
2374c5ff 489 }
490 }
491
0f4ec1d2 492 foreach (sort keys %resultsets) {
493 warn "load_namespaces found ResultSet class $_ with no "
c87014e8 494 . 'corresponding Result class';
2374c5ff 495 }
0f4ec1d2 496
fdcd8145 497 Class::C3->reinitialize;
498 $class->register_class(@$_) for (@to_register);
499
0f4ec1d2 500 return;
2374c5ff 501}
502
c216324a 503=head2 compose_connection (DEPRECATED)
87c4e602 504
27f01d1f 505=over 4
506
ebc77b53 507=item Arguments: $target_namespace, @db_info
429bd4f1 508
d601dc88 509=item Return Value: $new_schema
27f01d1f 510
511=back
076652e8 512
c216324a 513DEPRECATED. You probably wanted compose_namespace.
514
515Actually, you probably just wanted to call connect.
516
1c133e22 517=begin hidden
518
519(hidden due to deprecation)
c216324a 520
2053ab2a 521Calls L<DBIx::Class::Schema/"compose_namespace"> to the target namespace,
522calls L<DBIx::Class::Schema/connection> with @db_info on the new schema,
523then injects the L<DBix::Class::ResultSetProxy> component and a
524resultset_instance classdata entry on all the new classes, in order to support
82b01c38 525$target_namespaces::$class->search(...) method calls.
526
527This is primarily useful when you have a specific need for class method access
528to a connection. In normal usage it is preferred to call
529L<DBIx::Class::Schema/connect> and use the resulting schema object to operate
530on L<DBIx::Class::ResultSet> objects with L<DBIx::Class::Schema/resultset> for
531more information.
54540863 532
1c133e22 533=end hidden
534
076652e8 535=cut
536
c216324a 537{
538 my $warn;
539
540 sub compose_connection {
541 my ($self, $target, @info) = @_;
542
3943fd63 543 warn "compose_connection deprecated as of 0.08000"
544 unless ($INC{"DBIx/Class/CDBICompat.pm"} || $warn++);
c216324a 545
546 my $base = 'DBIx::Class::ResultSetProxy';
547 eval "require ${base};";
548 $self->throw_exception
549 ("No arguments to load_classes and couldn't load ${base} ($@)")
550 if $@;
551
552 if ($self eq $target) {
553 # Pathological case, largely caused by the docs on early C::M::DBIC::Plain
554 foreach my $moniker ($self->sources) {
555 my $source = $self->source($moniker);
556 my $class = $source->result_class;
557 $self->inject_base($class, $base);
558 $class->mk_classdata(resultset_instance => $source->resultset);
559 $class->mk_classdata(class_resolver => $self);
560 }
561 $self->connection(@info);
562 return $self;
563 }
564
565 my $schema = $self->compose_namespace($target, $base);
566 {
567 no strict 'refs';
ddc0a6c8 568 my $name = join '::', $target, 'schema';
569 *$name = Sub::Name::subname $name, sub { $schema };
c216324a 570 }
571
572 $schema->connection(@info);
573 foreach my $moniker ($schema->sources) {
574 my $source = $schema->source($moniker);
be381829 575 my $class = $source->result_class;
c216324a 576 #warn "$moniker $class $source ".$source->storage;
577 $class->mk_classdata(result_source_instance => $source);
be381829 578 $class->mk_classdata(resultset_instance => $source->resultset);
c216324a 579 $class->mk_classdata(class_resolver => $schema);
be381829 580 }
c216324a 581 return $schema;
bfb2bd4f 582 }
e678398e 583}
584
77254782 585=head2 compose_namespace
586
27f01d1f 587=over 4
588
589=item Arguments: $target_namespace, $additional_base_class?
82b01c38 590
d601dc88 591=item Return Value: $new_schema
27f01d1f 592
593=back
13765dad 594
82b01c38 595For each L<DBIx::Class::ResultSource> in the schema, this method creates a
596class in the target namespace (e.g. $target_namespace::CD,
597$target_namespace::Artist) that inherits from the corresponding classes
598attached to the current schema.
77254782 599
82b01c38 600It also attaches a corresponding L<DBIx::Class::ResultSource> object to the
601new $schema object. If C<$additional_base_class> is given, the new composed
602classes will inherit from first the corresponding classe from the current
603schema then the base class.
604
2053ab2a 605For example, for a schema with My::Schema::CD and My::Schema::Artist classes,
82b01c38 606
607 $schema->compose_namespace('My::DB', 'Base::Class');
608 print join (', ', @My::DB::CD::ISA) . "\n";
609 print join (', ', @My::DB::Artist::ISA) ."\n";
610
2053ab2a 611will produce the output
82b01c38 612
613 My::Schema::CD, Base::Class
614 My::Schema::Artist, Base::Class
77254782 615
616=cut
617
e678398e 618sub compose_namespace {
66d9ef6b 619 my ($self, $target, $base) = @_;
66d9ef6b 620 my $schema = $self->clone;
e9100ff7 621 {
622 no warnings qw/redefine/;
623 local *Class::C3::reinitialize = sub { };
624 foreach my $moniker ($schema->sources) {
625 my $source = $schema->source($moniker);
626 my $target_class = "${target}::${moniker}";
627 $self->inject_base(
628 $target_class => $source->result_class, ($base ? $base : ())
629 );
630 $source->result_class($target_class);
9d3d5af3 631 $target_class->result_source_instance($source)
632 if $target_class->can('result_source_instance');
e9100ff7 633 }
b7951443 634 }
e9100ff7 635 Class::C3->reinitialize();
11b78bd6 636 {
637 no strict 'refs';
978b42af 638 no warnings 'redefine';
1edaf6fe 639 foreach my $meth (qw/class source resultset/) {
ddc0a6c8 640 my $name = join '::', $target, $meth;
641 *$name = Sub::Name::subname $name, sub { shift->schema->$meth(@_) };
1edaf6fe 642 }
11b78bd6 643 }
bfb2bd4f 644 return $schema;
b7951443 645}
646
647sub setup_connection_class {
648 my ($class, $target, @info) = @_;
63e9583a 649 $class->inject_base($target => 'DBIx::Class::DB');
650 #$target->load_components('DB');
b7951443 651 $target->connection(@info);
652}
653
6b43ba5f 654=head2 storage_type
655
656=over 4
657
161fb223 658=item Arguments: $storage_type|{$storage_type, \%args}
6b43ba5f 659
161fb223 660=item Return Value: $storage_type|{$storage_type, \%args}
6b43ba5f 661
662=back
663
664Set the storage class that will be instantiated when L</connect> is called.
665If the classname starts with C<::>, the prefix C<DBIx::Class::Storage> is
666assumed by L</connect>. Defaults to C<::DBI>,
667which is L<DBIx::Class::Storage::DBI>.
668
669You want to use this to hardcoded subclasses of L<DBIx::Class::Storage::DBI>
670in cases where the appropriate subclass is not autodetected, such as when
671dealing with MSSQL via L<DBD::Sybase>, in which case you'd set it to
672C<::DBI::Sybase::MSSQL>.
673
106d5f3b 674If your storage type requires instantiation arguments, those are defined as a
675second argument in the form of a hashref and the entire value needs to be
161fb223 676wrapped into an arrayref or a hashref. We support both types of refs here in
677order to play nice with your Config::[class] or your choice.
678
679See L<DBIx::Class::Storage::DBI::Replicated> for an example of this.
106d5f3b 680
87c4e602 681=head2 connection
682
27f01d1f 683=over 4
684
ebc77b53 685=item Arguments: @args
66d9ef6b 686
d601dc88 687=item Return Value: $new_schema
27f01d1f 688
689=back
82b01c38 690
691Instantiates a new Storage object of type
692L<DBIx::Class::Schema/"storage_type"> and passes the arguments to
85f78622 693$storage->connect_info. Sets the connection in-place on the schema.
694
695See L<DBIx::Class::Storage::DBI/"connect_info"> for DBI-specific syntax,
696or L<DBIx::Class::Storage> in general.
66d9ef6b 697
698=cut
699
700sub connection {
701 my ($self, @info) = @_;
e59d3e5b 702 return $self if !@info && $self->storage;
106d5f3b 703
704 my ($storage_class, $args) = ref $self->storage_type ?
161fb223 705 ($self->_normalize_storage_type($self->storage_type),{}) : ($self->storage_type, {});
106d5f3b 706
1e10a11d 707 $storage_class = 'DBIx::Class::Storage'.$storage_class
708 if $storage_class =~ m/^::/;
8ef144ff 709 eval "require ${storage_class};";
bc0c9800 710 $self->throw_exception(
711 "No arguments to load_classes and couldn't load ${storage_class} ($@)"
712 ) if $@;
106d5f3b 713 my $storage = $storage_class->new($self=>$args);
66d9ef6b 714 $storage->connect_info(\@info);
715 $self->storage($storage);
716 return $self;
717}
718
161fb223 719sub _normalize_storage_type {
64cdad22 720 my ($self, $storage_type) = @_;
721 if(ref $storage_type eq 'ARRAY') {
722 return @$storage_type;
723 } elsif(ref $storage_type eq 'HASH') {
724 return %$storage_type;
725 } else {
726 $self->throw_exception('Unsupported REFTYPE given: '. ref $storage_type);
727 }
161fb223 728}
729
87c4e602 730=head2 connect
731
27f01d1f 732=over 4
733
ebc77b53 734=item Arguments: @info
66d9ef6b 735
d601dc88 736=item Return Value: $new_schema
27f01d1f 737
738=back
82b01c38 739
740This is a convenience method. It is equivalent to calling
741$schema->clone->connection(@info). See L</connection> and L</clone> for more
742information.
66d9ef6b 743
744=cut
745
08b515f1 746sub connect { shift->clone->connection(@_) }
747
4012acd8 748=head2 txn_do
08b515f1 749
4012acd8 750=over 4
08b515f1 751
4012acd8 752=item Arguments: C<$coderef>, @coderef_args?
08b515f1 753
4012acd8 754=item Return Value: The return value of $coderef
08b515f1 755
4012acd8 756=back
08b515f1 757
4012acd8 758Executes C<$coderef> with (optional) arguments C<@coderef_args> atomically,
759returning its result (if any). Equivalent to calling $schema->storage->txn_do.
760See L<DBIx::Class::Storage/"txn_do"> for more information.
08b515f1 761
4012acd8 762This interface is preferred over using the individual methods L</txn_begin>,
763L</txn_commit>, and L</txn_rollback> below.
08b515f1 764
4012acd8 765=cut
08b515f1 766
4012acd8 767sub txn_do {
768 my $self = shift;
08b515f1 769
4012acd8 770 $self->storage or $self->throw_exception
771 ('txn_do called on $schema without storage');
08b515f1 772
4012acd8 773 $self->storage->txn_do(@_);
774}
66d9ef6b 775
89028f42 776=head2 txn_scope_guard (EXPERIMENTAL)
75c8a7ab 777
89028f42 778Runs C<txn_scope_guard> on the schema's storage. See
779L<DBIx::Class::Storage/txn_scope_guard>.
75c8a7ab 780
b85be4c1 781=cut
782
1bc193ac 783sub txn_scope_guard {
784 my $self = shift;
785
786 $self->storage or $self->throw_exception
787 ('txn_scope_guard called on $schema without storage');
788
789 $self->storage->txn_scope_guard(@_);
790}
791
4012acd8 792=head2 txn_begin
a62cf8d4 793
4012acd8 794Begins a transaction (does nothing if AutoCommit is off). Equivalent to
795calling $schema->storage->txn_begin. See
796L<DBIx::Class::Storage::DBI/"txn_begin"> for more information.
27f01d1f 797
4012acd8 798=cut
82b01c38 799
4012acd8 800sub txn_begin {
801 my $self = shift;
27f01d1f 802
4012acd8 803 $self->storage or $self->throw_exception
804 ('txn_begin called on $schema without storage');
a62cf8d4 805
4012acd8 806 $self->storage->txn_begin;
807}
a62cf8d4 808
4012acd8 809=head2 txn_commit
a62cf8d4 810
4012acd8 811Commits the current transaction. Equivalent to calling
812$schema->storage->txn_commit. See L<DBIx::Class::Storage::DBI/"txn_commit">
813for more information.
a62cf8d4 814
4012acd8 815=cut
a62cf8d4 816
4012acd8 817sub txn_commit {
818 my $self = shift;
a62cf8d4 819
4012acd8 820 $self->storage or $self->throw_exception
821 ('txn_commit called on $schema without storage');
a62cf8d4 822
4012acd8 823 $self->storage->txn_commit;
824}
70634260 825
4012acd8 826=head2 txn_rollback
a62cf8d4 827
4012acd8 828Rolls back the current transaction. Equivalent to calling
829$schema->storage->txn_rollback. See
830L<DBIx::Class::Storage::DBI/"txn_rollback"> for more information.
a62cf8d4 831
832=cut
833
4012acd8 834sub txn_rollback {
835 my $self = shift;
a62cf8d4 836
19630353 837 $self->storage or $self->throw_exception
4012acd8 838 ('txn_rollback called on $schema without storage');
a62cf8d4 839
4012acd8 840 $self->storage->txn_rollback;
a62cf8d4 841}
842
adb3554a 843=head2 svp_begin
844
845Creates a new savepoint (does nothing outside a transaction).
846Equivalent to calling $schema->storage->svp_begin. See
847L<DBIx::Class::Storage::DBI/"svp_begin"> for more information.
848
849=cut
850
851sub svp_begin {
852 my ($self, $name) = @_;
853
854 $self->storage or $self->throw_exception
855 ('svp_begin called on $schema without storage');
856
857 $self->storage->svp_begin($name);
858}
859
860=head2 svp_release
861
862Releases a savepoint (does nothing outside a transaction).
863Equivalent to calling $schema->storage->svp_release. See
864L<DBIx::Class::Storage::DBI/"svp_release"> for more information.
865
866=cut
867
868sub svp_release {
869 my ($self, $name) = @_;
870
871 $self->storage or $self->throw_exception
872 ('svp_release called on $schema without storage');
873
874 $self->storage->svp_release($name);
875}
876
877=head2 svp_rollback
878
879Rollback to a savepoint (does nothing outside a transaction).
880Equivalent to calling $schema->storage->svp_rollback. See
881L<DBIx::Class::Storage::DBI/"svp_rollback"> for more information.
882
883=cut
884
885sub svp_rollback {
886 my ($self, $name) = @_;
887
888 $self->storage or $self->throw_exception
889 ('svp_rollback called on $schema without storage');
890
891 $self->storage->svp_rollback($name);
892}
893
66d9ef6b 894=head2 clone
895
27f01d1f 896=over 4
897
d601dc88 898=item Return Value: $new_schema
27f01d1f 899
900=back
82b01c38 901
66d9ef6b 902Clones the schema and its associated result_source objects and returns the
903copy.
904
905=cut
906
907sub clone {
908 my ($self) = @_;
04786a4c 909 my $clone = { (ref $self ? %$self : ()) };
910 bless $clone, (ref $self || $self);
911
73529292 912 $clone->class_mappings({ %{$clone->class_mappings} });
913 $clone->source_registrations({ %{$clone->source_registrations} });
66d9ef6b 914 foreach my $moniker ($self->sources) {
915 my $source = $self->source($moniker);
916 my $new = $source->new($source);
95120bb5 917 # we use extra here as we want to leave the class_mappings as they are
918 # but overwrite the source_registrations entry with the new source
919 $clone->register_extra_source($moniker => $new);
66d9ef6b 920 }
82cc0386 921 $clone->storage->set_schema($clone) if $clone->storage;
66d9ef6b 922 return $clone;
923}
924
87c4e602 925=head2 populate
926
27f01d1f 927=over 4
928
16c5f7d3 929=item Arguments: $source_name, \@data;
27f01d1f 930
931=back
a37a4697 932
16c5f7d3 933Pass this method a resultsource name, and an arrayref of
934arrayrefs. The arrayrefs should contain a list of column names,
935followed by one or many sets of matching data for the given columns.
936
744076d8 937In void context, C<insert_bulk> in L<DBIx::Class::Storage::DBI> is used
938to insert the data, as this is a fast method. However, insert_bulk currently
939assumes that your datasets all contain the same type of values, using scalar
940references in a column in one row, and not in another will probably not work.
941
942Otherwise, each set of data is inserted into the database using
16c5f7d3 943L<DBIx::Class::ResultSet/create>, and a arrayref of the resulting row
944objects is returned.
82b01c38 945
946i.e.,
a37a4697 947
24d67825 948 $schema->populate('Artist', [
949 [ qw/artistid name/ ],
950 [ 1, 'Popular Band' ],
951 [ 2, 'Indie Band' ],
a62cf8d4 952 ...
953 ]);
5a93e138 954
955Since wantarray context is basically the same as looping over $rs->create(...)
956you won't see any performance benefits and in this case the method is more for
957convenience. Void context sends the column information directly to storage
958using <DBI>s bulk insert method. So the performance will be much better for
959storages that support this method.
960
961Because of this difference in the way void context inserts rows into your
962database you need to note how this will effect any loaded components that
963override or augment insert. For example if you are using a component such
964as L<DBIx::Class::UUIDColumns> to populate your primary keys you MUST use
965wantarray context if you want the PKs automatically created.
a37a4697 966
967=cut
968
969sub populate {
970 my ($self, $name, $data) = @_;
971 my $rs = $self->resultset($name);
972 my @names = @{shift(@$data)};
54e0bd06 973 if(defined wantarray) {
974 my @created;
975 foreach my $item (@$data) {
976 my %create;
977 @create{@names} = @$item;
978 push(@created, $rs->create(\%create));
979 }
980 return @created;
a37a4697 981 }
8b93a938 982 my @results_to_create;
983 foreach my $datum (@$data) {
984 my %result_to_create;
985 foreach my $index (0..$#names) {
986 $result_to_create{$names[$index]} = $$datum[$index];
987 }
988 push @results_to_create, \%result_to_create;
989 }
990 $rs->populate(\@results_to_create);
a37a4697 991}
992
82cc0386 993=head2 exception_action
994
995=over 4
996
997=item Arguments: $code_reference
998
999=back
1000
db5dc233 1001If C<exception_action> is set for this class/object, L</throw_exception>
1002will prefer to call this code reference with the exception as an argument,
613397e7 1003rather than its normal C<croak> or C<confess> action.
db5dc233 1004
1005Your subroutine should probably just wrap the error in the exception
1006object/class of your choosing and rethrow. If, against all sage advice,
1007you'd like your C<exception_action> to suppress a particular exception
1008completely, simply have it return true.
82cc0386 1009
1010Example:
1011
1012 package My::Schema;
1013 use base qw/DBIx::Class::Schema/;
1014 use My::ExceptionClass;
1015 __PACKAGE__->exception_action(sub { My::ExceptionClass->throw(@_) });
1016 __PACKAGE__->load_classes;
1017
db5dc233 1018 # or:
82cc0386 1019 my $schema_obj = My::Schema->connect( .... );
1020 $schema_obj->exception_action(sub { My::ExceptionClass->throw(@_) });
1021
db5dc233 1022 # suppress all exceptions, like a moron:
1023 $schema_obj->exception_action(sub { 1 });
1024
613397e7 1025=head2 stacktrace
1026
84c5863b 1027=over 4
613397e7 1028
1029=item Arguments: boolean
1030
1031=back
1032
4981dc70 1033Whether L</throw_exception> should include stack trace information.
4b946902 1034Defaults to false normally, but defaults to true if C<$ENV{DBIC_TRACE}>
1035is true.
613397e7 1036
5160b401 1037=head2 throw_exception
701da8c4 1038
75d07914 1039=over 4
82b01c38 1040
ebc77b53 1041=item Arguments: $message
82b01c38 1042
1043=back
1044
1045Throws an exception. Defaults to using L<Carp::Clan> to report errors from
db5dc233 1046user's perspective. See L</exception_action> for details on overriding
4b946902 1047this method's behavior. If L</stacktrace> is turned on, C<throw_exception>'s
1048default behavior will provide a detailed stack trace.
701da8c4 1049
1050=cut
1051
1052sub throw_exception {
82cc0386 1053 my $self = shift;
4981dc70 1054
1055 DBIx::Class::Exception->throw($_[0], $self->stacktrace)
1056 if !$self->exception_action || !$self->exception_action->(@_);
701da8c4 1057}
1058
dfccde48 1059=head2 deploy
1c339d71 1060
82b01c38 1061=over 4
1062
6e73ac25 1063=item Arguments: $sqlt_args, $dir
82b01c38 1064
1065=back
1066
1067Attempts to deploy the schema to the current storage using L<SQL::Translator>.
ec6704d4 1068
51bace1c 1069See L<SQL::Translator/METHODS> for a list of values for C<$sqlt_args>. The most
1070common value for this would be C<< { add_drop_table => 1, } >> to have the SQL
1071produced include a DROP TABLE statement for each table created.
1072
499adf63 1073Additionally, the DBIx::Class parser accepts a C<sources> parameter as a hash
1074ref or an array ref, containing a list of source to deploy. If present, then
0e2c6809 1075only the sources listed will get deployed. Furthermore, you can use the
1076C<add_fk_index> parser parameter to prevent the parser from creating an index for each
1077FK.
499adf63 1078
1c339d71 1079=cut
1080
1081sub deploy {
6e73ac25 1082 my ($self, $sqltargs, $dir) = @_;
1c339d71 1083 $self->throw_exception("Can't deploy without storage") unless $self->storage;
6e73ac25 1084 $self->storage->deploy($self, undef, $sqltargs, $dir);
1c339d71 1085}
1086
0e0ce6c1 1087=head2 deployment_statements
1088
1089=over 4
1090
1091=item Arguments: $rdbms_type
1092
1093=back
1094
1095Returns the SQL statements used by L</deploy> and L<DBIx::Class::Schema/deploy>.
1096C<$rdbms_type> provides the DBI database driver name for which the SQL
1097statements are produced. If not supplied, the type of the current schema storage
1098will be used.
1099
1100=cut
1101
1102sub deployment_statements {
1103 my ($self, $rdbms_type) = @_;
1104
1105 $self->throw_exception("Can't generate deployment statements without a storage")
1106 if not $self->storage;
1107
1108 $self->storage->deployment_statements($self, $rdbms_type);
1109}
1110
c0f61310 1111=head2 create_ddl_dir (EXPERIMENTAL)
1112
1113=over 4
1114
c9d2e0a2 1115=item Arguments: \@databases, $version, $directory, $preversion, $sqlt_args
c0f61310 1116
1117=back
1118
1119Creates an SQL file based on the Schema, for each of the specified
c9d2e0a2 1120database types, in the given directory. Given a previous version number,
1121this will also create a file containing the ALTER TABLE statements to
1122transform the previous schema into the current one. Note that these
1123statements may contain DROP TABLE or DROP COLUMN statements that can
1124potentially destroy data.
1125
1126The file names are created using the C<ddl_filename> method below, please
1127override this method in your schema if you would like a different file
1128name format. For the ALTER file, the same format is used, replacing
1129$version in the name with "$preversion-$version".
1130
0e2c6809 1131See L<DBIx::Class::Schema/deploy> for details of $sqlt_args.
1132
c9d2e0a2 1133If no arguments are passed, then the following default values are used:
1134
1135=over 4
1136
1137=item databases - ['MySQL', 'SQLite', 'PostgreSQL']
1138
1139=item version - $schema->VERSION
1140
1141=item directory - './'
1142
1143=item preversion - <none>
1144
1145=back
c0f61310 1146
1147Note that this feature is currently EXPERIMENTAL and may not work correctly
1148across all databases, or fully handle complex relationships.
1149
c9d2e0a2 1150WARNING: Please check all SQL files created, before applying them.
1151
c0f61310 1152=cut
1153
6e73ac25 1154sub create_ddl_dir {
e673f011 1155 my $self = shift;
1156
1157 $self->throw_exception("Can't create_ddl_dir without storage") unless $self->storage;
1158 $self->storage->create_ddl_dir($self, @_);
1159}
1160
e63a82f7 1161=head2 ddl_filename
9b83fccd 1162
c9d2e0a2 1163=over 4
1164
99a74c4a 1165=item Arguments: $database-type, $version, $directory, $preversion
c9d2e0a2 1166
1167=back
1168
99a74c4a 1169 my $filename = $table->ddl_filename($type, $version, $dir, $preversion)
c9d2e0a2 1170
1171This method is called by C<create_ddl_dir> to compose a file name out of
1172the supplied directory, database type and version number. The default file
1173name format is: C<$dir$schema-$version-$type.sql>.
9b83fccd 1174
c9d2e0a2 1175You may override this method in your schema if you wish to use a different
1176format.
9b83fccd 1177
1178=cut
1179
6e73ac25 1180sub ddl_filename {
99a74c4a 1181 my ($self, $type, $version, $dir, $preversion) = @_;
e673f011 1182
99a74c4a 1183 my $filename = ref($self);
1184 $filename =~ s/::/-/g;
1185 $filename = File::Spec->catfile($dir, "$filename-$version-$type.sql");
1186 $filename =~ s/$version/$preversion-$version/ if($preversion);
1187
1188 return $filename;
e673f011 1189}
1190
d2f3e87b 1191=head2 sqlt_deploy_hook($sqlt_schema)
1192
1193An optional sub which you can declare in your own Schema class that will get
1194passed the L<SQL::Translator::Schema> object when you deploy the schema via
1195L</create_ddl_dir> or L</deploy>.
1196
1197For an example of what you can do with this, see
1198L<DBIx::Class::Manual::Cookbook/Adding Indexes And Functions To Your SQL>.
1199
4146e3da 1200=head2 thaw
1201
1202Provided as the recommened way of thawing schema objects. You can call
1203C<Storable::thaw> directly if you wish, but the thawed objects will not have a
1204reference to any schema, so are rather useless
1205
1206=cut
1207
1208sub thaw {
1209 my ($self, $obj) = @_;
1210 local $DBIx::Class::ResultSourceHandle::thaw_schema = $self;
1211 return Storable::thaw($obj);
1212}
1213
1214=head2 freeze
1215
1216This doesn't actualy do anything more than call L<Storable/freeze>, it is just
1217provided here for symetry.
1218
d2f3e87b 1219=cut
1220
4146e3da 1221sub freeze {
1222 return Storable::freeze($_[1]);
1223}
1224
1225=head2 dclone
1226
1227Recommeneded way of dcloning objects. This is needed to properly maintain
1228references to the schema object (which itself is B<not> cloned.)
1229
1230=cut
1231
1232sub dclone {
1233 my ($self, $obj) = @_;
1234 local $DBIx::Class::ResultSourceHandle::thaw_schema = $self;
1235 return Storable::dclone($obj);
1236}
1237
93e4d41a 1238=head2 schema_version
1239
1240Returns the current schema class' $VERSION
1241
1242=cut
1243
1244sub schema_version {
1245 my ($self) = @_;
1246 my $class = ref($self)||$self;
1247
1248 # does -not- use $schema->VERSION
1249 # since that varies in results depending on if version.pm is installed, and if
1250 # so the perl or XS versions. If you want this to change, bug the version.pm
1251 # author to make vpp and vxs behave the same.
1252
1253 my $version;
1254 {
1255 no strict 'refs';
1256 $version = ${"${class}::VERSION"};
1257 }
1258 return $version;
1259}
1260
a02675cd 12611;
c2da098a 1262
c2da098a 1263=head1 AUTHORS
1264
daec44b8 1265Matt S. Trout <mst@shadowcatsystems.co.uk>
c2da098a 1266
1267=head1 LICENSE
1268
1269You may distribute this code under the same terms as Perl itself.
1270
1271=cut