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