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
|
--TEST--
PDO PgSQL pgsqlCopyToArray and pgsqlCopyToFile
--SKIPIF--
<?php # vim:se ft=php:
if (!extension_loaded('pdo') || !extension_loaded('pdo_pgsql')) die('skip not loaded');
require dirname(__FILE__) . '/config.inc';
require dirname(__FILE__) . '/../../../ext/pdo/tests/pdo_test.inc';
PDOTest::skip();
?>
--FILE--
<?php
require dirname(__FILE__) . '/../../../ext/pdo/tests/pdo_test.inc';
$db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false);
$db->exec('CREATE TABLE test (a integer not null primary key, b text, c integer)');
$db->beginTransaction();
try {
echo "Preparing test table for CopyTo tests\n";
$stmt = $db->prepare("INSERT INTO test (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'));
echo "Testing pgsqlCopyToArray() with different field separator and not null indicator\n";
var_dump($db->pgsqlCopyToArray('test',";","NULL"));
echo "Testing pgsqlCopyToArray() with only selected fields\n";
var_dump($db->pgsqlCopyToArray('test',";","NULL",'a,c'));
echo "Testing pgsqlCopyToArray() with error\n";
var_dump($db->pgsqlCopyToArray('test_error'));
echo "Testing pgsqlCopyToFile() with default parameters\n";
$filename="test_pgsqlCopyToFile.csv";
var_dump($db->pgsqlCopyToFile('test',$filename));
echo file_get_contents($filename);
echo "Testing pgsqlCopyToFile() with different field separator and not null indicator\n";
var_dump($db->pgsqlCopyToFile('test',$filename,";","NULL"));
echo file_get_contents($filename);
echo "Testing pgsqlCopyToFile() with only selected fields\n";
var_dump($db->pgsqlCopyToFile('test',$filename,";","NULL",'a,c'));
echo file_get_contents($filename);
echo "Testing pgsqlCopyToFile() with error\n";
var_dump($db->pgsqlCopyToFile('test_error',$filename));
} catch (Exception $e) {
/* catch exceptions so that we can show the relative error */
echo "Exception! at line ", $e->getLine(), "\n";
var_dump($e->getMessage());
}
if(isset($filename)) {
@unlink($filename);
}
?>
--EXPECT--
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
bool(false)
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
bool(false)
|
