1 package DBIx::Class::Schema::Loader::Base;
5 use base qw/Class::Accessor::Grouped Class::C3::Componentised/;
6 use namespace::autoclean;
8 use Carp::Clan qw/^DBIx::Class/;
9 use DBIx::Class::Schema::Loader::RelBuilder;
10 use Data::Dump qw/ dump /;
15 use Lingua::EN::Inflect::Number qw//;
18 use Class::Inspector ();
19 use Data::Dumper::Concise;
20 use Scalar::Util 'looks_like_number';
21 use File::Slurp 'slurp';
24 our $VERSION = '0.05003';
26 __PACKAGE__->mk_group_ro_accessors('simple', qw/
33 additional_base_classes
48 default_resultset_class
51 overwrite_modifications
68 __PACKAGE__->mk_group_accessors('simple', qw/
70 schema_version_to_dump
72 _upgrading_from_load_classes
73 _downgrading_to_load_classes
74 _rewriting_result_namespace
79 pod_comment_spillover_length
84 DBIx::Class::Schema::Loader::Base - Base DBIx::Class::Schema::Loader Implementation.
88 See L<DBIx::Class::Schema::Loader>
92 This is the base class for the storage-specific C<DBIx::Class::Schema::*>
93 classes, and implements the common functionality between them.
95 =head1 CONSTRUCTOR OPTIONS
97 These constructor options are the base options for
98 L<DBIx::Class::Schema::Loader/loader_options>. Available constructor options are:
100 =head2 skip_relationships
102 Skip setting up relationships. The default is to attempt the loading
105 =head2 skip_load_external
107 Skip loading of other classes in @INC. The default is to merge all other classes
108 with the same name found in @INC into the schema file we are creating.
112 Static schemas (ones dumped to disk) will, by default, use the new-style 0.05XXX
113 relationship names and singularized Results, unless you're overwriting an
114 existing dump made by a 0.04XXX version of L<DBIx::Class::Schema::Loader>, in
115 which case the backward compatible RelBuilder will be activated, and
116 singularization will be turned off.
122 will disable the backward-compatible RelBuilder and use
123 the new-style relationship names along with singularized Results, even when
124 overwriting a dump made with an earlier version.
126 The option also takes a hashref:
128 naming => { relationships => 'v5', monikers => 'v4' }
136 How to name relationship accessors.
140 How to name Result classes.
150 Latest default style, whatever that happens to be.
154 Version 0.05XXX style.
158 Version 0.04XXX style.
162 Dynamic schemas will always default to the 0.04XXX relationship names and won't
163 singularize Results for backward compatibility, to activate the new RelBuilder
164 and singularization put this in your C<Schema.pm> file:
166 __PACKAGE__->naming('current');
168 Or if you prefer to use 0.05XXX features but insure that nothing breaks in the
169 next major version upgrade:
171 __PACKAGE__->naming('v5');
175 By default POD will be generated for columns and relationships, using database
176 metadata for the text if available and supported.
178 Reading database metadata (e.g. C<COMMENT ON TABLE some_table ...>) is only
179 supported for Postgres right now.
181 Set this to C<0> to turn off all POD generation.
183 =head2 pod_comment_mode
185 Controls where table comments appear in the generated POD. Smaller table
186 comments are appended to the C<NAME> section of the documentation, and larger
187 ones are inserted into C<DESCRIPTION> instead. You can force a C<DESCRIPTION>
188 section to be generated with the comment always, only use C<NAME>, or choose
189 the length threshold at which the comment is forced into the description.
195 Use C<NAME> section only.
199 Force C<DESCRIPTION> always.
203 Use C<DESCRIPTION> if length > L</pod_comment_spillover_length>, this is the
208 =head2 pod_comment_spillover_length
210 When pod_comment_mode is set to C<auto>, this is the length of the comment at
211 which it will be forced into a separate description section.
215 =head2 relationship_attrs
217 Hashref of attributes to pass to each generated relationship, listed
218 by type. Also supports relationship type 'all', containing options to
219 pass to all generated relationships. Attributes set for more specific
220 relationship types override those set in 'all'.
224 relationship_attrs => {
225 all => { cascade_delete => 0 },
226 has_many => { cascade_delete => 1 },
229 will set the C<cascade_delete> option to 0 for all generated relationships,
230 except for C<has_many>, which will have cascade_delete as 1.
232 NOTE: this option is not supported if v4 backward-compatible naming is
233 set either globally (naming => 'v4') or just for relationships.
237 If set to true, each constructive L<DBIx::Class> statement the loader
238 decides to execute will be C<warn>-ed before execution.
242 Set the name of the schema to load (schema in the sense that your database
243 vendor means it). Does not currently support loading more than one schema
248 Only load tables matching regex. Best specified as a qr// regex.
252 Exclude tables matching regex. Best specified as a qr// regex.
256 Overrides the default table name to moniker translation. Can be either
257 a hashref of table keys and moniker values, or a coderef for a translator
258 function taking a single scalar table name argument and returning
259 a scalar moniker. If the hash entry does not exist, or the function
260 returns a false value, the code falls back to default behavior
263 The default behavior is to singularize the table name, and: C<join '', map
264 ucfirst, split /[\W_]+/, lc $table>, which is to say: lowercase everything,
265 split up the table name into chunks anywhere a non-alpha-numeric character
266 occurs, change the case of first letter of each chunk to upper case, and put
267 the chunks back together. Examples:
269 Table Name | Moniker Name
270 ---------------------------
272 luser_group | LuserGroup
273 luser-opts | LuserOpt
275 =head2 inflect_plural
277 Just like L</moniker_map> above (can be hash/code-ref, falls back to default
278 if hash key does not exist or coderef returns false), but acts as a map
279 for pluralizing relationship names. The default behavior is to utilize
280 L<Lingua::EN::Inflect::Number/to_PL>.
282 =head2 inflect_singular
284 As L</inflect_plural> above, but for singularizing relationship names.
285 Default behavior is to utilize L<Lingua::EN::Inflect::Number/to_S>.
287 =head2 schema_base_class
289 Base class for your schema classes. Defaults to 'DBIx::Class::Schema'.
291 =head2 result_base_class
293 Base class for your table classes (aka result classes). Defaults to
296 =head2 additional_base_classes
298 List of additional base classes all of your table classes will use.
300 =head2 left_base_classes
302 List of additional base classes all of your table classes will use
303 that need to be leftmost.
305 =head2 additional_classes
307 List of additional classes which all of your table classes will use.
311 List of additional components to be loaded into all of your table
312 classes. A good example would be C<ResultSetManager>.
314 =head2 resultset_components
316 List of additional ResultSet components to be loaded into your table
317 classes. A good example would be C<AlwaysRS>. Component
318 C<ResultSetManager> will be automatically added to the above
319 C<components> list if this option is set.
321 =head2 use_namespaces
323 This is now the default, to go back to L<DBIx::Class::Schema/load_classes> pass
326 Generate result class names suitable for
327 L<DBIx::Class::Schema/load_namespaces> and call that instead of
328 L<DBIx::Class::Schema/load_classes>. When using this option you can also
329 specify any of the options for C<load_namespaces> (i.e. C<result_namespace>,
330 C<resultset_namespace>, C<default_resultset_class>), and they will be added
331 to the call (and the generated result class names adjusted appropriately).
333 =head2 dump_directory
335 This option is designed to be a tool to help you transition from this
336 loader to a manually-defined schema when you decide it's time to do so.
338 The value of this option is a perl libdir pathname. Within
339 that directory this module will create a baseline manual
340 L<DBIx::Class::Schema> module set, based on what it creates at runtime
343 The created schema class will have the same classname as the one on
344 which you are setting this option (and the ResultSource classes will be
345 based on this name as well).
347 Normally you wouldn't hard-code this setting in your schema class, as it
348 is meant for one-time manual usage.
350 See L<DBIx::Class::Schema::Loader/dump_to_dir> for examples of the
351 recommended way to access this functionality.
353 =head2 dump_overwrite
355 Deprecated. See L</really_erase_my_files> below, which does *not* mean
356 the same thing as the old C<dump_overwrite> setting from previous releases.
358 =head2 really_erase_my_files
360 Default false. If true, Loader will unconditionally delete any existing
361 files before creating the new ones from scratch when dumping a schema to disk.
363 The default behavior is instead to only replace the top portion of the
364 file, up to and including the final stanza which contains
365 C<# DO NOT MODIFY THIS OR ANYTHING ABOVE!>
366 leaving any customizations you placed after that as they were.
368 When C<really_erase_my_files> is not set, if the output file already exists,
369 but the aforementioned final stanza is not found, or the checksum
370 contained there does not match the generated contents, Loader will
371 croak and not touch the file.
373 You should really be using version control on your schema classes (and all
374 of the rest of your code for that matter). Don't blame me if a bug in this
375 code wipes something out when it shouldn't have, you've been warned.
377 =head2 overwrite_modifications
379 Default false. If false, when updating existing files, Loader will
380 refuse to modify any Loader-generated code that has been modified
381 since its last run (as determined by the checksum Loader put in its
384 If true, Loader will discard any manual modifications that have been
385 made to Loader-generated code.
387 Again, you should be using version control on your schema classes. Be
388 careful with this option.
390 =head2 custom_column_info
392 Hook for adding extra attributes to the
393 L<column_info|DBIx::Class::ResultSource/column_info> for a column.
395 Must be a coderef that returns a hashref with the extra attributes.
397 Receives the table name, column name and column_info.
401 custom_column_info => sub {
402 my ($table_name, $column_name, $column_info) = @_;
404 if ($column_name eq 'dog' && $column_info->{default_value} eq 'snoopy') {
405 return { is_snoopy => 1 };
409 This attribute can also be used to set C<inflate_datetime> on a non-datetime
410 column so it also receives the L</datetime_timezone> and/or L</datetime_locale>.
412 =head2 datetime_timezone
414 Sets the timezone attribute for L<DBIx::Class::InflateColumn::DateTime> for all
415 columns with the DATE/DATETIME/TIMESTAMP data_types.
417 =head2 datetime_locale
419 Sets the locale attribute for L<DBIx::Class::InflateColumn::DateTime> for all
420 columns with the DATE/DATETIME/TIMESTAMP data_types.
424 File in Perl format, which should return a HASH reference, from which to read
429 None of these methods are intended for direct invocation by regular
430 users of L<DBIx::Class::Schema::Loader>. Some are proxied via
431 L<DBIx::Class::Schema::Loader>.
435 my $CURRENT_V = 'v5';
438 schema_base_class result_base_class additional_base_classes
439 left_base_classes additional_classes components resultset_components
442 # ensure that a peice of object data is a valid arrayref, creating
443 # an empty one or encapsulating whatever's there.
444 sub _ensure_arrayref {
449 $self->{$_} = [ $self->{$_} ]
450 unless ref $self->{$_} eq 'ARRAY';
456 Constructor for L<DBIx::Class::Schema::Loader::Base>, used internally
457 by L<DBIx::Class::Schema::Loader>.
462 my ( $class, %args ) = @_;
464 my $self = { %args };
466 bless $self => $class;
468 if (my $config_file = $self->config_file) {
469 my $config_opts = do $config_file;
471 croak "Error reading config from $config_file: $@" if $@;
473 croak "Config file $config_file must be a hashref" unless ref($config_opts) eq 'HASH';
475 while (my ($k, $v) = each %$config_opts) {
476 $self->{$k} = $v unless exists $self->{$k};
480 $self->_ensure_arrayref(qw/additional_classes
481 additional_base_classes
487 $self->_validate_class_args;
489 push(@{$self->{components}}, 'ResultSetManager')
490 if @{$self->{resultset_components}};
492 $self->{monikers} = {};
493 $self->{classes} = {};
494 $self->{_upgrading_classes} = {};
496 $self->{schema_class} ||= ( ref $self->{schema} || $self->{schema} );
497 $self->{schema} ||= $self->{schema_class};
499 croak "dump_overwrite is deprecated. Please read the"
500 . " DBIx::Class::Schema::Loader::Base documentation"
501 if $self->{dump_overwrite};
503 $self->{dynamic} = ! $self->{dump_directory};
504 $self->{temp_directory} ||= File::Temp::tempdir( 'dbicXXXX',
509 $self->{dump_directory} ||= $self->{temp_directory};
511 $self->version_to_dump($DBIx::Class::Schema::Loader::VERSION);
512 $self->schema_version_to_dump($DBIx::Class::Schema::Loader::VERSION);
514 if ((not ref $self->naming) && defined $self->naming) {
515 my $naming_ver = $self->naming;
517 relationships => $naming_ver,
518 monikers => $naming_ver,
523 for (values %{ $self->naming }) {
524 $_ = $CURRENT_V if $_ eq 'current';
527 $self->{naming} ||= {};
529 if ($self->custom_column_info && ref $self->custom_column_info ne 'CODE') {
530 croak 'custom_column_info must be a CODE ref';
533 $self->_check_back_compat;
535 $self->use_namespaces(1) unless defined $self->use_namespaces;
536 $self->generate_pod(1) unless defined $self->generate_pod;
537 $self->pod_comment_mode('auto') unless defined $self->pod_comment_mode;
538 $self->pod_comment_spillover_length(60) unless defined $self->pod_comment_spillover_length;
543 sub _check_back_compat {
546 # dynamic schemas will always be in 0.04006 mode, unless overridden
547 if ($self->dynamic) {
548 # just in case, though no one is likely to dump a dynamic schema
549 $self->schema_version_to_dump('0.04006');
551 if (not %{ $self->naming }) {
552 warn <<EOF unless $ENV{SCHEMA_LOADER_BACKCOMPAT};
554 Dynamic schema detected, will run in 0.04006 mode.
556 Set the 'naming' attribute or the SCHEMA_LOADER_BACKCOMPAT environment variable
557 to disable this warning.
559 Also consider setting 'use_namespaces => 1' if/when upgrading.
561 See perldoc DBIx::Class::Schema::Loader::Manual::UpgradingFromV4 for more
566 $self->_upgrading_from('v4');
569 $self->naming->{relationships} ||= 'v4';
570 $self->naming->{monikers} ||= 'v4';
572 if ($self->use_namespaces) {
573 $self->_upgrading_from_load_classes(1);
576 $self->use_namespaces(0);
582 # otherwise check if we need backcompat mode for a static schema
583 my $filename = $self->_get_dump_filename($self->schema_class);
584 return unless -e $filename;
586 open(my $fh, '<', $filename)
587 or croak "Cannot open '$filename' for reading: $!";
589 my $load_classes = 0;
590 my $result_namespace = '';
593 if (/^__PACKAGE__->load_classes;/) {
595 } elsif (/result_namespace => '([^']+)'/) {
596 $result_namespace = $1;
597 } elsif (my ($real_ver) =
598 /^# Created by DBIx::Class::Schema::Loader v(\d+\.\d+)/) {
600 if ($load_classes && (not defined $self->use_namespaces)) {
601 warn <<"EOF" unless $ENV{SCHEMA_LOADER_BACKCOMPAT};
603 'load_classes;' static schema detected, turning off 'use_namespaces'.
605 Set the 'use_namespaces' attribute or the SCHEMA_LOADER_BACKCOMPAT environment
606 variable to disable this warning.
608 See perldoc DBIx::Class::Schema::Loader::Manual::UpgradingFromV4 for more
611 $self->use_namespaces(0);
613 elsif ($load_classes && $self->use_namespaces) {
614 $self->_upgrading_from_load_classes(1);
616 elsif ((not $load_classes) && defined $self->use_namespaces
617 && (not $self->use_namespaces)) {
618 $self->_downgrading_to_load_classes(
619 $result_namespace || 'Result'
622 elsif ((not defined $self->use_namespaces)
623 || $self->use_namespaces) {
624 if (not $self->result_namespace) {
625 $self->result_namespace($result_namespace || 'Result');
627 elsif ($result_namespace ne $self->result_namespace) {
628 $self->_rewriting_result_namespace(
629 $result_namespace || 'Result'
634 # XXX when we go past .0 this will need fixing
635 my ($v) = $real_ver =~ /([1-9])/;
638 last if $v eq $CURRENT_V || $real_ver =~ /^0\.\d\d999/;
640 if (not %{ $self->naming }) {
641 warn <<"EOF" unless $ENV{SCHEMA_LOADER_BACKCOMPAT};
643 Version $real_ver static schema detected, turning on backcompat mode.
645 Set the 'naming' attribute or the SCHEMA_LOADER_BACKCOMPAT environment variable
646 to disable this warning.
648 See perldoc DBIx::Class::Schema::Loader::Manual::UpgradingFromV4 for more
653 $self->_upgrading_from($v);
657 $self->naming->{relationships} ||= $v;
658 $self->naming->{monikers} ||= $v;
660 $self->schema_version_to_dump($real_ver);
668 sub _validate_class_args {
672 foreach my $k (@CLASS_ARGS) {
673 next unless $self->$k;
675 my @classes = ref $self->$k eq 'ARRAY' ? @{ $self->$k } : $self->$k;
676 foreach my $c (@classes) {
677 # components default to being under the DBIx::Class namespace unless they
678 # are preceeded with a '+'
679 if ( $k =~ m/components$/ && $c !~ s/^\+// ) {
680 $c = 'DBIx::Class::' . $c;
683 # 1 == installed, 0 == not installed, undef == invalid classname
684 my $installed = Class::Inspector->installed($c);
685 if ( defined($installed) ) {
686 if ( $installed == 0 ) {
687 croak qq/$c, as specified in the loader option "$k", is not installed/;
690 croak qq/$c, as specified in the loader option "$k", is an invalid class name/;
696 sub _find_file_in_inc {
697 my ($self, $file) = @_;
699 foreach my $prefix (@INC) {
700 my $fullpath = File::Spec->catfile($prefix, $file);
701 return $fullpath if -f $fullpath
702 # abs_path throws on Windows for nonexistant files
703 and eval { Cwd::abs_path($fullpath) } ne
704 (eval { Cwd::abs_path(File::Spec->catfile($self->dump_directory, $file)) } || '');
711 my ($self, $class) = @_;
713 my $class_path = $class;
714 $class_path =~ s{::}{/}g;
715 $class_path .= '.pm';
720 sub _find_class_in_inc {
721 my ($self, $class) = @_;
723 return $self->_find_file_in_inc($self->_class_path($class));
729 return $self->_upgrading_from
730 || $self->_upgrading_from_load_classes
731 || $self->_downgrading_to_load_classes
732 || $self->_rewriting_result_namespace
736 sub _rewrite_old_classnames {
737 my ($self, $code) = @_;
739 return $code unless $self->_rewriting;
741 my %old_classes = reverse %{ $self->_upgrading_classes };
743 my $re = join '|', keys %old_classes;
746 $code =~ s/$re/$old_classes{$1} || $1/eg;
752 my ($self, $class) = @_;
754 return if $self->{skip_load_external};
756 # so that we don't load our own classes, under any circumstances
757 local *INC = [ grep $_ ne $self->dump_directory, @INC ];
759 my $real_inc_path = $self->_find_class_in_inc($class);
761 my $old_class = $self->_upgrading_classes->{$class}
762 if $self->_rewriting;
764 my $old_real_inc_path = $self->_find_class_in_inc($old_class)
765 if $old_class && $old_class ne $class;
767 return unless $real_inc_path || $old_real_inc_path;
769 if ($real_inc_path) {
770 # If we make it to here, we loaded an external definition
771 warn qq/# Loaded external class definition for '$class'\n/
774 open(my $fh, '<', $real_inc_path)
775 or croak "Failed to open '$real_inc_path' for reading: $!";
776 my $code = do { local $/; <$fh> };
778 or croak "Failed to close $real_inc_path: $!";
779 $code = $self->_rewrite_old_classnames($code);
781 if ($self->dynamic) { # load the class too
782 # kill redefined warnings
783 my $warn_handler = $SIG{__WARN__} || sub { warn @_ };
784 local $SIG{__WARN__} = sub {
786 unless $_[0] =~ /^Subroutine \S+ redefined/;
792 $self->_ext_stmt($class,
793 qq|# These lines were loaded from '$real_inc_path' found in \@INC.\n|
794 .qq|# They are now part of the custom portion of this file\n|
795 .qq|# for you to hand-edit. If you do not either delete\n|
796 .qq|# this section or remove that file from \@INC, this section\n|
797 .qq|# will be repeated redundantly when you re-create this\n|
798 .qq|# file again via Loader! See skip_load_external to disable\n|
799 .qq|# this feature.\n|
802 $self->_ext_stmt($class, $code);
803 $self->_ext_stmt($class,
804 qq|# End of lines loaded from '$real_inc_path' |
808 if ($old_real_inc_path) {
809 open(my $fh, '<', $old_real_inc_path)
810 or croak "Failed to open '$old_real_inc_path' for reading: $!";
811 $self->_ext_stmt($class, <<"EOF");
813 # These lines were loaded from '$old_real_inc_path',
814 # based on the Result class name that would have been created by an 0.04006
815 # version of the Loader. For a static schema, this happens only once during
816 # upgrade. See skip_load_external to disable this feature.
819 my $code = slurp $old_real_inc_path;
820 $code = $self->_rewrite_old_classnames($code);
822 if ($self->dynamic) {
825 Detected external content in '$old_real_inc_path', a class name that would have
826 been used by an 0.04006 version of the Loader.
828 * PLEASE RENAME THIS CLASS: from '$old_class' to '$class', as that is the
829 new name of the Result.
831 # kill redefined warnings
832 my $warn_handler = $SIG{__WARN__} || sub { warn @_ };
833 local $SIG{__WARN__} = sub {
835 unless $_[0] =~ /^Subroutine \S+ redefined/;
842 $self->_ext_stmt($class, $code);
843 $self->_ext_stmt($class,
844 qq|# End of lines loaded from '$old_real_inc_path' |
851 Does the actual schema-construction work.
858 $self->_load_tables($self->_tables_list);
865 Rescan the database for newly added tables. Does
866 not process drops or changes. Returns a list of
867 the newly added table monikers.
869 The schema argument should be the schema class
870 or object to be affected. It should probably
871 be derived from the original schema_class used
877 my ($self, $schema) = @_;
879 $self->{schema} = $schema;
880 $self->_relbuilder->{schema} = $schema;
883 my @current = $self->_tables_list;
884 foreach my $table ($self->_tables_list) {
885 if(!exists $self->{_tables}->{$table}) {
886 push(@created, $table);
890 my $loaded = $self->_load_tables(@created);
892 return map { $self->monikers->{$_} } @$loaded;
896 no warnings 'uninitialized';
899 return if $self->{skip_relationships};
901 if ($self->naming->{relationships} eq 'v4') {
902 require DBIx::Class::Schema::Loader::RelBuilder::Compat::v0_040;
903 return $self->{relbuilder} ||=
904 DBIx::Class::Schema::Loader::RelBuilder::Compat::v0_040->new(
905 $self->schema, $self->inflect_plural, $self->inflect_singular
909 $self->{relbuilder} ||= DBIx::Class::Schema::Loader::RelBuilder->new (
911 $self->inflect_plural,
912 $self->inflect_singular,
913 $self->relationship_attrs,
918 my ($self, @tables) = @_;
920 # First, use _tables_list with constraint and exclude
921 # to get a list of tables to operate on
923 my $constraint = $self->constraint;
924 my $exclude = $self->exclude;
926 @tables = grep { /$constraint/ } @tables if $constraint;
927 @tables = grep { ! /$exclude/ } @tables if $exclude;
929 # Save the new tables to the tables list
931 $self->{_tables}->{$_} = 1;
934 $self->_make_src_class($_) for @tables;
937 # sanity-check for moniker clashes
938 my $inverse_moniker_idx;
939 for (keys %{$self->monikers}) {
940 push @{$inverse_moniker_idx->{$self->monikers->{$_}}}, $_;
944 for (keys %$inverse_moniker_idx) {
945 my $tables = $inverse_moniker_idx->{$_};
947 push @clashes, sprintf ("tables %s reduced to the same source moniker '%s'",
948 join (', ', map { "'$_'" } @$tables),
955 die 'Unable to load schema - chosen moniker/class naming style results in moniker clashes. '
956 . 'Either change the naming style, or supply an explicit moniker_map: '
957 . join ('; ', @clashes)
963 $self->_setup_src_meta($_) for @tables;
965 if(!$self->skip_relationships) {
966 # The relationship loader needs a working schema
968 local $self->{dump_directory} = $self->{temp_directory};
969 $self->_reload_classes(\@tables);
970 $self->_load_relationships($_) for @tables;
973 # Remove that temp dir from INC so it doesn't get reloaded
974 @INC = grep $_ ne $self->dump_directory, @INC;
977 $self->_load_external($_)
978 for map { $self->classes->{$_} } @tables;
980 # Reload without unloading first to preserve any symbols from external
982 $self->_reload_classes(\@tables, 0);
984 # Drop temporary cache
985 delete $self->{_cache};
990 sub _reload_classes {
991 my ($self, $tables, $unload) = @_;
993 my @tables = @$tables;
994 $unload = 1 unless defined $unload;
996 # so that we don't repeat custom sections
997 @INC = grep $_ ne $self->dump_directory, @INC;
999 $self->_dump_to_dir(map { $self->classes->{$_} } @tables);
1001 unshift @INC, $self->dump_directory;
1004 my %have_source = map { $_ => $self->schema->source($_) }
1005 $self->schema->sources;
1007 for my $table (@tables) {
1008 my $moniker = $self->monikers->{$table};
1009 my $class = $self->classes->{$table};
1012 no warnings 'redefine';
1013 local *Class::C3::reinitialize = sub {};
1016 Class::Unload->unload($class) if $unload;
1017 my ($source, $resultset_class);
1019 ($source = $have_source{$moniker})
1020 && ($resultset_class = $source->resultset_class)
1021 && ($resultset_class ne 'DBIx::Class::ResultSet')
1023 my $has_file = Class::Inspector->loaded_filename($resultset_class);
1024 Class::Unload->unload($resultset_class) if $unload;
1025 $self->_reload_class($resultset_class) if $has_file;
1027 $self->_reload_class($class);
1029 push @to_register, [$moniker, $class];
1032 Class::C3->reinitialize;
1033 for (@to_register) {
1034 $self->schema->register_class(@$_);
1038 # We use this instead of ensure_class_loaded when there are package symbols we
1041 my ($self, $class) = @_;
1043 my $class_path = $self->_class_path($class);
1044 delete $INC{ $class_path };
1046 # kill redefined warnings
1047 my $warn_handler = $SIG{__WARN__} || sub { warn @_ };
1048 local $SIG{__WARN__} = sub {
1050 unless $_[0] =~ /^Subroutine \S+ redefined/;
1052 eval "require $class;";
1055 sub _get_dump_filename {
1056 my ($self, $class) = (@_);
1058 $class =~ s{::}{/}g;
1059 return $self->dump_directory . q{/} . $class . q{.pm};
1062 sub _ensure_dump_subdirs {
1063 my ($self, $class) = (@_);
1065 my @name_parts = split(/::/, $class);
1066 pop @name_parts; # we don't care about the very last element,
1067 # which is a filename
1069 my $dir = $self->dump_directory;
1072 mkdir($dir) or croak "mkdir('$dir') failed: $!";
1074 last if !@name_parts;
1075 $dir = File::Spec->catdir($dir, shift @name_parts);
1080 my ($self, @classes) = @_;
1082 my $schema_class = $self->schema_class;
1083 my $schema_base_class = $self->schema_base_class || 'DBIx::Class::Schema';
1085 my $target_dir = $self->dump_directory;
1086 warn "Dumping manual schema for $schema_class to directory $target_dir ...\n"
1087 unless $self->{dynamic} or $self->{quiet};
1090 qq|package $schema_class;\n\n|
1091 . qq|# Created by DBIx::Class::Schema::Loader\n|
1092 . qq|# DO NOT MODIFY THE FIRST PART OF THIS FILE\n\n|
1093 . qq|use strict;\nuse warnings;\n\n|
1094 . qq|use base '$schema_base_class';\n\n|;
1096 if ($self->use_namespaces) {
1097 $schema_text .= qq|__PACKAGE__->load_namespaces|;
1098 my $namespace_options;
1099 for my $attr (qw(result_namespace
1101 default_resultset_class)) {
1103 $namespace_options .= qq| $attr => '| . $self->$attr . qq|',\n|
1106 $schema_text .= qq|(\n$namespace_options)| if $namespace_options;
1107 $schema_text .= qq|;\n|;
1110 $schema_text .= qq|__PACKAGE__->load_classes;\n|;
1114 local $self->{version_to_dump} = $self->schema_version_to_dump;
1115 $self->_write_classfile($schema_class, $schema_text, 1);
1118 my $result_base_class = $self->result_base_class || 'DBIx::Class::Core';
1120 foreach my $src_class (@classes) {
1122 qq|package $src_class;\n\n|
1123 . qq|# Created by DBIx::Class::Schema::Loader\n|
1124 . qq|# DO NOT MODIFY THE FIRST PART OF THIS FILE\n\n|
1125 . qq|use strict;\nuse warnings;\n\n|
1126 . qq|use base '$result_base_class';\n\n|;
1128 $self->_write_classfile($src_class, $src_text);
1131 # remove Result dir if downgrading from use_namespaces, and there are no
1133 if (my $result_ns = $self->_downgrading_to_load_classes
1134 || $self->_rewriting_result_namespace) {
1135 my $result_namespace = $self->_result_namespace(
1140 (my $result_dir = $result_namespace) =~ s{::}{/}g;
1141 $result_dir = $self->dump_directory . '/' . $result_dir;
1143 unless (my @files = glob "$result_dir/*") {
1148 warn "Schema dump completed.\n" unless $self->{dynamic} or $self->{quiet};
1153 my ($self, $version, $ts) = @_;
1154 return qq|\n\n# Created by DBIx::Class::Schema::Loader|
1157 . qq|\n# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:|;
1160 sub _write_classfile {
1161 my ($self, $class, $text, $is_schema) = @_;
1163 my $filename = $self->_get_dump_filename($class);
1164 $self->_ensure_dump_subdirs($class);
1166 if (-f $filename && $self->really_erase_my_files) {
1167 warn "Deleting existing file '$filename' due to "
1168 . "'really_erase_my_files' setting\n" unless $self->{quiet};
1172 my ($custom_content, $old_md5, $old_ver, $old_ts) = $self->_get_custom_content($class, $filename);
1174 if (my $old_class = $self->_upgrading_classes->{$class}) {
1175 my $old_filename = $self->_get_dump_filename($old_class);
1177 my ($old_custom_content) = $self->_get_custom_content(
1178 $old_class, $old_filename, 0 # do not add default comment
1181 $old_custom_content =~ s/\n\n# You can replace.*\n1;\n//;
1183 if ($old_custom_content) {
1185 "\n" . $old_custom_content . "\n" . $custom_content;
1188 unlink $old_filename;
1191 $custom_content = $self->_rewrite_old_classnames($custom_content);
1194 for @{$self->{_dump_storage}->{$class} || []};
1196 # Check and see if the dump is infact differnt
1200 $compare_to = $text . $self->_sig_comment($old_ver, $old_ts);
1203 if (Digest::MD5::md5_base64($compare_to) eq $old_md5) {
1204 return unless $self->_upgrading_from && $is_schema;
1208 $text .= $self->_sig_comment(
1209 $self->version_to_dump,
1210 POSIX::strftime('%Y-%m-%d %H:%M:%S', localtime)
1213 open(my $fh, '>', $filename)
1214 or croak "Cannot open '$filename' for writing: $!";
1216 # Write the top half and its MD5 sum
1217 print $fh $text . Digest::MD5::md5_base64($text) . "\n";
1219 # Write out anything loaded via external partial class file in @INC
1221 for @{$self->{_ext_storage}->{$class} || []};
1223 # Write out any custom content the user has added
1224 print $fh $custom_content;
1227 or croak "Error closing '$filename': $!";
1230 sub _default_custom_content {
1231 return qq|\n\n# You can replace this text with custom|
1232 . qq| content, and it will be preserved on regeneration|
1236 sub _get_custom_content {
1237 my ($self, $class, $filename, $add_default) = @_;
1239 $add_default = 1 unless defined $add_default;
1241 return ($self->_default_custom_content) if ! -f $filename;
1243 open(my $fh, '<', $filename)
1244 or croak "Cannot open '$filename' for reading: $!";
1247 qr{^(# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:)([A-Za-z0-9/+]{22})\n};
1250 my ($md5, $ts, $ver);
1252 if(!$md5 && /$mark_re/) {
1256 # Pull out the previous version and timestamp
1257 ($ver, $ts) = $buffer =~ m/# Created by DBIx::Class::Schema::Loader v(.*?) @ (.*?)$/s;
1260 croak "Checksum mismatch in '$filename', the auto-generated part of the file has been modified outside of this loader. Aborting.\nIf you want to overwrite these modifications, set the 'overwrite_modifications' loader option.\n"
1261 if !$self->overwrite_modifications && Digest::MD5::md5_base64($buffer) ne $md5;
1270 croak "Cannot not overwrite '$filename' without 'really_erase_my_files',"
1271 . " it does not appear to have been generated by Loader"
1274 # Default custom content:
1275 $buffer ||= $self->_default_custom_content if $add_default;
1277 return ($buffer, $md5, $ver, $ts);
1285 warn "$target: use $_;" if $self->debug;
1286 $self->_raw_stmt($target, "use $_;");
1293 my $schema_class = $self->schema_class;
1295 my $blist = join(q{ }, @_);
1296 warn "$target: use base qw/ $blist /;" if $self->debug && @_;
1297 $self->_raw_stmt($target, "use base qw/ $blist /;") if @_;
1300 sub _result_namespace {
1301 my ($self, $schema_class, $ns) = @_;
1302 my @result_namespace;
1304 if ($ns =~ /^\+(.*)/) {
1305 # Fully qualified namespace
1306 @result_namespace = ($1)
1309 # Relative namespace
1310 @result_namespace = ($schema_class, $ns);
1313 return wantarray ? @result_namespace : join '::', @result_namespace;
1316 # Create class with applicable bases, setup monikers, etc
1317 sub _make_src_class {
1318 my ($self, $table) = @_;
1320 my $schema = $self->schema;
1321 my $schema_class = $self->schema_class;
1323 my $table_moniker = $self->_table2moniker($table);
1324 my @result_namespace = ($schema_class);
1325 if ($self->use_namespaces) {
1326 my $result_namespace = $self->result_namespace || 'Result';
1327 @result_namespace = $self->_result_namespace(
1332 my $table_class = join(q{::}, @result_namespace, $table_moniker);
1334 if ((my $upgrading_v = $self->_upgrading_from)
1335 || $self->_rewriting) {
1336 local $self->naming->{monikers} = $upgrading_v
1339 my @result_namespace = @result_namespace;
1340 if ($self->_upgrading_from_load_classes) {
1341 @result_namespace = ($schema_class);
1343 elsif (my $ns = $self->_downgrading_to_load_classes) {
1344 @result_namespace = $self->_result_namespace(
1349 elsif ($ns = $self->_rewriting_result_namespace) {
1350 @result_namespace = $self->_result_namespace(
1356 my $old_class = join(q{::}, @result_namespace,
1357 $self->_table2moniker($table));
1359 $self->_upgrading_classes->{$table_class} = $old_class
1360 unless $table_class eq $old_class;
1363 my $table_normalized = lc $table;
1364 $self->classes->{$table} = $table_class;
1365 $self->classes->{$table_normalized} = $table_class;
1366 $self->monikers->{$table} = $table_moniker;
1367 $self->monikers->{$table_normalized} = $table_moniker;
1369 $self->_use ($table_class, @{$self->additional_classes});
1370 $self->_inject($table_class, @{$self->left_base_classes});
1372 if (my @components = @{ $self->components }) {
1373 $self->_dbic_stmt($table_class, 'load_components', @components);
1376 $self->_dbic_stmt($table_class, 'load_resultset_components', @{$self->resultset_components})
1377 if @{$self->resultset_components};
1378 $self->_inject($table_class, @{$self->additional_base_classes});
1381 # Set up metadata (cols, pks, etc)
1382 sub _setup_src_meta {
1383 my ($self, $table) = @_;
1385 my $schema = $self->schema;
1386 my $schema_class = $self->schema_class;
1388 my $table_class = $self->classes->{$table};
1389 my $table_moniker = $self->monikers->{$table};
1391 my $table_name = $table;
1392 my $name_sep = $self->schema->storage->sql_maker->name_sep;
1394 if ($name_sep && $table_name =~ /\Q$name_sep\E/) {
1395 $table_name = \ $self->_quote_table_name($table_name);
1398 $self->_dbic_stmt($table_class,'table',$table_name);
1400 my $cols = $self->_table_columns($table);
1401 my $col_info = $self->__columns_info_for($table);
1402 if ($self->_is_case_sensitive) {
1403 for my $col (keys %$col_info) {
1404 $col_info->{$col}{accessor} = lc $col
1405 if $col ne lc($col);
1408 $col_info = { map { lc($_), $col_info->{$_} } keys %$col_info };
1411 my $fks = $self->_table_fk_info($table);
1413 for my $fkdef (@$fks) {
1414 for my $col (@{ $fkdef->{local_columns} }) {
1415 $col_info->{$col}{is_foreign_key} = 1;
1421 map { $_, ($col_info->{$_}||{}) } @$cols
1424 my %uniq_tag; # used to eliminate duplicate uniqs
1426 my $pks = $self->_table_pk_info($table) || [];
1427 @$pks ? $self->_dbic_stmt($table_class,'set_primary_key',@$pks)
1428 : carp("$table has no primary key");
1429 $uniq_tag{ join("\0", @$pks) }++ if @$pks; # pk is a uniq
1431 my $uniqs = $self->_table_uniq_info($table) || [];
1433 my ($name, $cols) = @$_;
1434 next if $uniq_tag{ join("\0", @$cols) }++; # skip duplicates
1435 $self->_dbic_stmt($table_class,'add_unique_constraint', $name, $cols);
1440 sub __columns_info_for {
1441 my ($self, $table) = @_;
1443 my $result = $self->_columns_info_for($table);
1445 while (my ($col, $info) = each %$result) {
1446 $info = { %$info, %{ $self->_custom_column_info ($table, $col, $info) } };
1447 $info = { %$info, %{ $self->_datetime_column_info($table, $col, $info) } };
1449 $result->{$col} = $info;
1457 Returns a sorted list of loaded tables, using the original database table
1465 return keys %{$self->_tables};
1468 # Make a moniker from a table
1469 sub _default_table2moniker {
1470 no warnings 'uninitialized';
1471 my ($self, $table) = @_;
1473 if ($self->naming->{monikers} eq 'v4') {
1474 return join '', map ucfirst, split /[\W_]+/, lc $table;
1477 return join '', map ucfirst, split /[\W_]+/,
1478 Lingua::EN::Inflect::Number::to_S(lc $table);
1481 sub _table2moniker {
1482 my ( $self, $table ) = @_;
1486 if( ref $self->moniker_map eq 'HASH' ) {
1487 $moniker = $self->moniker_map->{$table};
1489 elsif( ref $self->moniker_map eq 'CODE' ) {
1490 $moniker = $self->moniker_map->($table);
1493 $moniker ||= $self->_default_table2moniker($table);
1498 sub _load_relationships {
1499 my ($self, $table) = @_;
1501 my $tbl_fk_info = $self->_table_fk_info($table);
1502 foreach my $fkdef (@$tbl_fk_info) {
1503 $fkdef->{remote_source} =
1504 $self->monikers->{delete $fkdef->{remote_table}};
1506 my $tbl_uniq_info = $self->_table_uniq_info($table);
1508 my $local_moniker = $self->monikers->{$table};
1509 my $rel_stmts = $self->_relbuilder->generate_code($local_moniker, $tbl_fk_info, $tbl_uniq_info);
1511 foreach my $src_class (sort keys %$rel_stmts) {
1512 my $src_stmts = $rel_stmts->{$src_class};
1513 foreach my $stmt (@$src_stmts) {
1514 $self->_dbic_stmt($src_class,$stmt->{method},@{$stmt->{args}});
1519 # Overload these in driver class:
1521 # Returns an arrayref of column names
1522 sub _table_columns { croak "ABSTRACT METHOD" }
1524 # Returns arrayref of pk col names
1525 sub _table_pk_info { croak "ABSTRACT METHOD" }
1527 # Returns an arrayref of uniqs [ [ foo => [ col1, col2 ] ], [ bar => [ ... ] ] ]
1528 sub _table_uniq_info { croak "ABSTRACT METHOD" }
1530 # Returns an arrayref of foreign key constraints, each
1531 # being a hashref with 3 keys:
1532 # local_columns (arrayref), remote_columns (arrayref), remote_table
1533 sub _table_fk_info { croak "ABSTRACT METHOD" }
1535 # Returns an array of lower case table names
1536 sub _tables_list { croak "ABSTRACT METHOD" }
1538 # Execute a constructive DBIC class method, with debug/dump_to_dir hooks.
1544 # generate the pod for this statement, storing it with $self->_pod
1545 $self->_make_pod( $class, $method, @_ ) if $self->generate_pod;
1547 my $args = dump(@_);
1548 $args = '(' . $args . ')' if @_ < 2;
1549 my $stmt = $method . $args . q{;};
1551 warn qq|$class\->$stmt\n| if $self->debug;
1552 $self->_raw_stmt($class, '__PACKAGE__->' . $stmt);
1556 # generates the accompanying pod for a DBIC class method statement,
1557 # storing it with $self->_pod
1563 if ( $method eq 'table' ) {
1565 my $pcm = $self->pod_comment_mode;
1566 my ($comment, $comment_overflows, $comment_in_name, $comment_in_desc);
1567 if ( $self->can('_table_comment') ) {
1568 $comment = $self->_table_comment($table);
1569 $comment_overflows = ($comment and length $comment > $self->pod_comment_spillover_length);
1570 $comment_in_name = ($pcm eq 'name' or ($pcm eq 'auto' and !$comment_overflows));
1571 $comment_in_desc = ($pcm eq 'description' or ($pcm eq 'auto' and $comment_overflows));
1573 $self->_pod( $class, "=head1 NAME" );
1574 my $table_descr = $class;
1575 $table_descr .= " - " . $comment if $comment and $comment_in_name;
1576 $self->{_class2table}{ $class } = $table;
1577 $self->_pod( $class, $table_descr );
1578 if ($comment and $comment_in_desc) {
1579 $self->_pod( $class, "=head1 DESCRIPTION" );
1580 $self->_pod( $class, $comment );
1582 $self->_pod_cut( $class );
1583 } elsif ( $method eq 'add_columns' ) {
1584 $self->_pod( $class, "=head1 ACCESSORS" );
1585 my $col_counter = 0;
1587 while( my ($name,$attrs) = splice @cols,0,2 ) {
1589 $self->_pod( $class, '=head2 ' . $name );
1590 $self->_pod( $class,
1592 my $s = $attrs->{$_};
1593 $s = !defined $s ? 'undef' :
1594 length($s) == 0 ? '(empty string)' :
1595 ref($s) eq 'SCALAR' ? $$s :
1602 looks_like_number($s) ? $s :
1607 } sort keys %$attrs,
1610 if( $self->can('_column_comment')
1611 and my $comment = $self->_column_comment( $self->{_class2table}{$class}, $col_counter)
1613 $self->_pod( $class, $comment );
1616 $self->_pod_cut( $class );
1617 } elsif ( $method =~ /^(belongs_to|has_many|might_have)$/ ) {
1618 $self->_pod( $class, "=head1 RELATIONS" ) unless $self->{_relations_started} { $class } ;
1619 my ( $accessor, $rel_class ) = @_;
1620 $self->_pod( $class, "=head2 $accessor" );
1621 $self->_pod( $class, 'Type: ' . $method );
1622 $self->_pod( $class, "Related object: L<$rel_class>" );
1623 $self->_pod_cut( $class );
1624 $self->{_relations_started} { $class } = 1;
1628 # Stores a POD documentation
1630 my ($self, $class, $stmt) = @_;
1631 $self->_raw_stmt( $class, "\n" . $stmt );
1635 my ($self, $class ) = @_;
1636 $self->_raw_stmt( $class, "\n=cut\n" );
1639 # Store a raw source line for a class (for dumping purposes)
1641 my ($self, $class, $stmt) = @_;
1642 push(@{$self->{_dump_storage}->{$class}}, $stmt);
1645 # Like above, but separately for the externally loaded stuff
1647 my ($self, $class, $stmt) = @_;
1648 push(@{$self->{_ext_storage}->{$class}}, $stmt);
1651 sub _quote_table_name {
1652 my ($self, $table) = @_;
1654 my $qt = $self->schema->storage->sql_maker->quote_char;
1656 return $table unless $qt;
1659 return $qt->[0] . $table . $qt->[1];
1662 return $qt . $table . $qt;
1665 sub _is_case_sensitive { 0 }
1667 sub _custom_column_info {
1668 my ( $self, $table_name, $column_name, $column_info ) = @_;
1670 if (my $code = $self->custom_column_info) {
1671 return $code->($table_name, $column_name, $column_info) || {};
1676 sub _datetime_column_info {
1677 my ( $self, $table_name, $column_name, $column_info ) = @_;
1679 my $type = $column_info->{data_type} || '';
1680 if ((grep $_, @{ $column_info }{map "inflate_$_", qw/date datetime timestamp/})
1681 or ($type =~ /date|timestamp/i)) {
1682 $result->{timezone} = $self->datetime_timezone if $self->datetime_timezone;
1683 $result->{locale} = $self->datetime_locale if $self->datetime_locale;
1688 # remove the dump dir from @INC on destruction
1692 @INC = grep $_ ne $self->dump_directory, @INC;
1697 Returns a hashref of loaded table to moniker mappings. There will
1698 be two entries for each table, the original name and the "normalized"
1699 name, in the case that the two are different (such as databases
1700 that like uppercase table names, or preserve your original mixed-case
1701 definitions, or what-have-you).
1705 Returns a hashref of table to class mappings. In some cases it will
1706 contain multiple entries per table for the original and normalized table
1707 names, as above in L</monikers>.
1711 L<DBIx::Class::Schema::Loader>
1715 See L<DBIx::Class::Schema::Loader/AUTHOR> and L<DBIx::Class::Schema::Loader/CONTRIBUTORS>.
1719 This library is free software; you can redistribute it and/or modify it under
1720 the same terms as Perl itself.