1 package DBIx::Class::ResultSource;
6 use base qw/DBIx::Class::ResultSource::RowParser DBIx::Class/;
8 use DBIx::Class::ResultSet;
9 use DBIx::Class::ResultSourceHandle;
11 use DBIx::Class::Carp;
12 use DBIx::Class::_Util 'is_literal_value';
13 use Devel::GlobalDestruction;
15 use List::Util 'first';
16 use Scalar::Util qw/blessed weaken isweak/;
20 __PACKAGE__->mk_group_accessors(simple => qw/
21 source_name name source_info
22 _ordered_columns _columns _primaries _unique_constraints
23 _relationships resultset_attributes
24 column_info_from_storage
27 __PACKAGE__->mk_group_accessors(component_class => qw/
32 __PACKAGE__->mk_classdata( sqlt_deploy_callback => 'default_sqlt_deploy_hook' );
36 DBIx::Class::ResultSource - Result source object
40 # Create a table based result source, in a result class.
42 package MyApp::Schema::Result::Artist;
43 use base qw/DBIx::Class::Core/;
45 __PACKAGE__->table('artist');
46 __PACKAGE__->add_columns(qw/ artistid name /);
47 __PACKAGE__->set_primary_key('artistid');
48 __PACKAGE__->has_many(cds => 'MyApp::Schema::Result::CD');
52 # Create a query (view) based result source, in a result class
53 package MyApp::Schema::Result::Year2000CDs;
54 use base qw/DBIx::Class::Core/;
56 __PACKAGE__->load_components('InflateColumn::DateTime');
57 __PACKAGE__->table_class('DBIx::Class::ResultSource::View');
59 __PACKAGE__->table('year2000cds');
60 __PACKAGE__->result_source_instance->is_virtual(1);
61 __PACKAGE__->result_source_instance->view_definition(
62 "SELECT cdid, artist, title FROM cd WHERE year ='2000'"
68 A ResultSource is an object that represents a source of data for querying.
70 This class is a base class for various specialised types of result
71 sources, for example L<DBIx::Class::ResultSource::Table>. Table is the
72 default result source type, so one is created for you when defining a
73 result class as described in the synopsis above.
75 More specifically, the L<DBIx::Class::Core> base class pulls in the
76 L<DBIx::Class::ResultSourceProxy::Table> component, which defines
77 the L<table|DBIx::Class::ResultSourceProxy::Table/table> method.
78 When called, C<table> creates and stores an instance of
79 L<DBIx::Class::ResultSoure::Table>. Luckily, to use tables as result
80 sources, you don't need to remember any of this.
82 Result sources representing select queries, or views, can also be
83 created, see L<DBIx::Class::ResultSource::View> for full details.
85 =head2 Finding result source objects
87 As mentioned above, a result source instance is created and stored for
88 you when you define a L<result class|DBIx::Class::Manual::Glossary/Result class>.
90 You can retrieve the result source at runtime in the following ways:
94 =item From a Schema object:
96 $schema->source($source_name);
98 =item From a Result object:
100 $result->result_source;
102 =item From a ResultSet object:
115 my ($class, $attrs) = @_;
116 $class = ref $class if ref $class;
118 my $new = bless { %{$attrs || {}} }, $class;
119 $new->{resultset_class} ||= 'DBIx::Class::ResultSet';
120 $new->{resultset_attributes} = { %{$new->{resultset_attributes} || {}} };
121 $new->{_ordered_columns} = [ @{$new->{_ordered_columns}||[]}];
122 $new->{_columns} = { %{$new->{_columns}||{}} };
123 $new->{_relationships} = { %{$new->{_relationships}||{}} };
124 $new->{name} ||= "!!NAME NOT SET!!";
125 $new->{_columns_info_loaded} ||= 0;
135 =item Arguments: @columns
137 =item Return Value: L<$result_source|/new>
141 $source->add_columns(qw/col1 col2 col3/);
143 $source->add_columns('col1' => \%col1_info, 'col2' => \%col2_info, ...);
145 Adds columns to the result source. If supplied colname => hashref
146 pairs, uses the hashref as the L</column_info> for that column. Repeated
147 calls of this method will add more columns, not replace them.
149 The column names given will be created as accessor methods on your
150 L<Result|DBIx::Class::Manual::ResultClass> objects. You can change the name of the accessor
151 by supplying an L</accessor> in the column_info hash.
153 If a column name beginning with a plus sign ('+col1') is provided, the
154 attributes provided will be merged with any existing attributes for the
155 column, with the new attributes taking precedence in the case that an
156 attribute already exists. Using this without a hashref
157 (C<< $source->add_columns(qw/+col1 +col2/) >>) is legal, but useless --
158 it does the same thing it would do without the plus.
160 The contents of the column_info are not set in stone. The following
161 keys are currently recognised/used by DBIx::Class:
167 { accessor => '_name' }
169 # example use, replace standard accessor with one of your own:
171 my ($self, $value) = @_;
173 die "Name cannot contain digits!" if($value =~ /\d/);
174 $self->_name($value);
176 return $self->_name();
179 Use this to set the name of the accessor method for this column. If unset,
180 the name of the column will be used.
184 { data_type => 'integer' }
186 This contains the column type. It is automatically filled if you use the
187 L<SQL::Translator::Producer::DBIx::Class::File> producer, or the
188 L<DBIx::Class::Schema::Loader> module.
190 Currently there is no standard set of values for the data_type. Use
191 whatever your database supports.
197 The length of your column, if it is a column type that can have a size
198 restriction. This is currently only used to create tables from your
199 schema, see L<DBIx::Class::Schema/deploy>.
205 Set this to a true value for a column that is allowed to contain NULL
206 values, default is false. This is currently only used to create tables
207 from your schema, see L<DBIx::Class::Schema/deploy>.
209 =item is_auto_increment
211 { is_auto_increment => 1 }
213 Set this to a true value for a column whose value is somehow
214 automatically set, defaults to false. This is used to determine which
215 columns to empty when cloning objects using
216 L<DBIx::Class::Row/copy>. It is also used by
217 L<DBIx::Class::Schema/deploy>.
223 Set this to a true or false value (not C<undef>) to explicitly specify
224 if this column contains numeric data. This controls how set_column
225 decides whether to consider a column dirty after an update: if
226 C<is_numeric> is true a numeric comparison C<< != >> will take place
227 instead of the usual C<eq>
229 If not specified the storage class will attempt to figure this out on
230 first access to the column, based on the column C<data_type>. The
231 result will be cached in this attribute.
235 { is_foreign_key => 1 }
237 Set this to a true value for a column that contains a key from a
238 foreign table, defaults to false. This is currently only used to
239 create tables from your schema, see L<DBIx::Class::Schema/deploy>.
243 { default_value => \'now()' }
245 Set this to the default value which will be inserted into a column by
246 the database. Can contain either a value or a function (use a
247 reference to a scalar e.g. C<\'now()'> if you want a function). This
248 is currently only used to create tables from your schema, see
249 L<DBIx::Class::Schema/deploy>.
251 See the note on L<DBIx::Class::Row/new> for more information about possible
252 issues related to db-side default values.
256 { sequence => 'my_table_seq' }
258 Set this on a primary key column to the name of the sequence used to
259 generate a new key value. If not specified, L<DBIx::Class::PK::Auto>
260 will attempt to retrieve the name of the sequence from the database
263 =item retrieve_on_insert
265 { retrieve_on_insert => 1 }
267 For every column where this is set to true, DBIC will retrieve the RDBMS-side
268 value upon a new row insertion (normally only the autoincrement PK is
269 retrieved on insert). C<INSERT ... RETURNING> is used automatically if
270 supported by the underlying storage, otherwise an extra SELECT statement is
271 executed to retrieve the missing data.
275 { auto_nextval => 1 }
277 Set this to a true value for a column whose value is retrieved automatically
278 from a sequence or function (if supported by your Storage driver.) For a
279 sequence, if you do not use a trigger to get the nextval, you have to set the
280 L</sequence> value as well.
282 Also set this for MSSQL columns with the 'uniqueidentifier'
283 L<data_type|DBIx::Class::ResultSource/data_type> whose values you want to
284 automatically generate using C<NEWID()>, unless they are a primary key in which
285 case this will be done anyway.
289 This is used by L<DBIx::Class::Schema/deploy> and L<SQL::Translator>
290 to add extra non-generic data to the column. For example: C<< extra
291 => { unsigned => 1} >> is used by the MySQL producer to set an integer
292 column to unsigned. For more details, see
293 L<SQL::Translator::Producer::MySQL>.
301 =item Arguments: $colname, \%columninfo?
303 =item Return Value: 1/0 (true/false)
307 $source->add_column('col' => \%info);
309 Add a single column and optional column info. Uses the same column
310 info keys as L</add_columns>.
315 my ($self, @cols) = @_;
316 $self->_ordered_columns(\@cols) unless $self->_ordered_columns;
319 my $columns = $self->_columns;
320 while (my $col = shift @cols) {
321 my $column_info = {};
322 if ($col =~ s/^\+//) {
323 $column_info = $self->column_info($col);
326 # If next entry is { ... } use that for the column info, if not
327 # use an empty hashref
329 my $new_info = shift(@cols);
330 %$column_info = (%$column_info, %$new_info);
332 push(@added, $col) unless exists $columns->{$col};
333 $columns->{$col} = $column_info;
335 push @{ $self->_ordered_columns }, @added;
339 sub add_column { shift->add_columns(@_); } # DO NOT CHANGE THIS TO GLOB
345 =item Arguments: $colname
347 =item Return Value: 1/0 (true/false)
351 if ($source->has_column($colname)) { ... }
353 Returns true if the source has a column of this name, false otherwise.
358 my ($self, $column) = @_;
359 return exists $self->_columns->{$column};
366 =item Arguments: $colname
368 =item Return Value: Hashref of info
372 my $info = $source->column_info($col);
374 Returns the column metadata hashref for a column, as originally passed
375 to L</add_columns>. See L</add_columns> above for information on the
376 contents of the hashref.
381 my ($self, $column) = @_;
382 $self->throw_exception("No such column $column")
383 unless exists $self->_columns->{$column};
385 if ( ! $self->_columns->{$column}{data_type}
386 and ! $self->{_columns_info_loaded}
387 and $self->column_info_from_storage
388 and my $stor = try { $self->storage } )
390 $self->{_columns_info_loaded}++;
392 # try for the case of storage without table
394 my $info = $stor->columns_info_for( $self->from );
396 { (lc $_) => $info->{$_} }
400 foreach my $col ( keys %{$self->_columns} ) {
401 $self->_columns->{$col} = {
402 %{ $self->_columns->{$col} },
403 %{ $info->{$col} || $lc_info->{lc $col} || {} }
409 return $self->_columns->{$column};
416 =item Arguments: none
418 =item Return Value: Ordered list of column names
422 my @column_names = $source->columns;
424 Returns all column names in the order they were declared to L</add_columns>.
430 $self->throw_exception(
431 "columns() is a read-only accessor, did you mean add_columns()?"
433 return @{$self->{_ordered_columns}||[]};
440 =item Arguments: \@colnames ?
442 =item Return Value: Hashref of column name/info pairs
446 my $columns_info = $source->columns_info;
448 Like L</column_info> but returns information for the requested columns. If
449 the optional column-list arrayref is omitted it returns info on all columns
450 currently defined on the ResultSource via L</add_columns>.
455 my ($self, $columns) = @_;
457 my $colinfo = $self->_columns;
460 first { ! $_->{data_type} } values %$colinfo
462 ! $self->{_columns_info_loaded}
464 $self->column_info_from_storage
466 my $stor = try { $self->storage }
468 $self->{_columns_info_loaded}++;
470 # try for the case of storage without table
472 my $info = $stor->columns_info_for( $self->from );
474 { (lc $_) => $info->{$_} }
478 foreach my $col ( keys %$colinfo ) {
480 %{ $colinfo->{$col} },
481 %{ $info->{$col} || $lc_info->{lc $col} || {} }
491 if (my $inf = $colinfo->{$_}) {
495 $self->throw_exception( sprintf (
496 "No such column '%s' on source '%s'",
498 $self->source_name || $self->name || 'Unknown source...?',
510 =head2 remove_columns
514 =item Arguments: @colnames
516 =item Return Value: not defined
520 $source->remove_columns(qw/col1 col2 col3/);
522 Removes the given list of columns by name, from the result source.
524 B<Warning>: Removing a column that is also used in the sources primary
525 key, or in one of the sources unique constraints, B<will> result in a
526 broken result source.
532 =item Arguments: $colname
534 =item Return Value: not defined
538 $source->remove_column('col');
540 Remove a single column by name from the result source, similar to
543 B<Warning>: Removing a column that is also used in the sources primary
544 key, or in one of the sources unique constraints, B<will> result in a
545 broken result source.
550 my ($self, @to_remove) = @_;
552 my $columns = $self->_columns
557 delete $columns->{$_};
561 $self->_ordered_columns([ grep { not $to_remove{$_} } @{$self->_ordered_columns} ]);
564 sub remove_column { shift->remove_columns(@_); } # DO NOT CHANGE THIS TO GLOB
566 =head2 set_primary_key
570 =item Arguments: @cols
572 =item Return Value: not defined
576 Defines one or more columns as primary key for this source. Must be
577 called after L</add_columns>.
579 Additionally, defines a L<unique constraint|add_unique_constraint>
582 Note: you normally do want to define a primary key on your sources
583 B<even if the underlying database table does not have a primary key>.
585 L<DBIx::Class::Manual::Intro/The Significance and Importance of Primary Keys>
590 sub set_primary_key {
591 my ($self, @cols) = @_;
593 my $colinfo = $self->columns_info(\@cols);
594 for my $col (@cols) {
595 carp_unique(sprintf (
596 "Primary key of source '%s' includes the column '%s' which has its "
597 . "'is_nullable' attribute set to true. This is a mistake and will cause "
598 . 'various Result-object operations to fail',
599 $self->source_name || $self->name || 'Unknown source...?',
601 )) if $colinfo->{$col}{is_nullable};
604 $self->_primaries(\@cols);
606 $self->add_unique_constraint(primary => \@cols);
609 =head2 primary_columns
613 =item Arguments: none
615 =item Return Value: Ordered list of primary column names
619 Read-only accessor which returns the list of primary keys, supplied by
624 sub primary_columns {
625 return @{shift->_primaries||[]};
628 # a helper method that will automatically die with a descriptive message if
629 # no pk is defined on the source in question. For internal use to save
630 # on if @pks... boilerplate
631 sub _pri_cols_or_die {
633 my @pcols = $self->primary_columns
634 or $self->throw_exception (sprintf(
635 "Operation requires a primary key to be declared on '%s' via set_primary_key",
636 # source_name is set only after schema-registration
637 $self->source_name || $self->result_class || $self->name || 'Unknown source...?',
642 # same as above but mandating single-column PK (used by relationship condition
644 sub _single_pri_col_or_die {
646 my ($pri, @too_many) = $self->_pri_cols_or_die;
648 $self->throw_exception( sprintf(
649 "Operation requires a single-column primary key declared on '%s'",
650 $self->source_name || $self->result_class || $self->name || 'Unknown source...?',
658 Manually define the correct sequence for your table, to avoid the overhead
659 associated with looking up the sequence automatically. The supplied sequence
660 will be applied to the L</column_info> of each L<primary_key|/set_primary_key>
664 =item Arguments: $sequence_name
666 =item Return Value: not defined
673 my ($self,$seq) = @_;
675 my @pks = $self->primary_columns
678 $_->{sequence} = $seq
679 for values %{ $self->columns_info (\@pks) };
683 =head2 add_unique_constraint
687 =item Arguments: $name?, \@colnames
689 =item Return Value: not defined
693 Declare a unique constraint on this source. Call once for each unique
696 # For UNIQUE (column1, column2)
697 __PACKAGE__->add_unique_constraint(
698 constraint_name => [ qw/column1 column2/ ],
701 Alternatively, you can specify only the columns:
703 __PACKAGE__->add_unique_constraint([ qw/column1 column2/ ]);
705 This will result in a unique constraint named
706 C<table_column1_column2>, where C<table> is replaced with the table
709 Unique constraints are used, for example, when you pass the constraint
710 name as the C<key> attribute to L<DBIx::Class::ResultSet/find>. Then
711 only columns in the constraint are searched.
713 Throws an error if any of the given column names do not yet exist on
718 sub add_unique_constraint {
722 $self->throw_exception(
723 'add_unique_constraint() does not accept multiple constraints, use '
724 . 'add_unique_constraints() instead'
729 if (ref $cols ne 'ARRAY') {
730 $self->throw_exception (
731 'Expecting an arrayref of constraint columns, got ' . ($cols||'NOTHING')
737 $name ||= $self->name_unique_constraint($cols);
739 foreach my $col (@$cols) {
740 $self->throw_exception("No such column $col on table " . $self->name)
741 unless $self->has_column($col);
744 my %unique_constraints = $self->unique_constraints;
745 $unique_constraints{$name} = $cols;
746 $self->_unique_constraints(\%unique_constraints);
749 =head2 add_unique_constraints
753 =item Arguments: @constraints
755 =item Return Value: not defined
759 Declare multiple unique constraints on this source.
761 __PACKAGE__->add_unique_constraints(
762 constraint_name1 => [ qw/column1 column2/ ],
763 constraint_name2 => [ qw/column2 column3/ ],
766 Alternatively, you can specify only the columns:
768 __PACKAGE__->add_unique_constraints(
769 [ qw/column1 column2/ ],
770 [ qw/column3 column4/ ]
773 This will result in unique constraints named C<table_column1_column2> and
774 C<table_column3_column4>, where C<table> is replaced with the table name.
776 Throws an error if any of the given column names do not yet exist on
779 See also L</add_unique_constraint>.
783 sub add_unique_constraints {
785 my @constraints = @_;
787 if ( !(@constraints % 2) && first { ref $_ ne 'ARRAY' } @constraints ) {
788 # with constraint name
789 while (my ($name, $constraint) = splice @constraints, 0, 2) {
790 $self->add_unique_constraint($name => $constraint);
795 foreach my $constraint (@constraints) {
796 $self->add_unique_constraint($constraint);
801 =head2 name_unique_constraint
805 =item Arguments: \@colnames
807 =item Return Value: Constraint name
811 $source->table('mytable');
812 $source->name_unique_constraint(['col1', 'col2']);
816 Return a name for a unique constraint containing the specified
817 columns. The name is created by joining the table name and each column
818 name, using an underscore character.
820 For example, a constraint on a table named C<cd> containing the columns
821 C<artist> and C<title> would result in a constraint name of C<cd_artist_title>.
823 This is used by L</add_unique_constraint> if you do not specify the
824 optional constraint name.
828 sub name_unique_constraint {
829 my ($self, $cols) = @_;
831 my $name = $self->name;
832 $name = $$name if (ref $name eq 'SCALAR');
834 return join '_', $name, @$cols;
837 =head2 unique_constraints
841 =item Arguments: none
843 =item Return Value: Hash of unique constraint data
847 $source->unique_constraints();
849 Read-only accessor which returns a hash of unique constraints on this
852 The hash is keyed by constraint name, and contains an arrayref of
853 column names as values.
857 sub unique_constraints {
858 return %{shift->_unique_constraints||{}};
861 =head2 unique_constraint_names
865 =item Arguments: none
867 =item Return Value: Unique constraint names
871 $source->unique_constraint_names();
873 Returns the list of unique constraint names defined on this source.
877 sub unique_constraint_names {
880 my %unique_constraints = $self->unique_constraints;
882 return keys %unique_constraints;
885 =head2 unique_constraint_columns
889 =item Arguments: $constraintname
891 =item Return Value: List of constraint columns
895 $source->unique_constraint_columns('myconstraint');
897 Returns the list of columns that make up the specified unique constraint.
901 sub unique_constraint_columns {
902 my ($self, $constraint_name) = @_;
904 my %unique_constraints = $self->unique_constraints;
906 $self->throw_exception(
907 "Unknown unique constraint $constraint_name on '" . $self->name . "'"
908 ) unless exists $unique_constraints{$constraint_name};
910 return @{ $unique_constraints{$constraint_name} };
913 =head2 sqlt_deploy_callback
917 =item Arguments: $callback_name | \&callback_code
919 =item Return Value: $callback_name | \&callback_code
923 __PACKAGE__->sqlt_deploy_callback('mycallbackmethod');
927 __PACKAGE__->sqlt_deploy_callback(sub {
928 my ($source_instance, $sqlt_table) = @_;
932 An accessor to set a callback to be called during deployment of
933 the schema via L<DBIx::Class::Schema/create_ddl_dir> or
934 L<DBIx::Class::Schema/deploy>.
936 The callback can be set as either a code reference or the name of a
937 method in the current result class.
939 Defaults to L</default_sqlt_deploy_hook>.
941 Your callback will be passed the $source object representing the
942 ResultSource instance being deployed, and the
943 L<SQL::Translator::Schema::Table> object being created from it. The
944 callback can be used to manipulate the table object or add your own
945 customised indexes. If you need to manipulate a non-table object, use
946 the L<DBIx::Class::Schema/sqlt_deploy_hook>.
948 See L<DBIx::Class::Manual::Cookbook/Adding Indexes And Functions To
949 Your SQL> for examples.
951 This sqlt deployment callback can only be used to manipulate
952 SQL::Translator objects as they get turned into SQL. To execute
953 post-deploy statements which SQL::Translator does not currently
954 handle, override L<DBIx::Class::Schema/deploy> in your Schema class
955 and call L<dbh_do|DBIx::Class::Storage::DBI/dbh_do>.
957 =head2 default_sqlt_deploy_hook
959 This is the default deploy hook implementation which checks if your
960 current Result class has a C<sqlt_deploy_hook> method, and if present
961 invokes it B<on the Result class directly>. This is to preserve the
962 semantics of C<sqlt_deploy_hook> which was originally designed to expect
963 the Result class name and the
964 L<$sqlt_table instance|SQL::Translator::Schema::Table> of the table being
969 sub default_sqlt_deploy_hook {
972 my $class = $self->result_class;
974 if ($class and $class->can('sqlt_deploy_hook')) {
975 $class->sqlt_deploy_hook(@_);
979 sub _invoke_sqlt_deploy_hook {
981 if ( my $hook = $self->sqlt_deploy_callback) {
990 =item Arguments: $classname
992 =item Return Value: $classname
996 use My::Schema::ResultClass::Inflator;
999 use My::Schema::Artist;
1001 __PACKAGE__->result_class('My::Schema::ResultClass::Inflator');
1003 Set the default result class for this source. You can use this to create
1004 and use your own result inflator. See L<DBIx::Class::ResultSet/result_class>
1007 Please note that setting this to something like
1008 L<DBIx::Class::ResultClass::HashRefInflator> will make every result unblessed
1009 and make life more difficult. Inflators like those are better suited to
1010 temporary usage via L<DBIx::Class::ResultSet/result_class>.
1016 =item Arguments: none
1018 =item Return Value: L<$resultset|DBIx::Class::ResultSet>
1022 Returns a resultset for the given source. This will initially be created
1023 on demand by calling
1025 $self->resultset_class->new($self, $self->resultset_attributes)
1027 but is cached from then on unless resultset_class changes.
1029 =head2 resultset_class
1033 =item Arguments: $classname
1035 =item Return Value: $classname
1039 package My::Schema::ResultSet::Artist;
1040 use base 'DBIx::Class::ResultSet';
1043 # In the result class
1044 __PACKAGE__->resultset_class('My::Schema::ResultSet::Artist');
1047 $source->resultset_class('My::Schema::ResultSet::Artist');
1049 Set the class of the resultset. This is useful if you want to create your
1050 own resultset methods. Create your own class derived from
1051 L<DBIx::Class::ResultSet>, and set it here. If called with no arguments,
1052 this method returns the name of the existing resultset class, if one
1055 =head2 resultset_attributes
1059 =item Arguments: L<\%attrs|DBIx::Class::ResultSet/ATTRIBUTES>
1061 =item Return Value: L<\%attrs|DBIx::Class::ResultSet/ATTRIBUTES>
1065 # In the result class
1066 __PACKAGE__->resultset_attributes({ order_by => [ 'id' ] });
1069 $source->resultset_attributes({ order_by => [ 'id' ] });
1071 Store a collection of resultset attributes, that will be set on every
1072 L<DBIx::Class::ResultSet> produced from this result source.
1074 B<CAVEAT>: C<resultset_attributes> comes with its own set of issues and
1075 bugs! While C<resultset_attributes> isn't deprecated per se, its usage is
1078 Since relationships use attributes to link tables together, the "default"
1079 attributes you set may cause unpredictable and undesired behavior. Furthermore,
1080 the defaults cannot be turned off, so you are stuck with them.
1082 In most cases, what you should actually be using are project-specific methods:
1084 package My::Schema::ResultSet::Artist;
1085 use base 'DBIx::Class::ResultSet';
1089 #__PACKAGE__->resultset_attributes({ prefetch => 'tracks' });
1092 sub with_tracks { shift->search({}, { prefetch => 'tracks' }) }
1095 $schema->resultset('Artist')->with_tracks->...
1097 This gives you the flexibility of not using it when you don't need it.
1099 For more complex situations, another solution would be to use a virtual view
1100 via L<DBIx::Class::ResultSource::View>.
1106 $self->throw_exception(
1107 'resultset does not take any arguments. If you want another resultset, '.
1108 'call it on the schema instead.'
1111 $self->resultset_class->new(
1114 try { %{$self->schema->default_resultset_attributes} },
1115 %{$self->{resultset_attributes}},
1124 =item Arguments: none
1126 =item Result value: $name
1130 Returns the name of the result source, which will typically be the table
1131 name. This may be a scalar reference if the result source has a non-standard
1138 =item Arguments: $source_name
1140 =item Result value: $source_name
1144 Set an alternate name for the result source when it is loaded into a schema.
1145 This is useful if you want to refer to a result source by a name other than
1148 package ArchivedBooks;
1149 use base qw/DBIx::Class/;
1150 __PACKAGE__->table('books_archive');
1151 __PACKAGE__->source_name('Books');
1153 # from your schema...
1154 $schema->resultset('Books')->find(1);
1160 =item Arguments: none
1162 =item Return Value: FROM clause
1166 my $from_clause = $source->from();
1168 Returns an expression of the source to be supplied to storage to specify
1169 retrieval from this source. In the case of a database, the required FROM
1174 sub from { die 'Virtual method!' }
1180 =item Arguments: L<$schema?|DBIx::Class::Schema>
1182 =item Return Value: L<$schema|DBIx::Class::Schema>
1186 my $schema = $source->schema();
1188 Sets and/or returns the L<DBIx::Class::Schema> object to which this
1189 result source instance has been attached to.
1195 $_[0]->{schema} = $_[1];
1198 $_[0]->{schema} || do {
1199 my $name = $_[0]->{source_name} || '_unnamed_';
1200 my $err = 'Unable to perform storage-dependent operations with a detached result source '
1201 . "(source '$name' is not associated with a schema).";
1203 $err .= ' You need to use $schema->thaw() or manually set'
1204 . ' $DBIx::Class::ResultSourceHandle::thaw_schema while thawing.'
1205 if $_[0]->{_detached_thaw};
1207 DBIx::Class::Exception->throw($err);
1216 =item Arguments: none
1218 =item Return Value: L<$storage|DBIx::Class::Storage>
1222 $source->storage->debug(1);
1224 Returns the L<storage handle|DBIx::Class::Storage> for the current schema.
1228 sub storage { shift->schema->storage; }
1230 =head2 add_relationship
1234 =item Arguments: $rel_name, $related_source_name, \%cond, \%attrs?
1236 =item Return Value: 1/true if it succeeded
1240 $source->add_relationship('rel_name', 'related_source', $cond, $attrs);
1242 L<DBIx::Class::Relationship> describes a series of methods which
1243 create pre-defined useful types of relationships. Look there first
1244 before using this method directly.
1246 The relationship name can be arbitrary, but must be unique for each
1247 relationship attached to this result source. 'related_source' should
1248 be the name with which the related result source was registered with
1249 the current schema. For example:
1251 $schema->source('Book')->add_relationship('reviews', 'Review', {
1252 'foreign.book_id' => 'self.id',
1255 The condition C<$cond> needs to be an L<SQL::Abstract>-style
1256 representation of the join between the tables. For example, if you're
1257 creating a relation from Author to Book,
1259 { 'foreign.author_id' => 'self.id' }
1261 will result in the JOIN clause
1263 author me JOIN book foreign ON foreign.author_id = me.id
1265 You can specify as many foreign => self mappings as necessary.
1267 Valid attributes are as follows:
1273 Explicitly specifies the type of join to use in the relationship. Any
1274 SQL join type is valid, e.g. C<LEFT> or C<RIGHT>. It will be placed in
1275 the SQL command immediately before C<JOIN>.
1279 An arrayref containing a list of accessors in the foreign class to proxy in
1280 the main class. If, for example, you do the following:
1282 CD->might_have(liner_notes => 'LinerNotes', undef, {
1283 proxy => [ qw/notes/ ],
1286 Then, assuming LinerNotes has an accessor named notes, you can do:
1288 my $cd = CD->find(1);
1289 # set notes -- LinerNotes object is created if it doesn't exist
1290 $cd->notes('Notes go here');
1294 Specifies the type of accessor that should be created for the
1295 relationship. Valid values are C<single> (for when there is only a single
1296 related object), C<multi> (when there can be many), and C<filter> (for
1297 when there is a single related object, but you also want the relationship
1298 accessor to double as a column accessor). For C<multi> accessors, an
1299 add_to_* method is also created, which calls C<create_related> for the
1304 Throws an exception if the condition is improperly supplied, or cannot
1309 sub add_relationship {
1310 my ($self, $rel, $f_source_name, $cond, $attrs) = @_;
1311 $self->throw_exception("Can't create relationship without join condition")
1315 # Check foreign and self are right in cond
1316 if ( (ref $cond ||'') eq 'HASH') {
1318 $self->throw_exception("Keys of condition should be of form 'foreign.col', not '$_'")
1319 if /\./ && !/^foreign\./;
1323 my %rels = %{ $self->_relationships };
1324 $rels{$rel} = { class => $f_source_name,
1325 source => $f_source_name,
1328 $self->_relationships(\%rels);
1332 # XXX disabled. doesn't work properly currently. skip in tests.
1334 my $f_source = $self->schema->source($f_source_name);
1335 unless ($f_source) {
1336 $self->ensure_class_loaded($f_source_name);
1337 $f_source = $f_source_name->result_source;
1338 #my $s_class = ref($self->schema);
1339 #$f_source_name =~ m/^${s_class}::(.*)$/;
1340 #$self->schema->register_class(($1 || $f_source_name), $f_source_name);
1341 #$f_source = $self->schema->source($f_source_name);
1343 return unless $f_source; # Can't test rel without f_source
1345 try { $self->_resolve_join($rel, 'me', {}, []) }
1347 # If the resolve failed, back out and re-throw the error
1349 $self->_relationships(\%rels);
1350 $self->throw_exception("Error creating relationship $rel: $_");
1356 =head2 relationships
1360 =item Arguments: none
1362 =item Return Value: L<@rel_names|DBIx::Class::Relationship>
1366 my @relnames = $source->relationships();
1368 Returns all relationship names for this source.
1373 return keys %{shift->_relationships};
1376 =head2 relationship_info
1380 =item Arguments: L<$rel_name|DBIx::Class::Relationship>
1382 =item Return Value: L<\%rel_data|DBIx::Class::Relationship::Base/add_relationship>
1386 Returns a hash of relationship information for the specified relationship
1387 name. The keys/values are as specified for L<DBIx::Class::Relationship::Base/add_relationship>.
1391 sub relationship_info {
1392 #my ($self, $rel) = @_;
1393 return shift->_relationships->{+shift};
1396 =head2 has_relationship
1400 =item Arguments: L<$rel_name|DBIx::Class::Relationship>
1402 =item Return Value: 1/0 (true/false)
1406 Returns true if the source has a relationship of this name, false otherwise.
1410 sub has_relationship {
1411 #my ($self, $rel) = @_;
1412 return exists shift->_relationships->{+shift};
1415 =head2 reverse_relationship_info
1419 =item Arguments: L<$rel_name|DBIx::Class::Relationship>
1421 =item Return Value: L<\%rel_data|DBIx::Class::Relationship::Base/add_relationship>
1425 Looks through all the relationships on the source this relationship
1426 points to, looking for one whose condition is the reverse of the
1427 condition on this relationship.
1429 A common use of this is to find the name of the C<belongs_to> relation
1430 opposing a C<has_many> relation. For definition of these look in
1431 L<DBIx::Class::Relationship>.
1433 The returned hashref is keyed by the name of the opposing
1434 relationship, and contains its data in the same manner as
1435 L</relationship_info>.
1439 sub reverse_relationship_info {
1440 my ($self, $rel) = @_;
1442 my $rel_info = $self->relationship_info($rel)
1443 or $self->throw_exception("No such relationship '$rel'");
1447 return $ret unless ((ref $rel_info->{cond}) eq 'HASH');
1449 my $stripped_cond = $self->__strip_relcond ($rel_info->{cond});
1451 my $registered_source_name = $self->source_name;
1453 # this may be a partial schema or something else equally esoteric
1454 my $other_rsrc = $self->related_source($rel);
1456 # Get all the relationships for that source that related to this source
1457 # whose foreign column set are our self columns on $rel and whose self
1458 # columns are our foreign columns on $rel
1459 foreach my $other_rel ($other_rsrc->relationships) {
1461 # only consider stuff that points back to us
1462 # "us" here is tricky - if we are in a schema registration, we want
1463 # to use the source_names, otherwise we will use the actual classes
1465 # the schema may be partial
1466 my $roundtrip_rsrc = try { $other_rsrc->related_source($other_rel) }
1469 if ($registered_source_name) {
1470 next if $registered_source_name ne ($roundtrip_rsrc->source_name || '')
1473 next if $self->result_class ne $roundtrip_rsrc->result_class;
1476 my $other_rel_info = $other_rsrc->relationship_info($other_rel);
1478 # this can happen when we have a self-referential class
1479 next if $other_rel_info eq $rel_info;
1481 next unless ref $other_rel_info->{cond} eq 'HASH';
1482 my $other_stripped_cond = $self->__strip_relcond($other_rel_info->{cond});
1484 $ret->{$other_rel} = $other_rel_info if (
1485 $self->_compare_relationship_keys (
1486 [ keys %$stripped_cond ], [ values %$other_stripped_cond ]
1489 $self->_compare_relationship_keys (
1490 [ values %$stripped_cond ], [ keys %$other_stripped_cond ]
1498 # all this does is removes the foreign/self prefix from a condition
1499 sub __strip_relcond {
1502 { map { /^ (?:foreign|self) \. (\w+) $/x } ($_, $_[1]{$_}) }
1507 sub compare_relationship_keys {
1508 carp 'compare_relationship_keys is a private method, stop calling it';
1510 $self->_compare_relationship_keys (@_);
1513 # Returns true if both sets of keynames are the same, false otherwise.
1514 sub _compare_relationship_keys {
1515 # my ($self, $keys1, $keys2) = @_;
1517 join ("\x00", sort @{$_[1]})
1519 join ("\x00", sort @{$_[2]})
1523 # optionally takes either an arrayref of column names, or a hashref of already
1524 # retrieved colinfos
1525 # returns an arrayref of column names of the shortest unique constraint
1526 # (matching some of the input if any), giving preference to the PK
1527 sub _identifying_column_set {
1528 my ($self, $cols) = @_;
1530 my %unique = $self->unique_constraints;
1531 my $colinfos = ref $cols eq 'HASH' ? $cols : $self->columns_info($cols||());
1533 # always prefer the PK first, and then shortest constraints first
1535 for my $set (delete $unique{primary}, sort { @$a <=> @$b } (values %unique) ) {
1536 next unless $set && @$set;
1539 next USET unless ($colinfos->{$_} && !$colinfos->{$_}{is_nullable} );
1542 # copy so we can mangle it at will
1549 # Returns the {from} structure used to express JOIN conditions
1551 my ($self, $join, $alias, $seen, $jpath, $parent_force_left) = @_;
1553 # we need a supplied one, because we do in-place modifications, no returns
1554 $self->throw_exception ('You must supply a seen hashref as the 3rd argument to _resolve_join')
1555 unless ref $seen eq 'HASH';
1557 $self->throw_exception ('You must supply a joinpath arrayref as the 4th argument to _resolve_join')
1558 unless ref $jpath eq 'ARRAY';
1560 $jpath = [@$jpath]; # copy
1562 if (not defined $join or not length $join) {
1565 elsif (ref $join eq 'ARRAY') {
1568 $self->_resolve_join($_, $alias, $seen, $jpath, $parent_force_left);
1571 elsif (ref $join eq 'HASH') {
1574 for my $rel (keys %$join) {
1576 my $rel_info = $self->relationship_info($rel)
1577 or $self->throw_exception("No such relationship '$rel' on " . $self->source_name);
1579 my $force_left = $parent_force_left;
1580 $force_left ||= lc($rel_info->{attrs}{join_type}||'') eq 'left';
1582 # the actual seen value will be incremented by the recursion
1583 my $as = $self->storage->relname_to_table_alias(
1584 $rel, ($seen->{$rel} && $seen->{$rel} + 1)
1588 $self->_resolve_join($rel, $alias, $seen, [@$jpath], $force_left),
1589 $self->related_source($rel)->_resolve_join(
1590 $join->{$rel}, $as, $seen, [@$jpath, { $rel => $as }], $force_left
1598 $self->throw_exception("No idea how to resolve join reftype ".ref $join);
1601 my $count = ++$seen->{$join};
1602 my $as = $self->storage->relname_to_table_alias(
1603 $join, ($count > 1 && $count)
1606 my $rel_info = $self->relationship_info($join)
1607 or $self->throw_exception("No such relationship $join on " . $self->source_name);
1609 my $rel_src = $self->related_source($join);
1610 return [ { $as => $rel_src->from,
1612 -join_type => $parent_force_left
1614 : $rel_info->{attrs}{join_type}
1616 -join_path => [@$jpath, { $join => $as } ],
1618 (! $rel_info->{attrs}{accessor})
1620 first { $rel_info->{attrs}{accessor} eq $_ } (qw/single filter/)
1623 -relation_chain_depth => ( $seen->{-relation_chain_depth} || 0 ) + 1,
1625 scalar $self->_resolve_condition($rel_info->{cond}, $as, $alias, $join)
1631 carp 'pk_depends_on is a private method, stop calling it';
1633 $self->_pk_depends_on (@_);
1636 # Determines whether a relation is dependent on an object from this source
1637 # having already been inserted. Takes the name of the relationship and a
1638 # hashref of columns of the related object.
1639 sub _pk_depends_on {
1640 my ($self, $rel_name, $rel_data) = @_;
1642 my $relinfo = $self->relationship_info($rel_name);
1644 # don't assume things if the relationship direction is specified
1645 return $relinfo->{attrs}{is_foreign_key_constraint}
1646 if exists ($relinfo->{attrs}{is_foreign_key_constraint});
1648 my $cond = $relinfo->{cond};
1649 return 0 unless ref($cond) eq 'HASH';
1651 # map { foreign.foo => 'self.bar' } to { bar => 'foo' }
1652 my $keyhash = { map { my $x = $_; $x =~ s/.*\.//; $x; } reverse %$cond };
1654 # assume anything that references our PK probably is dependent on us
1655 # rather than vice versa, unless the far side is (a) defined or (b)
1657 my $rel_source = $self->related_source($rel_name);
1659 foreach my $p ($self->primary_columns) {
1660 if (exists $keyhash->{$p}) {
1661 unless (defined($rel_data->{$keyhash->{$p}})
1662 || $rel_source->column_info($keyhash->{$p})
1663 ->{is_auto_increment}) {
1672 sub resolve_condition {
1673 carp 'resolve_condition is a private method, stop calling it';
1675 $self->_resolve_condition (@_);
1678 our $UNRESOLVABLE_CONDITION = \ '1 = 0';
1680 # Resolves the passed condition to a concrete query fragment and a flag
1681 # indicating whether this is a cross-table condition. Also an optional
1682 # list of non-trivial values (normally conditions) returned as a part
1683 # of a joinfree condition hash
1684 sub _resolve_condition {
1685 my ($self, $cond, $as, $for, $rel_name) = @_;
1687 my $obj_rel = defined blessed $for;
1689 if (ref $cond eq 'CODE') {
1690 my $relalias = $obj_rel ? 'me' : $as;
1692 my ($crosstable_cond, $joinfree_cond) = $cond->({
1693 self_alias => $obj_rel ? $as : $for,
1694 foreign_alias => $relalias,
1695 self_resultsource => $self,
1696 foreign_relname => $rel_name || ($obj_rel ? $as : $for),
1697 self_rowobj => $obj_rel ? $for : undef
1701 if ($joinfree_cond) {
1703 # FIXME sanity check until things stabilize, remove at some point
1704 $self->throw_exception (
1705 "A join-free condition returned for relationship '$rel_name' without a row-object to chain from"
1708 # FIXME another sanity check
1710 ref $joinfree_cond ne 'HASH'
1712 first { $_ !~ /^\Q$relalias.\E.+/ } keys %$joinfree_cond
1714 $self->throw_exception (
1715 "The join-free condition returned for relationship '$rel_name' must be a hash "
1716 .'reference with all keys being valid columns on the related result source'
1721 for (values %$joinfree_cond) {
1731 # see which parts of the joinfree cond are conditionals
1732 my $relcol_list = { map { $_ => 1 } $self->related_source($rel_name)->columns };
1734 for my $c (keys %$joinfree_cond) {
1735 my ($colname) = $c =~ /^ (?: \Q$relalias.\E )? (.+)/x;
1737 unless ($relcol_list->{$colname}) {
1738 push @$cond_cols, $colname;
1743 ref $joinfree_cond->{$c}
1745 ! is_literal_value( $joinfree_cond->{$c} )
1747 push @$cond_cols, $colname;
1752 return wantarray ? ($joinfree_cond, 0, $cond_cols) : $joinfree_cond;
1755 return wantarray ? ($crosstable_cond, 1) : $crosstable_cond;
1758 elsif (ref $cond eq 'HASH') {
1760 foreach my $k (keys %{$cond}) {
1761 my $v = $cond->{$k};
1762 # XXX should probably check these are valid columns
1763 $k =~ s/^foreign\.// ||
1764 $self->throw_exception("Invalid rel cond key ${k}");
1765 $v =~ s/^self\.// ||
1766 $self->throw_exception("Invalid rel cond val ${v}");
1767 if (ref $for) { # Object
1768 #warn "$self $k $for $v";
1769 unless ($for->has_column_loaded($v)) {
1770 if ($for->in_storage) {
1771 $self->throw_exception(sprintf
1772 "Unable to resolve relationship '%s' from object %s: column '%s' not "
1773 . 'loaded from storage (or not passed to new() prior to insert()). You '
1774 . 'probably need to call ->discard_changes to get the server-side defaults '
1775 . 'from the database.',
1781 return $UNRESOLVABLE_CONDITION;
1783 $ret{$k} = $for->get_column($v);
1784 #$ret{$k} = $for->get_column($v) if $for->has_column_loaded($v);
1786 } elsif (!defined $for) { # undef, i.e. "no object"
1788 } elsif (ref $as eq 'HASH') { # reverse hashref
1789 $ret{$v} = $as->{$k};
1790 } elsif (ref $as) { # reverse object
1791 $ret{$v} = $as->get_column($k);
1792 } elsif (!defined $as) { # undef, i.e. "no reverse object"
1795 $ret{"${as}.${k}"} = { -ident => "${for}.${v}" };
1800 ? ( \%ret, ($obj_rel || !defined $as || ref $as) ? 0 : 1 )
1804 elsif (ref $cond eq 'ARRAY') {
1805 my (@ret, $crosstable);
1807 my ($cond, $crosstab) = $self->_resolve_condition($_, $as, $for, $rel_name);
1809 $crosstable ||= $crosstab;
1811 return wantarray ? (\@ret, $crosstable) : \@ret;
1814 $self->throw_exception ("Can't handle condition $cond for relationship '$rel_name' yet :(");
1818 =head2 related_source
1822 =item Arguments: $rel_name
1824 =item Return Value: $source
1828 Returns the result source object for the given relationship.
1832 sub related_source {
1833 my ($self, $rel) = @_;
1834 if( !$self->has_relationship( $rel ) ) {
1835 $self->throw_exception("No such relationship '$rel' on " . $self->source_name);
1838 # if we are not registered with a schema - just use the prototype
1839 # however if we do have a schema - ask for the source by name (and
1840 # throw in the process if all fails)
1841 if (my $schema = try { $self->schema }) {
1842 $schema->source($self->relationship_info($rel)->{source});
1845 my $class = $self->relationship_info($rel)->{class};
1846 $self->ensure_class_loaded($class);
1847 $class->result_source_instance;
1851 =head2 related_class
1855 =item Arguments: $rel_name
1857 =item Return Value: $classname
1861 Returns the class name for objects in the given relationship.
1866 my ($self, $rel) = @_;
1867 if( !$self->has_relationship( $rel ) ) {
1868 $self->throw_exception("No such relationship '$rel' on " . $self->source_name);
1870 return $self->schema->class($self->relationship_info($rel)->{source});
1877 =item Arguments: none
1879 =item Return Value: L<$source_handle|DBIx::Class::ResultSourceHandle>
1883 Obtain a new L<result source handle instance|DBIx::Class::ResultSourceHandle>
1884 for this source. Used as a serializable pointer to this resultsource, as it is not
1885 easy (nor advisable) to serialize CODErefs which may very well be present in e.g.
1886 relationship definitions.
1891 return DBIx::Class::ResultSourceHandle->new({
1892 source_moniker => $_[0]->source_name,
1894 # so that a detached thaw can be re-frozen
1895 $_[0]->{_detached_thaw}
1896 ? ( _detached_source => $_[0] )
1897 : ( schema => $_[0]->schema )
1902 my $global_phase_destroy;
1904 return if $global_phase_destroy ||= in_global_destruction;
1910 # Under no circumstances shall $_[0] be stored anywhere else (like copied to
1911 # a lexical variable, or shifted, or anything else). Doing so will mess up
1912 # the refcount of this particular result source, and will allow the $schema
1913 # we are trying to save to reattach back to the source we are destroying.
1914 # The relevant code checking refcounts is in ::Schema::DESTROY()
1916 # if we are not a schema instance holder - we don't matter
1918 ! ref $_[0]->{schema}
1920 isweak $_[0]->{schema}
1923 # weaken our schema hold forcing the schema to find somewhere else to live
1924 # during global destruction (if we have not yet bailed out) this will throw
1925 # which will serve as a signal to not try doing anything else
1926 # however beware - on older perls the exception seems randomly untrappable
1927 # due to some weird race condition during thread joining :(((
1930 weaken $_[0]->{schema};
1932 # if schema is still there reintroduce ourselves with strong refs back to us
1933 if ($_[0]->{schema}) {
1934 my $srcregs = $_[0]->{schema}->source_registrations;
1935 for (keys %$srcregs) {
1936 next unless $srcregs->{$_};
1937 $srcregs->{$_} = $_[0] if $srcregs->{$_} == $_[0];
1943 $global_phase_destroy = 1;
1949 sub STORABLE_freeze { Storable::nfreeze($_[0]->handle) }
1952 my ($self, $cloning, $ice) = @_;
1953 %$self = %{ (Storable::thaw($ice))->resolve };
1956 =head2 throw_exception
1958 See L<DBIx::Class::Schema/"throw_exception">.
1962 sub throw_exception {
1966 ? $self->{schema}->throw_exception(@_)
1967 : DBIx::Class::Exception->throw(@_)
1973 Stores a hashref of per-source metadata. No specific key names
1974 have yet been standardized, the examples below are purely hypothetical
1975 and don't actually accomplish anything on their own:
1977 __PACKAGE__->source_info({
1978 "_tablespace" => 'fast_disk_array_3',
1979 "_engine" => 'InnoDB',
1986 $class->new({attribute_name => value});
1988 Creates a new ResultSource object. Not normally called directly by end users.
1990 =head2 column_info_from_storage
1994 =item Arguments: 1/0 (default: 0)
1996 =item Return Value: 1/0
2000 __PACKAGE__->column_info_from_storage(1);
2002 Enables the on-demand automatic loading of the above column
2003 metadata from storage as necessary. This is *deprecated*, and
2004 should not be used. It will be removed before 1.0.
2007 =head1 AUTHOR AND CONTRIBUTORS
2009 See L<AUTHOR|DBIx::Class/AUTHOR> and L<CONTRIBUTORS|DBIx::Class/CONTRIBUTORS> in DBIx::Class
2013 You may distribute this code under the same terms as Perl itself.