1 package DBIx::Class::Schema::Loader::Base;
5 use base qw/Class::Accessor::Fast/;
8 use UNIVERSAL::require;
9 use DBIx::Class::Schema::Loader::RelBuilder;
10 use Data::Dump qw/ dump /;
14 __PACKAGE__->mk_ro_accessors(qw/
21 additional_base_classes
32 legacy_default_inflections
42 DBIx::Class::Schema::Loader::Base - Base DBIx::Class::Schema::Loader Implementation.
46 See L<DBIx::Class::Schema::Loader>
50 This is the base class for the storage-specific C<DBIx::Class::Schema::*>
51 classes, and implements the common functionality between them.
53 =head1 CONSTRUCTOR OPTIONS
55 These constructor options are the base options for
56 L<DBIx::Class::Schema::Loader/loader_opts>. Available constructor options are:
60 Try to automatically detect/setup has_a and has_many relationships.
64 If set to true, each constructive L<DBIx::Class> statement the loader
65 decides to execute will be C<warn>-ed before execution.
69 Only load tables matching regex. Best specified as a qr// regex.
73 Exclude tables matching regex. Best specified as a qr// regex.
77 Overrides the default table name to moniker translation. Can be either
78 a hashref of table keys and moniker values, or a coderef for a translator
79 function taking a single scalar table name argument and returning
80 a scalar moniker. If the hash entry does not exist, or the function
81 returns a false value, the code falls back to default behavior
84 The default behavior is: C<join '', map ucfirst, split /[\W_]+/, lc $table>,
85 which is to say: lowercase everything, split up the table name into chunks
86 anywhere a non-alpha-numeric character occurs, change the case of first letter
87 of each chunk to upper case, and put the chunks back together. Examples:
89 Table Name | Moniker Name
90 ---------------------------
92 luser_group | LuserGroup
93 luser-opts | LuserOpts
97 Just like L</moniker_map> above (can be hash/code-ref, falls back to default
98 if hash key does not exist or coderef returns false), but acts as a map
99 for pluralizing relationship names. The default behavior is to utilize
100 L<Lingua::EN::Inflect::Number/to_PL>.
102 =head2 inflect_singular
104 As L</inflect_plural> above, but for singularizing relationship names.
105 Default behavior is to utilize L<Lingua::EN::Inflect::Number/to_S>.
107 =head2 additional_base_classes
109 List of additional base classes all of your table classes will use.
111 =head2 left_base_classes
113 List of additional base classes all of your table classes will use
114 that need to be leftmost.
116 =head2 additional_classes
118 List of additional classes which all of your table classes will use.
122 List of additional components to be loaded into all of your table
123 classes. A good example would be C<ResultSetManager>.
125 =head2 resultset_components
127 List of additional ResultSet components to be loaded into your table
128 classes. A good example would be C<AlwaysRS>. Component
129 C<ResultSetManager> will be automatically added to the above
130 C<components> list if this option is set.
132 =head2 legacy_default_inflections
134 Setting this option changes the default fallback for L</inflect_plural> to
135 utilize L<Lingua::EN::Inflect/PL>, and L</inflect_singular> to a no-op.
136 Those choices produce substandard results, but might be necessary to support
137 your existing code if you started developing on a version prior to 0.03 and
138 don't wish to go around updating all your relationship names to the new
141 =head2 dump_directory
143 This option is designed to be a tool to help you transition from this
144 loader to a manually-defined schema when you decide it's time to do so.
146 The value of this option is a perl libdir pathname. Within
147 that directory this module will create a baseline manual
148 L<DBIx::Class::Schema> module set, based on what it creates at runtime
151 The created schema class will have the same classname as the one on
152 which you are setting this option (and the ResultSource classes will be
153 based on this name as well). Therefore it is wise to note that if you
154 point the C<dump_directory> option of a schema class at the live libdir
155 where that class is currently located, it will overwrite itself with a
156 manual version of itself. This might be a really good or bad thing
157 depending on your situation and perspective.
159 Normally you wouldn't hard-code this setting in your schema class, as it
160 is meant for one-time manual usage.
162 See L<DBIx::Class::Schema::Loader/dump_to_dir> for examples of the
163 recommended way to access this functionality.
165 =head1 DEPRECATED CONSTRUCTOR OPTIONS
169 Equivalent to L</inflect_plural>.
173 Equivalent to L</inflect_plural>.
175 =head2 connect_info, dsn, user, password, options
177 You connect these schemas the same way you would any L<DBIx::Class::Schema>,
178 which is by calling either C<connect> or C<connection> on a schema class
179 or object. These options are only supported via the deprecated
180 C<load_from_connection> interface, which will be removed in the future.
184 None of these methods are intended for direct invocation by regular
185 users of L<DBIx::Class::Schema::Loader>. Anything you can find here
186 can also be found via standard L<DBIx::Class::Schema> methods somehow.
190 # ensure that a peice of object data is a valid arrayref, creating
191 # an empty one or encapsulating whatever's there.
192 sub _ensure_arrayref {
197 $self->{$_} = [ $self->{$_} ]
198 unless ref $self->{$_} eq 'ARRAY';
204 Constructor for L<DBIx::Class::Schema::Loader::Base>, used internally
205 by L<DBIx::Class::Schema::Loader>.
210 my ( $class, %args ) = @_;
212 my $self = { %args };
214 bless $self => $class;
216 $self->{db_schema} ||= '';
217 $self->_ensure_arrayref(qw/additional_classes
218 additional_base_classes
224 push(@{$self->{components}}, 'ResultSetManager')
225 if @{$self->{resultset_components}};
227 $self->{monikers} = {};
228 $self->{classes} = {};
230 # Support deprecated arguments
231 for(qw/inflect_map inflect/) {
232 warn "Argument $_ is deprecated in favor of 'inflect_plural'"
235 $self->{inflect_plural} ||= $self->{inflect_map} || $self->{inflect};
237 $self->{schema_class} ||= ( ref $self->{schema} || $self->{schema} );
238 $self->{schema} ||= $self->{schema_class};
246 foreach my $table_class (values %{$self->classes}) {
247 $table_class->require;
248 if($@ && $@ !~ /^Can't locate /) {
249 croak "Failed to load external class definition"
250 . " for '$table_class': $@";
252 next if $@; # "Can't locate" error
254 # If we make it to here, we loaded an external definition
255 warn qq/# Loaded external class definition for '$table_class'\n/
258 if($self->dump_directory) {
259 my $class_path = $table_class;
260 $class_path =~ s{::}{/}g;
261 $class_path .= '.pm';
262 my $filename = $INC{$class_path};
263 croak 'Failed to locate actual external module file for '
266 open(my $fh, '<', $filename)
267 or croak "Failed to open $filename for reading: $!";
268 $self->_raw_stmt($table_class,
269 q|# These lines loaded from user-supplied external file: |
273 $self->_raw_stmt($table_class, $_);
275 $self->_raw_stmt($table_class,
276 q|# End of lines loaded from user-supplied external file |
279 or croak "Failed to close $filename: $!";
286 Does the actual schema-construction work.
293 $self->_load_classes;
294 $self->_load_relationships if $self->relationships;
295 $self->_load_external;
296 $self->_dump_to_dir if $self->dump_directory;
298 # Drop temporary cache
299 delete $self->{_cache};
304 sub _get_dump_filename {
305 my ($self, $class) = (@_);
308 return $self->dump_directory . q{/} . $class . q{.pm};
311 sub _ensure_dump_subdirs {
312 my ($self, $class) = (@_);
314 my @name_parts = split(/::/, $class);
316 my $dir = $self->dump_directory;
317 foreach (@name_parts) {
320 mkdir($dir) or die "mkdir('$dir') failed: $!";
328 my $target_dir = $self->dump_directory;
329 my $schema_class = $self->schema_class;
331 die "Must specify target directory for dumping!" if ! $target_dir;
333 warn "Dumping manual schema for $schema_class to directory $target_dir ...\n";
335 if(! -d $target_dir) {
336 mkdir($target_dir) or die "mkdir('$target_dir') failed: $!";
339 my $verstr = $DBIx::Class::Schema::Loader::VERSION;
340 my $datestr = POSIX::strftime('%Y-%m-%d %H:%M:%S', localtime);
341 my $tagline = qq|# Created by DBIx::Class::Schema::Loader v$verstr @ $datestr|;
343 $self->_ensure_dump_subdirs($schema_class);
345 my $schema_fn = $self->_get_dump_filename($schema_class);
346 open(my $schema_fh, '>', $schema_fn)
347 or die "Cannot open $schema_fn for writing: $!";
348 print $schema_fh qq|package $schema_class;\n\n$tagline\n\n|;
349 print $schema_fh qq|use strict;\nuse warnings;\n\n|;
350 print $schema_fh qq|use base 'DBIx::Class::Schema';\n\n|;
351 print $schema_fh qq|__PACKAGE__->load_classes;\n|;
352 print $schema_fh qq|\n1;\n\n|;
354 or die "Cannot close $schema_fn: $!";
356 foreach my $src_class (sort keys %{$self->{_dump_storage}}) {
357 $self->_ensure_dump_subdirs($src_class);
358 my $src_fn = $self->_get_dump_filename($src_class);
359 open(my $src_fh, '>', $src_fn)
360 or die "Cannot open $src_fn for writing: $!";
361 print $src_fh qq|package $src_class;\n\n$tagline\n\n|;
362 print $src_fh qq|use strict;\nuse warnings;\n\n|;
363 print $src_fh qq|use base 'DBIx::Class';\n\n|;
364 print $src_fh qq|$_\n|
365 for @{$self->{_dump_storage}->{$src_class}};
366 print $src_fh qq|\n1;\n\n|;
368 or die "Cannot close $src_fn: $!";
371 warn "Schema dump completed.\n";
379 $_->require or croak ($_ . "->require: $@");
380 $self->_raw_stmt($target, "use $_;");
381 warn "$target: use $_" if $self->debug;
382 eval "package $target; use $_;";
383 croak "use $_: $@" if $@;
390 my $schema_class = $self->schema_class;
392 my $blist = join(q{ }, @_);
393 $self->_raw_stmt($target, "use base qw/ $blist /;") if @_;
394 warn "$target: use base qw/ $blist /" if $self->debug;
396 $_->require or croak ($_ . "->require: $@");
397 $schema_class->inject_base($target, $_);
401 # Load and setup classes
405 my $schema = $self->schema;
406 my $schema_class = $self->schema_class;
407 my $constraint = $self->constraint;
408 my $exclude = $self->exclude;
409 my @tables = sort $self->_tables_list;
411 warn "No tables found in database, nothing to load" if !@tables;
414 @tables = grep { /$constraint/ } @tables if $constraint;
415 @tables = grep { ! /$exclude/ } @tables if $exclude;
417 warn "All tables excluded by constraint/exclude, nothing to load"
421 $self->{_tables} = \@tables;
423 foreach my $table (@tables) {
424 my $table_moniker = $self->_table2moniker($table);
425 my $table_class = $schema_class . q{::} . $table_moniker;
427 my $table_normalized = lc $table;
428 $self->classes->{$table} = $table_class;
429 $self->classes->{$table_normalized} = $table_class;
430 $self->monikers->{$table} = $table_moniker;
431 $self->monikers->{$table_normalized} = $table_moniker;
433 no warnings 'redefine';
434 local *Class::C3::reinitialize = sub { };
437 { no strict 'refs'; @{"${table_class}::ISA"} = qw/DBIx::Class/ }
439 $self->_use ($table_class, @{$self->additional_classes});
440 $self->_inject($table_class, @{$self->additional_base_classes});
442 $self->_dbic_stmt($table_class, 'load_components', @{$self->components}, qw/PK::Auto Core/);
444 $self->_dbic_stmt($table_class, 'load_resultset_components', @{$self->resultset_components})
445 if @{$self->resultset_components};
446 $self->_inject($table_class, @{$self->left_base_classes});
449 Class::C3::reinitialize;
451 foreach my $table (@tables) {
452 my $table_class = $self->classes->{$table};
453 my $table_moniker = $self->monikers->{$table};
455 $self->_dbic_stmt($table_class,'table',$table);
457 my $cols = $self->_table_columns($table);
459 eval { $col_info = $schema->storage->columns_info_for($table) };
461 $self->_dbic_stmt($table_class,'add_columns',@$cols);
465 foreach my $col (@$cols) {
466 $cols_hash{$col} = \%{($col_info->{$col})};
468 $self->_dbic_stmt($table_class,'add_columns',%cols_hash);
471 my $pks = $self->_table_pk_info($table) || [];
472 @$pks ? $self->_dbic_stmt($table_class,'set_primary_key',@$pks)
473 : carp("$table has no primary key");
475 my $uniqs = $self->_table_uniq_info($table) || [];
476 $self->_dbic_stmt($table_class,'add_unique_constraint',@$_) for (@$uniqs);
478 $schema_class->register_class($table_moniker, $table_class);
479 $schema->register_class($table_moniker, $table_class) if $schema ne $schema_class;
485 Returns a sorted list of loaded tables, using the original database table
493 return @{$self->_tables};
496 # Make a moniker from a table
498 my ( $self, $table ) = @_;
502 if( ref $self->moniker_map eq 'HASH' ) {
503 $moniker = $self->moniker_map->{$table};
505 elsif( ref $self->moniker_map eq 'CODE' ) {
506 $moniker = $self->moniker_map->($table);
509 $moniker ||= join '', map ucfirst, split /[\W_]+/, lc $table;
514 sub _load_relationships {
517 # Construct the fk_info RelBuilder wants to see, by
518 # translating table names to monikers in the _fk_info output
520 foreach my $table ($self->tables) {
521 my $tbl_fk_info = $self->_table_fk_info($table);
522 foreach my $fkdef (@$tbl_fk_info) {
523 $fkdef->{remote_source} =
524 $self->monikers->{delete $fkdef->{remote_table}};
526 my $moniker = $self->monikers->{$table};
527 $fk_info{$moniker} = $tbl_fk_info;
530 my $relbuilder = DBIx::Class::Schema::Loader::RelBuilder->new(
531 $self->schema_class, \%fk_info, $self->inflect_plural,
532 $self->inflect_singular
535 my $rel_stmts = $relbuilder->generate_code;
536 foreach my $src_class (sort keys %$rel_stmts) {
537 my $src_stmts = $rel_stmts->{$src_class};
538 foreach my $stmt (@$src_stmts) {
539 $self->_dbic_stmt($src_class,$stmt->{method},@{$stmt->{args}});
544 # Overload these in driver class:
546 # Returns an arrayref of column names
547 sub _table_columns { croak "ABSTRACT METHOD" }
549 # Returns arrayref of pk col names
550 sub _table_pk_info { croak "ABSTRACT METHOD" }
552 # Returns an arrayref of uniqs [ [ foo => [ col1, col2 ] ], [ bar => [ ... ] ] ]
553 sub _table_uniq_info { croak "ABSTRACT METHOD" }
555 # Returns an arrayref of foreign key constraints, each
556 # being a hashref with 3 keys:
557 # local_columns (arrayref), remote_columns (arrayref), remote_table
558 sub _table_fk_info { croak "ABSTRACT METHOD" }
560 # Returns an array of lower case table names
561 sub _tables_list { croak "ABSTRACT METHOD" }
563 # Execute a constructive DBIC class method, with debug/dump_to_dir hooks.
569 if(!$self->debug && !$self->dump_directory) {
575 $args = '(' . $args . ')' if @_ < 2;
576 my $stmt = $method . $args . q{;};
578 warn qq|$class\->$stmt\n| if $self->debug;
580 $self->_raw_stmt($class, '__PACKAGE__->' . $stmt);
583 # Store a raw source line for a class (for dumping purposes)
585 my ($self, $class, $stmt) = @_;
586 push(@{$self->{_dump_storage}->{$class}}, $stmt) if $self->dump_directory;
591 Returns a hashref of loaded table to moniker mappings. There will
592 be two entries for each table, the original name and the "normalized"
593 name, in the case that the two are different (such as databases
594 that like uppercase table names, or preserve your original mixed-case
595 definitions, or what-have-you).
599 Returns a hashref of table to class mappings. In some cases it will
600 contain multiple entries per table for the original and normalized table
601 names, as above in L</monikers>.
605 L<DBIx::Class::Schema::Loader>