-use warnings;
use strict;
-
-use File::Temp ();
+use warnings;
use Test::More;
-
+use DBIx::Class::Schema::Loader::Utils qw/slurp_file write_file/;
+use namespace::clean;
+use File::Temp ();
use lib qw(t/lib);
use dbixcsl_dumper_tests;
my $t = 'dbixcsl_dumper_tests';
# test loading external content
$t->dump_test(
classname => 'DBICTest::Schema::_no_skip_load_external',
- warnings => [
- qr/Dumping manual schema for DBICTest::Schema::_no_skip_load_external to directory /,
- qr/Schema dump completed/,
- ],
regexes => {
Foo => [
qr/package DBICTest::Schema::_no_skip_load_external::Foo;\nour \$skip_me = "bad mojo";\n1;/
$t->dump_test(
classname => 'DBICTest::Schema::_skip_load_external',
options => {
- skip_load_external => 1
+ skip_load_external => 1,
},
- warnings => [
- qr/Dumping manual schema for DBICTest::Schema::_skip_load_external to directory /,
- qr/Schema dump completed/,
- ],
neg_regexes => {
Foo => [
qr/package DBICTest::Schema::_skip_load_external::Foo;\nour \$skip_me = "bad mojo";\n1;/
$t->dump_test(
classname => 'DBICTest::Schema::_config_file',
options => { config_file => "$config_file" },
- warnings => [
- qr/Dumping manual schema for DBICTest::Schema::_config_file to directory /,
- qr/Schema dump completed/,
- ],
neg_regexes => {
Foo => [
qr/has_many/,
$t->dump_test(
classname => 'DBICTest::Schema::_clashing_monikers',
test_db_class => 'make_dbictest_db_clashing_monikers',
- error => qr/tables 'bar', 'bars' reduced to the same source moniker 'Bar'/,
+ error => qr/tables (?:"bar", "bars"|"bars", "bar") reduced to the same source moniker 'Bar'/,
);
classname => 'DBICTest::Schema::_preserve_column_accessors',
test_db_class => 'make_dbictest_db_with_unique',
options => { naming => { column_accessors => 'preserve' } },
- warnings => [
- qr/Dumping manual schema for DBICTest::Schema::_preserve_column_accessors to directory /,
- qr/Schema dump completed/,
- ],
neg_regexes => {
RouteChange => [
qr/\baccessor\b/,
$t->dump_test(
classname => 'DBICTest::Schema::_sorted_rels',
test_db_class => 'make_dbictest_db_with_unique',
- warnings => [
- qr/Dumping manual schema for DBICTest::Schema::_sorted_rels to directory /,
- qr/Schema dump completed/,
- ],
regexes => {
Baz => [
qr/->might_have\(\n "quux".*->belongs_to\(\n "station_visited"/s,
$t->cleanup;
+$t->dump_test(
+ classname => 'DBICTest::Schema::_sorted_uniqs',
+ test_db_class => 'make_dbictest_db_multi_unique',
+ regexes => {
+ Bar => [
+ qr/->add_unique_constraint\("uniq1_unique".*->add_unique_constraint\("uniq2_unique"/s,
+ ],
+ },
+);
+
+$t->cleanup;
+
# test naming => { monikers => 'plural' }
$t->dump_test(
classname => 'DBICTest::Schema::_plural_monikers',
options => { naming => { monikers => 'plural' } },
- warnings => [
- qr/Dumping manual schema for DBICTest::Schema::_plural_monikers to directory /,
- qr/Schema dump completed/,
- ],
regexes => {
Foos => [
qr/\n=head1 NAME\n\nDBICTest::Schema::_plural_monikers::Foos\n\n=cut\n\n/,
classname => 'DBICTest::Schema::_singular_monikers',
test_db_class => 'make_dbictest_db_plural_tables',
options => { naming => { monikers => 'singular' } },
- warnings => [
- qr/Dumping manual schema for DBICTest::Schema::_singular_monikers to directory /,
- qr/Schema dump completed/,
- ],
regexes => {
Foo => [
qr/\n=head1 NAME\n\nDBICTest::Schema::_singular_monikers::Foo\n\n=cut\n\n/,
classname => 'DBICTest::Schema::_preserve_monikers',
test_db_class => 'make_dbictest_db_plural_tables',
options => { naming => { monikers => 'preserve' } },
- warnings => [
- qr/Dumping manual schema for DBICTest::Schema::_preserve_monikers to directory /,
- qr/Schema dump completed/,
- ],
regexes => {
Foos => [
qr/\n=head1 NAME\n\nDBICTest::Schema::_preserve_monikers::Foos\n\n=cut\n\n/,
$t->cleanup;
-# test out the POD
+# test out the POD and "use utf8;"
$t->dump_test(
classname => 'DBICTest::DumpMore::1',
options => {
left_base_classes => 'TestLeftBase',
components => [ 'TestComponent', '+TestComponentFQN' ],
},
- warnings => [
- qr/Dumping manual schema for DBICTest::DumpMore::1 to directory /,
- qr/Schema dump completed/,
- ],
regexes => {
schema => [
+ qr/^use utf8;\n/,
qr/package DBICTest::DumpMore::1;/,
qr/->load_classes/,
],
Foo => [
+ qr/^use utf8;\n/,
qr/package DBICTest::DumpMore::1::Foo;/,
qr/\n=head1 NAME\n\nDBICTest::DumpMore::1::Foo\n\n=cut\n\nuse strict;\nuse warnings;\n\n/,
qr/\n=head1 BASE CLASS: L<My::ResultBaseClass>\n\n=cut\n\nuse base 'My::ResultBaseClass';\n\n/,
qr/1;\n$/,
],
Bar => [
+ qr/^use utf8;\n/,
qr/package DBICTest::DumpMore::1::Bar;/,
qr/\n=head1 NAME\n\nDBICTest::DumpMore::1::Bar\n\n=cut\n\nuse strict;\nuse warnings;\n\n/,
qr/\n=head1 BASE CLASS: L<My::ResultBaseClass>\n\n=cut\n\nuse base 'My::ResultBaseClass';\n\n/,
$t->dump_test(
classname => 'DBICTest::DumpMore::1',
- warnings => [
- qr/Dumping manual schema for DBICTest::DumpMore::1 to directory /,
- qr/Schema dump completed/,
- ],
regexes => {
schema => [
qr/package DBICTest::DumpMore::1;/,
options => {
really_erase_my_files => 1
},
- warnings => [
- qr/Dumping manual schema for DBICTest::DumpMore::1 to directory /,
- qr/Deleting existing file /,
- qr/Deleting existing file /,
- qr/Deleting existing file /,
- qr/Schema dump completed/,
- ],
regexes => {
schema => [
qr/package DBICTest::DumpMore::1;/,
use_namespaces => 1,
generate_pod => 0
},
- warnings => [
- qr/Dumping manual schema for DBICTest::DumpMore::1 to directory /,
- qr/Schema dump completed/,
- ],
neg_regexes => {
'Result/Foo' => [
qr/^=/m,
use_namespaces => 1
},
warnings => [
- qr/Dumping manual schema for DBICTest::DumpMore::1 to directory /,
- qr/Schema dump completed/,
+ qr/^db_schema is not supported on SQLite/,
],
regexes => {
'Result/Foo' => [
},
);
+# test qualify_objects
$t->dump_test(
classname => 'DBICTest::DumpMore::1',
options => {
- use_namespaces => 1
+ db_schema => [ 'foo_schema', 'bar_schema' ],
+ qualify_objects => 0,
+ use_namespaces => 1,
+ },
+ warnings => [
+ qr/^db_schema is not supported on SQLite/,
+ ],
+ regexes => {
+ 'Result/Foo' => [
+ # the table name should not include the db schema
+ qr/^\Q__PACKAGE__->table("foo");\E/m,
+ ],
+ 'Result/Bar' => [
+ # the table name should not include the db schema
+ qr/^\Q__PACKAGE__->table("bar");\E/m,
+ ],
+ },
+);
+
+# test moniker_parts
+$t->dump_test(
+ classname => 'DBICTest::DumpMore::1',
+ options => {
+ db_schema => 'my_schema',
+ moniker_parts => ['_schema', 'name'],
+ qualify_objects => 1,
+ use_namespaces => 1,
},
warnings => [
- qr/Dumping manual schema for DBICTest::DumpMore::1 to directory /,
- qr/Schema dump completed/,
+ qr/^db_schema is not supported on SQLite/,
],
regexes => {
+ 'Result/MySchemaFoo' => [
+ qr/^\Q__PACKAGE__->table("my_schema.foo");\E/m,
+ # the has_many relname should not have the schema in it!
+ qr/^__PACKAGE__->has_many\(\n "bars"/m,
+ ],
+ },
+);
+
+$t->dump_test(
+ classname => 'DBICTest::DumpMore::1',
+ options => {
+ use_namespaces => 1
+ },
+ regexes => {
schema => [
qr/package DBICTest::DumpMore::1;/,
qr/->load_namespaces/,
resultset_namespace => 'RSet',
default_resultset_class => 'RSetBase',
},
- warnings => [
- qr/Dumping manual schema for DBICTest::DumpMore::1 to directory /,
- qr/Schema dump completed/,
- ],
regexes => {
schema => [
qr/package DBICTest::DumpMore::1;/,
result_base_class => 'My::ResultBaseClass',
schema_base_class => 'My::SchemaBaseClass',
},
- warnings => [
- qr/Dumping manual schema for DBICTest::DumpMore::1 to directory /,
- qr/Schema dump completed/,
- ],
regexes => {
schema => [
qr/package DBICTest::DumpMore::1;/,
},
);
-
$t->dump_test(
classname => 'DBICTest::DumpMore::1',
options => {
'',
{ quote_char => '"' },
],
- warnings => [
- qr/Dumping manual schema for DBICTest::DumpMore::1 to directory /,
- qr/Schema dump completed/,
- ],
+);
+
+# test fix for RT#70507 (end comment and 1; gets lost if left with actual
+# custom content)
+
+$t->dump_test(
+ classname => 'DBICTest::DumpMore::Upgrade',
+ options => {
+ use_namespaces => 0,
+ },
+);
+
+my $file = $t->class_file('DBICTest::DumpMore::Upgrade::Foo');
+
+my $code = slurp_file $file;
+
+$code =~ s/(?=# You can replace)/sub custom_method { 'custom_method works' }\n0;\n\n/;
+
+write_file $file, $code;
+
+$t->dump_test(
+ classname => 'DBICTest::DumpMore::Upgrade',
+ options => {
+ use_namespaces => 1,
+ },
+ regexes => {
+ 'Result/Foo' => [
+ qr/sub custom_method { 'custom_method works' }\n0;\n\n# You can replace.*\n1;\n\z/,
+ ],
+ },
);
done_testing;