1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
|
#!/usr/bin/perl -w
use strict;
use File::Spec;
use lib '.', File::Spec->catdir( File::Spec->curdir, 't', 'lib' );
use Alzabo::Test::Utils;
use Test::More;
my @rdbms_names = Alzabo::Test::Utils->rdbms_names;
unless (@rdbms_names)
{
plan skip_all => 'no test config provided';
exit;
}
my $tests_per_run = 2;
plan tests => $tests_per_run * @rdbms_names;
Alzabo::Test::Utils->remove_all_schemas;
foreach my $rdbms (@rdbms_names)
{
Test::More::diag( "Running $rdbms reverse engineering tests" );
my $s1 = Alzabo::Test::Utils->make_schema($rdbms);
my $config = Alzabo::Test::Utils->test_config_for($rdbms);
delete $config->{schema_name};
$config->{name} = $s1->name;
$config->{rdbms} = $s1->driver->driver_id;
my $s2;
eval_ok( sub { $s2 = Alzabo::Create::Schema->reverse_engineer(%$config) },
"Reverse engineer the @{[$s1->name]} schema with @{[$s1->driver->driver_id]}" );
if ( ref $s2 )
{
my @diff = $s1->rules->schema_sql_diff( old => $s1,
new => $s2 );
my $sql = join "\n", @diff;
is ( $sql, '',
"Reverse engineered schema's SQL should be the same as the original's" );
$s1->delete;
}
else
{
ok( 0, "Reverse engineering failed, cannot do diff" );
}
}
|
