X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=lib%2FDBIx%2FClass%2FSchema%2FLoader%2FBase.pm;h=c7a9856d2b148ee22050f6de245cd3ee2aae6789;hb=e344eed6c9cf62f2e5e78a31d8c499014a16c68c;hp=16ce37339330995800763d8794f1b5adad6693cf;hpb=a13b280367c1e372e5dbc00862c92751082a9fc2;p=dbsrgits%2FDBIx-Class-Schema-Loader.git diff --git a/lib/DBIx/Class/Schema/Loader/Base.pm b/lib/DBIx/Class/Schema/Loader/Base.pm index 16ce373..c7a9856 100644 --- a/lib/DBIx/Class/Schema/Loader/Base.pm +++ b/lib/DBIx/Class/Schema/Loader/Base.pm @@ -4,13 +4,18 @@ use strict; use warnings; use base qw/Class::Accessor::Fast/; use Class::C3; -use Carp; +use Carp::Clan qw/^DBIx::Class/; use UNIVERSAL::require; use DBIx::Class::Schema::Loader::RelBuilder; use Data::Dump qw/ dump /; use POSIX qw//; +use File::Spec qw//; +use Cwd qw//; +use Digest::MD5 qw//; require DBIx::Class; +our $VERSION = '0.04999_02'; + __PACKAGE__->mk_ro_accessors(qw/ schema schema_class @@ -22,14 +27,18 @@ __PACKAGE__->mk_ro_accessors(qw/ left_base_classes components resultset_components - relationships + skip_relationships moniker_map inflect_singular inflect_plural debug dump_directory - - legacy_default_inflections + dump_overwrite + really_erase_my_files + use_namespaces + result_namespace + resultset_namespace + default_resultset_class db_schema _tables @@ -55,15 +64,22 @@ classes, and implements the common functionality between them. These constructor options are the base options for L. Available constructor options are: -=head2 relationships +=head2 skip_relationships -Try to automatically detect/setup has_a and has_many relationships. +Skip setting up relationships. The default is to attempt the loading +of relationships. =head2 debug If set to true, each constructive L statement the loader decides to execute will be C-ed before execution. +=head2 db_schema + +Set the name of the schema to load (schema in the sense that your database +vendor means it). Does not currently support loading more than one schema +name. + =head2 constraint Only load tables matching regex. Best specified as a qr// regex. @@ -129,14 +145,14 @@ classes. A good example would be C. Component C will be automatically added to the above C list if this option is set. -=head2 legacy_default_inflections +=head2 use_namespaces -Setting this option changes the default fallback for L to -utilize L, and L to a no-op. -Those choices produce substandard results, but might be necessary to support -your existing code if you started developing on a version prior to 0.03 and -don't wish to go around updating all your relationship names to the new -defaults. +Generate result class names suitable for +L and call that instead of +L. When using this option you can also +specify any of the options for C (i.e. C, +C, C), and they will be added +to the call (and the generated result class names adjusted appropriately). =head2 dump_directory @@ -150,11 +166,7 @@ in memory. The created schema class will have the same classname as the one on which you are setting this option (and the ResultSource classes will be -based on this name as well). Therefore it is wise to note that if you -point the C option of a schema class at the live libdir -where that class is currently located, it will overwrite itself with a -manual version of itself. This might be a really good or bad thing -depending on your situation and perspective. +based on this name as well). Normally you wouldn't hard-code this setting in your schema class, as it is meant for one-time manual usage. @@ -162,22 +174,29 @@ is meant for one-time manual usage. See L for examples of the recommended way to access this functionality. -=head1 DEPRECATED CONSTRUCTOR OPTIONS +=head2 dump_overwrite -=head2 inflect_map +Deprecated. See L below, which does *not* mean +the same thing as the old C setting from previous releases. -Equivalent to L. +=head2 really_erase_my_files -=head2 inflect +Default false. If true, Loader will unconditionally delete any existing +files before creating the new ones from scratch when dumping a schema to disk. -Equivalent to L. +The default behavior is instead to only replace the top portion of the +file, up to and including the final stanza which contains +C<# DO NOT MODIFY THIS OR ANYTHING ABOVE!> +leaving any customizations you placed after that as they were. -=head2 connect_info, dsn, user, password, options +When C is not set, if the output file already exists, +but the aforementioned final stanza is not found, or the checksum +contained there does not match the generated contents, Loader will +croak and not touch the file. -You connect these schemas the same way you would any L, -which is by calling either C or C on a schema class -or object. These options are only supported via the deprecated -C interface, which will be removed in the future. +You should really be using version control on your schema classes (and all +of the rest of your code for that matter). Don't blame me if a bug in this +code wipes something out when it shouldn't have, you've been warned. =head1 METHODS @@ -213,7 +232,6 @@ sub new { bless $self => $class; - $self->{db_schema} ||= ''; $self->_ensure_arrayref(qw/additional_classes additional_base_classes left_base_classes @@ -227,58 +245,84 @@ sub new { $self->{monikers} = {}; $self->{classes} = {}; - # Support deprecated arguments - for(qw/inflect_map inflect/) { - warn "Argument $_ is deprecated in favor of 'inflect_plural'" - if $self->{$_}; - } - $self->{inflect_plural} ||= $self->{inflect_map} || $self->{inflect}; - $self->{schema_class} ||= ( ref $self->{schema} || $self->{schema} ); $self->{schema} ||= $self->{schema_class}; + croak "dump_overwrite is deprecated. Please read the" + . " DBIx::Class::Schema::Loader::Base documentation" + if $self->{dump_overwrite}; + + $self->{relbuilder} = DBIx::Class::Schema::Loader::RelBuilder->new( + $self->schema_class, $self->inflect_plural, $self->inflect_singular + ) if !$self->{skip_relationships}; + $self; } -sub _load_external { - my $self = shift; +sub _find_file_in_inc { + my ($self, $file) = @_; - foreach my $table_class (values %{$self->classes}) { - $table_class->require; - if($@ && $@ !~ /^Can't locate /) { - croak "Failed to load external class definition" - . " for '$table_class': $@"; - } - next if $@; # "Can't locate" error - - # If we make it to here, we loaded an external definition - warn qq/# Loaded external class definition for '$table_class'\n/ - if $self->debug; - - if($self->dump_directory) { - my $class_path = $table_class; - $class_path =~ s{::}{/}g; - $class_path .= '.pm'; - my $filename = $INC{$class_path}; - croak 'Failed to locate actual external module file for ' - . "'$table_class'" - if !$filename; - open(my $fh, '<', $filename) - or croak "Failed to open $filename for reading: $!"; - $self->_raw_stmt($table_class, - q|# These lines loaded from user-supplied external file: | - ); - while(<$fh>) { - chomp; - $self->_raw_stmt($table_class, $_); - } - $self->_raw_stmt($table_class, - q|# End of lines loaded from user-supplied external file | - ); - close($fh) - or croak "Failed to close $filename: $!"; - } + foreach my $prefix (@INC) { + my $fullpath = $prefix . '/' . $file; + return $fullpath if -f $fullpath; + } + + return; +} + +sub _load_external { + my ($self, $class) = @_; + + my $class_path = $class; + $class_path =~ s{::}{/}g; + $class_path .= '.pm'; + + my $inc_path = $self->_find_file_in_inc($class_path); + + return if !$inc_path; + + my $real_dump_path = $self->dump_directory + ? Cwd::abs_path( + File::Spec->catfile($self->dump_directory, $class_path) + ) + : ''; + my $real_inc_path = Cwd::abs_path($inc_path); + return if $real_inc_path eq $real_dump_path; + + $class->require; + croak "Failed to load external class definition" + . " for '$class': $@" + if $@; + + # If we make it to here, we loaded an external definition + warn qq/# Loaded external class definition for '$class'\n/ + if $self->debug; + + # The rest is only relevant when dumping + return if !$self->dump_directory; + + croak 'Failed to locate actual external module file for ' + . "'$class'" + if !$real_inc_path; + open(my $fh, '<', $real_inc_path) + or croak "Failed to open '$real_inc_path' for reading: $!"; + $self->_ext_stmt($class, + qq|# These lines were loaded from '$real_inc_path' found in \@INC.| + .q|# They are now part of the custom portion of this file| + .q|# for you to hand-edit. If you do not either delete| + .q|# this section or remove that file from @INC, this section| + .q|# will be repeated redundantly when you re-create this| + .q|# file again via Loader!| + ); + while(<$fh>) { + chomp; + $self->_ext_stmt($class, $_); } + $self->_ext_stmt($class, + qq|# End of lines loaded from '$real_inc_path' | + ); + close($fh) + or croak "Failed to close $real_inc_path: $!"; } =head2 load @@ -290,15 +334,85 @@ Does the actual schema-construction work. sub load { my $self = shift; - $self->_load_classes; - $self->_load_relationships if $self->relationships; - $self->_load_external; + $self->_load_tables($self->_tables_list); +} + +=head2 rescan + +Arguments: schema + +Rescan the database for newly added tables. Does +not process drops or changes. Returns a list of +the newly added table monikers. + +The schema argument should be the schema class +or object to be affected. It should probably +be derived from the original schema_class used +during L. + +=cut + +sub rescan { + my ($self, $schema) = @_; + + $self->{schema} = $schema; + + my @created; + my @current = $self->_tables_list; + foreach my $table ($self->_tables_list) { + if(!exists $self->{_tables}->{$table}) { + push(@created, $table); + } + } + + my $loaded = $self->_load_tables(@created); + + return map { $self->monikers->{$_} } @$loaded; +} + +sub _load_tables { + my ($self, @tables) = @_; + + # First, use _tables_list with constraint and exclude + # to get a list of tables to operate on + + my $constraint = $self->constraint; + my $exclude = $self->exclude; + + @tables = grep { /$constraint/ } @tables if $constraint; + @tables = grep { ! /$exclude/ } @tables if $exclude; + + # Save the new tables to the tables list + foreach (@tables) { + $self->{_tables}->{$_} = 1; + } + + # Set up classes/monikers + { + no warnings 'redefine'; + local *Class::C3::reinitialize = sub { }; + use warnings; + + $self->_make_src_class($_) for @tables; + } + + Class::C3::reinitialize; + + $self->_setup_src_meta($_) for @tables; + + if(!$self->skip_relationships) { + $self->_load_relationships($_) for @tables; + } + + $self->_load_external($_) + for map { $self->classes->{$_} } @tables; + $self->_dump_to_dir if $self->dump_directory; # Drop temporary cache delete $self->{_cache}; - 1; + return \@tables; } sub _get_dump_filename { @@ -312,13 +426,16 @@ sub _ensure_dump_subdirs { my ($self, $class) = (@_); my @name_parts = split(/::/, $class); - pop @name_parts; + pop @name_parts; # we don't care about the very last element, + # which is a filename + my $dir = $self->dump_directory; - foreach (@name_parts) { - $dir .= q{/} . $_; - if(! -d $dir) { - mkdir($dir) or die "mkdir('$dir') failed: $!"; + while (1) { + if(!-d $dir) { + mkdir($dir) or croak "mkdir('$dir') failed: $!"; } + last if !@name_parts; + $dir = File::Spec->catdir($dir, shift @name_parts); } } @@ -326,62 +443,139 @@ sub _dump_to_dir { my ($self) = @_; my $target_dir = $self->dump_directory; + my $schema_class = $self->schema_class; - die "Must specify target directory for dumping!" if ! $target_dir; + croak "Must specify target directory for dumping!" if ! $target_dir; warn "Dumping manual schema for $schema_class to directory $target_dir ...\n"; - if(! -d $target_dir) { - mkdir($target_dir) or die "mkdir('$target_dir') failed: $!"; + my $schema_text = + qq|package $schema_class;\n\n| + . qq|use strict;\nuse warnings;\n\n| + . qq|use base 'DBIx::Class::Schema';\n\n|; + + + if ($self->use_namespaces) { + $schema_text .= qq|__PACKAGE__->load_namespaces|; + my $namespace_options; + for my $attr (qw(result_namespace + resultset_namespace + default_resultset_class)) { + if ($self->$attr) { + $namespace_options .= qq| $attr => '| . $self->$attr . qq|',\n| + } + } + $schema_text .= qq|(\n$namespace_options)| if $namespace_options; + $schema_text .= qq|;\n|; } + else { + $schema_text .= qq|__PACKAGE__->load_classes;\n|; - my $verstr = $DBIx::Class::Schema::Loader::VERSION; - my $datestr = POSIX::strftime('%Y-%m-%d %H:%M:%S', localtime); - my $tagline = qq|# Created by DBIx::Class::Schema::Loader v$verstr @ $datestr|; - - $self->_ensure_dump_subdirs($schema_class); + } - my $schema_fn = $self->_get_dump_filename($schema_class); - open(my $schema_fh, '>', $schema_fn) - or die "Cannot open $schema_fn for writing: $!"; - print $schema_fh qq|package $schema_class;\n\n$tagline\n\n|; - print $schema_fh qq|use strict;\nuse warnings;\n\n|; - print $schema_fh qq|use base 'DBIx::Class::Schema';\n\n|; - print $schema_fh qq|__PACKAGE__->load_classes;\n|; - print $schema_fh qq|\n1;\n\n|; - close($schema_fh) - or die "Cannot close $schema_fn: $!"; + $self->_write_classfile($schema_class, $schema_text); foreach my $src_class (sort keys %{$self->{_dump_storage}}) { - $self->_ensure_dump_subdirs($src_class); - my $src_fn = $self->_get_dump_filename($src_class); - open(my $src_fh, '>', $src_fn) - or die "Cannot open $src_fn for writing: $!"; - print $src_fh qq|package $src_class;\n\n$tagline\n\n|; - print $src_fh qq|use strict;\nuse warnings;\n\n|; - print $src_fh qq|use base 'DBIx::Class';\n\n|; - print $src_fh qq|$_\n| - for @{$self->{_dump_storage}->{$src_class}}; - print $src_fh qq|\n1;\n\n|; - close($src_fh) - or die "Cannot close $src_fn: $!"; + my $src_text = + qq|package $src_class;\n\n| + . qq|use strict;\nuse warnings;\n\n| + . qq|use base 'DBIx::Class';\n\n|; + + $self->_write_classfile($src_class, $src_text); } warn "Schema dump completed.\n"; } +sub _write_classfile { + my ($self, $class, $text) = @_; + + my $filename = $self->_get_dump_filename($class); + $self->_ensure_dump_subdirs($class); + + if (-f $filename && $self->really_erase_my_files) { + warn "Deleting existing file '$filename' due to " + . "'really_erase_my_files' setting\n"; + unlink($filename); + } + + my $custom_content = $self->_get_custom_content($class, $filename); + + $custom_content ||= qq|\n\n# You can replace this text with custom| + . qq| content, and it will be preserved on regeneration| + . qq|\n1;\n|; + + $text .= qq|$_\n| + for @{$self->{_dump_storage}->{$class} || []}; + + $text .= qq|\n\n# Created by DBIx::Class::Schema::Loader| + . qq| v| . $DBIx::Class::Schema::Loader::VERSION + . q| @ | . POSIX::strftime('%Y-%m-%d %H:%M:%S', localtime) + . qq|\n# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:|; + + open(my $fh, '>', $filename) + or croak "Cannot open '$filename' for writing: $!"; + + # Write the top half and its MD5 sum + print $fh $text . Digest::MD5::md5_base64($text) . "\n"; + + # Write out anything loaded via external partial class file in @INC + print $fh qq|$_\n| + for @{$self->{_ext_storage}->{$class} || []}; + + print $fh $custom_content; + + close($fh) + or croak "Cannot close '$filename': $!"; +} + +sub _get_custom_content { + my ($self, $class, $filename) = @_; + + return if ! -f $filename; + open(my $fh, '<', $filename) + or croak "Cannot open '$filename' for reading: $!"; + + my $mark_re = + qr{^(# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:)([A-Za-z0-9/+]{22})\n}; + + my $found = 0; + my $buffer = ''; + while(<$fh>) { + if(!$found && /$mark_re/) { + $found = 1; + $buffer .= $1; + croak "Checksum mismatch in '$filename'" + if Digest::MD5::md5_base64($buffer) ne $2; + + $buffer = ''; + } + else { + $buffer .= $_; + } + } + + croak "Cannot not overwrite '$filename' without 'really_erase_my_files'," + . " it does not appear to have been generated by Loader" + if !$found; + + return $buffer; +} + sub _use { my $self = shift; my $target = shift; + my $evalstr; foreach (@_) { - $_->require or croak ($_ . "->require: $@"); + warn "$target: use $_;" if $self->debug; $self->_raw_stmt($target, "use $_;"); - warn "$target: use $_" if $self->debug; - eval "package $target; use $_;"; - croak "use $_: $@" if $@; + $_->require or croak ($_ . "->require: $@"); + $evalstr .= "package $target; use $_;"; } + eval $evalstr if $evalstr; + croak $@ if $@; } sub _inject { @@ -390,94 +584,96 @@ sub _inject { my $schema_class = $self->schema_class; my $blist = join(q{ }, @_); + warn "$target: use base qw/ $blist /;" if $self->debug && @_; $self->_raw_stmt($target, "use base qw/ $blist /;") if @_; - warn "$target: use base qw/ $blist /" if $self->debug; foreach (@_) { $_->require or croak ($_ . "->require: $@"); $schema_class->inject_base($target, $_); } } -# Load and setup classes -sub _load_classes { - my $self = shift; +# Create class with applicable bases, setup monikers, etc +sub _make_src_class { + my ($self, $table) = @_; my $schema = $self->schema; my $schema_class = $self->schema_class; - my $constraint = $self->constraint; - my $exclude = $self->exclude; - my @tables = sort $self->_tables_list; - - warn "No tables found in database, nothing to load" if !@tables; - if(@tables) { - @tables = grep { /$constraint/ } @tables if $constraint; - @tables = grep { ! /$exclude/ } @tables if $exclude; - - warn "All tables excluded by constraint/exclude, nothing to load" - if !@tables; + my $table_moniker = $self->_table2moniker($table); + my @result_namespace = ($schema_class); + if ($self->use_namespaces) { + my $result_namespace = $self->result_namespace || 'Result'; + if ($result_namespace =~ /^\+(.*)/) { + # Fully qualified namespace + @result_namespace = ($1) + } + else { + # Relative namespace + push @result_namespace, $result_namespace; + } } + my $table_class = join(q{::}, @result_namespace, $table_moniker); - $self->{_tables} = \@tables; + my $table_normalized = lc $table; + $self->classes->{$table} = $table_class; + $self->classes->{$table_normalized} = $table_class; + $self->monikers->{$table} = $table_moniker; + $self->monikers->{$table_normalized} = $table_moniker; - foreach my $table (@tables) { - my $table_moniker = $self->_table2moniker($table); - my $table_class = $schema_class . q{::} . $table_moniker; + { no strict 'refs'; @{"${table_class}::ISA"} = qw/DBIx::Class/ } - my $table_normalized = lc $table; - $self->classes->{$table} = $table_class; - $self->classes->{$table_normalized} = $table_class; - $self->monikers->{$table} = $table_moniker; - $self->monikers->{$table_normalized} = $table_moniker; + $self->_use ($table_class, @{$self->additional_classes}); + $self->_inject($table_class, @{$self->additional_base_classes}); - no warnings 'redefine'; - local *Class::C3::reinitialize = sub { }; - use warnings; - - { no strict 'refs'; @{"${table_class}::ISA"} = qw/DBIx::Class/ } + $self->_dbic_stmt($table_class, 'load_components', @{$self->components}, 'Core'); - $self->_use ($table_class, @{$self->additional_classes}); - $self->_inject($table_class, @{$self->additional_base_classes}); - - $self->_dbic_stmt($table_class, 'load_components', @{$self->components}, qw/PK::Auto Core/); + $self->_dbic_stmt($table_class, 'load_resultset_components', @{$self->resultset_components}) + if @{$self->resultset_components}; + $self->_inject($table_class, @{$self->left_base_classes}); +} - $self->_dbic_stmt($table_class, 'load_resultset_components', @{$self->resultset_components}) - if @{$self->resultset_components}; - $self->_inject($table_class, @{$self->left_base_classes}); - } +# Set up metadata (cols, pks, etc) and register the class with the schema +sub _setup_src_meta { + my ($self, $table) = @_; - Class::C3::reinitialize; + my $schema = $self->schema; + my $schema_class = $self->schema_class; - foreach my $table (@tables) { - my $table_class = $self->classes->{$table}; - my $table_moniker = $self->monikers->{$table}; + my $table_class = $self->classes->{$table}; + my $table_moniker = $self->monikers->{$table}; - $self->_dbic_stmt($table_class,'table',$table); + $self->_dbic_stmt($table_class,'table',$table); - my $cols = $self->_table_columns($table); - my $col_info; - eval { $col_info = $schema->storage->columns_info_for($table) }; - if($@) { - $self->_dbic_stmt($table_class,'add_columns',@$cols); - } - else { - my %cols_hash; - foreach my $col (@$cols) { - $cols_hash{$col} = \%{($col_info->{$col})}; + my $cols = $self->_table_columns($table); + my $col_info; + eval { $col_info = $self->_columns_info_for($table) }; + if($@) { + $self->_dbic_stmt($table_class,'add_columns',@$cols); + } + else { + my %col_info_lc = map { lc($_), $col_info->{$_} } keys %$col_info; + my $fks = $self->_table_fk_info($table); + for my $fkdef (@$fks) { + for my $col (@{ $fkdef->{local_columns} }) { + $col_info_lc{$col}->{is_foreign_key} = 1; } - $self->_dbic_stmt($table_class,'add_columns',%cols_hash); } + $self->_dbic_stmt( + $table_class, + 'add_columns', + map { $_, ($col_info_lc{$_}||{}) } @$cols + ); + } - my $pks = $self->_table_pk_info($table) || []; - @$pks ? $self->_dbic_stmt($table_class,'set_primary_key',@$pks) - : carp("$table has no primary key"); + my $pks = $self->_table_pk_info($table) || []; + @$pks ? $self->_dbic_stmt($table_class,'set_primary_key',@$pks) + : carp("$table has no primary key"); - my $uniqs = $self->_table_uniq_info($table) || []; - $self->_dbic_stmt($table_class,'add_unique_constraint',@$_) for (@$uniqs); + my $uniqs = $self->_table_uniq_info($table) || []; + $self->_dbic_stmt($table_class,'add_unique_constraint',@$_) for (@$uniqs); - $schema_class->register_class($table_moniker, $table_class); - $schema->register_class($table_moniker, $table_class) if $schema ne $schema_class; - } + $schema_class->register_class($table_moniker, $table_class); + $schema->register_class($table_moniker, $table_class) if $schema ne $schema_class; } =head2 tables @@ -490,7 +686,7 @@ names. sub tables { my $self = shift; - return @{$self->_tables}; + return keys %{$self->_tables}; } # Make a moniker from a table @@ -512,27 +708,18 @@ sub _table2moniker { } sub _load_relationships { - my $self = shift; + my ($self, $table) = @_; - # Construct the fk_info RelBuilder wants to see, by - # translating table names to monikers in the _fk_info output - my %fk_info; - foreach my $table ($self->tables) { - my $tbl_fk_info = $self->_table_fk_info($table); - foreach my $fkdef (@$tbl_fk_info) { - $fkdef->{remote_source} = - $self->monikers->{delete $fkdef->{remote_table}}; - } - my $moniker = $self->monikers->{$table}; - $fk_info{$moniker} = $tbl_fk_info; + my $tbl_fk_info = $self->_table_fk_info($table); + foreach my $fkdef (@$tbl_fk_info) { + $fkdef->{remote_source} = + $self->monikers->{delete $fkdef->{remote_table}}; } + my $tbl_uniq_info = $self->_table_uniq_info($table); - my $relbuilder = DBIx::Class::Schema::Loader::RelBuilder->new( - $self->schema_class, \%fk_info, $self->inflect_plural, - $self->inflect_singular - ); + my $local_moniker = $self->monikers->{$table}; + my $rel_stmts = $self->{relbuilder}->generate_code($local_moniker, $tbl_fk_info, $tbl_uniq_info); - my $rel_stmts = $relbuilder->generate_code; foreach my $src_class (sort keys %$rel_stmts) { my $src_stmts = $rel_stmts->{$src_class}; foreach my $stmt (@$src_stmts) { @@ -586,6 +773,12 @@ sub _raw_stmt { push(@{$self->{_dump_storage}->{$class}}, $stmt) if $self->dump_directory; } +# Like above, but separately for the externally loaded stuff +sub _ext_stmt { + my ($self, $class, $stmt) = @_; + push(@{$self->{_ext_storage}->{$class}}, $stmt) if $self->dump_directory; +} + =head2 monikers Returns a hashref of loaded table to moniker mappings. There will