summaryrefslogtreecommitdiff
path: root/ext/pdo_pgsql
diff options
context:
space:
mode:
authorNikita Popov <nikita.ppv@gmail.com>2020-02-03 22:52:20 +0100
committerNikita Popov <nikita.ppv@gmail.com>2020-02-03 22:52:20 +0100
commitf8d795820e780a6322e054c26c581570613c14f0 (patch)
tree99d3ae01ce564752807341c5743863b4c92513f8 /ext/pdo_pgsql
parentd2cb200e10ada6fa44c54a29292bb4665728fff0 (diff)
downloadphp-git-f8d795820e780a6322e054c26c581570613c14f0.tar.gz
Reindent phpt files
Diffstat (limited to 'ext/pdo_pgsql')
-rw-r--r--ext/pdo_pgsql/tests/bug43925.phpt18
-rw-r--r--ext/pdo_pgsql/tests/bug46274.phpt2
-rw-r--r--ext/pdo_pgsql/tests/bug48764.phpt18
-rw-r--r--ext/pdo_pgsql/tests/bug66584.phpt30
-rw-r--r--ext/pdo_pgsql/tests/bug67462.phpt12
-rw-r--r--ext/pdo_pgsql/tests/bug68371.phpt84
-rw-r--r--ext/pdo_pgsql/tests/bug69344.phpt26
-rw-r--r--ext/pdo_pgsql/tests/bug70313.phpt12
-rw-r--r--ext/pdo_pgsql/tests/bug70861.phpt10
-rw-r--r--ext/pdo_pgsql/tests/bug71885.phpt20
-rw-r--r--ext/pdo_pgsql/tests/bug71885_2.phpt14
-rw-r--r--ext/pdo_pgsql/tests/bug72294.phpt24
-rw-r--r--ext/pdo_pgsql/tests/bug72570.phpt4
-rw-r--r--ext/pdo_pgsql/tests/bug75402.phpt20
-rw-r--r--ext/pdo_pgsql/tests/bug_33876.phpt40
-rw-r--r--ext/pdo_pgsql/tests/config.inc18
-rw-r--r--ext/pdo_pgsql/tests/copy_from.phpt36
-rw-r--r--ext/pdo_pgsql/tests/copy_to.phpt28
-rw-r--r--ext/pdo_pgsql/tests/disable_prepares.phpt4
-rw-r--r--ext/pdo_pgsql/tests/is_in_transaction.phpt14
-rw-r--r--ext/pdo_pgsql/tests/large_objects.phpt20
21 files changed, 227 insertions, 227 deletions
diff --git a/ext/pdo_pgsql/tests/bug43925.phpt b/ext/pdo_pgsql/tests/bug43925.phpt
index d90f36fbbc..20b1156de5 100644
--- a/ext/pdo_pgsql/tests/bug43925.phpt
+++ b/ext/pdo_pgsql/tests/bug43925.phpt
@@ -29,13 +29,13 @@ $dbh->query('INSERT INTO nodes (id, root, lft, rgt) VALUES (3, 1, 4, 5);');
$stmt = $dbh->prepare('
- SELECT *
- FROM nodes
- WHERE (:rootId > 0 OR lft > :left OR rgt > :left)
- AND (root = :rootId OR root = :left)
- AND (1 > :left OR 1 < :left OR 1 = :left)
- AND (:x > 0 OR :x < 10 OR :x > 100)
- OR :y = 1 OR :left = 1
+ SELECT *
+ FROM nodes
+ WHERE (:rootId > 0 OR lft > :left OR rgt > :left)
+ AND (root = :rootId OR root = :left)
+ AND (1 > :left OR 1 < :left OR 1 = :left)
+ AND (:x > 0 OR :x < 10 OR :x > 100)
+ OR :y = 1 OR :left = 1
');
$stmt->bindValue('left', 1, PDO::PARAM_INT);
@@ -46,8 +46,8 @@ $stmt->bindValue('y', 50, PDO::PARAM_INT);
$stmt->execute();
foreach ($stmt->fetchAll() as $row) {
- print implode(' - ', $row);
- print "\n";
+ print implode(' - ', $row);
+ print "\n";
}
$dbh->query('DROP TABLE nodes');
diff --git a/ext/pdo_pgsql/tests/bug46274.phpt b/ext/pdo_pgsql/tests/bug46274.phpt
index 0ae6849b41..9f3dbf0542 100644
--- a/ext/pdo_pgsql/tests/bug46274.phpt
+++ b/ext/pdo_pgsql/tests/bug46274.phpt
@@ -15,7 +15,7 @@ $db = PDOTest::test_factory(__DIR__ . '/common.phpt');
$db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
try {
- @$db->query("SET bytea_output = 'escape'");
+ @$db->query("SET bytea_output = 'escape'");
} catch (Exception $e) {
}
diff --git a/ext/pdo_pgsql/tests/bug48764.phpt b/ext/pdo_pgsql/tests/bug48764.phpt
index 1f890267e5..c1d6c6a74f 100644
--- a/ext/pdo_pgsql/tests/bug48764.phpt
+++ b/ext/pdo_pgsql/tests/bug48764.phpt
@@ -37,7 +37,7 @@ $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, 0);
bug($db);
putenv('PDOTEST_ATTR='.serialize(array(
- PDO::ATTR_EMULATE_PREPARES => 1,
+ PDO::ATTR_EMULATE_PREPARES => 1,
)));
$db = PDOTest::factory('PDO', false);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
@@ -50,14 +50,14 @@ putenv('PDOTEST_ATTR');
function bug($db, $options = array()) {
- try {
- $stmt = $db->prepare("SELECT ?", $options);
- $stmt->execute(array(1));
- echo "OK\n";
- } catch (PDOException $e) {
- // Indetermined data type when using native prepared statements
- echo $e->getCode()."\n";
- }
+ try {
+ $stmt = $db->prepare("SELECT ?", $options);
+ $stmt->execute(array(1));
+ echo "OK\n";
+ } catch (PDOException $e) {
+ // Indetermined data type when using native prepared statements
+ echo $e->getCode()."\n";
+ }
}
--EXPECT--
Test 1
diff --git a/ext/pdo_pgsql/tests/bug66584.phpt b/ext/pdo_pgsql/tests/bug66584.phpt
index 7c98046a30..4fc43d8817 100644
--- a/ext/pdo_pgsql/tests/bug66584.phpt
+++ b/ext/pdo_pgsql/tests/bug66584.phpt
@@ -21,24 +21,24 @@ $pdo->query("CREATE TABLE b66584 (a int)");
$pdo->query("INSERT INTO b66584 VALUES (165)");
for ($i = 1; $i >= 0; $i--) {
- $pdo->setAttribute(\PDO::ATTR_EMULATE_PREPARES, (bool)$i);
+ $pdo->setAttribute(\PDO::ATTR_EMULATE_PREPARES, (bool)$i);
- try {
- run($pdo, [0 => 1, 2 => 165, 5 => 3]);
- } catch (\Exception $e) {
- var_dump($e->getMessage());
- }
+ try {
+ run($pdo, [0 => 1, 2 => 165, 5 => 3]);
+ } catch (\Exception $e) {
+ var_dump($e->getMessage());
+ }
- try {
- run($pdo, json_decode('{"0":234,"1":165,"2":221,"3":207,"4":188,"5":216,"6":1150,"7":916,"8":967,"9":987,"10":951,"11":990,"12":959,"13":896,"14":947,"15":877,"16":1000,"17":1023,"18":904,"19":856,"20":860,"21":866,"22":930,"23":974,"24":1032,"25":1016,"26":1050,"27":1059,"28":1040,"29":1064,"30":1004,"31":214,"32":189,"33":166,"34":1002,"35":167,"36":191,"37":859,"38":204,"39":181,"40":1001,"42":208,"43":198,"44":177,"45":1003,"46":858,"47":190,"48":162,"49":210,"50":171,"51":197,"52":168,"53":194,"54":209,"55":200,"56":192,"57":180,"58":232,"59":222,"60":163,"61":196,"62":217,"64":176,"65":193,"66":172,"67":195,"68":170,"69":173,"70":233,"71":223,"72":218,"73":186,"74":175,"75":224,"76":205,"77":211,"78":235,"79":1101,"80":225,"81":236,"82":1102,"83":1164,"84":1083,"85":1005,"86":861,"87":1179,"88":960,"89":991,"90":1187,"91":880,"92":1149,"93":1033,"94":931,"95":1006,"96":862,"97":1151,"98":917,"99":881,"100":1148,"101":1065,"102":867,"103":952,"104":1152,"105":918,"106":961,"107":1180,"108":992,"109":1188,"110":932,"111":933,"112":968,"113":868,"114":882,"115":1147,"116":1017,"117":1131,"118":1174,"119":1178,"120":1186,"121":869,"122":1051,"123":934,"124":969,"125":975,"126":1066,"127":237,"128":953,"129":1024,"130":1146,"131":883,"132":1145,"133":884,"134":885,"135":1144,"136":886,"137":1143,"138":1025,"139":897,"140":898,"141":899,"142":1026,"143":1142,"144":887,"145":1141,"146":888,"147":889,"148":1140,"149":1189,"150":993,"151":1139,"152":890,"153":1138,"154":891,"155":900,"156":892,"157":1137,"158":1027,"159":901,"160":1136,"161":893,"162":870,"163":1052,"164":954,"165":1041,"166":1018,"167":1165,"168":1084,"169":962,"170":1181,"171":994,"172":1190,"173":1042,"174":935,"175":226,"176":871,"177":1191,"178":995,"179":977,"180":948,"181":1175,"182":1053,"183":955,"184":1182,"185":963,"186":1067,"187":919,"188":1153,"189":920,"190":1154,"191":1055,"192":1054,"193":1056,"194":863,"195":872,"196":1028,"197":921,"198":1155,"199":936,"200":970,"201":1019,"202":1166,"203":1085,"204":1135,"205":894,"206":1034,"207":905,"208":873,"209":937,"210":902,"211":1029,"212":1007,"213":864,"214":1043,"215":1057,"216":956,"217":957,"218":939,"219":1086,"220":1167,"221":1087,"222":1168,"223":1173,"224":1108,"225":978,"226":1044,"227":1183,"228":964,"229":965,"230":1184,"231":1045,"232":874,"233":940,"234":1046,"235":979,"236":903,"237":980,"238":1156,"239":922,"240":1035,"241":906,"242":971,"243":972,"244":878,"245":1134,"246":879,"247":1133,"248":907,"249":1036,"250":908,"251":1132,"252":895,"253":909,"254":1060,"255":981,"256":1068,"257":996,"258":1192,"259":941,"260":865,"261":1008,"262":910,"263":997,"264":1193,"265":982,"266":942,"267":1020,"268":983,"269":1061,"270":949,"271":1176,"272":875,"273":911,"274":1069,"275":1157,"276":923,"277":1158,"278":924,"279":988,"280":984,"281":925,"282":1159,"283":1062,"284":1047,"285":1194,"286":998,"287":1021,"288":1030,"289":1031,"290":1070,"291":1088,"292":1169,"293":958,"294":1195,"295":999,"296":966,"297":1185,"298":944,"299":945,"300":1022,"301":1103,"302":220,"303":1099,"304":1048,"305":927,"306":1161,"307":989,"308":973,"309":1071,"310":1074,"311":1072,"312":1073,"313":912,"314":1037,"315":913,"316":914,"317":1177,"318":950,"319":1049,"320":876,"321":985,"322":915,"323":1038,"324":946,"325":1089,"326":1170,"327":1090,"328":1171,"329":1091,"330":1172,"331":1063,"332":986,"333":928,"334":1162,"335":929,"336":1163,"337":976,"338":231,"339":201,"340":1098,"341":215}', true));
- } catch (\Exception $e) {
- var_dump($e->getMessage());
- }
+ try {
+ run($pdo, json_decode('{"0":234,"1":165,"2":221,"3":207,"4":188,"5":216,"6":1150,"7":916,"8":967,"9":987,"10":951,"11":990,"12":959,"13":896,"14":947,"15":877,"16":1000,"17":1023,"18":904,"19":856,"20":860,"21":866,"22":930,"23":974,"24":1032,"25":1016,"26":1050,"27":1059,"28":1040,"29":1064,"30":1004,"31":214,"32":189,"33":166,"34":1002,"35":167,"36":191,"37":859,"38":204,"39":181,"40":1001,"42":208,"43":198,"44":177,"45":1003,"46":858,"47":190,"48":162,"49":210,"50":171,"51":197,"52":168,"53":194,"54":209,"55":200,"56":192,"57":180,"58":232,"59":222,"60":163,"61":196,"62":217,"64":176,"65":193,"66":172,"67":195,"68":170,"69":173,"70":233,"71":223,"72":218,"73":186,"74":175,"75":224,"76":205,"77":211,"78":235,"79":1101,"80":225,"81":236,"82":1102,"83":1164,"84":1083,"85":1005,"86":861,"87":1179,"88":960,"89":991,"90":1187,"91":880,"92":1149,"93":1033,"94":931,"95":1006,"96":862,"97":1151,"98":917,"99":881,"100":1148,"101":1065,"102":867,"103":952,"104":1152,"105":918,"106":961,"107":1180,"108":992,"109":1188,"110":932,"111":933,"112":968,"113":868,"114":882,"115":1147,"116":1017,"117":1131,"118":1174,"119":1178,"120":1186,"121":869,"122":1051,"123":934,"124":969,"125":975,"126":1066,"127":237,"128":953,"129":1024,"130":1146,"131":883,"132":1145,"133":884,"134":885,"135":1144,"136":886,"137":1143,"138":1025,"139":897,"140":898,"141":899,"142":1026,"143":1142,"144":887,"145":1141,"146":888,"147":889,"148":1140,"149":1189,"150":993,"151":1139,"152":890,"153":1138,"154":891,"155":900,"156":892,"157":1137,"158":1027,"159":901,"160":1136,"161":893,"162":870,"163":1052,"164":954,"165":1041,"166":1018,"167":1165,"168":1084,"169":962,"170":1181,"171":994,"172":1190,"173":1042,"174":935,"175":226,"176":871,"177":1191,"178":995,"179":977,"180":948,"181":1175,"182":1053,"183":955,"184":1182,"185":963,"186":1067,"187":919,"188":1153,"189":920,"190":1154,"191":1055,"192":1054,"193":1056,"194":863,"195":872,"196":1028,"197":921,"198":1155,"199":936,"200":970,"201":1019,"202":1166,"203":1085,"204":1135,"205":894,"206":1034,"207":905,"208":873,"209":937,"210":902,"211":1029,"212":1007,"213":864,"214":1043,"215":1057,"216":956,"217":957,"218":939,"219":1086,"220":1167,"221":1087,"222":1168,"223":1173,"224":1108,"225":978,"226":1044,"227":1183,"228":964,"229":965,"230":1184,"231":1045,"232":874,"233":940,"234":1046,"235":979,"236":903,"237":980,"238":1156,"239":922,"240":1035,"241":906,"242":971,"243":972,"244":878,"245":1134,"246":879,"247":1133,"248":907,"249":1036,"250":908,"251":1132,"252":895,"253":909,"254":1060,"255":981,"256":1068,"257":996,"258":1192,"259":941,"260":865,"261":1008,"262":910,"263":997,"264":1193,"265":982,"266":942,"267":1020,"268":983,"269":1061,"270":949,"271":1176,"272":875,"273":911,"274":1069,"275":1157,"276":923,"277":1158,"278":924,"279":988,"280":984,"281":925,"282":1159,"283":1062,"284":1047,"285":1194,"286":998,"287":1021,"288":1030,"289":1031,"290":1070,"291":1088,"292":1169,"293":958,"294":1195,"295":999,"296":966,"297":1185,"298":944,"299":945,"300":1022,"301":1103,"302":220,"303":1099,"304":1048,"305":927,"306":1161,"307":989,"308":973,"309":1071,"310":1074,"311":1072,"312":1073,"313":912,"314":1037,"315":913,"316":914,"317":1177,"318":950,"319":1049,"320":876,"321":985,"322":915,"323":1038,"324":946,"325":1089,"326":1170,"327":1090,"328":1171,"329":1091,"330":1172,"331":1063,"332":986,"333":928,"334":1162,"335":929,"336":1163,"337":976,"338":231,"339":201,"340":1098,"341":215}', true));
+ } catch (\Exception $e) {
+ var_dump($e->getMessage());
+ }
}
try {
- $pdo->query("DROP TABLE b66584");
- $pdo->rollback();
+ $pdo->query("DROP TABLE b66584");
+ $pdo->rollback();
} catch (\Exception $e) {
}
@@ -48,11 +48,11 @@ function run($pdo, $data)
$stmt = $pdo->prepare("SELECT COUNT(*) FROM b66584 WHERE a IN ({$bind})");
- var_dump(count($data));
+ var_dump(count($data));
$stmt->execute($data);
- var_dump($stmt->fetchColumn());
+ var_dump($stmt->fetchColumn());
}
?>
diff --git a/ext/pdo_pgsql/tests/bug67462.phpt b/ext/pdo_pgsql/tests/bug67462.phpt
index 11a39a5f12..197bbb32ed 100644
--- a/ext/pdo_pgsql/tests/bug67462.phpt
+++ b/ext/pdo_pgsql/tests/bug67462.phpt
@@ -17,14 +17,14 @@ $pdo->setAttribute (\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
$pdo->beginTransaction();
try {
- $pdo->query("CREATE TABLE b67462 (a int NOT NULL PRIMARY KEY DEFERRABLE INITIALLY DEFERRED)");
- $pdo->query("INSERT INTO b67462 VALUES (1), (1)");
+ $pdo->query("CREATE TABLE b67462 (a int NOT NULL PRIMARY KEY DEFERRABLE INITIALLY DEFERRED)");
+ $pdo->query("INSERT INTO b67462 VALUES (1), (1)");
- var_dump($pdo->inTransaction());
- $pdo->commit(); // This should fail!
+ var_dump($pdo->inTransaction());
+ $pdo->commit(); // This should fail!
} catch (\Exception $e) {
- var_dump($pdo->inTransaction());
- var_dump($pdo->beginTransaction());
+ var_dump($pdo->inTransaction());
+ var_dump($pdo->beginTransaction());
}
?>
diff --git a/ext/pdo_pgsql/tests/bug68371.phpt b/ext/pdo_pgsql/tests/bug68371.phpt
index 24dc5f501f..8cbcc7179c 100644
--- a/ext/pdo_pgsql/tests/bug68371.phpt
+++ b/ext/pdo_pgsql/tests/bug68371.phpt
@@ -16,53 +16,53 @@ $pdo->setAttribute (\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
$attrs = array(
// Extensive test: default value and set+get values
- PDO::ATTR_EMULATE_PREPARES => array(null, true, false),
- PDO::PGSQL_ATTR_DISABLE_PREPARES => array(null, true, false),
+ PDO::ATTR_EMULATE_PREPARES => array(null, true, false),
+ PDO::PGSQL_ATTR_DISABLE_PREPARES => array(null, true, false),
// Just test the default
- PDO::ATTR_AUTOCOMMIT => array(null),
- PDO::ATTR_PREFETCH => array(null),
- PDO::ATTR_TIMEOUT => array(null),
- PDO::ATTR_ERRMODE => array(null),
- PDO::ATTR_SERVER_VERSION => array(null),
- PDO::ATTR_CLIENT_VERSION => array(null),
- PDO::ATTR_SERVER_INFO => array(null),
- PDO::ATTR_CONNECTION_STATUS => array(null),
- PDO::ATTR_CASE => array(null),
- PDO::ATTR_CURSOR_NAME => array(null),
- PDO::ATTR_CURSOR => array(null),
- PDO::ATTR_ORACLE_NULLS => array(null),
- PDO::ATTR_PERSISTENT => array(null),
- PDO::ATTR_STATEMENT_CLASS => array(null),
- PDO::ATTR_FETCH_TABLE_NAMES => array(null),
- PDO::ATTR_FETCH_CATALOG_NAMES => array(null),
- PDO::ATTR_DRIVER_NAME => array(null),
- PDO::ATTR_STRINGIFY_FETCHES => array(null),
- PDO::ATTR_MAX_COLUMN_LEN => array(null),
- PDO::ATTR_DEFAULT_FETCH_MODE => array(null),
+ PDO::ATTR_AUTOCOMMIT => array(null),
+ PDO::ATTR_PREFETCH => array(null),
+ PDO::ATTR_TIMEOUT => array(null),
+ PDO::ATTR_ERRMODE => array(null),
+ PDO::ATTR_SERVER_VERSION => array(null),
+ PDO::ATTR_CLIENT_VERSION => array(null),
+ PDO::ATTR_SERVER_INFO => array(null),
+ PDO::ATTR_CONNECTION_STATUS => array(null),
+ PDO::ATTR_CASE => array(null),
+ PDO::ATTR_CURSOR_NAME => array(null),
+ PDO::ATTR_CURSOR => array(null),
+ PDO::ATTR_ORACLE_NULLS => array(null),
+ PDO::ATTR_PERSISTENT => array(null),
+ PDO::ATTR_STATEMENT_CLASS => array(null),
+ PDO::ATTR_FETCH_TABLE_NAMES => array(null),
+ PDO::ATTR_FETCH_CATALOG_NAMES => array(null),
+ PDO::ATTR_DRIVER_NAME => array(null),
+ PDO::ATTR_STRINGIFY_FETCHES => array(null),
+ PDO::ATTR_MAX_COLUMN_LEN => array(null),
+ PDO::ATTR_DEFAULT_FETCH_MODE => array(null),
);
foreach ($attrs as $a => $vals) {
- foreach ($vals as $v) {
- try {
- if (!isset($v)) {
- var_dump($pdo->getAttribute($a));
- } else {
- $pdo->setAttribute($a, $v);
- if ($pdo->getAttribute($a) === $v) {
- echo "OK\n";
- } else {
- throw new \Exception('KO');
- }
- }
- } catch (\Exception $e) {
- if ($e->getCode() == 'IM001') {
- echo "ERR\n";
- } else {
- echo "ERR {$e->getMessage()}\n";
- }
- }
- }
+ foreach ($vals as $v) {
+ try {
+ if (!isset($v)) {
+ var_dump($pdo->getAttribute($a));
+ } else {
+ $pdo->setAttribute($a, $v);
+ if ($pdo->getAttribute($a) === $v) {
+ echo "OK\n";
+ } else {
+ throw new \Exception('KO');
+ }
+ }
+ } catch (\Exception $e) {
+ if ($e->getCode() == 'IM001') {
+ echo "ERR\n";
+ } else {
+ echo "ERR {$e->getMessage()}\n";
+ }
+ }
+ }
}
?>
diff --git a/ext/pdo_pgsql/tests/bug69344.phpt b/ext/pdo_pgsql/tests/bug69344.phpt
index 14d45d0ddb..f544518455 100644
--- a/ext/pdo_pgsql/tests/bug69344.phpt
+++ b/ext/pdo_pgsql/tests/bug69344.phpt
@@ -16,19 +16,19 @@ $pdo->setAttribute (\PDO::ATTR_ERRMODE, \PDO::ERRMODE_EXCEPTION);
$pdo->setAttribute (\PDO::ATTR_DEFAULT_FETCH_MODE, \PDO::FETCH_ASSOC);
$test = function () use ($pdo) {
- $arr = [
- 0 => "a",
- 2 => "b",
- ];
-
- $stmt = $pdo->prepare("SELECT (?)::text AS a, (?)::text AS b");
-
- try {
- $stmt->execute($arr);
- var_dump($stmt->fetch());
- } catch (\Exception $e) {
- echo $e->getMessage()."\n";
- }
+ $arr = [
+ 0 => "a",
+ 2 => "b",
+ ];
+
+ $stmt = $pdo->prepare("SELECT (?)::text AS a, (?)::text AS b");
+
+ try {
+ $stmt->execute($arr);
+ var_dump($stmt->fetch());
+ } catch (\Exception $e) {
+ echo $e->getMessage()."\n";
+ }
};
$test();
diff --git a/ext/pdo_pgsql/tests/bug70313.phpt b/ext/pdo_pgsql/tests/bug70313.phpt
index f734442f8c..07c7f68ab3 100644
--- a/ext/pdo_pgsql/tests/bug70313.phpt
+++ b/ext/pdo_pgsql/tests/bug70313.phpt
@@ -15,20 +15,20 @@ $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
try {
- $stmt = $db->prepare(");");
+ $stmt = $db->prepare(");");
- $stmt->execute([1]);
+ $stmt->execute([1]);
} catch (PDOException $e) {
- var_dump($e->getCode());
+ var_dump($e->getCode());
}
$db->setAttribute(PDO::ATTR_EMULATE_PREPARES, true);
try {
- $stmt = $db->prepare(");");
+ $stmt = $db->prepare(");");
- $stmt->execute([1]);
+ $stmt->execute([1]);
} catch (PDOException $e) {
- var_dump($e->getCode());
+ var_dump($e->getCode());
}
?>
diff --git a/ext/pdo_pgsql/tests/bug70861.phpt b/ext/pdo_pgsql/tests/bug70861.phpt
index 2da08e6e03..a7d1d1f9d6 100644
--- a/ext/pdo_pgsql/tests/bug70861.phpt
+++ b/ext/pdo_pgsql/tests/bug70861.phpt
@@ -15,7 +15,7 @@ $db = PDOTest::test_factory(__DIR__ . '/common.phpt');
$db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, true);
try {
- @$db->query("SET bytea_output = 'escape'");
+ @$db->query("SET bytea_output = 'escape'");
} catch (Exception $e) {
}
@@ -23,10 +23,10 @@ $db->query('DROP TABLE IF EXISTS test_blob_crash CASCADE');
$db->query('CREATE TABLE test_blob_crash (id SERIAL NOT NULL, blob1 BYTEA)');
class HelloWrapper {
- public function stream_open() { return true; }
- public function stream_eof() { return true; }
- public function stream_read() { return NULL; }
- public function stream_stat() { return array(); }
+ public function stream_open() { return true; }
+ public function stream_eof() { return true; }
+ public function stream_read() { return NULL; }
+ public function stream_stat() { return array(); }
}
stream_wrapper_register("hello", "HelloWrapper");
diff --git a/ext/pdo_pgsql/tests/bug71885.phpt b/ext/pdo_pgsql/tests/bug71885.phpt
index ea5b1882ff..f47ffcb444 100644
--- a/ext/pdo_pgsql/tests/bug71885.phpt
+++ b/ext/pdo_pgsql/tests/bug71885.phpt
@@ -16,19 +16,19 @@ $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_NUM);
foreach ([false, true] as $emulate) {
- $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, $emulate);
+ $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, $emulate);
- try {
- $stmt = $db->prepare('select ?- lseg \'((-1,0),(1,0))\'');
- $stmt->execute();
- } catch (PDOException $e) {
- var_dump('ERR');
- }
+ try {
+ $stmt = $db->prepare('select ?- lseg \'((-1,0),(1,0))\'');
+ $stmt->execute();
+ } catch (PDOException $e) {
+ var_dump('ERR');
+ }
- $stmt = $db->prepare('select ??- lseg \'((-1,0),(1,0))\'');
- $stmt->execute();
+ $stmt = $db->prepare('select ??- lseg \'((-1,0),(1,0))\'');
+ $stmt->execute();
- var_dump($stmt->fetch());
+ var_dump($stmt->fetch());
}
?>
diff --git a/ext/pdo_pgsql/tests/bug71885_2.phpt b/ext/pdo_pgsql/tests/bug71885_2.phpt
index f957a39610..452902ed38 100644
--- a/ext/pdo_pgsql/tests/bug71885_2.phpt
+++ b/ext/pdo_pgsql/tests/bug71885_2.phpt
@@ -25,15 +25,15 @@ $db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_NUM);
$jsonb = $db->quote(json_encode(['a' => 1]));
foreach ([false, true] as $emulate) {
- $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, $emulate);
+ $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, $emulate);
- $stmt = $db->prepare("SELECT {$jsonb}::jsonb ?? ?");
- $stmt->execute(['b']);
- var_dump($stmt->fetch());
+ $stmt = $db->prepare("SELECT {$jsonb}::jsonb ?? ?");
+ $stmt->execute(['b']);
+ var_dump($stmt->fetch());
- $stmt = $db->prepare("SELECT {$jsonb}::jsonb ???");
- $stmt->execute(['a']);
- var_dump($stmt->fetch());
+ $stmt = $db->prepare("SELECT {$jsonb}::jsonb ???");
+ $stmt->execute(['a']);
+ var_dump($stmt->fetch());
}
?>
diff --git a/ext/pdo_pgsql/tests/bug72294.phpt b/ext/pdo_pgsql/tests/bug72294.phpt
index bd5124ff17..6940fa8d1f 100644
--- a/ext/pdo_pgsql/tests/bug72294.phpt
+++ b/ext/pdo_pgsql/tests/bug72294.phpt
@@ -102,7 +102,7 @@ class PreparedStatementCache
//return $pdo->prepare( $sql );
$this->cached_statements[$sql] = $pdo->prepare( $sql );
- return $this->cached_statements[$sql];
+ return $this->cached_statements[$sql];
}
}
@@ -110,29 +110,29 @@ class DatabaseTest extends PHPUnit_Framework_TestCase
{
public function testIt()
{
- $pdo = PDOTest::test_factory(__DIR__ . '/common.phpt');
+ $pdo = PDOTest::test_factory(__DIR__ . '/common.phpt');
- $prepared_statement_cache = new PreparedStatementCache( $pdo );
+ $prepared_statement_cache = new PreparedStatementCache( $pdo );
- for( $i = 1; $i <= 300; ++$i ) {
- $statement = $prepared_statement_cache->prepare( $pdo, <<<SQL
+ for( $i = 1; $i <= 300; ++$i ) {
+ $statement = $prepared_statement_cache->prepare( $pdo, <<<SQL
SELECT $i;
SQL
- );
+ );
$statement->execute();
- }
+ }
}
public function test_construct()
{
- $pdo = PDOTest::test_factory(__DIR__ . '/common.phpt');
+ $pdo = PDOTest::test_factory(__DIR__ . '/common.phpt');
- $pdo->exec( 'CREATE TEMPORARY TABLE temp_table ( test_column INT NOT NULL );' );
+ $pdo->exec( 'CREATE TEMPORARY TABLE temp_table ( test_column INT NOT NULL );' );
- $this->cache = new PreparedStatementCache( $pdo );
+ $this->cache = new PreparedStatementCache( $pdo );
- $statement = $this->cache->prepare( $pdo, 'SELECT * FROM temp_table WHERE test_column > 0' );
- $statement->execute();
+ $statement = $this->cache->prepare( $pdo, 'SELECT * FROM temp_table WHERE test_column > 0' );
+ $statement->execute();
}
}
diff --git a/ext/pdo_pgsql/tests/bug72570.phpt b/ext/pdo_pgsql/tests/bug72570.phpt
index b479974484..1d5512f1f6 100644
--- a/ext/pdo_pgsql/tests/bug72570.phpt
+++ b/ext/pdo_pgsql/tests/bug72570.phpt
@@ -18,9 +18,9 @@ $db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
$stmt = $db->prepare("SELECT 1");
try {
- var_dump($stmt->execute([1]));
+ var_dump($stmt->execute([1]));
} catch (PDOException $e) {
- var_dump($e->getCode());
+ var_dump($e->getCode());
}
?>
diff --git a/ext/pdo_pgsql/tests/bug75402.phpt b/ext/pdo_pgsql/tests/bug75402.phpt
index 9c7460b871..52ae4df957 100644
--- a/ext/pdo_pgsql/tests/bug75402.phpt
+++ b/ext/pdo_pgsql/tests/bug75402.phpt
@@ -46,7 +46,7 @@ $db->query("INSERT INTO bug75402 (\"id\", \"group_id\", \"submitter\", \"operati
-$sql = "SELECT
+$sql = "SELECT
ID as \"sID\",
GROUP_ID as \"sGroupID\",
SUBMITTER as \"sOwner\",
@@ -56,19 +56,19 @@ $sql = "SELECT
STATUS as \"sStatus\",
PROGRESS as \"sProgress\",
HIDDEN as \"bHidden\",
- to_char(INSERT_DATETIME, 'IYYY.MM.DD HH24:MI:SS') as \"sDatetime\"
- FROM bug75402
+ to_char(INSERT_DATETIME, 'IYYY.MM.DD HH24:MI:SS') as \"sDatetime\"
+ FROM bug75402
ORDER BY INSERT_DATETIME DESC";
if ($db) {
$stmt = $db->prepare($sql,
- array(
- // With the following options memory is not being
- // deallocated
- \PDO::ATTR_CURSOR => \PDO::CURSOR_SCROLL
- // With the following option memory is de-allocated
- // \PDO::ATTR_CURSOR => \PDO::CURSOR_FWDONLY
- )
+ array(
+ // With the following options memory is not being
+ // deallocated
+ \PDO::ATTR_CURSOR => \PDO::CURSOR_SCROLL
+ // With the following option memory is de-allocated
+ // \PDO::ATTR_CURSOR => \PDO::CURSOR_FWDONLY
+ )
);
$stmt->execute();
diff --git a/ext/pdo_pgsql/tests/bug_33876.phpt b/ext/pdo_pgsql/tests/bug_33876.phpt
index dc213f6abb..a425f6d9f6 100644
--- a/ext/pdo_pgsql/tests/bug_33876.phpt
+++ b/ext/pdo_pgsql/tests/bug_33876.phpt
@@ -23,70 +23,70 @@ $res = $db->prepare('SELECT foo from test where bar = ?');
# this is the portable approach to binding a bool
$res->bindValue(1, false, PDO::PARAM_BOOL);
if (!$res->execute())
- print_r($res->errorInfo());
+ print_r($res->errorInfo());
else
- print_r($res->fetchAll(PDO::FETCH_ASSOC));
+ print_r($res->fetchAll(PDO::FETCH_ASSOC));
# this is the portable approach to binding a bool
$res->bindValue(1, true, PDO::PARAM_BOOL);
if (!$res->execute())
- print_r($res->errorInfo());
+ print_r($res->errorInfo());
else
- print_r($res->fetchAll(PDO::FETCH_ASSOC));
+ print_r($res->fetchAll(PDO::FETCH_ASSOC));
# true gets cast to string (because the implied default is string)
# true-as-string is 1, so this "works"
if (!$res->execute(array(true)))
- print_r($res->errorInfo());
+ print_r($res->errorInfo());
else
- print_r($res->fetchAll(PDO::FETCH_ASSOC));
+ print_r($res->fetchAll(PDO::FETCH_ASSOC));
# Expected to fail; unless told otherwise, PDO assumes string inputs
# false -> "" as string, which pgsql doesn't like
if (!$res->execute(array(false)))
- print_r($res->errorInfo());
+ print_r($res->errorInfo());
else
- print_r($res->fetchAll(PDO::FETCH_ASSOC));
+ print_r($res->fetchAll(PDO::FETCH_ASSOC));
# And now using emulator prepares
echo "EMUL\n";
$res = $db->prepare('SELECT foo from test where bar = ?', array(
- PDO::ATTR_EMULATE_PREPARES => true));
+ PDO::ATTR_EMULATE_PREPARES => true));
# this is the portable approach to binding a bool
$res->bindValue(1, false, PDO::PARAM_BOOL);
if (!$res->execute())
- print_r($res->errorInfo());
+ print_r($res->errorInfo());
else
- print_r($res->fetchAll(PDO::FETCH_ASSOC));
+ print_r($res->fetchAll(PDO::FETCH_ASSOC));
# this is the portable approach to binding a bool
$res->bindValue(1, true, PDO::PARAM_BOOL);
if (!$res->execute())
- print_r($res->errorInfo());
+ print_r($res->errorInfo());
else
- print_r($res->fetchAll(PDO::FETCH_ASSOC));
+ print_r($res->fetchAll(PDO::FETCH_ASSOC));
# true gets cast to string (because the implied default is string)
# true-as-string is 1, so this "works"
if (!$res->execute(array(true)))
- print_r($res->errorInfo());
+ print_r($res->errorInfo());
else
- print_r($res->fetchAll(PDO::FETCH_ASSOC));
+ print_r($res->fetchAll(PDO::FETCH_ASSOC));
# Expected to fail; unless told otherwise, PDO assumes string inputs
# false -> "" as string, which pgsql doesn't like
if (!$res->execute(array(false))) {
- $err = $res->errorInfo();
- // Strip additional lines outputted by recent PgSQL versions
- $err[2] = trim(current(explode("\n", $err[2])));
- print_r($err);
+ $err = $res->errorInfo();
+ // Strip additional lines outputted by recent PgSQL versions
+ $err[2] = trim(current(explode("\n", $err[2])));
+ print_r($err);
} else {
- print_r($res->fetchAll(PDO::FETCH_ASSOC));
+ print_r($res->fetchAll(PDO::FETCH_ASSOC));
}
--EXPECTF--
Array
diff --git a/ext/pdo_pgsql/tests/config.inc b/ext/pdo_pgsql/tests/config.inc
index 0fefe4664b..367671e42a 100644
--- a/ext/pdo_pgsql/tests/config.inc
+++ b/ext/pdo_pgsql/tests/config.inc
@@ -1,16 +1,16 @@
<?php
if (false !== getenv('PDO_PGSQL_TEST_DSN')) {
- # user set them from their shell
- $config['ENV']['PDOTEST_DSN'] = getenv('PDO_PGSQL_TEST_DSN');
- if (false !== getenv('PDO_PGSQL_TEST_ATTR')) {
- $config['ENV']['PDOTEST_ATTR'] = getenv('PDO_PGSQL_TEST_ATTR');
- }
+ # user set them from their shell
+ $config['ENV']['PDOTEST_DSN'] = getenv('PDO_PGSQL_TEST_DSN');
+ if (false !== getenv('PDO_PGSQL_TEST_ATTR')) {
+ $config['ENV']['PDOTEST_ATTR'] = getenv('PDO_PGSQL_TEST_ATTR');
+ }
} else {
- $config['ENV']['PDOTEST_DSN'] = 'pgsql:host=localhost port=5432 dbname=test user=postgres password=postgres';
- $config['ENV']['PDOTEST_USER'] = 'postgres';
- $config['ENV']['PDOTEST_PASS'] = 'postgres';
+ $config['ENV']['PDOTEST_DSN'] = 'pgsql:host=localhost port=5432 dbname=test user=postgres password=postgres';
+ $config['ENV']['PDOTEST_USER'] = 'postgres';
+ $config['ENV']['PDOTEST_PASS'] = 'postgres';
}
foreach ($config['ENV'] as $k => $v) {
- putenv("$k=$v");
+ putenv("$k=$v");
}
diff --git a/ext/pdo_pgsql/tests/copy_from.phpt b/ext/pdo_pgsql/tests/copy_from.phpt
index 55a9df72aa..b57a8ea9ae 100644
--- a/ext/pdo_pgsql/tests/copy_from.phpt
+++ b/ext/pdo_pgsql/tests/copy_from.phpt
@@ -22,11 +22,11 @@ $tableRows = array();
$tableRowsWithDifferentNullValues = array();
for($i=0;$i<3;$i++) {
- $firstParameter = $i;
- $secondParameter = "test insert {$i}";
- $tableRows[] = "{$firstParameter}\t{$secondParameter}\t\\N";
- $tableRowsWithDifferentNullValues[] = "{$firstParameter};{$secondParameter};NULL";
- $tableRowsWithDifferentNullValuesAndSelectedFields[] = "{$firstParameter};NULL";
+ $firstParameter = $i;
+ $secondParameter = "test insert {$i}";
+ $tableRows[] = "{$firstParameter}\t{$secondParameter}\t\\N";
+ $tableRowsWithDifferentNullValues[] = "{$firstParameter};{$secondParameter};NULL";
+ $tableRowsWithDifferentNullValuesAndSelectedFields[] = "{$firstParameter};NULL";
}
$filename = 'test_pgsqlCopyFromFile.csv';
$filenameWithDifferentNullValues = 'test_pgsqlCopyFromFileWithDifferentNullValues.csv';
@@ -42,7 +42,7 @@ var_dump($db->pgsqlCopyFromArray('test',$tableRows));
$stmt = $db->query("select * from test");
foreach($stmt as $r) {
- var_dump($r);
+ var_dump($r);
}
$db->rollback();
@@ -51,7 +51,7 @@ $db->beginTransaction();
var_dump($db->pgsqlCopyFromArray('test',$tableRowsWithDifferentNullValues,";","NULL"));
$stmt = $db->query("select * from test");
foreach($stmt as $r) {
- var_dump($r);
+ var_dump($r);
}
$db->rollback();
@@ -60,16 +60,16 @@ $db->beginTransaction();
var_dump($db->pgsqlCopyFromArray('test',$tableRowsWithDifferentNullValuesAndSelectedFields,";","NULL",'a,c'));
$stmt = $db->query("select * from test");
foreach($stmt as $r) {
- var_dump($r);
+ var_dump($r);
}
$db->rollback();
echo "Testing pgsqlCopyFromArray() with error\n";
$db->beginTransaction();
try {
- var_dump($db->pgsqlCopyFromArray('test_error',$tableRowsWithDifferentNullValuesAndSelectedFields,";","NULL",'a,c'));
+ var_dump($db->pgsqlCopyFromArray('test_error',$tableRowsWithDifferentNullValuesAndSelectedFields,";","NULL",'a,c'));
} catch (Exception $e) {
- echo "Exception: {$e->getMessage()}\n";
+ echo "Exception: {$e->getMessage()}\n";
}
$db->rollback();
@@ -79,7 +79,7 @@ var_dump($db->pgsqlCopyFromFile('test',$filename));
$stmt = $db->query("select * from test");
foreach($stmt as $r) {
- var_dump($r);
+ var_dump($r);
}
$db->rollback();
@@ -88,7 +88,7 @@ $db->beginTransaction();
var_dump($db->pgsqlCopyFromFile('test',$filenameWithDifferentNullValues,";","NULL"));
$stmt = $db->query("select * from test");
foreach($stmt as $r) {
- var_dump($r);
+ var_dump($r);
}
$db->rollback();
@@ -97,31 +97,31 @@ $db->beginTransaction();
var_dump($db->pgsqlCopyFromFile('test',$filenameWithDifferentNullValuesAndSelectedFields,";","NULL",'a,c'));
$stmt = $db->query("select * from test");
foreach($stmt as $r) {
- var_dump($r);
+ var_dump($r);
}
$db->rollback();
echo "Testing pgsqlCopyFromFile() with error\n";
$db->beginTransaction();
try {
- var_dump($db->pgsqlCopyFromFile('test_error',$filenameWithDifferentNullValuesAndSelectedFields,";","NULL",'a,c'));
+ var_dump($db->pgsqlCopyFromFile('test_error',$filenameWithDifferentNullValuesAndSelectedFields,";","NULL",'a,c'));
} catch (Exception $e) {
- echo "Exception: {$e->getMessage()}\n";
+ echo "Exception: {$e->getMessage()}\n";
}
$db->rollback();
echo "Testing pgsqlCopyFromFile() with non existing file\n";
$db->beginTransaction();
try {
- var_dump($db->pgsqlCopyFromFile('test',"nonexisting/foo.csv",";","NULL",'a,c'));
+ var_dump($db->pgsqlCopyFromFile('test',"nonexisting/foo.csv",";","NULL",'a,c'));
} catch (Exception $e) {
- echo "Exception: {$e->getMessage()}\n";
+ echo "Exception: {$e->getMessage()}\n";
}
$db->rollback();
// Clean up
foreach (array($filename, $filenameWithDifferentNullValues, $filenameWithDifferentNullValuesAndSelectedFields) as $f) {
- @unlink($f);
+ @unlink($f);
}
?>
--EXPECTF--
diff --git a/ext/pdo_pgsql/tests/copy_to.phpt b/ext/pdo_pgsql/tests/copy_to.phpt
index 3df882c93c..edda1483db 100644
--- a/ext/pdo_pgsql/tests/copy_to.phpt
+++ b/ext/pdo_pgsql/tests/copy_to.phpt
@@ -22,13 +22,13 @@ 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();
+ $firstParameter = $i;
+ $secondParameter = "test insert {$i}";
+ $thirdParameter = NULL;
+ $stmt->bindValue(1, $firstParameter);
+ $stmt->bindValue(2, $secondParameter);
+ $stmt->bindValue(3, $thirdParameter);
+ $stmt->execute();
}
$db->commit();
@@ -42,9 +42,9 @@ var_dump($db->pgsqlCopyToArray('test',";","NULL",'a,c'));
echo "Testing pgsqlCopyToArray() with error\n";
try {
- var_dump($db->pgsqlCopyToArray('test_error'));
+ var_dump($db->pgsqlCopyToArray('test_error'));
} catch (Exception $e) {
- echo "Exception: {$e->getMessage()}\n";
+ echo "Exception: {$e->getMessage()}\n";
}
echo "Testing pgsqlCopyToFile() with default parameters\n";
@@ -61,20 +61,20 @@ echo file_get_contents($filename);
echo "Testing pgsqlCopyToFile() with error\n";
try {
- var_dump($db->pgsqlCopyToFile('test_error',$filename));
+ var_dump($db->pgsqlCopyToFile('test_error',$filename));
} catch (Exception $e) {
- echo "Exception: {$e->getMessage()}\n";
+ echo "Exception: {$e->getMessage()}\n";
}
echo "Testing pgsqlCopyToFile() to unwritable file\n";
try {
- var_dump($db->pgsqlCopyToFile('test', 'nonexistent/foo.csv'));
+ var_dump($db->pgsqlCopyToFile('test', 'nonexistent/foo.csv'));
} catch (Exception $e) {
- echo "Exception: {$e->getMessage()}\n";
+ echo "Exception: {$e->getMessage()}\n";
}
if(isset($filename)) {
- @unlink($filename);
+ @unlink($filename);
}
?>
--EXPECTF--
diff --git a/ext/pdo_pgsql/tests/disable_prepares.phpt b/ext/pdo_pgsql/tests/disable_prepares.phpt
index bbc6a62e87..f224bffb15 100644
--- a/ext/pdo_pgsql/tests/disable_prepares.phpt
+++ b/ext/pdo_pgsql/tests/disable_prepares.phpt
@@ -15,7 +15,7 @@ $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_COLUMN);
$stmt = $db->prepare("SELECT statement FROM pg_prepared_statements", array(
- PDO::ATTR_EMULATE_PREPARES => true));
+ PDO::ATTR_EMULATE_PREPARES => true));
$stmt2 = $db->prepare("SELECT (?)::int2");
$stmt2->execute(array(1));
@@ -27,7 +27,7 @@ $stmt->execute();
$first = $stmt->fetchAll();
$stmt3 = $db->prepare("SELECT (?)::int4", array(
- PDO::PGSQL_ATTR_DISABLE_PREPARES => true));
+ PDO::PGSQL_ATTR_DISABLE_PREPARES => true));
$stmt3->execute(array(3));
var_dump($stmt3->fetch());
$stmt3->execute(array(4));
diff --git a/ext/pdo_pgsql/tests/is_in_transaction.phpt b/ext/pdo_pgsql/tests/is_in_transaction.phpt
index f5e950a047..cff798619b 100644
--- a/ext/pdo_pgsql/tests/is_in_transaction.phpt
+++ b/ext/pdo_pgsql/tests/is_in_transaction.phpt
@@ -39,19 +39,19 @@ $stmt->bindValue(1, "error");
$stmt->bindValue(2, "test insert");
$stmt->execute();
} catch (Exception $e) {
- /* We catch the exception because the execute will give error and we must test the PDO::PGSQL_TRANSACTION_ERROR */
- echo "Test PDO::PGSQL_TRANSACTION_INERROR\n";
- var_dump($db->inTransaction());
- $db->rollBack();
+ /* We catch the exception because the execute will give error and we must test the PDO::PGSQL_TRANSACTION_ERROR */
+ echo "Test PDO::PGSQL_TRANSACTION_INERROR\n";
+ var_dump($db->inTransaction());
+ $db->rollBack();
}
echo "Test PDO::PGSQL_TRANSACTION_IDLE\n";
var_dump($db->inTransaction());
} catch (Exception $e) {
- /* catch exceptions so that we can show the relative error */
- echo "Exception! at line ", $e->getLine(), "\n";
- var_dump($e->getMessage());
+ /* catch exceptions so that we can show the relative error */
+ echo "Exception! at line ", $e->getLine(), "\n";
+ var_dump($e->getMessage());
}
?>
diff --git a/ext/pdo_pgsql/tests/large_objects.phpt b/ext/pdo_pgsql/tests/large_objects.phpt
index 6215e49cb5..d1f1f05048 100644
--- a/ext/pdo_pgsql/tests/large_objects.phpt
+++ b/ext/pdo_pgsql/tests/large_objects.phpt
@@ -38,8 +38,8 @@ $stmt->bindColumn('bloboid', $lob, PDO::PARAM_LOB);
$stmt->execute();
echo "Fetching:\n";
while (($row = $stmt->fetch(PDO::FETCH_ASSOC))) {
- var_dump($row['blobid']);
- var_dump(stream_get_contents($lob));
+ var_dump($row['blobid']);
+ var_dump(stream_get_contents($lob));
}
echo "Fetched!\n";
@@ -49,8 +49,8 @@ $stmt->execute();
$stmt->bindColumn('bloboid', $lob, PDO::PARAM_LOB);
echo "Fetching late bind:\n";
while (($row = $stmt->fetch(PDO::FETCH_ASSOC))) {
- var_dump($row['blobid']);
- var_dump(is_int($row['bloboid']));
+ var_dump($row['blobid']);
+ var_dump(is_int($row['bloboid']));
}
echo "Fetched!\n";
@@ -60,16 +60,16 @@ $stmt->execute();
$stmt->bindColumn('bloboid', $lob, PDO::PARAM_LOB);
echo "Fetching NO bind:\n";
while (($row = $stmt->fetch(PDO::FETCH_ASSOC))) {
- var_dump($row['blobid']);
- var_dump(is_int($row['bloboid']));
+ var_dump($row['blobid']);
+ var_dump(is_int($row['bloboid']));
}
echo "Fetched!\n";
} catch (Exception $e) {
- /* catch exceptions so that we can guarantee to clean
- * up the LOB */
- echo "Exception! at line ", $e->getLine(), "\n";
- var_dump($e->getMessage());
+ /* catch exceptions so that we can guarantee to clean
+ * up the LOB */
+ echo "Exception! at line ", $e->getLine(), "\n";
+ var_dump($e->getMessage());
}
/* Now to remove the large object from the database, so it doesn't