summaryrefslogtreecommitdiff
path: root/ext/oci8/tests/commit.phpt
diff options
context:
space:
mode:
authorSVN Migration <svn@php.net>2006-10-15 21:09:28 +0000
committerSVN Migration <svn@php.net>2006-10-15 21:09:28 +0000
commit88ec761548b66f58acc1a86cdd0fc164ca925476 (patch)
treed0af978fa00d83bb1d82c613f66477fbd6bb18aa /ext/oci8/tests/commit.phpt
parent268984b4787e797db6054313fc9ba3b9e845306e (diff)
downloadphp-git-PECL_OPENSSL.tar.gz
This commit was manufactured by cvs2svn to create branch 'PECL_OPENSSL'.PECL_OPENSSL
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