refactored compose_namepspace
[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);
a917fb06 134 weaken($source->{schema}) if ref($self);
6eec9003 135 return if ($params->{extra});
136
0dc79249 137 if ($source->result_class) {
96c95414 138 my %map = %{$self->class_mappings};
2a4d9487 139 if (exists $map{$source->result_class}) {
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) = @_;
6eec9003 620
621 $self = $self->clone;
622 foreach my $moniker ($self->sources) {
623 my $source = $self->source($moniker);
624 my $source_class = ref $source;
625 my $source_copy = $source_class->new({
626 %$source,
627 _relationships => Storable::dclone( $source->_relationships ),
628 });
629
630 my $target_class = "${target}::${moniker}";
631 $self->inject_base(
632 $target_class => $source_copy->result_class, ($base ? $base : ())
633 );
634 $source_copy->result_class($target_class);
635 $self->register_source($moniker, $source_copy);
11b78bd6 636 }
6eec9003 637 return $self;
b7951443 638}
639
640sub setup_connection_class {
641 my ($class, $target, @info) = @_;
63e9583a 642 $class->inject_base($target => 'DBIx::Class::DB');
643 #$target->load_components('DB');
b7951443 644 $target->connection(@info);
645}
646
6b43ba5f 647=head2 storage_type
648
649=over 4
650
161fb223 651=item Arguments: $storage_type|{$storage_type, \%args}
6b43ba5f 652
161fb223 653=item Return Value: $storage_type|{$storage_type, \%args}
6b43ba5f 654
655=back
656
657Set the storage class that will be instantiated when L</connect> is called.
658If the classname starts with C<::>, the prefix C<DBIx::Class::Storage> is
659assumed by L</connect>. Defaults to C<::DBI>,
660which is L<DBIx::Class::Storage::DBI>.
661
662You want to use this to hardcoded subclasses of L<DBIx::Class::Storage::DBI>
663in cases where the appropriate subclass is not autodetected, such as when
664dealing with MSSQL via L<DBD::Sybase>, in which case you'd set it to
665C<::DBI::Sybase::MSSQL>.
666
106d5f3b 667If your storage type requires instantiation arguments, those are defined as a
668second argument in the form of a hashref and the entire value needs to be
161fb223 669wrapped into an arrayref or a hashref. We support both types of refs here in
670order to play nice with your Config::[class] or your choice.
671
672See L<DBIx::Class::Storage::DBI::Replicated> for an example of this.
106d5f3b 673
87c4e602 674=head2 connection
675
27f01d1f 676=over 4
677
ebc77b53 678=item Arguments: @args
66d9ef6b 679
d601dc88 680=item Return Value: $new_schema
27f01d1f 681
682=back
82b01c38 683
684Instantiates a new Storage object of type
685L<DBIx::Class::Schema/"storage_type"> and passes the arguments to
85f78622 686$storage->connect_info. Sets the connection in-place on the schema.
687
688See L<DBIx::Class::Storage::DBI/"connect_info"> for DBI-specific syntax,
689or L<DBIx::Class::Storage> in general.
66d9ef6b 690
691=cut
692
693sub connection {
694 my ($self, @info) = @_;
e59d3e5b 695 return $self if !@info && $self->storage;
106d5f3b 696
697 my ($storage_class, $args) = ref $self->storage_type ?
161fb223 698 ($self->_normalize_storage_type($self->storage_type),{}) : ($self->storage_type, {});
106d5f3b 699
1e10a11d 700 $storage_class = 'DBIx::Class::Storage'.$storage_class
701 if $storage_class =~ m/^::/;
8ef144ff 702 eval "require ${storage_class};";
bc0c9800 703 $self->throw_exception(
704 "No arguments to load_classes and couldn't load ${storage_class} ($@)"
705 ) if $@;
106d5f3b 706 my $storage = $storage_class->new($self=>$args);
66d9ef6b 707 $storage->connect_info(\@info);
708 $self->storage($storage);
709 return $self;
710}
711
161fb223 712sub _normalize_storage_type {
64cdad22 713 my ($self, $storage_type) = @_;
714 if(ref $storage_type eq 'ARRAY') {
715 return @$storage_type;
716 } elsif(ref $storage_type eq 'HASH') {
717 return %$storage_type;
718 } else {
719 $self->throw_exception('Unsupported REFTYPE given: '. ref $storage_type);
720 }
161fb223 721}
722
87c4e602 723=head2 connect
724
27f01d1f 725=over 4
726
ebc77b53 727=item Arguments: @info
66d9ef6b 728
d601dc88 729=item Return Value: $new_schema
27f01d1f 730
731=back
82b01c38 732
733This is a convenience method. It is equivalent to calling
734$schema->clone->connection(@info). See L</connection> and L</clone> for more
735information.
66d9ef6b 736
737=cut
738
08b515f1 739sub connect { shift->clone->connection(@_) }
740
4012acd8 741=head2 txn_do
08b515f1 742
4012acd8 743=over 4
08b515f1 744
4012acd8 745=item Arguments: C<$coderef>, @coderef_args?
08b515f1 746
4012acd8 747=item Return Value: The return value of $coderef
08b515f1 748
4012acd8 749=back
08b515f1 750
4012acd8 751Executes C<$coderef> with (optional) arguments C<@coderef_args> atomically,
752returning its result (if any). Equivalent to calling $schema->storage->txn_do.
753See L<DBIx::Class::Storage/"txn_do"> for more information.
08b515f1 754
4012acd8 755This interface is preferred over using the individual methods L</txn_begin>,
756L</txn_commit>, and L</txn_rollback> below.
08b515f1 757
4012acd8 758=cut
08b515f1 759
4012acd8 760sub txn_do {
761 my $self = shift;
08b515f1 762
4012acd8 763 $self->storage or $self->throw_exception
764 ('txn_do called on $schema without storage');
08b515f1 765
4012acd8 766 $self->storage->txn_do(@_);
767}
66d9ef6b 768
89028f42 769=head2 txn_scope_guard (EXPERIMENTAL)
75c8a7ab 770
89028f42 771Runs C<txn_scope_guard> on the schema's storage. See
772L<DBIx::Class::Storage/txn_scope_guard>.
75c8a7ab 773
b85be4c1 774=cut
775
1bc193ac 776sub txn_scope_guard {
777 my $self = shift;
778
779 $self->storage or $self->throw_exception
780 ('txn_scope_guard called on $schema without storage');
781
782 $self->storage->txn_scope_guard(@_);
783}
784
4012acd8 785=head2 txn_begin
a62cf8d4 786
4012acd8 787Begins a transaction (does nothing if AutoCommit is off). Equivalent to
788calling $schema->storage->txn_begin. See
789L<DBIx::Class::Storage::DBI/"txn_begin"> for more information.
27f01d1f 790
4012acd8 791=cut
82b01c38 792
4012acd8 793sub txn_begin {
794 my $self = shift;
27f01d1f 795
4012acd8 796 $self->storage or $self->throw_exception
797 ('txn_begin called on $schema without storage');
a62cf8d4 798
4012acd8 799 $self->storage->txn_begin;
800}
a62cf8d4 801
4012acd8 802=head2 txn_commit
a62cf8d4 803
4012acd8 804Commits the current transaction. Equivalent to calling
805$schema->storage->txn_commit. See L<DBIx::Class::Storage::DBI/"txn_commit">
806for more information.
a62cf8d4 807
4012acd8 808=cut
a62cf8d4 809
4012acd8 810sub txn_commit {
811 my $self = shift;
a62cf8d4 812
4012acd8 813 $self->storage or $self->throw_exception
814 ('txn_commit called on $schema without storage');
a62cf8d4 815
4012acd8 816 $self->storage->txn_commit;
817}
70634260 818
4012acd8 819=head2 txn_rollback
a62cf8d4 820
4012acd8 821Rolls back the current transaction. Equivalent to calling
822$schema->storage->txn_rollback. See
823L<DBIx::Class::Storage::DBI/"txn_rollback"> for more information.
a62cf8d4 824
825=cut
826
4012acd8 827sub txn_rollback {
828 my $self = shift;
a62cf8d4 829
19630353 830 $self->storage or $self->throw_exception
4012acd8 831 ('txn_rollback called on $schema without storage');
a62cf8d4 832
4012acd8 833 $self->storage->txn_rollback;
a62cf8d4 834}
835
adb3554a 836=head2 svp_begin
837
838Creates a new savepoint (does nothing outside a transaction).
839Equivalent to calling $schema->storage->svp_begin. See
840L<DBIx::Class::Storage::DBI/"svp_begin"> for more information.
841
842=cut
843
844sub svp_begin {
845 my ($self, $name) = @_;
846
847 $self->storage or $self->throw_exception
848 ('svp_begin called on $schema without storage');
849
850 $self->storage->svp_begin($name);
851}
852
853=head2 svp_release
854
855Releases a savepoint (does nothing outside a transaction).
856Equivalent to calling $schema->storage->svp_release. See
857L<DBIx::Class::Storage::DBI/"svp_release"> for more information.
858
859=cut
860
861sub svp_release {
862 my ($self, $name) = @_;
863
864 $self->storage or $self->throw_exception
865 ('svp_release called on $schema without storage');
866
867 $self->storage->svp_release($name);
868}
869
870=head2 svp_rollback
871
872Rollback to a savepoint (does nothing outside a transaction).
873Equivalent to calling $schema->storage->svp_rollback. See
874L<DBIx::Class::Storage::DBI/"svp_rollback"> for more information.
875
876=cut
877
878sub svp_rollback {
879 my ($self, $name) = @_;
880
881 $self->storage or $self->throw_exception
882 ('svp_rollback called on $schema without storage');
883
884 $self->storage->svp_rollback($name);
885}
886
66d9ef6b 887=head2 clone
888
27f01d1f 889=over 4
890
d601dc88 891=item Return Value: $new_schema
27f01d1f 892
893=back
82b01c38 894
66d9ef6b 895Clones the schema and its associated result_source objects and returns the
896copy.
897
898=cut
899
900sub clone {
901 my ($self) = @_;
04786a4c 902 my $clone = { (ref $self ? %$self : ()) };
903 bless $clone, (ref $self || $self);
904
73529292 905 $clone->class_mappings({ %{$clone->class_mappings} });
906 $clone->source_registrations({ %{$clone->source_registrations} });
66d9ef6b 907 foreach my $moniker ($self->sources) {
908 my $source = $self->source($moniker);
909 my $new = $source->new($source);
95120bb5 910 # we use extra here as we want to leave the class_mappings as they are
911 # but overwrite the source_registrations entry with the new source
912 $clone->register_extra_source($moniker => $new);
66d9ef6b 913 }
82cc0386 914 $clone->storage->set_schema($clone) if $clone->storage;
66d9ef6b 915 return $clone;
916}
917
87c4e602 918=head2 populate
919
27f01d1f 920=over 4
921
16c5f7d3 922=item Arguments: $source_name, \@data;
27f01d1f 923
924=back
a37a4697 925
16c5f7d3 926Pass this method a resultsource name, and an arrayref of
927arrayrefs. The arrayrefs should contain a list of column names,
928followed by one or many sets of matching data for the given columns.
929
744076d8 930In void context, C<insert_bulk> in L<DBIx::Class::Storage::DBI> is used
931to insert the data, as this is a fast method. However, insert_bulk currently
932assumes that your datasets all contain the same type of values, using scalar
933references in a column in one row, and not in another will probably not work.
934
935Otherwise, each set of data is inserted into the database using
16c5f7d3 936L<DBIx::Class::ResultSet/create>, and a arrayref of the resulting row
937objects is returned.
82b01c38 938
939i.e.,
a37a4697 940
24d67825 941 $schema->populate('Artist', [
942 [ qw/artistid name/ ],
943 [ 1, 'Popular Band' ],
944 [ 2, 'Indie Band' ],
a62cf8d4 945 ...
946 ]);
5a93e138 947
948Since wantarray context is basically the same as looping over $rs->create(...)
949you won't see any performance benefits and in this case the method is more for
950convenience. Void context sends the column information directly to storage
951using <DBI>s bulk insert method. So the performance will be much better for
952storages that support this method.
953
954Because of this difference in the way void context inserts rows into your
955database you need to note how this will effect any loaded components that
956override or augment insert. For example if you are using a component such
957as L<DBIx::Class::UUIDColumns> to populate your primary keys you MUST use
958wantarray context if you want the PKs automatically created.
a37a4697 959
960=cut
961
962sub populate {
963 my ($self, $name, $data) = @_;
964 my $rs = $self->resultset($name);
965 my @names = @{shift(@$data)};
54e0bd06 966 if(defined wantarray) {
967 my @created;
968 foreach my $item (@$data) {
969 my %create;
970 @create{@names} = @$item;
971 push(@created, $rs->create(\%create));
972 }
973 return @created;
a37a4697 974 }
8b93a938 975 my @results_to_create;
976 foreach my $datum (@$data) {
977 my %result_to_create;
978 foreach my $index (0..$#names) {
979 $result_to_create{$names[$index]} = $$datum[$index];
980 }
981 push @results_to_create, \%result_to_create;
982 }
983 $rs->populate(\@results_to_create);
a37a4697 984}
985
82cc0386 986=head2 exception_action
987
988=over 4
989
990=item Arguments: $code_reference
991
992=back
993
db5dc233 994If C<exception_action> is set for this class/object, L</throw_exception>
995will prefer to call this code reference with the exception as an argument,
613397e7 996rather than its normal C<croak> or C<confess> action.
db5dc233 997
998Your subroutine should probably just wrap the error in the exception
999object/class of your choosing and rethrow. If, against all sage advice,
1000you'd like your C<exception_action> to suppress a particular exception
1001completely, simply have it return true.
82cc0386 1002
1003Example:
1004
1005 package My::Schema;
1006 use base qw/DBIx::Class::Schema/;
1007 use My::ExceptionClass;
1008 __PACKAGE__->exception_action(sub { My::ExceptionClass->throw(@_) });
1009 __PACKAGE__->load_classes;
1010
db5dc233 1011 # or:
82cc0386 1012 my $schema_obj = My::Schema->connect( .... );
1013 $schema_obj->exception_action(sub { My::ExceptionClass->throw(@_) });
1014
db5dc233 1015 # suppress all exceptions, like a moron:
1016 $schema_obj->exception_action(sub { 1 });
1017
613397e7 1018=head2 stacktrace
1019
84c5863b 1020=over 4
613397e7 1021
1022=item Arguments: boolean
1023
1024=back
1025
4981dc70 1026Whether L</throw_exception> should include stack trace information.
4b946902 1027Defaults to false normally, but defaults to true if C<$ENV{DBIC_TRACE}>
1028is true.
613397e7 1029
5160b401 1030=head2 throw_exception
701da8c4 1031
75d07914 1032=over 4
82b01c38 1033
ebc77b53 1034=item Arguments: $message
82b01c38 1035
1036=back
1037
1038Throws an exception. Defaults to using L<Carp::Clan> to report errors from
db5dc233 1039user's perspective. See L</exception_action> for details on overriding
4b946902 1040this method's behavior. If L</stacktrace> is turned on, C<throw_exception>'s
1041default behavior will provide a detailed stack trace.
701da8c4 1042
1043=cut
1044
1045sub throw_exception {
82cc0386 1046 my $self = shift;
4981dc70 1047
1048 DBIx::Class::Exception->throw($_[0], $self->stacktrace)
1049 if !$self->exception_action || !$self->exception_action->(@_);
701da8c4 1050}
1051
dfccde48 1052=head2 deploy
1c339d71 1053
82b01c38 1054=over 4
1055
6e73ac25 1056=item Arguments: $sqlt_args, $dir
82b01c38 1057
1058=back
1059
1060Attempts to deploy the schema to the current storage using L<SQL::Translator>.
ec6704d4 1061
51bace1c 1062See L<SQL::Translator/METHODS> for a list of values for C<$sqlt_args>. The most
1063common value for this would be C<< { add_drop_table => 1, } >> to have the SQL
1064produced include a DROP TABLE statement for each table created.
1065
499adf63 1066Additionally, the DBIx::Class parser accepts a C<sources> parameter as a hash
1067ref or an array ref, containing a list of source to deploy. If present, then
0e2c6809 1068only the sources listed will get deployed. Furthermore, you can use the
1069C<add_fk_index> parser parameter to prevent the parser from creating an index for each
1070FK.
499adf63 1071
1c339d71 1072=cut
1073
1074sub deploy {
6e73ac25 1075 my ($self, $sqltargs, $dir) = @_;
1c339d71 1076 $self->throw_exception("Can't deploy without storage") unless $self->storage;
6e73ac25 1077 $self->storage->deploy($self, undef, $sqltargs, $dir);
1c339d71 1078}
1079
0e0ce6c1 1080=head2 deployment_statements
1081
1082=over 4
1083
1084=item Arguments: $rdbms_type
1085
1086=back
1087
1088Returns the SQL statements used by L</deploy> and L<DBIx::Class::Schema/deploy>.
1089C<$rdbms_type> provides the DBI database driver name for which the SQL
1090statements are produced. If not supplied, the type of the current schema storage
1091will be used.
1092
1093=cut
1094
1095sub deployment_statements {
1096 my ($self, $rdbms_type) = @_;
1097
1098 $self->throw_exception("Can't generate deployment statements without a storage")
1099 if not $self->storage;
1100
1101 $self->storage->deployment_statements($self, $rdbms_type);
1102}
1103
c0f61310 1104=head2 create_ddl_dir (EXPERIMENTAL)
1105
1106=over 4
1107
c9d2e0a2 1108=item Arguments: \@databases, $version, $directory, $preversion, $sqlt_args
c0f61310 1109
1110=back
1111
1112Creates an SQL file based on the Schema, for each of the specified
c9d2e0a2 1113database types, in the given directory. Given a previous version number,
1114this will also create a file containing the ALTER TABLE statements to
1115transform the previous schema into the current one. Note that these
1116statements may contain DROP TABLE or DROP COLUMN statements that can
1117potentially destroy data.
1118
1119The file names are created using the C<ddl_filename> method below, please
1120override this method in your schema if you would like a different file
1121name format. For the ALTER file, the same format is used, replacing
1122$version in the name with "$preversion-$version".
1123
0e2c6809 1124See L<DBIx::Class::Schema/deploy> for details of $sqlt_args.
1125
c9d2e0a2 1126If no arguments are passed, then the following default values are used:
1127
1128=over 4
1129
1130=item databases - ['MySQL', 'SQLite', 'PostgreSQL']
1131
1132=item version - $schema->VERSION
1133
1134=item directory - './'
1135
1136=item preversion - <none>
1137
1138=back
c0f61310 1139
1140Note that this feature is currently EXPERIMENTAL and may not work correctly
1141across all databases, or fully handle complex relationships.
1142
c9d2e0a2 1143WARNING: Please check all SQL files created, before applying them.
1144
c0f61310 1145=cut
1146
6e73ac25 1147sub create_ddl_dir {
e673f011 1148 my $self = shift;
1149
1150 $self->throw_exception("Can't create_ddl_dir without storage") unless $self->storage;
1151 $self->storage->create_ddl_dir($self, @_);
1152}
1153
e63a82f7 1154=head2 ddl_filename
9b83fccd 1155
c9d2e0a2 1156=over 4
1157
99a74c4a 1158=item Arguments: $database-type, $version, $directory, $preversion
c9d2e0a2 1159
1160=back
1161
99a74c4a 1162 my $filename = $table->ddl_filename($type, $version, $dir, $preversion)
c9d2e0a2 1163
1164This method is called by C<create_ddl_dir> to compose a file name out of
1165the supplied directory, database type and version number. The default file
1166name format is: C<$dir$schema-$version-$type.sql>.
9b83fccd 1167
c9d2e0a2 1168You may override this method in your schema if you wish to use a different
1169format.
9b83fccd 1170
1171=cut
1172
6e73ac25 1173sub ddl_filename {
99a74c4a 1174 my ($self, $type, $version, $dir, $preversion) = @_;
e673f011 1175
99a74c4a 1176 my $filename = ref($self);
1177 $filename =~ s/::/-/g;
1178 $filename = File::Spec->catfile($dir, "$filename-$version-$type.sql");
1179 $filename =~ s/$version/$preversion-$version/ if($preversion);
1180
1181 return $filename;
e673f011 1182}
1183
d2f3e87b 1184=head2 sqlt_deploy_hook($sqlt_schema)
1185
1186An optional sub which you can declare in your own Schema class that will get
1187passed the L<SQL::Translator::Schema> object when you deploy the schema via
1188L</create_ddl_dir> or L</deploy>.
1189
1190For an example of what you can do with this, see
1191L<DBIx::Class::Manual::Cookbook/Adding Indexes And Functions To Your SQL>.
1192
4146e3da 1193=head2 thaw
1194
1195Provided as the recommened way of thawing schema objects. You can call
1196C<Storable::thaw> directly if you wish, but the thawed objects will not have a
1197reference to any schema, so are rather useless
1198
1199=cut
1200
1201sub thaw {
1202 my ($self, $obj) = @_;
1203 local $DBIx::Class::ResultSourceHandle::thaw_schema = $self;
1204 return Storable::thaw($obj);
1205}
1206
1207=head2 freeze
1208
1209This doesn't actualy do anything more than call L<Storable/freeze>, it is just
1210provided here for symetry.
1211
d2f3e87b 1212=cut
1213
4146e3da 1214sub freeze {
1215 return Storable::freeze($_[1]);
1216}
1217
1218=head2 dclone
1219
1220Recommeneded way of dcloning objects. This is needed to properly maintain
1221references to the schema object (which itself is B<not> cloned.)
1222
1223=cut
1224
1225sub dclone {
1226 my ($self, $obj) = @_;
1227 local $DBIx::Class::ResultSourceHandle::thaw_schema = $self;
1228 return Storable::dclone($obj);
1229}
1230
93e4d41a 1231=head2 schema_version
1232
1233Returns the current schema class' $VERSION
1234
1235=cut
1236
1237sub schema_version {
1238 my ($self) = @_;
1239 my $class = ref($self)||$self;
1240
1241 # does -not- use $schema->VERSION
1242 # since that varies in results depending on if version.pm is installed, and if
1243 # so the perl or XS versions. If you want this to change, bug the version.pm
1244 # author to make vpp and vxs behave the same.
1245
1246 my $version;
1247 {
1248 no strict 'refs';
1249 $version = ${"${class}::VERSION"};
1250 }
1251 return $version;
1252}
1253
a02675cd 12541;
c2da098a 1255
c2da098a 1256=head1 AUTHORS
1257
daec44b8 1258Matt S. Trout <mst@shadowcatsystems.co.uk>
c2da098a 1259
1260=head1 LICENSE
1261
1262You may distribute this code under the same terms as Perl itself.
1263
1264=cut