summaryrefslogtreecommitdiff
path: root/ext/pdo_firebird/tests
diff options
context:
space:
mode:
Diffstat (limited to 'ext/pdo_firebird/tests')
-rw-r--r--ext/pdo_firebird/tests/common.phpt27
-rw-r--r--ext/pdo_firebird/tests/connect.phpt16
-rw-r--r--ext/pdo_firebird/tests/ddl.phpt37
-rw-r--r--ext/pdo_firebird/tests/execute.phpt65
-rw-r--r--ext/pdo_firebird/tests/skipif.inc5
-rw-r--r--ext/pdo_firebird/tests/testdb.inc34
6 files changed, 0 insertions, 184 deletions
diff --git a/ext/pdo_firebird/tests/common.phpt b/ext/pdo_firebird/tests/common.phpt
deleted file mode 100644
index 00d4b239ab..0000000000
--- a/ext/pdo_firebird/tests/common.phpt
+++ /dev/null
@@ -1,27 +0,0 @@
---TEST--
-FIREBIRD
---SKIPIF--
-<?php # vim:ft=php
-if (!extension_loaded('pdo_firebird')) print 'skip'; ?>
---REDIRECTTEST--
-# magic auto-configuration
-
-$config = array(
- 'TESTS' => 'ext/pdo/tests'
-);
-
-
-if (false !== getenv('PDO_FIREBIRD_TEST_DSN')) {
- # user set them from their shell
- $config['ENV']['PDOTEST_DSN'] = getenv('PDO_FIREBIRD_TEST_DSN');
- $config['ENV']['PDOTEST_USER'] = getenv('PDO_FIREBIRD_TEST_USER');
- $config['ENV']['PDOTEST_PASS'] = getenv('PDO_FIREBIRD_TEST_PASS');
- if (false !== getenv('PDO_FIREBIRD_TEST_ATTR')) {
- $config['ENV']['PDOTEST_ATTR'] = getenv('PDO_FIREBIRD_TEST_ATTR');
- }
-} else {
- $config['ENV']['PDOTEST_DSN'] = 'firebird:dbname=/opt/firebird/test.gdb';
- $config['ENV']['PDOTEST_USER'] = 'SYSDBA';
- $config['ENV']['PDOTEST_PASS'] = 'password';
-}
-return $config;
diff --git a/ext/pdo_firebird/tests/connect.phpt b/ext/pdo_firebird/tests/connect.phpt
deleted file mode 100644
index e4bb8ef54e..0000000000
--- a/ext/pdo_firebird/tests/connect.phpt
+++ /dev/null
@@ -1,16 +0,0 @@
---TEST--
-PDO_Firebird: connect/disconnect
---SKIPIF--
-<?php include("skipif.inc"); ?>
---FILE--
-<?php /* $Id$ */
-
- require("testdb.inc");
-
- $db = new PDO("firebird:dbname=$test_base",$user,$password) or die;
- unset($db);
- echo "done\n";
-
-?>
---EXPECT--
-done
diff --git a/ext/pdo_firebird/tests/ddl.phpt b/ext/pdo_firebird/tests/ddl.phpt
deleted file mode 100644
index 7709bb3f07..0000000000
--- a/ext/pdo_firebird/tests/ddl.phpt
+++ /dev/null
@@ -1,37 +0,0 @@
---TEST--
-PDO_Firebird: DDL/transactions
---SKIPIF--
-<?php include("skipif.inc"); ?>
---FILE--
-<?php /* $Id$ */
-
- require("testdb.inc");
-
- $db = new PDO("firebird:dbname=$test_base",$user,$password) or die;
- $db->setAttribute(PDO_ATTR_ERRMODE, PDO_ERRMODE_WARNING);
-
- $db->exec("CREATE TABLE ddl (id INT NOT NULL PRIMARY KEY, text BLOB SUB_TYPE 1)");
- $db->exec("CREATE GENERATOR gen_ddl_id");
- $db->exec("CREATE TRIGGER ddl_bi FOR ddl BEFORE INSERT AS
- BEGIN IF (NEW.id IS NULL) THEN NEW.id=GEN_ID(gen_ddl_id,1); END");
-
- $db->setAttribute(PDO_ATTR_AUTOCOMMIT,0);
-
- $db->beginTransaction();
- var_dump($db->exec("INSERT INTO ddl (text) VALUES ('bla')"));
- var_dump($db->exec("UPDATE ddl SET text='blabla'"));
- $db->rollback();
-
- $db->beginTransaction();
- var_dump($db->exec("DELETE FROM ddl"));
- $db->commit();
-
- unset($db);
- echo "done\n";
-
-?>
---EXPECT--
-int(1)
-int(1)
-int(0)
-done
diff --git a/ext/pdo_firebird/tests/execute.phpt b/ext/pdo_firebird/tests/execute.phpt
deleted file mode 100644
index 8975048325..0000000000
--- a/ext/pdo_firebird/tests/execute.phpt
+++ /dev/null
@@ -1,65 +0,0 @@
---TEST--
-PDO_Firebird: prepare/execute/binding
---SKIPIF--
-<?php include("skipif.inc"); ?>
---INI--
-ibase.timestampformat=%Y-%m-%d %H:%M:%S
---FILE--
-<?php /* $Id$ */
-
- require("testdb.inc");
-
- $db = new PDO("firebird:dbname=$test_base",$user,$password) or die;
-
- var_dump($db->getAttribute(PDO_ATTR_CONNECTION_STATUS));
-
- $db->setAttribute(PDO_ATTR_ERRMODE, PDO_ERRMODE_WARNING);
-
- $db->exec("CREATE TABLE ddl (id SMALLINT NOT NULL PRIMARY KEY, text VARCHAR(32),
- datetime TIMESTAMP DEFAULT '2000-02-12' NOT NULL)");
- $db->exec("INSERT INTO ddl (id,text) VALUES (1,'bla')");
-
- $s = $db->prepare("SELECT * FROM ddl WHERE id=? FOR UPDATE");
-
- $s->bindParam(1,$id = 0);
- $s->bindColumn("TEXT",$var = null);
- $id = 1;
- $s->execute();
- $s->setAttribute(PDO_ATTR_CURSOR_NAME, "c");
-
- var_dump($id);
-
- var_dump($s->fetch());
-
- var_dump($var);
-
- var_dump($db->exec("UPDATE ddl SET id=2 WHERE CURRENT OF c"));
-
- var_dump($s->fetch());
-
- unset($s);
- unset($db);
- echo "done\n";
-
-?>
---EXPECT--
-bool(true)
-int(1)
-array(6) {
- ["ID"]=>
- string(1) "1"
- [0]=>
- string(1) "1"
- ["TEXT"]=>
- string(3) "bla"
- [1]=>
- string(3) "bla"
- ["DATETIME"]=>
- string(19) "2000-02-12 00:00:00"
- [2]=>
- string(19) "2000-02-12 00:00:00"
-}
-string(3) "bla"
-int(1)
-bool(false)
-done
diff --git a/ext/pdo_firebird/tests/skipif.inc b/ext/pdo_firebird/tests/skipif.inc
deleted file mode 100644
index 5a6cd372d1..0000000000
--- a/ext/pdo_firebird/tests/skipif.inc
+++ /dev/null
@@ -1,5 +0,0 @@
-<?php /* $Id$ */
-
-if (!extension_loaded("interbase") || !extension_loaded("pdo_firebird")) print "skip";
-
-?>
diff --git a/ext/pdo_firebird/tests/testdb.inc b/ext/pdo_firebird/tests/testdb.inc
deleted file mode 100644
index f6951a7b13..0000000000
--- a/ext/pdo_firebird/tests/testdb.inc
+++ /dev/null
@@ -1,34 +0,0 @@
-<?php /* $Id$ */
-
-$user = 'SYSDBA';
-$password = 'masterkey';
-ini_set('ibase.default_user',$user);
-ini_set('ibase.default_password',$password);
-
-/* we need just the generated name, not the file itself */
-unlink($test_base = tempnam('/tmp',"php_ibase_test"));
-
-function init_db()
-{
- global $test_base, $user, $password;
-
- $test_db = ibase_query(IBASE_CREATE,sprintf("CREATE DATABASE '%s' USER '%s' PASSWORD '%s'",
- $test_base, $user, $password));
- $tr = ibase_trans($test_db);
- ibase_query($tr,"create table test1 (i integer, c varchar(100))");
- ibase_commit_ret($tr);
- ibase_query($tr,"insert into test1(i, c) values(1, 'test table not created with isql')");
- ibase_commit($tr);
- ibase_close($test_db);
-}
-
-function cleanup_db()
-{
- global $test_base;
-
- $r = ibase_connect($test_base);
- ibase_drop_db($r);
-}
-
-register_shutdown_function('cleanup_db');
-init_db();
View Lorry Controller Status