1use strict; 2use warnings; 3 4use Test::More; 5use Test::Exception; 6use Test::Warn; 7 8BEGIN { 9 require DBIx::Class; 10 plan skip_all => 'Test needs ' . DBIx::Class::Optional::Dependencies->req_missing_for('admin') 11 unless DBIx::Class::Optional::Dependencies->req_ok_for('admin'); 12 13 plan skip_all => 'Test needs ' . DBIx::Class::Optional::Dependencies->req_missing_for('deploy') 14 unless DBIx::Class::Optional::Dependencies->req_ok_for('deploy'); 15} 16 17use lib qw(t/lib); 18use DBICTest; 19 20use Path::Class; 21 22use_ok 'DBIx::Class::Admin'; 23 24 25my $sql_dir = dir(qw/t var/); 26my @connect_info = DBICTest->_database( 27 no_deploy=>1, 28 no_populate=>1, 29 sqlite_use_file => 1, 30); 31{ # create the schema 32 33# make sure we are clean 34clean_dir($sql_dir); 35 36 37my $admin = DBIx::Class::Admin->new( 38 schema_class=> "DBICTest::Schema", 39 sql_dir=> $sql_dir, 40 connect_info => \@connect_info, 41); 42isa_ok ($admin, 'DBIx::Class::Admin', 'create the admin object'); 43lives_ok { $admin->create('MySQL'); } 'Can create MySQL sql'; 44lives_ok { $admin->create('SQLite'); } 'Can Create SQLite sql'; 45} 46 47{ # upgrade schema 48 49#my $schema = DBICTest->init_schema( 50# no_deploy => 1, 51# no_populat => 1, 52# sqlite_use_file => 1, 53#); 54 55clean_dir($sql_dir); 56require DBICVersion_v1; 57 58my $admin = DBIx::Class::Admin->new( 59 schema_class => 'DBICVersion::Schema', 60 sql_dir => $sql_dir, 61 connect_info => \@connect_info, 62); 63 64my $schema = $admin->schema(); 65 66lives_ok { $admin->create($schema->storage->sqlt_type(), {add_drop_table=>0}); } 'Can create DBICVersionOrig sql in ' . $schema->storage->sqlt_type; 67lives_ok { $admin->deploy( ) } 'Can Deploy schema'; 68 69# connect to now deployed schema 70lives_ok { $schema = DBICVersion::Schema->connect(@{$schema->storage->connect_info()}); } 'Connect to deployed Database'; 71 72is($schema->get_db_version, $DBICVersion::Schema::VERSION, 'Schema deployed and versions match'); 73 74 75require DBICVersion_v2; 76 77$admin = DBIx::Class::Admin->new( 78 schema_class => 'DBICVersion::Schema', 79 sql_dir => $sql_dir, 80 connect_info => \@connect_info 81); 82 83lives_ok { $admin->create($schema->storage->sqlt_type(), {}, "1.0" ); } 'Can create diff for ' . $schema->storage->sqlt_type; 84{ 85 local $SIG{__WARN__} = sub { warn $_[0] unless $_[0] =~ /DB version .+? is lower than the schema version/ }; 86 lives_ok {$admin->upgrade();} 'upgrade the schema'; 87} 88 89is($schema->get_db_version, $DBICVersion::Schema::VERSION, 'Schema and db versions match'); 90 91} 92 93{ # install 94 95clean_dir($sql_dir); 96 97my $admin = DBIx::Class::Admin->new( 98 schema_class => 'DBICVersion::Schema', 99 sql_dir => $sql_dir, 100 _confirm => 1, 101 connect_info => \@connect_info, 102); 103 104$admin->version("3.0"); 105lives_ok { $admin->install(); } 'install schema version 3.0'; 106is($admin->schema->get_db_version, "3.0", 'db thinks its version 3.0'); 107dies_ok { $admin->install("4.0"); } 'cannot install to allready existing version'; 108 109$admin->force(1); 110warnings_exist ( sub { 111 lives_ok { $admin->install("4.0") } 'can force install to allready existing version' 112}, qr/Forcing install may not be a good idea/, 'Force warning emitted' ); 113is($admin->schema->get_db_version, "4.0", 'db thinks its version 4.0'); 114#clean_dir($sql_dir); 115} 116 117sub clean_dir { 118 my ($dir) = @_; 119 $dir = $dir->resolve; 120 if ( ! -d $dir ) { 121 $dir->mkpath(); 122 } 123 foreach my $file ($dir->children) { 124 # skip any hidden files 125 next if ($file =~ /^\./); 126 unlink $file; 127 } 128} 129 130done_testing; 131