1 package DBIx::Class::Schema::Loader::Base;
5 use base qw/Class::Accessor::Grouped Class::C3::Componentised/;
7 use Carp::Clan qw/^DBIx::Class/;
8 use DBIx::Class::Schema::Loader::RelBuilder;
9 use Data::Dump qw/ dump /;
14 use Lingua::EN::Inflect::Number qw//;
15 use Lingua::EN::Inflect::Phrase qw//;
18 use Class::Inspector ();
19 use Scalar::Util 'looks_like_number';
20 use File::Slurp 'read_file';
21 use DBIx::Class::Schema::Loader::Utils qw/split_name dumper_squashed eval_package_without_redefine_warnings class_path/;
22 use DBIx::Class::Schema::Loader::Optional::Dependencies ();
25 use Encode qw/encode/;
28 our $VERSION = '0.07010';
30 __PACKAGE__->mk_group_ro_accessors('simple', qw/
37 additional_base_classes
52 default_resultset_class
57 overwrite_modifications
78 __PACKAGE__->mk_group_accessors('simple', qw/
80 schema_version_to_dump
82 _upgrading_from_load_classes
83 _downgrading_to_load_classes
84 _rewriting_result_namespace
89 pod_comment_spillover_length
96 datetime_undef_if_invalid
103 DBIx::Class::Schema::Loader::Base - Base DBIx::Class::Schema::Loader Implementation.
107 See L<DBIx::Class::Schema::Loader>
111 This is the base class for the storage-specific C<DBIx::Class::Schema::*>
112 classes, and implements the common functionality between them.
114 =head1 CONSTRUCTOR OPTIONS
116 These constructor options are the base options for
117 L<DBIx::Class::Schema::Loader/loader_options>. Available constructor options are:
119 =head2 skip_relationships
121 Skip setting up relationships. The default is to attempt the loading
124 =head2 skip_load_external
126 Skip loading of other classes in @INC. The default is to merge all other classes
127 with the same name found in @INC into the schema file we are creating.
131 Static schemas (ones dumped to disk) will, by default, use the new-style
132 relationship names and singularized Results, unless you're overwriting an
133 existing dump made by an older version of L<DBIx::Class::Schema::Loader>, in
134 which case the backward compatible RelBuilder will be activated, and the
135 appropriate monikerization used.
141 will disable the backward-compatible RelBuilder and use
142 the new-style relationship names along with singularized Results, even when
143 overwriting a dump made with an earlier version.
145 The option also takes a hashref:
147 naming => { relationships => 'v7', monikers => 'v7' }
155 How to name relationship accessors.
159 How to name Result classes.
161 =item column_accessors
163 How to name column accessors in Result classes.
173 Latest style, whatever that happens to be.
177 Unsingularlized monikers, C<has_many> only relationships with no _id stripping.
181 Monikers singularized as whole words, C<might_have> relationships for FKs on
182 C<UNIQUE> constraints, C<_id> stripping for belongs_to relationships.
184 Some of the C<_id> stripping edge cases in C<0.05003> have been reverted for
189 All monikers and relationships are inflected using
190 L<Lingua::EN::Inflect::Phrase>, and there is more aggressive C<_id> stripping
191 from relationship names.
193 In general, there is very little difference between v5 and v6 schemas.
197 This mode is identical to C<v6> mode, except that monikerization of CamelCase
198 table names is also done correctly.
200 CamelCase column names in case-preserving mode will also be handled correctly
201 for relationship name inflection. See L</preserve_case>.
203 In this mode, CamelCase L</column_accessors> are normalized based on case
204 transition instead of just being lowercased, so C<FooId> becomes C<foo_id>.
206 If you don't have any CamelCase table or column names, you can upgrade without
207 breaking any of your code.
211 For L</monikers>, this option does not inflect the table names but makes
212 monikers based on the actual name. For L</column_accessors> this option does
213 not normalize CamelCase column names to lowercase column accessors, but makes
214 accessors that are the same names as the columns (with any non-\w chars
215 replaced with underscores.)
219 For L</monikers>, singularizes the names using the most current inflector. This
220 is the same as setting the option to L</current>.
224 For L</monikers>, pluralizes the names, using the most current inflector.
228 Dynamic schemas will always default to the 0.04XXX relationship names and won't
229 singularize Results for backward compatibility, to activate the new RelBuilder
230 and singularization put this in your C<Schema.pm> file:
232 __PACKAGE__->naming('current');
234 Or if you prefer to use 0.07XXX features but insure that nothing breaks in the
235 next major version upgrade:
237 __PACKAGE__->naming('v7');
241 By default POD will be generated for columns and relationships, using database
242 metadata for the text if available and supported.
244 Reading database metadata (e.g. C<COMMENT ON TABLE some_table ...>) is only
245 supported for Postgres right now.
247 Set this to C<0> to turn off all POD generation.
249 =head2 pod_comment_mode
251 Controls where table comments appear in the generated POD. Smaller table
252 comments are appended to the C<NAME> section of the documentation, and larger
253 ones are inserted into C<DESCRIPTION> instead. You can force a C<DESCRIPTION>
254 section to be generated with the comment always, only use C<NAME>, or choose
255 the length threshold at which the comment is forced into the description.
261 Use C<NAME> section only.
265 Force C<DESCRIPTION> always.
269 Use C<DESCRIPTION> if length > L</pod_comment_spillover_length>, this is the
274 =head2 pod_comment_spillover_length
276 When pod_comment_mode is set to C<auto>, this is the length of the comment at
277 which it will be forced into a separate description section.
281 =head2 relationship_attrs
283 Hashref of attributes to pass to each generated relationship, listed
284 by type. Also supports relationship type 'all', containing options to
285 pass to all generated relationships. Attributes set for more specific
286 relationship types override those set in 'all'.
290 relationship_attrs => {
291 belongs_to => { is_deferrable => 0 },
294 use this to turn off DEFERRABLE on your foreign key constraints.
298 If set to true, each constructive L<DBIx::Class> statement the loader
299 decides to execute will be C<warn>-ed before execution.
303 Set the name of the schema to load (schema in the sense that your database
304 vendor means it). Does not currently support loading more than one schema
309 Only load tables matching regex. Best specified as a qr// regex.
313 Exclude tables matching regex. Best specified as a qr// regex.
317 Overrides the default table name to moniker translation. Can be either
318 a hashref of table keys and moniker values, or a coderef for a translator
319 function taking a single scalar table name argument and returning
320 a scalar moniker. If the hash entry does not exist, or the function
321 returns a false value, the code falls back to default behavior
324 The default behavior is to split on case transition and non-alphanumeric
325 boundaries, singularize the resulting phrase, then join the titlecased words
328 Table Name | Moniker Name
329 ---------------------------------
331 luser_group | LuserGroup
332 luser-opts | LuserOpt
333 stations_visited | StationVisited
334 routeChange | RouteChange
336 =head2 col_accessor_map
338 Same as moniker_map, but for column accessor names. If a coderef is
339 passed, the code is called with arguments of
341 the name of the column in the underlying database,
342 default accessor name that DBICSL would ordinarily give this column,
344 table_class => name of the DBIC class we are building,
345 table_moniker => calculated moniker for this table (after moniker_map if present),
346 table_name => name of the database table,
347 full_table_name => schema-qualified name of the database table (RDBMS specific),
348 schema_class => name of the schema class we are building,
349 column_info => hashref of column info (data_type, is_nullable, etc),
352 =head2 inflect_plural
354 Just like L</moniker_map> above (can be hash/code-ref, falls back to default
355 if hash key does not exist or coderef returns false), but acts as a map
356 for pluralizing relationship names. The default behavior is to utilize
357 L<Lingua::EN::Inflect::Phrase/to_PL>.
359 =head2 inflect_singular
361 As L</inflect_plural> above, but for singularizing relationship names.
362 Default behavior is to utilize L<Lingua::EN::Inflect::Phrase/to_S>.
364 =head2 schema_base_class
366 Base class for your schema classes. Defaults to 'DBIx::Class::Schema'.
368 =head2 result_base_class
370 Base class for your table classes (aka result classes). Defaults to
373 =head2 additional_base_classes
375 List of additional base classes all of your table classes will use.
377 =head2 left_base_classes
379 List of additional base classes all of your table classes will use
380 that need to be leftmost.
382 =head2 additional_classes
384 List of additional classes which all of your table classes will use.
388 List of additional components to be loaded into all of your table
389 classes. A good example would be
390 L<InflateColumn::DateTime|DBIx::Class::InflateColumn::DateTime>
392 =head2 result_components_map
394 A hashref of moniker keys and component values. Unlike L</components>, which
395 loads the given components into every Result class, this option allows you to
396 load certain components for specified Result classes. For example:
398 result_components_map => {
399 StationVisited => '+YourApp::Schema::Component::StationVisited',
401 '+YourApp::Schema::Component::RouteChange',
402 'InflateColumn::DateTime',
406 You may use this in conjunction with L</components>.
410 List of L<Moose> roles to be applied to all of your Result classes.
412 =head2 result_roles_map
414 A hashref of moniker keys and role values. Unlike L</result_roles>, which
415 applies the given roles to every Result class, this option allows you to apply
416 certain roles for specified Result classes. For example:
418 result_roles_map => {
420 'YourApp::Role::Building',
421 'YourApp::Role::Destination',
423 RouteChange => 'YourApp::Role::TripEvent',
426 You may use this in conjunction with L</result_roles>.
428 =head2 use_namespaces
430 This is now the default, to go back to L<DBIx::Class::Schema/load_classes> pass
433 Generate result class names suitable for
434 L<DBIx::Class::Schema/load_namespaces> and call that instead of
435 L<DBIx::Class::Schema/load_classes>. When using this option you can also
436 specify any of the options for C<load_namespaces> (i.e. C<result_namespace>,
437 C<resultset_namespace>, C<default_resultset_class>), and they will be added
438 to the call (and the generated result class names adjusted appropriately).
440 =head2 dump_directory
442 The value of this option is a perl libdir pathname. Within
443 that directory this module will create a baseline manual
444 L<DBIx::Class::Schema> module set, based on what it creates at runtime.
446 The created schema class will have the same classname as the one on
447 which you are setting this option (and the ResultSource classes will be
448 based on this name as well).
450 Normally you wouldn't hard-code this setting in your schema class, as it
451 is meant for one-time manual usage.
453 See L<DBIx::Class::Schema::Loader/dump_to_dir> for examples of the
454 recommended way to access this functionality.
456 =head2 dump_overwrite
458 Deprecated. See L</really_erase_my_files> below, which does *not* mean
459 the same thing as the old C<dump_overwrite> setting from previous releases.
461 =head2 really_erase_my_files
463 Default false. If true, Loader will unconditionally delete any existing
464 files before creating the new ones from scratch when dumping a schema to disk.
466 The default behavior is instead to only replace the top portion of the
467 file, up to and including the final stanza which contains
468 C<# DO NOT MODIFY THE FIRST PART OF THIS FILE>
469 leaving any customizations you placed after that as they were.
471 When C<really_erase_my_files> is not set, if the output file already exists,
472 but the aforementioned final stanza is not found, or the checksum
473 contained there does not match the generated contents, Loader will
474 croak and not touch the file.
476 You should really be using version control on your schema classes (and all
477 of the rest of your code for that matter). Don't blame me if a bug in this
478 code wipes something out when it shouldn't have, you've been warned.
480 =head2 overwrite_modifications
482 Default false. If false, when updating existing files, Loader will
483 refuse to modify any Loader-generated code that has been modified
484 since its last run (as determined by the checksum Loader put in its
487 If true, Loader will discard any manual modifications that have been
488 made to Loader-generated code.
490 Again, you should be using version control on your schema classes. Be
491 careful with this option.
493 =head2 custom_column_info
495 Hook for adding extra attributes to the
496 L<column_info|DBIx::Class::ResultSource/column_info> for a column.
498 Must be a coderef that returns a hashref with the extra attributes.
500 Receives the table name, column name and column_info.
504 custom_column_info => sub {
505 my ($table_name, $column_name, $column_info) = @_;
507 if ($column_name eq 'dog' && $column_info->{default_value} eq 'snoopy') {
508 return { is_snoopy => 1 };
512 This attribute can also be used to set C<inflate_datetime> on a non-datetime
513 column so it also receives the L</datetime_timezone> and/or L</datetime_locale>.
515 =head2 datetime_timezone
517 Sets the timezone attribute for L<DBIx::Class::InflateColumn::DateTime> for all
518 columns with the DATE/DATETIME/TIMESTAMP data_types.
520 =head2 datetime_locale
522 Sets the locale attribute for L<DBIx::Class::InflateColumn::DateTime> for all
523 columns with the DATE/DATETIME/TIMESTAMP data_types.
525 =head2 datetime_undef_if_invalid
527 Pass a C<0> for this option when using MySQL if you B<DON'T> want C<<
528 datetime_undef_if_invalid => 1 >> in your column info for DATE, DATETIME and
531 The default is recommended to deal with data such as C<00/00/00> which
532 sometimes ends up in such columns in MySQL.
536 File in Perl format, which should return a HASH reference, from which to read
541 Usually column names are lowercased, to make them easier to work with in
542 L<DBIx::Class>. This option lets you turn this behavior off, if the driver
545 Drivers for case sensitive databases like Sybase ASE or MSSQL with a
546 case-sensitive collation will turn this option on unconditionally.
548 Currently the drivers for SQLite, mysql, MSSQL and Firebird/InterBase support
551 =head2 qualify_objects
553 Set to true to prepend the L</db_schema> to table names for C<<
554 __PACKAGE__->table >> calls, and to some other things like Oracle sequences.
558 Creates Schema and Result classes that use L<Moose>, L<MooseX::NonMoose> and
559 L<namespace::autoclean>. The default content after the md5 sum also makes the
562 It is safe to upgrade your existing Schema to this option.
564 =head2 col_collision_map
566 This option controls how accessors for column names which collide with perl
567 methods are named. See L</COLUMN ACCESSOR COLLISIONS> for more information.
569 This option takes either a single L<sprintf|perlfunc/sprintf> format or a hashref of
570 strings which are compiled to regular expressions that map to
571 L<sprintf|perlfunc/sprintf> formats.
575 col_collision_map => 'column_%s'
577 col_collision_map => { '(.*)' => 'column_%s' }
579 col_collision_map => { '(foo).*(bar)' => 'column_%s_%s' }
581 =head2 rel_collision_map
583 Works just like L</col_collision_map>, but for relationship names/accessors
584 rather than column names/accessors.
586 The default is to just append C<_rel> to the relationship name, see
587 L</RELATIONSHIP NAME COLLISIONS>.
591 None of these methods are intended for direct invocation by regular
592 users of L<DBIx::Class::Schema::Loader>. Some are proxied via
593 L<DBIx::Class::Schema::Loader>.
597 my $CURRENT_V = 'v7';
600 schema_base_class result_base_class additional_base_classes
601 left_base_classes additional_classes components result_roles
604 # ensure that a peice of object data is a valid arrayref, creating
605 # an empty one or encapsulating whatever's there.
606 sub _ensure_arrayref {
611 $self->{$_} = [ $self->{$_} ]
612 unless ref $self->{$_} eq 'ARRAY';
618 Constructor for L<DBIx::Class::Schema::Loader::Base>, used internally
619 by L<DBIx::Class::Schema::Loader>.
624 my ( $class, %args ) = @_;
626 if (exists $args{column_accessor_map}) {
627 $args{col_accessor_map} = delete $args{column_accessor_map};
630 my $self = { %args };
632 # don't lose undef options
633 for (values %$self) {
634 $_ = 0 unless defined $_;
637 bless $self => $class;
639 if (my $config_file = $self->config_file) {
640 my $config_opts = do $config_file;
642 croak "Error reading config from $config_file: $@" if $@;
644 croak "Config file $config_file must be a hashref" unless ref($config_opts) eq 'HASH';
646 while (my ($k, $v) = each %$config_opts) {
647 $self->{$k} = $v unless exists $self->{$k};
651 $self->result_components_map($self->{result_component_map})
652 if defined $self->{result_component_map};
654 $self->result_roles_map($self->{result_role_map})
655 if defined $self->{result_role_map};
657 croak "the result_roles and result_roles_map options may only be used in conjunction with use_moose=1"
658 if ((not defined $self->use_moose) || (not $self->use_moose))
659 && ((defined $self->result_roles) || (defined $self->result_roles_map));
661 $self->_ensure_arrayref(qw/additional_classes
662 additional_base_classes
668 $self->_validate_class_args;
670 croak "result_components_map must be a hash"
671 if defined $self->result_components_map
672 && ref $self->result_components_map ne 'HASH';
674 if ($self->result_components_map) {
675 my %rc_map = %{ $self->result_components_map };
676 foreach my $moniker (keys %rc_map) {
677 $rc_map{$moniker} = [ $rc_map{$moniker} ] unless ref $rc_map{$moniker};
679 $self->result_components_map(\%rc_map);
682 $self->result_components_map({});
684 $self->_validate_result_components_map;
686 croak "result_roles_map must be a hash"
687 if defined $self->result_roles_map
688 && ref $self->result_roles_map ne 'HASH';
690 if ($self->result_roles_map) {
691 my %rr_map = %{ $self->result_roles_map };
692 foreach my $moniker (keys %rr_map) {
693 $rr_map{$moniker} = [ $rr_map{$moniker} ] unless ref $rr_map{$moniker};
695 $self->result_roles_map(\%rr_map);
697 $self->result_roles_map({});
699 $self->_validate_result_roles_map;
701 if ($self->use_moose) {
702 if (not DBIx::Class::Schema::Loader::Optional::Dependencies->req_ok_for('use_moose')) {
703 die sprintf "You must install the following CPAN modules to enable the use_moose option: %s.\n",
704 DBIx::Class::Schema::Loader::Optional::Dependencies->req_missing_for('use_moose');
708 $self->{monikers} = {};
709 $self->{tables} = {};
710 $self->{class_to_table} = {};
711 $self->{classes} = {};
712 $self->{_upgrading_classes} = {};
714 $self->{schema_class} ||= ( ref $self->{schema} || $self->{schema} );
715 $self->{schema} ||= $self->{schema_class};
717 croak "dump_overwrite is deprecated. Please read the"
718 . " DBIx::Class::Schema::Loader::Base documentation"
719 if $self->{dump_overwrite};
721 $self->{dynamic} = ! $self->{dump_directory};
722 $self->{temp_directory} ||= File::Temp::tempdir( 'dbicXXXX',
727 $self->{dump_directory} ||= $self->{temp_directory};
729 $self->real_dump_directory($self->{dump_directory});
731 $self->version_to_dump($DBIx::Class::Schema::Loader::VERSION);
732 $self->schema_version_to_dump($DBIx::Class::Schema::Loader::VERSION);
734 if (not defined $self->naming) {
735 $self->naming_set(0);
738 $self->naming_set(1);
741 if ((not ref $self->naming) && defined $self->naming) {
742 my $naming_ver = $self->naming;
744 relationships => $naming_ver,
745 monikers => $naming_ver,
746 column_accessors => $naming_ver,
751 for (values %{ $self->naming }) {
752 $_ = $CURRENT_V if $_ eq 'current';
755 $self->{naming} ||= {};
757 if ($self->custom_column_info && ref $self->custom_column_info ne 'CODE') {
758 croak 'custom_column_info must be a CODE ref';
761 $self->_check_back_compat;
763 $self->use_namespaces(1) unless defined $self->use_namespaces;
764 $self->generate_pod(1) unless defined $self->generate_pod;
765 $self->pod_comment_mode('auto') unless defined $self->pod_comment_mode;
766 $self->pod_comment_spillover_length(60) unless defined $self->pod_comment_spillover_length;
768 if (my $col_collision_map = $self->col_collision_map) {
769 if (my $reftype = ref $col_collision_map) {
770 if ($reftype ne 'HASH') {
771 croak "Invalid type $reftype for option 'col_collision_map'";
775 $self->col_collision_map({ '(.*)' => $col_collision_map });
782 sub _check_back_compat {
785 # dynamic schemas will always be in 0.04006 mode, unless overridden
786 if ($self->dynamic) {
787 # just in case, though no one is likely to dump a dynamic schema
788 $self->schema_version_to_dump('0.04006');
790 if (not $self->naming_set) {
791 warn <<EOF unless $ENV{SCHEMA_LOADER_BACKCOMPAT};
793 Dynamic schema detected, will run in 0.04006 mode.
795 Set the 'naming' attribute or the SCHEMA_LOADER_BACKCOMPAT environment variable
796 to disable this warning.
798 See perldoc DBIx::Class::Schema::Loader::Manual::UpgradingFromV4 for more
803 $self->_upgrading_from('v4');
806 if ((not defined $self->use_namespaces) && ($self->naming_set)) {
807 $self->use_namespaces(1);
810 $self->naming->{relationships} ||= 'v4';
811 $self->naming->{monikers} ||= 'v4';
813 if ($self->use_namespaces) {
814 $self->_upgrading_from_load_classes(1);
817 $self->use_namespaces(0);
823 # otherwise check if we need backcompat mode for a static schema
824 my $filename = $self->get_dump_filename($self->schema_class);
825 return unless -e $filename;
827 my ($old_gen, $old_md5, $old_ver, $old_ts, $old_custom) =
828 $self->_parse_generated_file($filename);
830 return unless $old_ver;
832 # determine if the existing schema was dumped with use_moose => 1
833 if (! defined $self->use_moose) {
834 $self->{use_moose} = 1 if $old_gen =~ /^ (?!\s*\#) use \s+ Moose/xm;
837 my $load_classes = ($old_gen =~ /^__PACKAGE__->load_classes;/m) ? 1 : 0;
839 my $result_namespace = do { ($old_gen =~ /result_namespace => (.+)/) ? $1 : '' };
840 my $ds = eval $result_namespace;
842 Could not eval expression '$result_namespace' for result_namespace from
845 $result_namespace = $ds || '';
847 if ($load_classes && (not defined $self->use_namespaces)) {
848 warn <<"EOF" unless $ENV{SCHEMA_LOADER_BACKCOMPAT};
850 'load_classes;' static schema detected, turning off 'use_namespaces'.
852 Set the 'use_namespaces' attribute or the SCHEMA_LOADER_BACKCOMPAT environment
853 variable to disable this warning.
855 See perldoc DBIx::Class::Schema::Loader::Manual::UpgradingFromV4 for more
858 $self->use_namespaces(0);
860 elsif ($load_classes && $self->use_namespaces) {
861 $self->_upgrading_from_load_classes(1);
863 elsif ((not $load_classes) && defined $self->use_namespaces && ! $self->use_namespaces) {
864 $self->_downgrading_to_load_classes(
865 $result_namespace || 'Result'
868 elsif ((not defined $self->use_namespaces) || $self->use_namespaces) {
869 if (not $self->result_namespace) {
870 $self->result_namespace($result_namespace || 'Result');
872 elsif ($result_namespace ne $self->result_namespace) {
873 $self->_rewriting_result_namespace(
874 $result_namespace || 'Result'
879 # XXX when we go past .0 this will need fixing
880 my ($v) = $old_ver =~ /([1-9])/;
883 return if ($v eq $CURRENT_V || $old_ver =~ /^0\.\d\d999/);
885 if (not %{ $self->naming }) {
886 warn <<"EOF" unless $ENV{SCHEMA_LOADER_BACKCOMPAT};
888 Version $old_ver static schema detected, turning on backcompat mode.
890 Set the 'naming' attribute or the SCHEMA_LOADER_BACKCOMPAT environment variable
891 to disable this warning.
893 See: 'naming' in perldoc DBIx::Class::Schema::Loader::Base .
895 See perldoc DBIx::Class::Schema::Loader::Manual::UpgradingFromV4 if upgrading
896 from version 0.04006.
899 $self->naming->{relationships} ||= $v;
900 $self->naming->{monikers} ||= $v;
901 $self->naming->{column_accessors} ||= $v;
903 $self->schema_version_to_dump($old_ver);
906 $self->_upgrading_from($v);
910 sub _validate_class_args {
913 foreach my $k (@CLASS_ARGS) {
914 next unless $self->$k;
916 my @classes = ref $self->$k eq 'ARRAY' ? @{ $self->$k } : $self->$k;
917 $self->_validate_classes($k, \@classes);
921 sub _validate_result_components_map {
924 foreach my $classes (values %{ $self->result_components_map }) {
925 $self->_validate_classes('result_components_map', $classes);
929 sub _validate_result_roles_map {
932 foreach my $classes (values %{ $self->result_roles_map }) {
933 $self->_validate_classes('result_roles_map', $classes);
937 sub _validate_classes {
942 # make a copy to not destroy original
943 my @classes = @$classes;
945 foreach my $c (@classes) {
946 # components default to being under the DBIx::Class namespace unless they
947 # are preceeded with a '+'
948 if ( $key =~ m/component/ && $c !~ s/^\+// ) {
949 $c = 'DBIx::Class::' . $c;
952 # 1 == installed, 0 == not installed, undef == invalid classname
953 my $installed = Class::Inspector->installed($c);
954 if ( defined($installed) ) {
955 if ( $installed == 0 ) {
956 croak qq/$c, as specified in the loader option "$key", is not installed/;
959 croak qq/$c, as specified in the loader option "$key", is an invalid class name/;
965 sub _find_file_in_inc {
966 my ($self, $file) = @_;
968 foreach my $prefix (@INC) {
969 my $fullpath = File::Spec->catfile($prefix, $file);
970 return $fullpath if -f $fullpath
971 # abs_path throws on Windows for nonexistant files
972 and (try { Cwd::abs_path($fullpath) }) ne
973 ((try { Cwd::abs_path(File::Spec->catfile($self->dump_directory, $file)) }) || '');
979 sub _find_class_in_inc {
980 my ($self, $class) = @_;
982 return $self->_find_file_in_inc(class_path($class));
988 return $self->_upgrading_from
989 || $self->_upgrading_from_load_classes
990 || $self->_downgrading_to_load_classes
991 || $self->_rewriting_result_namespace
995 sub _rewrite_old_classnames {
996 my ($self, $code) = @_;
998 return $code unless $self->_rewriting;
1000 my %old_classes = reverse %{ $self->_upgrading_classes };
1002 my $re = join '|', keys %old_classes;
1003 $re = qr/\b($re)\b/;
1005 $code =~ s/$re/$old_classes{$1} || $1/eg;
1010 sub _load_external {
1011 my ($self, $class) = @_;
1013 return if $self->{skip_load_external};
1015 # so that we don't load our own classes, under any circumstances
1016 local *INC = [ grep $_ ne $self->dump_directory, @INC ];
1018 my $real_inc_path = $self->_find_class_in_inc($class);
1020 my $old_class = $self->_upgrading_classes->{$class}
1021 if $self->_rewriting;
1023 my $old_real_inc_path = $self->_find_class_in_inc($old_class)
1024 if $old_class && $old_class ne $class;
1026 return unless $real_inc_path || $old_real_inc_path;
1028 if ($real_inc_path) {
1029 # If we make it to here, we loaded an external definition
1030 warn qq/# Loaded external class definition for '$class'\n/
1033 my $code = $self->_rewrite_old_classnames(scalar read_file($real_inc_path, binmode => ':encoding(UTF-8)'));
1035 if ($self->dynamic) { # load the class too
1036 eval_package_without_redefine_warnings($class, $code);
1039 $self->_ext_stmt($class,
1040 qq|# These lines were loaded from '$real_inc_path' found in \@INC.\n|
1041 .qq|# They are now part of the custom portion of this file\n|
1042 .qq|# for you to hand-edit. If you do not either delete\n|
1043 .qq|# this section or remove that file from \@INC, this section\n|
1044 .qq|# will be repeated redundantly when you re-create this\n|
1045 .qq|# file again via Loader! See skip_load_external to disable\n|
1046 .qq|# this feature.\n|
1049 $self->_ext_stmt($class, $code);
1050 $self->_ext_stmt($class,
1051 qq|# End of lines loaded from '$real_inc_path' |
1055 if ($old_real_inc_path) {
1056 my $code = read_file($old_real_inc_path, binmode => ':encoding(UTF-8)');
1058 $self->_ext_stmt($class, <<"EOF");
1060 # These lines were loaded from '$old_real_inc_path',
1061 # based on the Result class name that would have been created by an older
1062 # version of the Loader. For a static schema, this happens only once during
1063 # upgrade. See skip_load_external to disable this feature.
1066 $code = $self->_rewrite_old_classnames($code);
1068 if ($self->dynamic) {
1071 Detected external content in '$old_real_inc_path', a class name that would have
1072 been used by an older version of the Loader.
1074 * PLEASE RENAME THIS CLASS: from '$old_class' to '$class', as that is the
1075 new name of the Result.
1077 eval_package_without_redefine_warnings($class, $code);
1081 $self->_ext_stmt($class, $code);
1082 $self->_ext_stmt($class,
1083 qq|# End of lines loaded from '$old_real_inc_path' |
1090 Does the actual schema-construction work.
1097 $self->_load_tables(
1098 $self->_tables_list({ constraint => $self->constraint, exclude => $self->exclude })
1106 Rescan the database for changes. Returns a list of the newly added table
1109 The schema argument should be the schema class or object to be affected. It
1110 should probably be derived from the original schema_class used during L</load>.
1115 my ($self, $schema) = @_;
1117 $self->{schema} = $schema;
1118 $self->_relbuilder->{schema} = $schema;
1121 my @current = $self->_tables_list({ constraint => $self->constraint, exclude => $self->exclude });
1123 foreach my $table (@current) {
1124 if(!exists $self->{_tables}->{$table}) {
1125 push(@created, $table);
1130 @current{@current} = ();
1131 foreach my $table (keys %{ $self->{_tables} }) {
1132 if (not exists $current{$table}) {
1133 $self->_unregister_source_for_table($table);
1137 delete $self->{_dump_storage};
1138 delete $self->{_relations_started};
1140 my $loaded = $self->_load_tables(@current);
1142 return map { $self->monikers->{$_} } @created;
1148 return if $self->{skip_relationships};
1150 return $self->{relbuilder} ||= do {
1152 no warnings 'uninitialized';
1153 my $relbuilder_suff =
1159 ->{ $self->naming->{relationships}};
1161 my $relbuilder_class = 'DBIx::Class::Schema::Loader::RelBuilder'.$relbuilder_suff;
1162 $self->ensure_class_loaded($relbuilder_class);
1163 $relbuilder_class->new( $self );
1169 my ($self, @tables) = @_;
1171 # Save the new tables to the tables list
1173 $self->{_tables}->{$_} = 1;
1176 $self->_make_src_class($_) for @tables;
1178 # sanity-check for moniker clashes
1179 my $inverse_moniker_idx;
1180 for (keys %{$self->monikers}) {
1181 push @{$inverse_moniker_idx->{$self->monikers->{$_}}}, $_;
1185 for (keys %$inverse_moniker_idx) {
1186 my $tables = $inverse_moniker_idx->{$_};
1188 push @clashes, sprintf ("tables %s reduced to the same source moniker '%s'",
1189 join (', ', map { "'$_'" } @$tables),
1196 die 'Unable to load schema - chosen moniker/class naming style results in moniker clashes. '
1197 . 'Either change the naming style, or supply an explicit moniker_map: '
1198 . join ('; ', @clashes)
1204 $self->_setup_src_meta($_) for @tables;
1206 if(!$self->skip_relationships) {
1207 # The relationship loader needs a working schema
1209 local $self->{dump_directory} = $self->{temp_directory};
1210 $self->_reload_classes(\@tables);
1211 $self->_load_relationships(\@tables);
1214 # Remove that temp dir from INC so it doesn't get reloaded
1215 @INC = grep $_ ne $self->dump_directory, @INC;
1218 $self->_load_roles($_) for @tables;
1220 $self->_load_external($_)
1221 for map { $self->classes->{$_} } @tables;
1223 # Reload without unloading first to preserve any symbols from external
1225 $self->_reload_classes(\@tables, { unload => 0 });
1227 # Drop temporary cache
1228 delete $self->{_cache};
1233 sub _reload_classes {
1234 my ($self, $tables, $opts) = @_;
1236 my @tables = @$tables;
1238 my $unload = $opts->{unload};
1239 $unload = 1 unless defined $unload;
1241 # so that we don't repeat custom sections
1242 @INC = grep $_ ne $self->dump_directory, @INC;
1244 $self->_dump_to_dir(map { $self->classes->{$_} } @tables);
1246 unshift @INC, $self->dump_directory;
1249 my %have_source = map { $_ => $self->schema->source($_) }
1250 $self->schema->sources;
1252 for my $table (@tables) {
1253 my $moniker = $self->monikers->{$table};
1254 my $class = $self->classes->{$table};
1257 no warnings 'redefine';
1258 local *Class::C3::reinitialize = sub {}; # to speed things up, reinitialized below
1261 if (my $mc = $self->_moose_metaclass($class)) {
1264 Class::Unload->unload($class) if $unload;
1265 my ($source, $resultset_class);
1267 ($source = $have_source{$moniker})
1268 && ($resultset_class = $source->resultset_class)
1269 && ($resultset_class ne 'DBIx::Class::ResultSet')
1271 my $has_file = Class::Inspector->loaded_filename($resultset_class);
1272 if (my $mc = $self->_moose_metaclass($resultset_class)) {
1275 Class::Unload->unload($resultset_class) if $unload;
1276 $self->_reload_class($resultset_class) if $has_file;
1278 $self->_reload_class($class);
1280 push @to_register, [$moniker, $class];
1283 Class::C3->reinitialize;
1284 for (@to_register) {
1285 $self->schema->register_class(@$_);
1289 sub _moose_metaclass {
1290 return undef unless $INC{'Class/MOP.pm'}; # if CMOP is not loaded the class could not have loaded in the 1st place
1294 my $mc = try { Class::MOP::class_of($class) }
1297 return $mc->isa('Moose::Meta::Class') ? $mc : undef;
1300 # We use this instead of ensure_class_loaded when there are package symbols we
1303 my ($self, $class) = @_;
1305 delete $INC{ +class_path($class) };
1308 eval_package_without_redefine_warnings ($class, "require $class");
1311 my $source = read_file($self->_get_dump_filename($class), binmode => ':encoding(UTF-8)');
1312 die "Failed to reload class $class: $_.\n\nCLASS SOURCE:\n\n$source";
1316 sub _get_dump_filename {
1317 my ($self, $class) = (@_);
1319 $class =~ s{::}{/}g;
1320 return $self->dump_directory . q{/} . $class . q{.pm};
1323 =head2 get_dump_filename
1327 Returns the full path to the file for a class that the class has been or will
1328 be dumped to. This is a file in a temp dir for a dynamic schema.
1332 sub get_dump_filename {
1333 my ($self, $class) = (@_);
1335 local $self->{dump_directory} = $self->real_dump_directory;
1337 return $self->_get_dump_filename($class);
1340 sub _ensure_dump_subdirs {
1341 my ($self, $class) = (@_);
1343 my @name_parts = split(/::/, $class);
1344 pop @name_parts; # we don't care about the very last element,
1345 # which is a filename
1347 my $dir = $self->dump_directory;
1350 mkdir($dir) or croak "mkdir('$dir') failed: $!";
1352 last if !@name_parts;
1353 $dir = File::Spec->catdir($dir, shift @name_parts);
1358 my ($self, @classes) = @_;
1360 my $schema_class = $self->schema_class;
1361 my $schema_base_class = $self->schema_base_class || 'DBIx::Class::Schema';
1363 my $target_dir = $self->dump_directory;
1364 warn "Dumping manual schema for $schema_class to directory $target_dir ...\n"
1365 unless $self->{dynamic} or $self->{quiet};
1368 qq|package $schema_class;\n\n|
1369 . qq|# Created by DBIx::Class::Schema::Loader\n|
1370 . qq|# DO NOT MODIFY THE FIRST PART OF THIS FILE\n\n|;
1372 if ($self->use_moose) {
1373 $schema_text.= qq|use Moose;\nuse namespace::autoclean;\nextends '$schema_base_class';\n\n|;
1376 $schema_text .= qq|use strict;\nuse warnings;\n\nuse base '$schema_base_class';\n\n|;
1379 if ($self->use_namespaces) {
1380 $schema_text .= qq|__PACKAGE__->load_namespaces|;
1381 my $namespace_options;
1383 my @attr = qw/resultset_namespace default_resultset_class/;
1385 unshift @attr, 'result_namespace' unless (not $self->result_namespace) || $self->result_namespace eq 'Result';
1387 for my $attr (@attr) {
1389 my $code = dumper_squashed $self->$attr;
1390 $namespace_options .= qq| $attr => $code,\n|
1393 $schema_text .= qq|(\n$namespace_options)| if $namespace_options;
1394 $schema_text .= qq|;\n|;
1397 $schema_text .= qq|__PACKAGE__->load_classes;\n|;
1401 local $self->{version_to_dump} = $self->schema_version_to_dump;
1402 $self->_write_classfile($schema_class, $schema_text, 1);
1405 my $result_base_class = $self->result_base_class || 'DBIx::Class::Core';
1407 foreach my $src_class (@classes) {
1409 qq|package $src_class;\n\n|
1410 . qq|# Created by DBIx::Class::Schema::Loader\n|
1411 . qq|# DO NOT MODIFY THE FIRST PART OF THIS FILE\n\n|;
1413 $src_text .= $self->_make_pod_heading($src_class);
1415 $src_text .= qq|use strict;\nuse warnings;\n\n|;
1417 $src_text .= $self->_base_class_pod($result_base_class)
1418 unless $result_base_class eq 'DBIx::Class::Core';
1420 if ($self->use_moose) {
1421 $src_text.= qq|use Moose;\nuse MooseX::NonMoose;\nuse namespace::autoclean;|;
1423 # these options 'use base' which is compile time
1424 if (@{ $self->left_base_classes } || @{ $self->additional_base_classes }) {
1425 $src_text .= qq|\nBEGIN { extends '$result_base_class' }\n|;
1428 $src_text .= qq|\nextends '$result_base_class';\n|;
1432 $src_text .= qq|use base '$result_base_class';\n|;
1435 $self->_write_classfile($src_class, $src_text);
1438 # remove Result dir if downgrading from use_namespaces, and there are no
1440 if (my $result_ns = $self->_downgrading_to_load_classes
1441 || $self->_rewriting_result_namespace) {
1442 my $result_namespace = $self->_result_namespace(
1447 (my $result_dir = $result_namespace) =~ s{::}{/}g;
1448 $result_dir = $self->dump_directory . '/' . $result_dir;
1450 unless (my @files = glob "$result_dir/*") {
1455 warn "Schema dump completed.\n" unless $self->{dynamic} or $self->{quiet};
1460 my ($self, $version, $ts) = @_;
1461 return qq|\n\n# Created by DBIx::Class::Schema::Loader|
1464 . qq|\n# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:|;
1467 sub _write_classfile {
1468 my ($self, $class, $text, $is_schema) = @_;
1470 my $filename = $self->_get_dump_filename($class);
1471 $self->_ensure_dump_subdirs($class);
1473 if (-f $filename && $self->really_erase_my_files) {
1474 warn "Deleting existing file '$filename' due to "
1475 . "'really_erase_my_files' setting\n" unless $self->{quiet};
1479 my ($old_gen, $old_md5, $old_ver, $old_ts, $old_custom)
1480 = $self->_parse_generated_file($filename);
1482 if (! $old_gen && -f $filename) {
1483 croak "Cannot overwrite '$filename' without 'really_erase_my_files',"
1484 . " it does not appear to have been generated by Loader"
1487 my $custom_content = $old_custom || '';
1489 # prepend extra custom content from a *renamed* class (singularization effect)
1490 if (my $renamed_class = $self->_upgrading_classes->{$class}) {
1491 my $old_filename = $self->_get_dump_filename($renamed_class);
1493 if (-f $old_filename) {
1494 my $extra_custom = ($self->_parse_generated_file ($old_filename))[4];
1496 $extra_custom =~ s/\n\n# You can replace.*\n1;\n//;
1498 $custom_content = join ("\n", '', $extra_custom, $custom_content)
1501 unlink $old_filename;
1505 $custom_content ||= $self->_default_custom_content($is_schema);
1507 # If upgrading to use_moose=1 replace default custom content with default Moose custom content.
1508 # If there is already custom content, which does not have the Moose content, add it.
1509 if ($self->use_moose) {
1511 my $non_moose_custom_content = do {
1512 local $self->{use_moose} = 0;
1513 $self->_default_custom_content;
1516 if ($custom_content eq $non_moose_custom_content) {
1517 $custom_content = $self->_default_custom_content($is_schema);
1519 elsif ($custom_content !~ /\Q@{[$self->_default_moose_custom_content($is_schema)]}\E/) {
1520 $custom_content .= $self->_default_custom_content($is_schema);
1523 elsif (defined $self->use_moose && $old_gen) {
1524 croak 'It is not possible to "downgrade" a schema that was loaded with use_moose => 1 to use_moose => 0, due to differing custom content'
1525 if $old_gen =~ /use \s+ MooseX?\b/x;
1528 $custom_content = $self->_rewrite_old_classnames($custom_content);
1531 for @{$self->{_dump_storage}->{$class} || []};
1533 # Check and see if the dump is infact differnt
1537 $compare_to = $text . $self->_sig_comment($old_ver, $old_ts);
1538 if (Digest::MD5::md5_base64(encode 'UTF-8', $compare_to) eq $old_md5) {
1539 return unless $self->_upgrading_from && $is_schema;
1543 $text .= $self->_sig_comment(
1544 $self->version_to_dump,
1545 POSIX::strftime('%Y-%m-%d %H:%M:%S', localtime)
1548 open(my $fh, '>:encoding(UTF-8)', $filename)
1549 or croak "Cannot open '$filename' for writing: $!";
1551 # Write the top half and its MD5 sum
1552 print $fh $text . Digest::MD5::md5_base64(encode 'UTF-8', $text) . "\n";
1554 # Write out anything loaded via external partial class file in @INC
1556 for @{$self->{_ext_storage}->{$class} || []};
1558 # Write out any custom content the user has added
1559 print $fh $custom_content;
1562 or croak "Error closing '$filename': $!";
1565 sub _default_moose_custom_content {
1566 my ($self, $is_schema) = @_;
1568 if (not $is_schema) {
1569 return qq|\n__PACKAGE__->meta->make_immutable;|;
1572 return qq|\n__PACKAGE__->meta->make_immutable(inline_constructor => 0);|;
1575 sub _default_custom_content {
1576 my ($self, $is_schema) = @_;
1577 my $default = qq|\n\n# You can replace this text with custom|
1578 . qq| code or comments, and it will be preserved on regeneration|;
1579 if ($self->use_moose) {
1580 $default .= $self->_default_moose_custom_content($is_schema);
1582 $default .= qq|\n1;\n|;
1586 sub _parse_generated_file {
1587 my ($self, $fn) = @_;
1589 return unless -f $fn;
1591 open(my $fh, '<:encoding(UTF-8)', $fn)
1592 or croak "Cannot open '$fn' for reading: $!";
1595 qr{^(# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:)([A-Za-z0-9/+]{22})\n};
1597 my ($md5, $ts, $ver, $gen);
1603 # Pull out the version and timestamp from the line above
1604 ($ver, $ts) = $gen =~ m/^# Created by DBIx::Class::Schema::Loader v(.*?) @ (.*?)\Z/m;
1607 croak "Checksum mismatch in '$fn', 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"
1608 if !$self->overwrite_modifications && Digest::MD5::md5_base64(encode 'UTF-8', $gen) ne $md5;
1617 my $custom = do { local $/; <$fh> }
1622 return ($gen, $md5, $ver, $ts, $custom);
1630 warn "$target: use $_;" if $self->debug;
1631 $self->_raw_stmt($target, "use $_;");
1639 my $blist = join(q{ }, @_);
1641 return unless $blist;
1643 warn "$target: use base qw/$blist/;" if $self->debug;
1644 $self->_raw_stmt($target, "use base qw/$blist/;");
1651 my $rlist = join(q{, }, map { qq{'$_'} } @_);
1653 return unless $rlist;
1655 warn "$target: with $rlist;" if $self->debug;
1656 $self->_raw_stmt($target, "\nwith $rlist;");
1659 sub _result_namespace {
1660 my ($self, $schema_class, $ns) = @_;
1661 my @result_namespace;
1663 $ns = $ns->[0] if ref $ns;
1665 if ($ns =~ /^\+(.*)/) {
1666 # Fully qualified namespace
1667 @result_namespace = ($1)
1670 # Relative namespace
1671 @result_namespace = ($schema_class, $ns);
1674 return wantarray ? @result_namespace : join '::', @result_namespace;
1677 # Create class with applicable bases, setup monikers, etc
1678 sub _make_src_class {
1679 my ($self, $table) = @_;
1681 my $schema = $self->schema;
1682 my $schema_class = $self->schema_class;
1684 my $table_moniker = $self->_table2moniker($table);
1685 my @result_namespace = ($schema_class);
1686 if ($self->use_namespaces) {
1687 my $result_namespace = $self->result_namespace || 'Result';
1688 @result_namespace = $self->_result_namespace(
1693 my $table_class = join(q{::}, @result_namespace, $table_moniker);
1695 if ((my $upgrading_v = $self->_upgrading_from)
1696 || $self->_rewriting) {
1697 local $self->naming->{monikers} = $upgrading_v
1700 my @result_namespace = @result_namespace;
1701 if ($self->_upgrading_from_load_classes) {
1702 @result_namespace = ($schema_class);
1704 elsif (my $ns = $self->_downgrading_to_load_classes) {
1705 @result_namespace = $self->_result_namespace(
1710 elsif ($ns = $self->_rewriting_result_namespace) {
1711 @result_namespace = $self->_result_namespace(
1717 my $old_class = join(q{::}, @result_namespace,
1718 $self->_table2moniker($table));
1720 $self->_upgrading_classes->{$table_class} = $old_class
1721 unless $table_class eq $old_class;
1724 $self->classes->{$table} = $table_class;
1725 $self->monikers->{$table} = $table_moniker;
1726 $self->tables->{$table_moniker} = $table;
1727 $self->class_to_table->{$table_class} = $table;
1729 $self->_pod_class_list($table_class, 'ADDITIONAL CLASSES USED', @{$self->additional_classes});
1731 $self->_use ($table_class, @{$self->additional_classes});
1733 $self->_pod_class_list($table_class, 'LEFT BASE CLASSES', @{$self->left_base_classes});
1735 $self->_inject($table_class, @{$self->left_base_classes});
1737 my @components = @{ $self->components || [] };
1739 push @components, @{ $self->result_components_map->{$table_moniker} }
1740 if exists $self->result_components_map->{$table_moniker};
1742 my @fq_components = @components;
1743 foreach my $component (@fq_components) {
1744 if ($component !~ s/^\+//) {
1745 $component = "DBIx::Class::$component";
1749 $self->_pod_class_list($table_class, 'COMPONENTS LOADED', @fq_components);
1751 $self->_dbic_stmt($table_class, 'load_components', @components) if @components;
1753 $self->_pod_class_list($table_class, 'ADDITIONAL BASE CLASSES', @{$self->additional_base_classes});
1755 $self->_inject($table_class, @{$self->additional_base_classes});
1758 sub _is_result_class_method {
1759 my ($self, $name, $table_name) = @_;
1761 my $table_moniker = $table_name ? $self->monikers->{$table_name} : '';
1763 $self->_result_class_methods({})
1764 if not defined $self->_result_class_methods;
1766 if (not exists $self->_result_class_methods->{$table_moniker}) {
1767 my (@methods, %methods);
1768 my $base = $self->result_base_class || 'DBIx::Class::Core';
1770 my @components = @{ $self->components || [] };
1772 push @components, @{ $self->result_components_map->{$table_moniker} }
1773 if exists $self->result_components_map->{$table_moniker};
1775 for my $c (@components) {
1776 $c = $c =~ /^\+/ ? substr($c,1) : "DBIx::Class::$c";
1779 my @roles = @{ $self->result_roles || [] };
1781 push @roles, @{ $self->result_roles_map->{$table_moniker} }
1782 if exists $self->result_roles_map->{$table_moniker};
1784 for my $class ($base, @components,
1785 ($self->use_moose ? 'Moose::Object' : ()), @roles) {
1786 $self->ensure_class_loaded($class);
1788 push @methods, @{ Class::Inspector->methods($class) || [] };
1791 push @methods, @{ Class::Inspector->methods('UNIVERSAL') };
1793 @methods{@methods} = ();
1795 $self->_result_class_methods->{$table_moniker} = \%methods;
1797 my $result_methods = $self->_result_class_methods->{$table_moniker};
1799 return exists $result_methods->{$name};
1802 sub _resolve_col_accessor_collisions {
1803 my ($self, $table, $col_info) = @_;
1805 my $table_name = ref $table ? $$table : $table;
1807 while (my ($col, $info) = each %$col_info) {
1808 my $accessor = $info->{accessor} || $col;
1810 next if $accessor eq 'id'; # special case (very common column)
1812 if ($self->_is_result_class_method($accessor, $table_name)) {
1815 if (my $map = $self->col_collision_map) {
1816 for my $re (keys %$map) {
1817 if (my @matches = $col =~ /$re/) {
1818 $info->{accessor} = sprintf $map->{$re}, @matches;
1826 Column '$col' in table '$table_name' collides with an inherited method.
1827 See "COLUMN ACCESSOR COLLISIONS" in perldoc DBIx::Class::Schema::Loader::Base .
1829 $info->{accessor} = undef;
1835 # use the same logic to run moniker_map, col_accessor_map, and
1836 # relationship_name_map
1838 my ( $self, $map, $default_code, $ident, @extra ) = @_;
1840 my $default_ident = $default_code->( $ident, @extra );
1842 if( $map && ref $map eq 'HASH' ) {
1843 $new_ident = $map->{ $ident };
1845 elsif( $map && ref $map eq 'CODE' ) {
1846 $new_ident = $map->( $ident, $default_ident, @extra );
1849 $new_ident ||= $default_ident;
1854 sub _default_column_accessor_name {
1855 my ( $self, $column_name ) = @_;
1857 my $accessor_name = $column_name;
1858 $accessor_name =~ s/\W+/_/g;
1860 if ((($self->naming->{column_accessors}||'') =~ /(\d+)/ && $1 < 7) || (not $self->preserve_case)) {
1861 # older naming just lc'd the col accessor and that's all.
1862 return lc $accessor_name;
1864 elsif (($self->naming->{column_accessors}||'') eq 'preserve') {
1865 return $accessor_name;
1868 return join '_', map lc, split_name $column_name;
1871 sub _make_column_accessor_name {
1872 my ($self, $column_name, $column_context_info ) = @_;
1874 my $accessor = $self->_run_user_map(
1875 $self->col_accessor_map,
1876 sub { $self->_default_column_accessor_name( shift ) },
1878 $column_context_info,
1885 my ($self, $identifier) = @_;
1887 my $qt = $self->schema->storage->sql_maker->quote_char || '';
1890 return $qt->[0] . $identifier . $qt->[1];
1893 return "${qt}${identifier}${qt}";
1896 # Set up metadata (cols, pks, etc)
1897 sub _setup_src_meta {
1898 my ($self, $table) = @_;
1900 my $schema = $self->schema;
1901 my $schema_class = $self->schema_class;
1903 my $table_class = $self->classes->{$table};
1904 my $table_moniker = $self->monikers->{$table};
1906 my $table_name = $table;
1908 my $sql_maker = $self->schema->storage->sql_maker;
1909 my $name_sep = $sql_maker->name_sep;
1911 if ($name_sep && $table_name =~ /\Q$name_sep\E/) {
1912 $table_name = \ $self->_quote($table_name);
1915 my $full_table_name = ($self->qualify_objects ?
1916 ($self->_quote($self->db_schema) . '.') : '')
1917 . (ref $table_name ? $$table_name : $table_name);
1919 # be careful to not create refs Data::Dump can "optimize"
1920 $full_table_name = \do {"".$full_table_name} if ref $table_name;
1922 $self->_raw_stmt($table_class, ''); # add a blank line
1924 $self->_dbic_stmt($table_class, 'table', $full_table_name);
1926 my $cols = $self->_table_columns($table);
1927 my $col_info = $self->__columns_info_for($table);
1929 ### generate all the column accessor names
1930 while (my ($col, $info) = each %$col_info) {
1931 # hashref of other info that could be used by
1932 # user-defined accessor map functions
1934 table_class => $table_class,
1935 table_moniker => $table_moniker,
1936 table_name => $table_name,
1937 full_table_name => $full_table_name,
1938 schema_class => $schema_class,
1939 column_info => $info,
1942 $info->{accessor} = $self->_make_column_accessor_name( $col, $context );
1945 $self->_resolve_col_accessor_collisions($table, $col_info);
1947 # prune any redundant accessor names
1948 while (my ($col, $info) = each %$col_info) {
1949 no warnings 'uninitialized';
1950 delete $info->{accessor} if $info->{accessor} eq $col;
1953 my $fks = $self->_table_fk_info($table);
1955 foreach my $fkdef (@$fks) {
1956 for my $col (@{ $fkdef->{local_columns} }) {
1957 $col_info->{$col}{is_foreign_key} = 1;
1961 my $pks = $self->_table_pk_info($table) || [];
1963 foreach my $pkcol (@$pks) {
1964 $col_info->{$pkcol}{is_nullable} = 0;
1970 map { $_, ($col_info->{$_}||{}) } @$cols
1973 my %uniq_tag; # used to eliminate duplicate uniqs
1975 @$pks ? $self->_dbic_stmt($table_class,'set_primary_key',@$pks)
1976 : carp("$table has no primary key");
1977 $uniq_tag{ join("\0", @$pks) }++ if @$pks; # pk is a uniq
1979 my $uniqs = $self->_table_uniq_info($table) || [];
1981 my ($name, $cols) = @$_;
1982 next if $uniq_tag{ join("\0", @$cols) }++; # skip duplicates
1983 $self->_dbic_stmt($table_class,'add_unique_constraint', $name, $cols);
1988 sub __columns_info_for {
1989 my ($self, $table) = @_;
1991 my $result = $self->_columns_info_for($table);
1993 while (my ($col, $info) = each %$result) {
1994 $info = { %$info, %{ $self->_custom_column_info ($table, $col, $info) } };
1995 $info = { %$info, %{ $self->_datetime_column_info($table, $col, $info) } };
1997 $result->{$col} = $info;
2005 Returns a sorted list of loaded tables, using the original database table
2013 return keys %{$self->_tables};
2016 # Make a moniker from a table
2017 sub _default_table2moniker {
2018 no warnings 'uninitialized';
2019 my ($self, $table) = @_;
2021 if ($self->naming->{monikers} eq 'v4') {
2022 return join '', map ucfirst, split /[\W_]+/, lc $table;
2024 elsif ($self->naming->{monikers} eq 'v5') {
2025 return join '', map ucfirst, split /[\W_]+/,
2026 Lingua::EN::Inflect::Number::to_S(lc $table);
2028 elsif ($self->naming->{monikers} eq 'v6') {
2029 (my $as_phrase = lc $table) =~ s/_+/ /g;
2030 my $inflected = Lingua::EN::Inflect::Phrase::to_S($as_phrase);
2032 return join '', map ucfirst, split /\W+/, $inflected;
2035 my @words = map lc, split_name $table;
2036 my $as_phrase = join ' ', @words;
2038 my $inflected = $self->naming->{monikers} eq 'plural' ?
2039 Lingua::EN::Inflect::Phrase::to_PL($as_phrase)
2041 $self->naming->{monikers} eq 'preserve' ?
2044 Lingua::EN::Inflect::Phrase::to_S($as_phrase);
2046 return join '', map ucfirst, split /\W+/, $inflected;
2049 sub _table2moniker {
2050 my ( $self, $table ) = @_;
2052 $self->_run_user_map(
2054 sub { $self->_default_table2moniker( shift ) },
2059 sub _load_relationships {
2060 my ($self, $tables) = @_;
2064 foreach my $table (@$tables) {
2065 my $tbl_fk_info = $self->_table_fk_info($table);
2066 foreach my $fkdef (@$tbl_fk_info) {
2067 $fkdef->{remote_source} =
2068 $self->monikers->{delete $fkdef->{remote_table}};
2070 my $tbl_uniq_info = $self->_table_uniq_info($table);
2072 my $local_moniker = $self->monikers->{$table};
2074 push @tables, [ $local_moniker, $tbl_fk_info, $tbl_uniq_info ];
2077 my $rel_stmts = $self->_relbuilder->generate_code(\@tables);
2079 foreach my $src_class (sort keys %$rel_stmts) {
2080 my $src_stmts = $rel_stmts->{$src_class};
2081 foreach my $stmt (@$src_stmts) {
2082 $self->_dbic_stmt($src_class,$stmt->{method},@{$stmt->{args}});
2088 my ($self, $table) = @_;
2090 my $table_moniker = $self->monikers->{$table};
2091 my $table_class = $self->classes->{$table};
2093 my @roles = @{ $self->result_roles || [] };
2094 push @roles, @{ $self->result_roles_map->{$table_moniker} }
2095 if exists $self->result_roles_map->{$table_moniker};
2098 $self->_pod_class_list($table_class, 'L<Moose> ROLES APPLIED', @roles);
2100 $self->_with($table_class, @roles);
2104 # Overload these in driver class:
2106 # Returns an arrayref of column names
2107 sub _table_columns { croak "ABSTRACT METHOD" }
2109 # Returns arrayref of pk col names
2110 sub _table_pk_info { croak "ABSTRACT METHOD" }
2112 # Returns an arrayref of uniqs [ [ foo => [ col1, col2 ] ], [ bar => [ ... ] ] ]
2113 sub _table_uniq_info { croak "ABSTRACT METHOD" }
2115 # Returns an arrayref of foreign key constraints, each
2116 # being a hashref with 3 keys:
2117 # local_columns (arrayref), remote_columns (arrayref), remote_table
2118 sub _table_fk_info { croak "ABSTRACT METHOD" }
2120 # Returns an array of lower case table names
2121 sub _tables_list { croak "ABSTRACT METHOD" }
2123 # Execute a constructive DBIC class method, with debug/dump_to_dir hooks.
2129 # generate the pod for this statement, storing it with $self->_pod
2130 $self->_make_pod( $class, $method, @_ ) if $self->generate_pod;
2132 my $args = dump(@_);
2133 $args = '(' . $args . ')' if @_ < 2;
2134 my $stmt = $method . $args . q{;};
2136 warn qq|$class\->$stmt\n| if $self->debug;
2137 $self->_raw_stmt($class, '__PACKAGE__->' . $stmt);
2141 sub _make_pod_heading {
2142 my ($self, $class) = @_;
2144 return '' if not $self->generate_pod;
2146 my $table = $self->class_to_table->{$class};
2149 my $pcm = $self->pod_comment_mode;
2150 my ($comment, $comment_overflows, $comment_in_name, $comment_in_desc);
2151 $comment = $self->__table_comment($table);
2152 $comment_overflows = ($comment and length $comment > $self->pod_comment_spillover_length);
2153 $comment_in_name = ($pcm eq 'name' or ($pcm eq 'auto' and !$comment_overflows));
2154 $comment_in_desc = ($pcm eq 'description' or ($pcm eq 'auto' and $comment_overflows));
2156 $pod .= "=head1 NAME\n\n";
2158 my $table_descr = $class;
2159 $table_descr .= " - " . $comment if $comment and $comment_in_name;
2161 $pod .= "$table_descr\n\n";
2163 if ($comment and $comment_in_desc) {
2164 $pod .= "=head1 DESCRIPTION\n\n${comment}\n\n";
2171 # generates the accompanying pod for a DBIC class method statement,
2172 # storing it with $self->_pod
2178 if ( $method eq 'add_columns' ) {
2179 $self->_pod( $class, "=head1 ACCESSORS" );
2180 my $col_counter = 0;
2182 while( my ($name,$attrs) = splice @cols,0,2 ) {
2184 $self->_pod( $class, '=head2 ' . $name );
2185 $self->_pod( $class,
2187 my $s = $attrs->{$_};
2188 $s = !defined $s ? 'undef' :
2189 length($s) == 0 ? '(empty string)' :
2190 ref($s) eq 'SCALAR' ? $$s :
2191 ref($s) ? dumper_squashed $s :
2192 looks_like_number($s) ? $s : qq{'$s'};
2195 } sort keys %$attrs,
2197 if (my $comment = $self->__column_comment($self->class_to_table->{$class}, $col_counter, $name)) {
2198 $self->_pod( $class, $comment );
2201 $self->_pod_cut( $class );
2202 } elsif ( $method =~ /^(belongs_to|has_many|might_have)$/ ) {
2203 $self->_pod( $class, "=head1 RELATIONS" ) unless $self->{_relations_started} { $class } ;
2204 my ( $accessor, $rel_class ) = @_;
2205 $self->_pod( $class, "=head2 $accessor" );
2206 $self->_pod( $class, 'Type: ' . $method );
2207 $self->_pod( $class, "Related object: L<$rel_class>" );
2208 $self->_pod_cut( $class );
2209 $self->{_relations_started} { $class } = 1;
2213 sub _pod_class_list {
2214 my ($self, $class, $title, @classes) = @_;
2216 return unless @classes && $self->generate_pod;
2218 $self->_pod($class, "=head1 $title");
2219 $self->_pod($class, '=over 4');
2221 foreach my $link (@classes) {
2222 $self->_pod($class, "=item * L<$link>");
2225 $self->_pod($class, '=back');
2226 $self->_pod_cut($class);
2229 sub _base_class_pod {
2230 my ($self, $base_class) = @_;
2232 return unless $self->generate_pod;
2235 =head1 BASE CLASS: L<$base_class>
2242 sub _filter_comment {
2243 my ($self, $txt) = @_;
2245 $txt = '' if not defined $txt;
2247 $txt =~ s/(?:\015?\012|\015\012?)/\n/g;
2252 sub __table_comment {
2255 if (my $code = $self->can('_table_comment')) {
2256 return $self->_filter_comment($self->$code(@_));
2262 sub __column_comment {
2265 if (my $code = $self->can('_column_comment')) {
2266 return $self->_filter_comment($self->$code(@_));
2272 # Stores a POD documentation
2274 my ($self, $class, $stmt) = @_;
2275 $self->_raw_stmt( $class, "\n" . $stmt );
2279 my ($self, $class ) = @_;
2280 $self->_raw_stmt( $class, "\n=cut\n" );
2283 # Store a raw source line for a class (for dumping purposes)
2285 my ($self, $class, $stmt) = @_;
2286 push(@{$self->{_dump_storage}->{$class}}, $stmt);
2289 # Like above, but separately for the externally loaded stuff
2291 my ($self, $class, $stmt) = @_;
2292 push(@{$self->{_ext_storage}->{$class}}, $stmt);
2295 sub _custom_column_info {
2296 my ( $self, $table_name, $column_name, $column_info ) = @_;
2298 if (my $code = $self->custom_column_info) {
2299 return $code->($table_name, $column_name, $column_info) || {};
2304 sub _datetime_column_info {
2305 my ( $self, $table_name, $column_name, $column_info ) = @_;
2307 my $type = $column_info->{data_type} || '';
2308 if ((grep $_, @{ $column_info }{map "inflate_$_", qw/date datetime timestamp/})
2309 or ($type =~ /date|timestamp/i)) {
2310 $result->{timezone} = $self->datetime_timezone if $self->datetime_timezone;
2311 $result->{locale} = $self->datetime_locale if $self->datetime_locale;
2317 my ($self, $name) = @_;
2319 return $self->preserve_case ? $name : lc($name);
2323 my ($self, $name) = @_;
2325 return $self->preserve_case ? $name : uc($name);
2328 sub _unregister_source_for_table {
2329 my ($self, $table) = @_;
2333 my $schema = $self->schema;
2334 # in older DBIC it's a private method
2335 my $unregister = $schema->can('unregister_source') || $schema->can('_unregister_source');
2336 $schema->$unregister($self->_table2moniker($table));
2337 delete $self->monikers->{$table};
2338 delete $self->classes->{$table};
2339 delete $self->_upgrading_classes->{$table};
2340 delete $self->{_tables}{$table};
2344 # remove the dump dir from @INC on destruction
2348 @INC = grep $_ ne $self->dump_directory, @INC;
2353 Returns a hashref of loaded table to moniker mappings. There will
2354 be two entries for each table, the original name and the "normalized"
2355 name, in the case that the two are different (such as databases
2356 that like uppercase table names, or preserve your original mixed-case
2357 definitions, or what-have-you).
2361 Returns a hashref of table to class mappings. In some cases it will
2362 contain multiple entries per table for the original and normalized table
2363 names, as above in L</monikers>.
2365 =head1 COLUMN ACCESSOR COLLISIONS
2367 Occasionally you may have a column name that collides with a perl method, such
2368 as C<can>. In such cases, the default action is to set the C<accessor> of the
2369 column spec to C<undef>.
2371 You can then name the accessor yourself by placing code such as the following
2374 __PACKAGE__->add_column('+can' => { accessor => 'my_can' });
2376 Another option is to use the L</col_collision_map> option.
2378 =head1 RELATIONSHIP NAME COLLISIONS
2380 In very rare cases, you may get a collision between a generated relationship
2381 name and a method in your Result class, for example if you have a foreign key
2382 called C<belongs_to>.
2384 This is a problem because relationship names are also relationship accessor
2385 methods in L<DBIx::Class>.
2387 The default behavior is to append C<_rel> to the relationship name and print
2388 out a warning that refers to this text.
2390 You can also control the renaming with the L</rel_collision_map> option.
2394 L<DBIx::Class::Schema::Loader>
2398 See L<DBIx::Class::Schema::Loader/AUTHOR> and L<DBIx::Class::Schema::Loader/CONTRIBUTORS>.
2402 This library is free software; you can redistribute it and/or modify it under
2403 the same terms as Perl itself.
2408 # vim:et sts=4 sw=4 tw=0: