1 package DBIx::Class::Schema::Loader::Base;
5 use base qw/Class::Accessor::Fast/;
7 use Carp::Clan qw/^DBIx::Class/;
8 use UNIVERSAL::require;
9 use DBIx::Class::Schema::Loader::RelBuilder;
10 use Data::Dump qw/ dump /;
15 our $VERSION = '0.03999_01';
17 __PACKAGE__->mk_ro_accessors(qw/
24 additional_base_classes
36 legacy_default_inflections
46 DBIx::Class::Schema::Loader::Base - Base DBIx::Class::Schema::Loader Implementation.
50 See L<DBIx::Class::Schema::Loader>
54 This is the base class for the storage-specific C<DBIx::Class::Schema::*>
55 classes, and implements the common functionality between them.
57 =head1 CONSTRUCTOR OPTIONS
59 These constructor options are the base options for
60 L<DBIx::Class::Schema::Loader/loader_opts>. Available constructor options are:
62 =head2 skip_relationships
64 Skip setting up relationships. The default is to attempt the loading
69 If set to true, each constructive L<DBIx::Class> statement the loader
70 decides to execute will be C<warn>-ed before execution.
74 Set the name of the schema to load (schema in the sense that your database
75 vendor means it). Does not currently support loading more than one schema
80 Only load tables matching regex. Best specified as a qr// regex.
84 Exclude tables matching regex. Best specified as a qr// regex.
88 Overrides the default table name to moniker translation. Can be either
89 a hashref of table keys and moniker values, or a coderef for a translator
90 function taking a single scalar table name argument and returning
91 a scalar moniker. If the hash entry does not exist, or the function
92 returns a false value, the code falls back to default behavior
95 The default behavior is: C<join '', map ucfirst, split /[\W_]+/, lc $table>,
96 which is to say: lowercase everything, split up the table name into chunks
97 anywhere a non-alpha-numeric character occurs, change the case of first letter
98 of each chunk to upper case, and put the chunks back together. Examples:
100 Table Name | Moniker Name
101 ---------------------------
103 luser_group | LuserGroup
104 luser-opts | LuserOpts
106 =head2 inflect_plural
108 Just like L</moniker_map> above (can be hash/code-ref, falls back to default
109 if hash key does not exist or coderef returns false), but acts as a map
110 for pluralizing relationship names. The default behavior is to utilize
111 L<Lingua::EN::Inflect::Number/to_PL>.
113 =head2 inflect_singular
115 As L</inflect_plural> above, but for singularizing relationship names.
116 Default behavior is to utilize L<Lingua::EN::Inflect::Number/to_S>.
118 =head2 additional_base_classes
120 List of additional base classes all of your table classes will use.
122 =head2 left_base_classes
124 List of additional base classes all of your table classes will use
125 that need to be leftmost.
127 =head2 additional_classes
129 List of additional classes which all of your table classes will use.
133 List of additional components to be loaded into all of your table
134 classes. A good example would be C<ResultSetManager>.
136 =head2 resultset_components
138 List of additional ResultSet components to be loaded into your table
139 classes. A good example would be C<AlwaysRS>. Component
140 C<ResultSetManager> will be automatically added to the above
141 C<components> list if this option is set.
143 =head2 legacy_default_inflections
145 Setting this option changes the default fallback for L</inflect_plural> to
146 utilize L<Lingua::EN::Inflect/PL>, and L</inflect_singular> to a no-op.
147 Those choices produce substandard results, but might be necessary to support
148 your existing code if you started developing on a version prior to 0.03 and
149 don't wish to go around updating all your relationship names to the new
152 This option will continue to be supported until at least version 0.05xxx,
153 but may dissappear sometime thereafter. It is recommended that you update
154 your code to use the newer-style inflections when you have the time.
156 =head2 dump_directory
158 This option is designed to be a tool to help you transition from this
159 loader to a manually-defined schema when you decide it's time to do so.
161 The value of this option is a perl libdir pathname. Within
162 that directory this module will create a baseline manual
163 L<DBIx::Class::Schema> module set, based on what it creates at runtime
166 The created schema class will have the same classname as the one on
167 which you are setting this option (and the ResultSource classes will be
168 based on this name as well). Therefore it is wise to note that if you
169 point the C<dump_directory> option of a schema class at the live libdir
170 where that class is currently located, it will overwrite itself with a
171 manual version of itself. This might be a really good or bad thing
172 depending on your situation and perspective.
174 Normally you wouldn't hard-code this setting in your schema class, as it
175 is meant for one-time manual usage.
177 See L<DBIx::Class::Schema::Loader/dump_to_dir> for examples of the
178 recommended way to access this functionality.
180 =head2 dump_overwrite
182 If set to a true value, the dumping code will overwrite existing files.
183 The default is false, which means the dumping code will skip the already
188 None of these methods are intended for direct invocation by regular
189 users of L<DBIx::Class::Schema::Loader>. Anything you can find here
190 can also be found via standard L<DBIx::Class::Schema> methods somehow.
194 # ensure that a peice of object data is a valid arrayref, creating
195 # an empty one or encapsulating whatever's there.
196 sub _ensure_arrayref {
201 $self->{$_} = [ $self->{$_} ]
202 unless ref $self->{$_} eq 'ARRAY';
208 Constructor for L<DBIx::Class::Schema::Loader::Base>, used internally
209 by L<DBIx::Class::Schema::Loader>.
214 my ( $class, %args ) = @_;
216 my $self = { %args };
218 bless $self => $class;
220 $self->{db_schema} ||= '';
221 $self->_ensure_arrayref(qw/additional_classes
222 additional_base_classes
228 push(@{$self->{components}}, 'ResultSetManager')
229 if @{$self->{resultset_components}};
231 $self->{monikers} = {};
232 $self->{classes} = {};
234 $self->{schema_class} ||= ( ref $self->{schema} || $self->{schema} );
235 $self->{schema} ||= $self->{schema_class};
245 $abs_dump_dir = Cwd::abs_path($self->dump_directory)
246 if $self->dump_directory;
248 foreach my $table_class (values %{$self->classes}) {
249 $table_class->require;
250 if($@ && $@ !~ /^Can't locate /) {
251 croak "Failed to load external class definition"
252 . " for '$table_class': $@";
254 next if $@; # "Can't locate" error
256 # If we make it to here, we loaded an external definition
257 warn qq/# Loaded external class definition for '$table_class'\n/
261 my $class_path = $table_class;
262 $class_path =~ s{::}{/}g;
263 $class_path .= '.pm';
264 my $filename = Cwd::abs_path($INC{$class_path});
265 croak 'Failed to locate actual external module file for '
268 next if($filename =~ /^$abs_dump_dir/);
269 open(my $fh, '<', $filename)
270 or croak "Failed to open $filename for reading: $!";
271 $self->_raw_stmt($table_class,
272 q|# These lines loaded from user-supplied external file: |
276 $self->_raw_stmt($table_class, $_);
278 $self->_raw_stmt($table_class,
279 q|# End of lines loaded from user-supplied external file |
282 or croak "Failed to close $filename: $!";
289 Does the actual schema-construction work.
296 $self->_load_classes;
297 $self->_load_relationships if ! $self->skip_relationships;
298 $self->_load_external;
299 $self->_dump_to_dir if $self->dump_directory;
301 # Drop temporary cache
302 delete $self->{_cache};
307 sub _get_dump_filename {
308 my ($self, $class) = (@_);
311 return $self->dump_directory . q{/} . $class . q{.pm};
314 sub _ensure_dump_subdirs {
315 my ($self, $class) = (@_);
317 my @name_parts = split(/::/, $class);
319 my $dir = $self->dump_directory;
320 foreach (@name_parts) {
323 mkdir($dir) or croak "mkdir('$dir') failed: $!";
331 my $target_dir = $self->dump_directory;
333 my $schema_class = $self->schema_class;
335 croak "Must specify target directory for dumping!" if ! $target_dir;
337 warn "Dumping manual schema for $schema_class to directory $target_dir ...\n";
339 if(! -d $target_dir) {
340 mkdir($target_dir) or croak "mkdir('$target_dir') failed: $!";
343 my $verstr = $DBIx::Class::Schema::Loader::VERSION;
344 my $datestr = POSIX::strftime('%Y-%m-%d %H:%M:%S', localtime);
345 my $tagline = qq|# Created by DBIx::Class::Schema::Loader v$verstr @ $datestr|;
347 $self->_ensure_dump_subdirs($schema_class);
349 my $schema_fn = $self->_get_dump_filename($schema_class);
350 if (-f $schema_fn && !$self->dump_overwrite) {
351 warn "$schema_fn exists, will not overwrite\n";
354 open(my $schema_fh, '>', $schema_fn)
355 or croak "Cannot open $schema_fn for writing: $!";
356 print $schema_fh qq|package $schema_class;\n\n$tagline\n\n|;
357 print $schema_fh qq|use strict;\nuse warnings;\n\n|;
358 print $schema_fh qq|use base 'DBIx::Class::Schema';\n\n|;
359 print $schema_fh qq|__PACKAGE__->load_classes;\n|;
360 print $schema_fh qq|\n1;\n\n|;
362 or croak "Cannot close $schema_fn: $!";
365 foreach my $src_class (sort keys %{$self->{_dump_storage}}) {
366 $self->_ensure_dump_subdirs($src_class);
367 my $src_fn = $self->_get_dump_filename($src_class);
368 if (-f $src_fn && !$self->dump_overwrite) {
369 warn "$src_fn exists, will not overwrite\n";
372 open(my $src_fh, '>', $src_fn)
373 or croak "Cannot open $src_fn for writing: $!";
374 print $src_fh qq|package $src_class;\n\n$tagline\n\n|;
375 print $src_fh qq|use strict;\nuse warnings;\n\n|;
376 print $src_fh qq|use base 'DBIx::Class';\n\n|;
377 print $src_fh qq|$_\n|
378 for @{$self->{_dump_storage}->{$src_class}};
379 print $src_fh qq|\n1;\n\n|;
381 or croak "Cannot close $src_fn: $!";
384 warn "Schema dump completed.\n";
393 warn "$target: use $_;" if $self->debug;
394 $self->_raw_stmt($target, "use $_;");
395 $_->require or croak ($_ . "->require: $@");
396 $evalstr .= "package $target; use $_;";
398 eval $evalstr if $evalstr;
405 my $schema_class = $self->schema_class;
407 my $blist = join(q{ }, @_);
408 warn "$target: use base qw/ $blist /;" if $self->debug && @_;
409 $self->_raw_stmt($target, "use base qw/ $blist /;") if @_;
411 $_->require or croak ($_ . "->require: $@");
412 $schema_class->inject_base($target, $_);
416 # Load and setup classes
420 my $schema = $self->schema;
421 my $schema_class = $self->schema_class;
422 my $constraint = $self->constraint;
423 my $exclude = $self->exclude;
424 my @tables = sort $self->_tables_list;
426 warn "No tables found in database, nothing to load" if !@tables;
429 @tables = grep { /$constraint/ } @tables if $constraint;
430 @tables = grep { ! /$exclude/ } @tables if $exclude;
432 warn "All tables excluded by constraint/exclude, nothing to load"
436 $self->{_tables} = \@tables;
438 foreach my $table (@tables) {
439 my $table_moniker = $self->_table2moniker($table);
440 my $table_class = $schema_class . q{::} . $table_moniker;
442 my $table_normalized = lc $table;
443 $self->classes->{$table} = $table_class;
444 $self->classes->{$table_normalized} = $table_class;
445 $self->monikers->{$table} = $table_moniker;
446 $self->monikers->{$table_normalized} = $table_moniker;
448 no warnings 'redefine';
449 local *Class::C3::reinitialize = sub { };
452 { no strict 'refs'; @{"${table_class}::ISA"} = qw/DBIx::Class/ }
454 $self->_use ($table_class, @{$self->additional_classes});
455 $self->_inject($table_class, @{$self->additional_base_classes});
457 $self->_dbic_stmt($table_class, 'load_components', @{$self->components}, qw/PK::Auto Core/);
459 $self->_dbic_stmt($table_class, 'load_resultset_components', @{$self->resultset_components})
460 if @{$self->resultset_components};
461 $self->_inject($table_class, @{$self->left_base_classes});
464 Class::C3::reinitialize;
466 foreach my $table (@tables) {
467 my $table_class = $self->classes->{$table};
468 my $table_moniker = $self->monikers->{$table};
470 $self->_dbic_stmt($table_class,'table',$table);
472 my $cols = $self->_table_columns($table);
474 eval { $col_info = $self->_columns_info_for($table) };
476 $self->_dbic_stmt($table_class,'add_columns',@$cols);
479 my %col_info_lc = map { lc($_), $col_info->{$_} } keys %$col_info;
483 map { $_, ($col_info_lc{$_}||{}) } @$cols
487 my $pks = $self->_table_pk_info($table) || [];
488 @$pks ? $self->_dbic_stmt($table_class,'set_primary_key',@$pks)
489 : carp("$table has no primary key");
491 my $uniqs = $self->_table_uniq_info($table) || [];
492 $self->_dbic_stmt($table_class,'add_unique_constraint',@$_) for (@$uniqs);
494 $schema_class->register_class($table_moniker, $table_class);
495 $schema->register_class($table_moniker, $table_class) if $schema ne $schema_class;
501 Returns a sorted list of loaded tables, using the original database table
509 return @{$self->_tables};
512 # Make a moniker from a table
514 my ( $self, $table ) = @_;
518 if( ref $self->moniker_map eq 'HASH' ) {
519 $moniker = $self->moniker_map->{$table};
521 elsif( ref $self->moniker_map eq 'CODE' ) {
522 $moniker = $self->moniker_map->($table);
525 $moniker ||= join '', map ucfirst, split /[\W_]+/, lc $table;
530 sub _load_relationships {
533 # Construct the fk_info RelBuilder wants to see, by
534 # translating table names to monikers in the _fk_info output
536 foreach my $table ($self->tables) {
537 my $tbl_fk_info = $self->_table_fk_info($table);
538 foreach my $fkdef (@$tbl_fk_info) {
539 $fkdef->{remote_source} =
540 $self->monikers->{delete $fkdef->{remote_table}};
542 my $moniker = $self->monikers->{$table};
543 $fk_info{$moniker} = $tbl_fk_info;
546 my $relbuilder = DBIx::Class::Schema::Loader::RelBuilder->new(
547 $self->schema_class, \%fk_info, $self->inflect_plural,
548 $self->inflect_singular
551 my $rel_stmts = $relbuilder->generate_code;
552 foreach my $src_class (sort keys %$rel_stmts) {
553 my $src_stmts = $rel_stmts->{$src_class};
554 foreach my $stmt (@$src_stmts) {
555 $self->_dbic_stmt($src_class,$stmt->{method},@{$stmt->{args}});
560 # Overload these in driver class:
562 # Returns an arrayref of column names
563 sub _table_columns { croak "ABSTRACT METHOD" }
565 # Returns arrayref of pk col names
566 sub _table_pk_info { croak "ABSTRACT METHOD" }
568 # Returns an arrayref of uniqs [ [ foo => [ col1, col2 ] ], [ bar => [ ... ] ] ]
569 sub _table_uniq_info { croak "ABSTRACT METHOD" }
571 # Returns an arrayref of foreign key constraints, each
572 # being a hashref with 3 keys:
573 # local_columns (arrayref), remote_columns (arrayref), remote_table
574 sub _table_fk_info { croak "ABSTRACT METHOD" }
576 # Returns an array of lower case table names
577 sub _tables_list { croak "ABSTRACT METHOD" }
579 # Execute a constructive DBIC class method, with debug/dump_to_dir hooks.
585 if(!$self->debug && !$self->dump_directory) {
591 $args = '(' . $args . ')' if @_ < 2;
592 my $stmt = $method . $args . q{;};
594 warn qq|$class\->$stmt\n| if $self->debug;
596 $self->_raw_stmt($class, '__PACKAGE__->' . $stmt);
599 # Store a raw source line for a class (for dumping purposes)
601 my ($self, $class, $stmt) = @_;
602 push(@{$self->{_dump_storage}->{$class}}, $stmt) if $self->dump_directory;
607 Returns a hashref of loaded table to moniker mappings. There will
608 be two entries for each table, the original name and the "normalized"
609 name, in the case that the two are different (such as databases
610 that like uppercase table names, or preserve your original mixed-case
611 definitions, or what-have-you).
615 Returns a hashref of table to class mappings. In some cases it will
616 contain multiple entries per table for the original and normalized table
617 names, as above in L</monikers>.
621 L<DBIx::Class::Schema::Loader>