X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F94versioning.t;h=d9e2c415f78d42923c1bba1577d67e06a904730a;hb=95120bb5264aa779fa2da55be3b44f5cc9c08736;hp=3667c5282da200104f5a952f764b592dc3639b88;hpb=b4b1e91cbe7dfd356c74205e1c3393525b1f37d5;p=dbsrgits%2FDBIx-Class.git diff --git a/t/94versioning.t b/t/94versioning.t index 3667c52..d9e2c41 100644 --- a/t/94versioning.t +++ b/t/94versioning.t @@ -15,10 +15,10 @@ BEGIN { unless ($dsn); - eval "use DBD::mysql; use SQL::Translator 0.08;"; + eval "use DBD::mysql; use SQL::Translator 0.09;"; plan $@ - ? ( skip_all => 'needs DBD::mysql and SQL::Translator 0.08 for testing' ) - : ( tests => 13 ); + ? ( skip_all => 'needs DBD::mysql and SQL::Translator 0.09 for testing' ) + : ( tests => 17 ); } my $version_table_name = 'dbix_class_schema_versions'; @@ -27,17 +27,16 @@ my $old_table_name = 'SchemaVersions'; use lib qw(t/lib); use_ok('DBICVersionOrig'); -my $schema_orig = DBICVersion::Schema->connect($dsn, $user, $pass); +my $schema_orig = DBICVersion::Schema->connect($dsn, $user, $pass, { ignore_version => 1 }); eval { $schema_orig->storage->dbh->do('drop table ' . $version_table_name) }; eval { $schema_orig->storage->dbh->do('drop table ' . $old_table_name) }; -is($schema_orig->ddl_filename('MySQL', 't/var', '1.0'), File::Spec->catfile('t', 'var', 'DBICVersion-Schema-1.0-MySQL.sql'), 'Filename creation working'); +is($schema_orig->ddl_filename('MySQL', '1.0', 't/var'), File::Spec->catfile('t', 'var', 'DBICVersion-Schema-1.0-MySQL.sql'), 'Filename creation working'); unlink('t/var/DBICVersion-Schema-1.0-MySQL.sql') if (-e 't/var/DBICVersion-Schema-1.0-MySQL.sql'); $schema_orig->create_ddl_dir('MySQL', undef, 't/var'); ok(-f 't/var/DBICVersion-Schema-1.0-MySQL.sql', 'Created DDL file'); $schema_orig->deploy({ add_drop_table => 1 }); -$schema_orig->upgrade(); my $tvrs = $schema_orig->{vschema}->resultset('Table'); is($schema_orig->_source_exists($tvrs), 1, 'Created schema from DDL file'); @@ -47,7 +46,7 @@ eval "use DBICVersionNew"; unlink('t/var/DBICVersion-Schema-2.0-MySQL.sql'); unlink('t/var/DBICVersion-Schema-1.0-2.0-MySQL.sql'); - my $schema_upgrade = DBICVersion::Schema->connect($dsn, $user, $pass); + my $schema_upgrade = DBICVersion::Schema->connect($dsn, $user, $pass, { ignore_version => 1 }); is($schema_upgrade->get_db_version(), '1.0', 'get_db_version ok'); is($schema_upgrade->schema_version, '2.0', 'schema version ok'); $schema_upgrade->create_ddl_dir('MySQL', '2.0', 't/var', '1.0'); @@ -59,6 +58,9 @@ eval "use DBICVersionNew"; $schema_upgrade->storage->dbh->do('select NewVersionName from TestVersion'); }; is($@, '', 'new column created'); + + # should overwrite files + $schema_upgrade->create_ddl_dir('MySQL', '2.0', 't/var', '1.0'); } { @@ -83,3 +85,35 @@ eval "use DBICVersionNew"; ok($@, 'old version table gone'); } + +# check behaviour of DBIC_NO_VERSION_CHECK env var and ignore_version connect attr +{ + my $schema_version = DBICVersion::Schema->connect($dsn, $user, $pass); + eval { + $schema_version->storage->dbh->do("DELETE from $version_table_name"); + }; + + + my $warn = ''; + $SIG{__WARN__} = sub { $warn = shift }; + $schema_version = DBICVersion::Schema->connect($dsn, $user, $pass); + like($warn, qr/Your DB is currently unversioned/, 'warning detected without env var or attr'); + + + # should warn + $warn = ''; + $schema_version = DBICVersion::Schema->connect($dsn, $user, $pass, { ignore_version => 1 }); + is($warn, '', 'warning not detected with attr set'); + # should not warn + + $ENV{DBIC_NO_VERSION_CHECK} = 1; + $warn = ''; + $schema_version = DBICVersion::Schema->connect($dsn, $user, $pass); + is($warn, '', 'warning not detected with env var set'); + # should not warn + + $warn = ''; + $schema_version = DBICVersion::Schema->connect($dsn, $user, $pass, { ignore_version => 0 }); + like($warn, qr/Your DB is currently unversioned/, 'warning detected without env var or attr'); + # should warn +}