Test suite now is fully parallelizable
[dbsrgits/DBIx-Class-DeploymentHandler.git] / t / version_storages / standard.t
CommitLineData
02d58ac0 1#!perl
2
cbbd1b5f 3use strict;
4use warnings;
5
02d58ac0 6use Test::More;
7use Test::Exception;
8
9use lib 't/lib';
10use DBICDHTest;
3d3e2f00 11use aliased 'DBIx::Class::DeploymentHandler::VersionStorage::Standard';
c8a2f7bd 12use aliased 'DBIx::Class::DeploymentHandler::DeployMethod::SQL::Translator';
7b3d00f9 13use File::Temp 'tempdir';
02d58ac0 14
3d3e2f00 15use DBICVersion_v1;
16use DBIx::Class::DeploymentHandler;
f3b5161e 17my $dbh = DBICDHTest::dbh();
624e3018 18my @connection = (sub { $dbh }, { ignore_version => 1 });
7b3d00f9 19my $sql_dir = tempdir( CLEANUP => 1 );
3d3e2f00 20
21my $s = DBICVersion::Schema->connect(@connection);
c37d8797 22{
02a7b8ac 23 my $warning;
24 local $SIG{__WARN__} = sub {$warning = shift};
25 my $t = DBICVersion::Schema->connect('frewfrew', '', '');
26 like( $warning, qr/Your DB is currently unversioned. Please call upgrade on your schema to sync the DB/, 'warning when database is unversioned');
c37d8797 27}
28
c8a2f7bd 29my $dm = Translator->new({
02a7b8ac 30 schema => $s,
91adde75 31 script_directory => $sql_dir,
02a7b8ac 32 databases => ['SQLite'],
33 sql_translator_args => { add_drop_table => 0 },
3d3e2f00 34});
35
3d3e2f00 36my $vs = Standard->new({ schema => $s });
37
be140a5f 38$dm->prepare_resultsource_install({
39 result_source => $vs->version_rs->result_source
40});
c8a2f7bd 41
3d3e2f00 42ok( $vs, 'DBIC::DH::VersionStorage::Standard instantiates correctly' );
43
44ok( !$vs->version_storage_is_installed, 'VersionStorage is not yet installed' );
45
be140a5f 46$dm->install_resultsource({
47 result_source => $vs->version_rs->result_source,
48 version => '1.0',
49});
3d3e2f00 50
51ok( $vs->version_storage_is_installed, 'VersionStorage is now installed' );
52
53
c8a2f7bd 54$vs->add_database_version({
02a7b8ac 55 version => '1.0',
c8a2f7bd 56});
57
566925df 58ok(
02a7b8ac 59 eq_array(
60 [ $vs->version_rs->search(undef, {order_by => 'id'})->get_column('version')->all],
61 [ '1.0' ],
62 ),
63 'initial version works correctly'
3d3e2f00 64);
65
66is( $vs->database_version, '1.0', 'database version is 1.0');
67$vs->add_database_version({
02a7b8ac 68 version => '2.0',
3d3e2f00 69});
70is( $vs->database_version, '2.0', 'database version is 2.0');
71
566925df 72ok(
02a7b8ac 73 eq_array(
74 [ $vs->version_rs->search(undef, {order_by => 'id'})->get_column('version')->all],
75 [ '1.0', '2.0', ],
76 ),
77 'adding another version works correctly'
3d3e2f00 78);
79
624e3018 80my $u;
c37d8797 81{
02a7b8ac 82 my $warning;
83 local $SIG{__WARN__} = sub {$warning = shift};
624e3018 84 $u = DBICVersion::Schema->connect(sub { $dbh });
85 like( $warning, qr/Versions out of sync. This is 1\.0, your database contains version 2\.0, please call upgrade on your Schema\./, 'warning when database/schema mismatch');
c37d8797 86}
87
88
3d3e2f00 89$vs->version_rs->delete;
90
91ok( $vs->version_storage_is_installed, 'VersionStorage is still installed even if all versions are deleted' );
02d58ac0 92done_testing;