summaryrefslogtreecommitdiff
path: root/ext/pdo_firebird/tests/testdb.inc
diff options
context:
space:
mode:
authorArd Biesheuvel <abies@php.net>2004-06-11 01:37:06 +0000
committerArd Biesheuvel <abies@php.net>2004-06-11 01:37:06 +0000
commit1e3854597cbbc8d91ce5904643f0cc04a55327a8 (patch)
treee41443936f413b4dcecff61b4a1fab1882de6677 /ext/pdo_firebird/tests/testdb.inc
parentd0c4b3d3ece5125e9dd4603e359a70ac5c0cbf79 (diff)
downloadphp-git-1e3854597cbbc8d91ce5904643f0cc04a55327a8.tar.gz
Initial revision (incomplete)
Diffstat (limited to 'ext/pdo_firebird/tests/testdb.inc')
-rw-r--r--ext/pdo_firebird/tests/testdb.inc34
1 files changed, 34 insertions, 0 deletions
diff --git a/ext/pdo_firebird/tests/testdb.inc b/ext/pdo_firebird/tests/testdb.inc
new file mode 100644
index 0000000000..f6951a7b13
--- /dev/null
+++ b/ext/pdo_firebird/tests/testdb.inc
@@ -0,0 +1,34 @@
+<?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();