summaryrefslogtreecommitdiff
path: root/ext/oci8/tests/commit.phpt
diff options
context:
space:
mode:
Diffstat (limited to 'ext/oci8/tests/commit.phpt')
-rw-r--r--ext/oci8/tests/commit.phpt148
1 files changed, 0 insertions, 148 deletions
diff --git a/ext/oci8/tests/commit.phpt b/ext/oci8/tests/commit.phpt
deleted file mode 100644
index 3bef318c85..0000000000
--- a/ext/oci8/tests/commit.phpt
+++ /dev/null
@@ -1,148 +0,0 @@
---TEST--
-oci_commit()/oci_rollback()
---SKIPIF--
-<?php if (!extension_loaded('oci8')) die("skip no oci8 extension"); ?>
---FILE--
-<?php
-
-require dirname(__FILE__)."/connect.inc";
-require dirname(__FILE__).'/create_table.inc';
-
-$insert_sql = "INSERT INTO ".$schema.$table_name." (id, value) VALUES (1,1)";
-
-if (!($s = oci_parse($c, $insert_sql))) {
- die("oci_parse(insert) failed!\n");
-}
-
-for ($i = 0; $i<3; $i++) {
- if (!oci_execute($s, OCI_DEFAULT)) {
- die("oci_execute(insert) failed!\n");
- }
-}
-
-var_dump(oci_rollback($c));
-
-$select_sql = "SELECT * FROM ".$schema.$table_name."";
-
-if (!($select = oci_parse($c, $select_sql))) {
- die("oci_parse(select) failed!\n");
-}
-
-/* oci_fetch_all */
-if (!oci_execute($select)) {
- die("oci_execute(select) failed!\n");
-}
-var_dump(oci_fetch_all($select, $all));
-var_dump($all);
-
-/* ocifetchstatement */
-if (!oci_execute($s)) {
- die("oci_execute(select) failed!\n");
-}
-
-$insert_sql = "INSERT INTO ".$schema.$table_name." (id, value) VALUES (1,1)";
-
-if (!($s = oci_parse($c, $insert_sql))) {
- die("oci_parse(insert) failed!\n");
-}
-
-for ($i = 0; $i<3; $i++) {
- if (!oci_execute($s, OCI_DEFAULT)) {
- die("oci_execute(insert) failed!\n");
- }
-}
-
-var_dump(oci_commit($c));
-
-/* oci_fetch_all */
-if (!oci_execute($select)) {
- die("oci_execute(select) failed!\n");
-}
-var_dump(oci_fetch_all($select, $all));
-var_dump($all);
-
-
-require dirname(__FILE__).'/drop_table.inc';
-
-echo "Done\n";
-?>
---EXPECT--
-bool(true)
-int(0)
-array(5) {
- ["ID"]=>
- array(0) {
- }
- ["VALUE"]=>
- array(0) {
- }
- ["BLOB"]=>
- array(0) {
- }
- ["CLOB"]=>
- array(0) {
- }
- ["STRING"]=>
- array(0) {
- }
-}
-bool(true)
-int(4)
-array(5) {
- ["ID"]=>
- array(4) {
- [0]=>
- string(1) "1"
- [1]=>
- string(1) "1"
- [2]=>
- string(1) "1"
- [3]=>
- string(1) "1"
- }
- ["VALUE"]=>
- array(4) {
- [0]=>
- string(1) "1"
- [1]=>
- string(1) "1"
- [2]=>
- string(1) "1"
- [3]=>
- string(1) "1"
- }
- ["BLOB"]=>
- array(4) {
- [0]=>
- NULL
- [1]=>
- NULL
- [2]=>
- NULL
- [3]=>
- NULL
- }
- ["CLOB"]=>
- array(4) {
- [0]=>
- NULL
- [1]=>
- NULL
- [2]=>
- NULL
- [3]=>
- NULL
- }
- ["STRING"]=>
- array(4) {
- [0]=>
- NULL
- [1]=>
- NULL
- [2]=>
- NULL
- [3]=>
- NULL
- }
-}
-Done