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
65
66
67
68
69
70
71
72
73
|
#!/usr/bin/perl
BEGIN {
die "The PERCONA_TOOLKIT_BRANCH environment variable is not set.\n"
unless $ENV{PERCONA_TOOLKIT_BRANCH} && -d $ENV{PERCONA_TOOLKIT_BRANCH};
unshift @INC, "$ENV{PERCONA_TOOLKIT_BRANCH}/lib";
};
use strict;
use warnings FATAL => 'all';
use English qw(-no_match_vars);
use Test::More tests => 2;
use Outfile;
use DSNParser;
use Sandbox;
use PerconaTest;
# This is just for grabbing stuff from fetchrow_arrayref()
# instead of writing test rows by hand.
my $dp = new DSNParser(opts=>$dsn_opts);
my $sb = new Sandbox(basedir => '/tmp', DSNParser => $dp);
my $dbh = $sb->get_dbh_for('master');
my $outfile = new Outfile();
sub test_outfile {
my ( $rows, $expected_output ) = @_;
my $tmp_file = '/tmp/Outfile-output.txt';
open my $fh, '>', $tmp_file or die "Cannot open $tmp_file: $OS_ERROR";
$outfile->write($fh, $rows);
close $fh;
my $retval = system("diff $tmp_file $expected_output");
`rm -rf $tmp_file`;
$retval = $retval >> 8;
return !$retval;
}
ok(
test_outfile(
[
[
'1',
'a',
'some text',
'3.14',
'5.08',
'Here\'s more complex text that has "quotes", and maybe a comma.',
'2009-08-19 08:48:08',
'2009-08-19 08:48:08'
],
[
'2',
'',
'the char and text are blank, the',
undef,
'5.09',
'',
'2009-08-19 08:49:17',
'2009-08-19 08:49:17'
]
],
"$trunk/t/lib/samples/outfile001.txt",
),
'outfile001.txt'
);
# #############################################################################
# Done.
# #############################################################################
ok($sb->ok(), "Sandbox servers") or BAIL_OUT(__FILE__ . " broke the sandbox");
exit;
|
