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
|
#!/usr/bin/perl
# vim: set ft=perl:
#
use strict;
use File::Spec::Functions qw(catfile tmpdir);
use File::Temp qw(tempfile);
use FindBin qw($Bin);
use SQL::Translator;
use Test::More;
use Test::SQL::Translator qw(maybe_plan);
# This aggravates me; XML::Writer produces tons of warnings.
local $SIG{__WARN__} = sub {
CORE::warn(@_)
unless $_[0] =~ m#XML/Writer#;
};
BEGIN {
maybe_plan(2,
'SQL::Translator::Parser::MySQL',
'SQL::Translator::Producer::XML::SQLFairy');
}
my @data = qw(data mysql BGEP-RE-create.sql);
my $test_data = (-d "t")
? catfile($Bin, @data)
: catfile($Bin, "t", @data);
my $tr = SQL::Translator->new(
parser => 'MySQL',
producer => 'XML-SQLFairy',
filename => $test_data
);
my $data = $tr->translate;
ok($data, "MySQL->XML-SQLFairy");
SKIP: {
eval {
require XML::Parser;
};
if ($@) {
skip "Can't load XML::Parser" => 1;
}
# Can't get XML::Parser::parsestring to do Useful Things
my ($fh, $fname) = tempfile('sqlfXXXX',
UNLINK => 1,
SUFFIX => '.xml',
DIR => tmpdir);
print $fh $data;
$fh->close;
ok(XML::Parser->new->parsefile($fname),
"Successfully parsed output");
}
|
