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
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
|
--TEST--
PDO PgSQL pgsqlCopyToArray and pgsqlCopyToFile
--EXTENSIONS--
pdo
pdo_pgsql
--SKIPIF--
<?php
require __DIR__ . '/config.inc';
require __DIR__ . '/../../../ext/pdo/tests/pdo_test.inc';
PDOTest::skip();
?>
--FILE--
<?php
require __DIR__ . '/../../../ext/pdo/tests/pdo_test.inc';
$db = PDOTest::test_factory(__DIR__ . '/common.phpt');
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false);
$db->exec('CREATE TABLE test_copy_to (a integer not null primary key, b text, c integer)');
$db->beginTransaction();
echo "Preparing test table for CopyTo tests\n";
$stmt = $db->prepare("INSERT INTO test_copy_to (a, b, c) values (?, ?, ?)");
for($i=0;$i<3;$i++) {
$firstParameter = $i;
$secondParameter = "test insert {$i}";
$thirdParameter = NULL;
$stmt->bindValue(1, $firstParameter);
$stmt->bindValue(2, $secondParameter);
$stmt->bindValue(3, $thirdParameter);
$stmt->execute();
}
$db->commit();
echo "Testing pgsqlCopyToArray() with default parameters\n";
var_dump($db->pgsqlCopyToArray('test_copy_to'));
echo "Testing pgsqlCopyToArray() with different field separator and not null indicator\n";
var_dump($db->pgsqlCopyToArray('test_copy_to',";","NULL"));
echo "Testing pgsqlCopyToArray() with only selected fields\n";
var_dump($db->pgsqlCopyToArray('test_copy_to',";","NULL",'a,c'));
echo "Testing pgsqlCopyToArray() with error\n";
try {
var_dump($db->pgsqlCopyToArray('test_error'));
} catch (Exception $e) {
echo "Exception: {$e->getMessage()}\n";
}
echo "Testing pgsqlCopyToFile() with default parameters\n";
$filename="test_pgsqlCopyToFile.csv";
var_dump($db->pgsqlCopyToFile('test_copy_to',$filename));
echo file_get_contents($filename);
echo "Testing pgsqlCopyToFile() with different field separator and not null indicator\n";
var_dump($db->pgsqlCopyToFile('test_copy_to',$filename,";","NULL"));
echo file_get_contents($filename);
echo "Testing pgsqlCopyToFile() with only selected fields\n";
var_dump($db->pgsqlCopyToFile('test_copy_to',$filename,";","NULL",'a,c'));
echo file_get_contents($filename);
echo "Testing pgsqlCopyToFile() with error\n";
try {
var_dump($db->pgsqlCopyToFile('test_error',$filename));
} catch (Exception $e) {
echo "Exception: {$e->getMessage()}\n";
}
echo "Testing pgsqlCopyToFile() to unwritable file\n";
try {
var_dump($db->pgsqlCopyToFile('test_copy_to', 'nonexistent/foo.csv'));
} catch (Exception $e) {
echo "Exception: {$e->getMessage()}\n";
}
if(isset($filename)) {
@unlink($filename);
}
?>
--CLEAN--
<?php
require __DIR__ . '/../../../ext/pdo/tests/pdo_test.inc';
$db = PDOTest::test_factory(__DIR__ . '/common.phpt');
$db->exec('DROP TABLE test_copy_to');
?>
--EXPECTF--
Preparing test table for CopyTo tests
Testing pgsqlCopyToArray() with default parameters
array(3) {
[0]=>
string(19) "0 test insert 0 \N
"
[1]=>
string(19) "1 test insert 1 \N
"
[2]=>
string(19) "2 test insert 2 \N
"
}
Testing pgsqlCopyToArray() with different field separator and not null indicator
array(3) {
[0]=>
string(21) "0;test insert 0;NULL
"
[1]=>
string(21) "1;test insert 1;NULL
"
[2]=>
string(21) "2;test insert 2;NULL
"
}
Testing pgsqlCopyToArray() with only selected fields
array(3) {
[0]=>
string(7) "0;NULL
"
[1]=>
string(7) "1;NULL
"
[2]=>
string(7) "2;NULL
"
}
Testing pgsqlCopyToArray() with error
Exception: SQLSTATE[42P01]: Undefined table: 7 %s: %stest_error%s
Testing pgsqlCopyToFile() with default parameters
bool(true)
0 test insert 0 \N
1 test insert 1 \N
2 test insert 2 \N
Testing pgsqlCopyToFile() with different field separator and not null indicator
bool(true)
0;test insert 0;NULL
1;test insert 1;NULL
2;test insert 2;NULL
Testing pgsqlCopyToFile() with only selected fields
bool(true)
0;NULL
1;NULL
2;NULL
Testing pgsqlCopyToFile() with error
Exception: SQLSTATE[42P01]: Undefined table: 7 %s: %stest_error%s
Testing pgsqlCopyToFile() to unwritable file
Exception: SQLSTATE[HY000]: General error: 7 Unable to open the file for writing
|
