abies Tue Feb 17 07:24:43 2004 EDT
Added files:
/php-src/ext/interbase/tests 008.phpt
Modified files:
/php-src/ext/interbase/tests 004.phpt
Log:
Added event handling test
CS
http://cvs.php.net/diff.php/php-src/ext/interbase/tests/004.phpt?r1=1.10&r2=1.11&ty=u
Index: php-src/ext/interbase/tests/004.phpt
diff -u php-src/ext/interbase/tests/004.phpt:1.10
php-src/ext/interbase/tests/004.phpt:1.11
--- php-src/ext/interbase/tests/004.phpt:1.10 Fri Sep 5 13:02:02 2003
+++ php-src/ext/interbase/tests/004.phpt Tue Feb 17 07:24:42 2004
@@ -5,14 +5,14 @@
--POST--
--GET--
--FILE--
-<?php /* $Id: 004.phpt,v 1.10 2003/09/05 17:02:02 abies Exp $ */
+<?php /* $Id: 004.phpt,v 1.11 2004/02/17 12:24:42 abies Exp $ */
require("interbase.inc");
- ibase_connect($test_base);
+ $link = ibase_connect($test_base);
ibase_query(
- "create table test4 (
+ "CREATE TABLE test4 (
v_integer integer,
v_blob blob)");
ibase_commit();
@@ -28,10 +28,14 @@
echo "import blob 1\n";
$ftmp = fopen($name,"r");
$bl_s = ibase_blob_import($ftmp);
- ibase_query("insert into test4 (v_integer, v_blob) values (1, ?)", $bl_s);
+ ibase_query("INSERT INTO test4 (v_integer, v_blob) VALUES (1, ?)", $bl_s);
+
+ $bl_s = ibase_blob_import($ftmp,$link);
+ ibase_query($link, "INSERT INTO test4 (v_integer, v_blob) VALUES (1, ?)", $bl_s);
echo "test blob 1\n";
- $q = ibase_query("select v_blob from test4 where v_integer = 1");
+ $q = ibase_query("SELECT v_blob FROM test4 WHERE v_integer = 1");
+
$row = ibase_fetch_object($q);
$bl_h = ibase_blob_open($row->V_BLOB);
@@ -42,7 +46,7 @@
echo " BLOB 1 fail (1)\n";
ibase_blob_close($bl_h);
- $bl_h = ibase_blob_open($row->V_BLOB);
+ $bl_h = ibase_blob_open($row->V_BLOB,$link);
$blob = '';
while($piece = ibase_blob_get($bl_h, 100 * 1024))
@@ -55,11 +59,11 @@
echo "create blob 2\n";
- ibase_query("insert into test4 (v_integer, v_blob) values (2, ?)", $blob_str);
+ ibase_query("INSERT INTO test4 (v_integer, v_blob) VALUES (2, ?)", $blob_str);
echo "test blob 2\n";
- $q = ibase_query("select v_blob from test4 where v_integer = 2");
+ $q = ibase_query("SELECT v_blob FROM test4 WHERE v_integer = 2");
$row = ibase_fetch_object($q,IBASE_TEXT);
if($row->V_BLOB != $blob_str)
@@ -70,7 +74,7 @@
echo "create blob 3\n";
- $bl_h = ibase_blob_create();
+ $bl_h = ibase_blob_create($link);
ibase_blob_add($bl_h,
"+----------------------------------------------------------------------+\n");
ibase_blob_add($bl_h, "| PHP HTML Embedded Scripting Language Version 3.0
|\n");
@@ -97,21 +101,21 @@
ibase_blob_add($bl_h, "| contact [EMAIL PROTECTED]
|\n");
ibase_blob_add($bl_h,
"+----------------------------------------------------------------------+\n");
$bl_s = ibase_blob_close($bl_h);
- ibase_query("insert into test4 (v_integer, v_blob) values (3, ?)", $bl_s);
+ ibase_query("INSERT INTO test4 (v_integer, v_blob) VALUES (3, ?)", $bl_s);
ibase_commit();
echo "echo blob 3\n";
- $q = ibase_query("select v_blob from test4 where v_integer = 3");
+ $q = ibase_query("SELECT v_blob FROM test4 WHERE v_integer = 3");
$row = ibase_fetch_object($q);
ibase_commit();
ibase_close();
ibase_connect($test_base);
- ibase_blob_echo($row->V_BLOB);
+ ibase_blob_echo($row->V_BLOB, $link);
ibase_free_result($q);
echo "fetch blob 3\n";
- $q = ibase_query("select v_blob from test4 where v_integer = 3");
+ $q = ibase_query("SELECT v_blob FROM test4 WHERE v_integer = 3");
$row = ibase_fetch_object($q,IBASE_TEXT);
echo $row->V_BLOB;
ibase_free_result($q);
http://cvs.php.net/co.php/php-src/ext/interbase/tests/008.phpt?r=1.1&p=1
Index: php-src/ext/interbase/tests/008.phpt
+++ php-src/ext/interbase/tests/008.phpt
--TEST--
InterBase: event handling
--SKIPIF--
<?php include("skipif.inc"); ?>
--POST--
--GET--
--FILE--
<?php /* $Id: 008.phpt,v 1.1 2004/02/17 12:24:42 abies Exp $ */
require("interbase.inc");
$count = 0;
function event_callback($event)
{
global $count;
if ($event == 'TEST1') echo "FAIL TEST1\n";
return (++$count < 5); /* cancel event */
}
$link = ibase_connect($test_base);
ibase_query("CREATE PROCEDURE pevent AS BEGIN POST_EVENT 'TEST1'; POST_EVENT 'TEST2';
END");
ibase_commit();
$e = ibase_set_event_handler('event_callback','TEST1');
ibase_free_event_handler($e);
ibase_set_event_handler('event_callback','TEST2');
usleep(5E+5);
for ($i = 0; $i < 8; ++$i) {
ibase_query("EXECUTE PROCEDURE pevent");
ibase_commit();
usleep(3E+5);
}
usleep(5E+5);
if (!$count || $count > 5) echo "FAIL ($count)\n";
echo "end of test\n";
?>
--EXPECT--
end of test
--
PHP CVS Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
