diff options
Diffstat (limited to 'ext/interbase/tests')
24 files changed, 0 insertions, 1820 deletions
diff --git a/ext/interbase/tests/002.phpt b/ext/interbase/tests/002.phpt deleted file mode 100644 index 6c7d780588..0000000000 --- a/ext/interbase/tests/002.phpt +++ /dev/null @@ -1,33 +0,0 @@ ---TEST-- -InterBase: connect, close and pconnect ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php - - require("interbase.inc"); - - ibase_connect($test_base); - out_table("test1"); - ibase_close(); - - $con = ibase_connect($test_base); - $pcon1 = ibase_pconnect($test_base); - $pcon2 = ibase_pconnect($test_base); - ibase_close($con); - unset($con); - ibase_close($pcon1); - unset($pcon1); - - out_table("test1"); - - ibase_close($pcon2); - unset($pcon2); -?> ---EXPECT-- ---- test1 --- -1 test table not created with isql ---- ---- test1 --- -1 test table not created with isql ---- diff --git a/ext/interbase/tests/003.phpt b/ext/interbase/tests/003.phpt deleted file mode 100644 index 70fa5f0d30..0000000000 --- a/ext/interbase/tests/003.phpt +++ /dev/null @@ -1,183 +0,0 @@ ---TEST-- -InterBase: misc sql types (may take a while) ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php - - require("interbase.inc"); - ibase_connect($test_base); - - ibase_query( - "create table test3 ( - iter integer not null, - v_char char(1000), - v_date timestamp, - v_decimal4_2 decimal(4,2), - v_decimal4_0 decimal(4,0), - v_decimal7_2 decimal(7,2), - v_decimal7_0 decimal(7,0), - v_numeric15_15 numeric(15,15), - v_numeric15_0 numeric(15,0), - v_double double precision, - v_float float, - v_integer integer, - v_smallint smallint, - v_varchar varchar(10000) - )"); - ibase_commit(); - - /* should fail, but gracefully */ - @ibase_query("insert into test3 (iter) values (?)", null); - - /* if timefmt is not supported, suppress error here */ - ini_set('ibase.timestampformat',"%m/%d/%Y %H:%M:%S"); - - for($iter = 0; $iter < 10; $iter++){ - /* prepare data */ - $v_char = rand_str(1000); - $v_date = rand_datetime(); - $v_decimal4_2 = rand_number(4,2); - $v_decimal4_0 = rand_number(4,0); - $v_decimal7_2 = rand_number(7,2); - $v_decimal7_0 = rand_number(7,0); - $v_numeric15_15 = rand_number(15,15); - $v_numeric15_0 = $iter ? rand_number(15,0) : 0; - $v_double = rand_number(18); - $v_float = rand_number(7); - $v_integer = rand_number(9,0); - $v_smallint = rand_number(5) % 32767; - $v_varchar = rand_str(10000); - - ibase_query( - "insert into test3 (iter, v_char,v_date,v_decimal4_2, v_decimal4_0, v_decimal7_2, v_decimal7_0,v_numeric15_15, v_numeric15_0,v_double,v_float,v_integer,v_smallint,v_varchar) - values ($iter, '$v_char','$v_date',$v_decimal4_2, $v_decimal4_0, $v_decimal7_2, $v_decimal7_0,$v_numeric15_15, $v_numeric15_0,$v_double,$v_float,$v_integer,$v_smallint,'$v_varchar')"); - $sel = ibase_query("select * from test3 where iter = $iter"); - $row = ibase_fetch_object($sel); - if(substr($row->V_CHAR,0,strlen($v_char)) != $v_char){ - echo " CHAR fail:\n"; - echo " in: $v_char\n"; - echo " out: $row->V_CHAR\n"; - } - if($row->V_DATE != $v_date){ - echo " DATE fail\n"; - echo " in: $v_date\n"; - echo " out: $row->V_DATE\n"; - } - if($row->V_DECIMAL4_2 != $v_decimal4_2){ - echo " DECIMAL4_2 fail\n"; - echo " in: $v_decimal4_2\n"; - echo " out: $row->V_DECIMAL4_2\n"; - } - if($row->V_DECIMAL4_0 != $v_decimal4_0){ - echo " DECIMAL4_0 fail\n"; - echo " in: $v_decimal4_0\n"; - echo " out: $row->V_DECIMAL4_0\n"; - } - if($row->V_DECIMAL7_2 != $v_decimal7_2){ - echo " DECIMAL7_2 fail\n"; - echo " in: $v_decimal7_2\n"; - echo " out: $row->V_DECIMAL7_2\n"; - } - if($row->V_DECIMAL7_0 != $v_decimal7_0){ - echo " DECIMAL7_0 fail\n"; - echo " in: $v_decimal7_0\n"; - echo " out: $row->V_DECIMAL7_0\n"; - } - if($row->V_NUMERIC15_15 != $v_numeric15_15){ - echo " NUMERIC15_15 fail\n"; - echo " in: $v_numeric15_15\n"; - echo " out: $row->V_NUMERIC15_15\n"; - } - if($row->V_NUMERIC15_0 != (string)$v_numeric15_0){ - echo " NUMERIC15_0 fail\n"; - echo " in: $v_numeric15_0\n"; - echo " out: $row->V_NUMERIC15_0\n"; - } - - if(abs($row->V_DOUBLE - $v_double) > abs($v_double / 1E15)){ - echo " DOUBLE fail\n"; - echo " in: $v_double\n"; - echo " out: $row->V_DOUBLE\n"; - } - if(abs($row->V_FLOAT - $v_float) > abs($v_float / 1E7)){ - echo " FLOAT fail\n"; - echo " in: $v_float\n"; - echo " out: $row->V_FLOAT\n"; - } - if($row->V_INTEGER != $v_integer){ - echo " INTEGER fail\n"; - echo " in: $v_integer\n"; - echo " out: $row->V_INTEGER\n"; - } - if($row->V_SMALLINT != $v_smallint){ - echo " SMALLINT fail\n"; - echo " in: $v_smallint\n"; - echo " out: $row->V_SMALLINT\n"; - } - - if(substr($row->V_VARCHAR,0,strlen($v_varchar)) != $v_varchar){ - echo " VARCHAR fail:\n"; - echo " in: $v_varchar\n"; - echo " out: $row->V_VARCHAR\n"; - } - - ibase_free_result($sel); - } /* for($iter) */ - - /* check for correct handling of duplicate field names */ - $q = ibase_query('SELECT 1 AS id, 2 AS id, 3 AS id, 4 AS id, 5 AS id, 6 AS id, 7 AS id, 8 AS id, 9 AS id, - 10 AS id, 11 AS id, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22 FROM rdb$database'); - var_dump(ibase_fetch_assoc($q)); - - ibase_close(); - echo "end of test\n"; -?> ---EXPECT-- -array(22) { - ["ID"]=> - int(1) - ["ID_01"]=> - int(2) - ["ID_02"]=> - int(3) - ["ID_03"]=> - int(4) - ["ID_04"]=> - int(5) - ["ID_05"]=> - int(6) - ["ID_06"]=> - int(7) - ["ID_07"]=> - int(8) - ["ID_08"]=> - int(9) - ["ID_09"]=> - int(10) - ["ID_10"]=> - int(11) - ["CONSTANT"]=> - int(12) - ["CONSTANT_01"]=> - int(13) - ["CONSTANT_02"]=> - int(14) - ["CONSTANT_03"]=> - int(15) - ["CONSTANT_04"]=> - int(16) - ["CONSTANT_05"]=> - int(17) - ["CONSTANT_06"]=> - int(18) - ["CONSTANT_07"]=> - int(19) - ["CONSTANT_08"]=> - int(20) - ["CONSTANT_09"]=> - int(21) - ["CONSTANT_10"]=> - int(22) -} -end of test diff --git a/ext/interbase/tests/004.phpt b/ext/interbase/tests/004.phpt deleted file mode 100644 index 20f314ee6b..0000000000 --- a/ext/interbase/tests/004.phpt +++ /dev/null @@ -1,182 +0,0 @@ ---TEST-- -InterBase: BLOB test ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php - - require("interbase.inc"); - - $link = ibase_connect($test_base); - - ibase_query( - "CREATE TABLE test4 ( - v_integer integer, - v_blob blob)"); - ibase_commit(); - - /* create 100k blob file */ - $blob_str = rand_binstr(100*1024); - - $name = tempnam(__DIR__,"blob.tmp"); - $ftmp = fopen($name,"w"); - fwrite($ftmp,$blob_str); - fclose($ftmp); - - 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); - - $bl_s = ibase_blob_import($link,$ftmp); - ibase_query($link, "INSERT INTO test4 (v_integer, v_blob) VALUES (1, ?)", $bl_s); - fclose($ftmp); - - echo "test blob 1\n"; - $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); - - $blob = ''; - while($piece = ibase_blob_get($bl_h, 1 + rand() % 1024)) - $blob .= $piece; - if($blob != $blob_str) - echo " BLOB 1 fail (1)\n"; - ibase_blob_close($bl_h); - - $bl_h = ibase_blob_open($link,$row->V_BLOB); - - $blob = ''; - while($piece = ibase_blob_get($bl_h, 100 * 1024)) - $blob .= $piece; - if($blob != $blob_str) - echo " BLOB 1 fail (2)\n"; - ibase_blob_close($bl_h); - ibase_free_result($q); - unset($blob); - - echo "create blob 2\n"; - - 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"); - $row = ibase_fetch_object($q,IBASE_TEXT); - - if($row->V_BLOB != $blob_str) - echo " BLOB 2 fail\n"; - ibase_free_result($q); - unset($blob); - - - echo "create blob 3\n"; - - $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"); - ibase_blob_add($bl_h, "+----------------------------------------------------------------------+\n"); - ibase_blob_add($bl_h, "| Copyright (c) 1997-2000 PHP Development Team (See Credits file) |\n"); - ibase_blob_add($bl_h, "+----------------------------------------------------------------------+\n"); - ibase_blob_add($bl_h, "| This program is free software; you can redistribute it and/or modify |\n"); - ibase_blob_add($bl_h, "| it under the terms of one of the following licenses: |\n"); - ibase_blob_add($bl_h, "| |\n"); - ibase_blob_add($bl_h, "| A) the GNU General Public License as published by the Free Software |\n"); - ibase_blob_add($bl_h, "| Foundation; either version 2 of the License, or (at your option) |\n"); - ibase_blob_add($bl_h, "| any later version. |\n"); - ibase_blob_add($bl_h, "| |\n"); - ibase_blob_add($bl_h, "| B) the PHP License as published by the PHP Development Team and |\n"); - ibase_blob_add($bl_h, "| included in the distribution in the file: LICENSE |\n"); - ibase_blob_add($bl_h, "| |\n"); - ibase_blob_add($bl_h, "| This program is distributed in the hope that it will be useful, |\n"); - ibase_blob_add($bl_h, "| but WITHOUT ANY WARRANTY; without even the implied warranty of |\n"); - ibase_blob_add($bl_h, "| MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the |\n"); - ibase_blob_add($bl_h, "| GNU General Public License for more details. |\n"); - ibase_blob_add($bl_h, "| |\n"); - ibase_blob_add($bl_h, "| You should have received a copy of both licenses referred to here. |\n"); - ibase_blob_add($bl_h, "| If you did not, or have any questions about PHP licensing, please |\n"); - ibase_blob_add($bl_h, "| contact core@php.net. |\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_commit(); - echo "echo blob 3\n"; - - $q = ibase_query("SELECT v_blob FROM test4 WHERE v_integer = 3"); - $row = ibase_fetch_object($q); - ibase_commit(); - ibase_close(); - - $link = ibase_connect($test_base); - ibase_blob_echo($link, $row->V_BLOB); - ibase_free_result($q); - - echo "fetch blob 3\n"; - $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); - - ibase_close(); - unlink($name); - echo "end of test\n"; -?> ---EXPECT-- -import blob 1 -test blob 1 -create blob 2 -test blob 2 -create blob 3 -echo blob 3 -+----------------------------------------------------------------------+ -| PHP HTML Embedded Scripting Language Version 3.0 | -+----------------------------------------------------------------------+ -| Copyright (c) 1997-2000 PHP Development Team (See Credits file) | -+----------------------------------------------------------------------+ -| This program is free software; you can redistribute it and/or modify | -| it under the terms of one of the following licenses: | -| | -| A) the GNU General Public License as published by the Free Software | -| Foundation; either version 2 of the License, or (at your option) | -| any later version. | -| | -| B) the PHP License as published by the PHP Development Team and | -| included in the distribution in the file: LICENSE | -| | -| This program is distributed in the hope that it will be useful, | -| but WITHOUT ANY WARRANTY; without even the implied warranty of | -| MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the | -| GNU General Public License for more details. | -| | -| You should have received a copy of both licenses referred to here. | -| If you did not, or have any questions about PHP licensing, please | -| contact core@php.net. | -+----------------------------------------------------------------------+ -fetch blob 3 -+----------------------------------------------------------------------+ -| PHP HTML Embedded Scripting Language Version 3.0 | -+----------------------------------------------------------------------+ -| Copyright (c) 1997-2000 PHP Development Team (See Credits file) | -+----------------------------------------------------------------------+ -| This program is free software; you can redistribute it and/or modify | -| it under the terms of one of the following licenses: | -| | -| A) the GNU General Public License as published by the Free Software | -| Foundation; either version 2 of the License, or (at your option) | -| any later version. | -| | -| B) the PHP License as published by the PHP Development Team and | -| included in the distribution in the file: LICENSE | -| | -| This program is distributed in the hope that it will be useful, | -| but WITHOUT ANY WARRANTY; without even the implied warranty of | -| MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the | -| GNU General Public License for more details. | -| | -| You should have received a copy of both licenses referred to here. | -| If you did not, or have any questions about PHP licensing, please | -| contact core@php.net. | -+----------------------------------------------------------------------+ -end of test diff --git a/ext/interbase/tests/005.phpt b/ext/interbase/tests/005.phpt deleted file mode 100644 index 9a9acfd092..0000000000 --- a/ext/interbase/tests/005.phpt +++ /dev/null @@ -1,289 +0,0 @@ ---TEST-- -InterBase: transactions ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php - - require("interbase.inc"); - - ibase_connect($test_base); - - @ibase_query("create table test5 (i integer)"); - @ibase_query("delete from test5"); - ibase_close(); - - - echo "default transaction:\n"; - -/* -Difference between default and other transactions: -default committed when you call ibase_close(). -Other transaction doing rollback. - -If you not open default transaction with -ibase_trans, default transaction open -when you call ibase_query(), ibase_prepare(), -ibase_blob_create(), ibase_blob_import() first time. -*/ - -/* -simple default transaction test without ibase_trans() -*/ - - ibase_connect($test_base); - - echo "empty table\n"; - - /* out_table call ibase_query() - and ibase_query() start default transaction */ - out_table("test5"); - - /* in default transaction context */ - ibase_query("insert into test5 (i) values (1)"); - - echo "one row\n"; - out_table("test5"); - - ibase_rollback(); /* default rolled */ - - echo "after rollback table empty again\n"; - out_table("test5"); /* started new default transaction */ - - ibase_query("insert into test5 (i) values (2)"); - - ibase_close(); /* commit here! */ - - ibase_connect($test_base); - - echo "one row\n"; - out_table("test5"); - ibase_close(); - -/* -default transaction on default link -First open transaction on link will be default. -$tr_def_l1 may be omitted. All queryes without link and trans -parameters run in this context -*/ - - $link_def = ibase_connect($test_base); - - $tr_def_l1 = ibase_trans(IBASE_READ); /* here transaction start */ - - /* all default */ - $res = ibase_query("select * from test5"); - - echo "one row\n"; - out_result($res,"test5"); - - ibase_free_result($res); - - /* specify transaction context... */ - $res = ibase_query($tr_def_l1, "select * from test5"); - - echo "one row... again.\n"; - out_result($res,"test5"); - - ibase_free_result($res); - - /* specify default transaction on link */ - $res = ibase_query($link_def, "select * from test5"); - - echo "one row.\n"; - out_result($res,"test5"); - - ibase_free_result($res); - - ibase_rollback($link_def); /* just for example */ - - ibase_close(); - -/* -three transaction on default link -*/ - ibase_connect($test_base); - - $res = ibase_query("select * from test5"); - - echo "one row\n"; - out_result($res,"test5"); - - ibase_free_result($res); - - $tr_1 = ibase_query("SET TRANSACTION"); - $tr_2 = ibase_query("SET TRANSACTION READ ONLY"); - $tr_3 = ibase_trans(IBASE_READ+IBASE_COMMITTED+IBASE_REC_VERSION+IBASE_WAIT); - $tr_4 = ibase_trans(IBASE_READ+IBASE_COMMITTED+IBASE_REC_NO_VERSION+IBASE_NOWAIT); - - /* insert in first transaction context... */ - /* as default */ - ibase_query("insert into test5 (i) values (3)"); - /* specify context */ - ibase_query($tr_1, "insert into test5 (i) values (4)"); - - $res = ibase_query("select * from test5"); - - echo "two rows\n"; - out_result($res,"test5"); - - ibase_free_result($res); - - $res = ibase_query($tr_1, "select * from test5"); - - echo "two rows again\n"; - out_result($res,"test5"); - - ibase_free_result($res); - - ibase_commit(); - ibase_commit($tr_1); - - $tr_1 = ibase_trans(); - ibase_query($tr_1, "insert into test5 (i) values (5)"); - - /* tr_2 is IBASE_READ + IBASE_CONCURRENCY + IBASE_WAIT */ - $res = ibase_query($tr_2, "select * from test5"); - - echo "one row in second transaction\n"; - out_result($res,"test5"); - - ibase_free_result($res); - - /* tr_3 is IBASE_COMMITTED + IBASE_REC_VERSION + IBASE_WAIT */ - $res = ibase_query($tr_3, "select * from test5"); - - echo "three rows in third transaction\n"; - out_result($res,"test5"); - - ibase_free_result($res); - - /* tr_4 IBASE_COMMITTED + IBASE_REC_NO_VERSION + IBASE_NOWAIT */ - $res = ibase_query($tr_4, "select * from test5"); - - echo "three rows in fourth transaction with deadlock\n"; - out_result_trap_error($res,"test5"); - - ibase_free_result($res); - - ibase_rollback($tr_1); - ibase_close(); -/* -transactions on second link -*/ - $link_1 = ibase_pconnect($test_base); - $link_2 = ibase_pconnect($test_base); - - $tr_1 = ibase_trans(IBASE_DEFAULT, $link_2); /* this default transaction also */ - $tr_2 = ibase_trans(IBASE_COMMITTED, $link_2); - - $res = ibase_query($tr_1, "select * from test5"); - - echo "three rows\n"; - out_result($res,"test5"); - - ibase_free_result($res); - - ibase_query($tr_1, "insert into test5 (i) values (5)"); - - $res = ibase_query($tr_1, "select * from test5"); - - echo "four rows\n"; - out_result($res,"test5"); - - ibase_free_result($res); - - ibase_commit($tr_1); - - $res = ibase_query($tr_2, "select * from test5"); - - echo "four rows again\n"; - out_result($res,"test5"); - - ibase_free_result($res); - - ibase_close($link_1); - ibase_close($link_2); - - echo "end of test\n"; -?> ---EXPECTF-- -default transaction: -empty table ---- test5 --- ---- -one row ---- test5 --- -1 ---- -after rollback table empty again ---- test5 --- ---- -one row ---- test5 --- -2 ---- -one row ---- test5 --- -2 ---- -one row... again. ---- test5 --- -2 ---- -one row. ---- test5 --- -2 ---- -one row ---- test5 --- -2 ---- -two rows ---- test5 --- -2 -3 ---- -two rows again ---- test5 --- -2 -4 ---- -one row in second transaction ---- test5 --- -2 ---- -three rows in third transaction ---- test5 --- -2 -3 -4 ---- -three rows in fourth transaction with deadlock ---- test5 --- -2 -3 -4 -errmsg [lock conflict on no wait transaction deadlock %a] ---- -three rows ---- test5 --- -2 -3 -4 ---- -four rows ---- test5 --- -2 -3 -4 -5 ---- -four rows again ---- test5 --- -2 -3 -4 -5 ---- -end of test diff --git a/ext/interbase/tests/006.phpt b/ext/interbase/tests/006.phpt deleted file mode 100644 index b3ced2337b..0000000000 --- a/ext/interbase/tests/006.phpt +++ /dev/null @@ -1,300 +0,0 @@ ---TEST-- -InterBase: binding (may take a while) ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php - - require("interbase.inc"); - - ibase_connect($test_base); - - ibase_query( - "create table test6 ( - iter integer, - v_char char(1000), - v_date timestamp, - v_decimal decimal(12,3), - v_double double precision, - v_float float, - v_integer integer, - v_numeric numeric(4,2), - v_smallint smallint, - v_varchar varchar(10000) - )"); - ibase_query( - "create procedure add1 (arg integer) - returns (result integer) - as - begin - result = arg +1; - end"); - ibase_commit(); - - /* if timefmt not supported, hide error */ - ini_set('ibase.timestampformat',"%m/%d/%Y %H:%M:%S"); - - echo "insert\n"; - - for($iter = 0; $iter < 3; $iter++) { - /* prepare data */ - $v_char = rand_str(1000); - $v_date = rand_datetime(); - $v_decimal = rand_number(12,3); - $v_double = rand_number(20); - $v_float = rand_number(7); - $v_integer = rand_number(9,0); - $v_numeric = rand_number(4,2); - $v_smallint = rand_number(5) % 32767; - $v_varchar = rand_str(10000); - - ibase_query("insert into test6 - (iter,v_char,v_date,v_decimal,v_double,v_float, - v_integer,v_numeric,v_smallint,v_varchar) - values (?,?,?,?,?,?,?,?,?,?)", - $iter, $v_char, $v_date, $v_decimal, $v_double, $v_float, - $v_integer, $v_numeric, $v_smallint, $v_varchar); - $sel = ibase_query("select * from test6 where iter = ?", $iter); - - $row = ibase_fetch_object($sel); - if(substr($row->V_CHAR,0,strlen($v_char)) != $v_char) { - echo " CHAR fail:\n"; - echo " in: $v_char\n"; - echo " out: $row->V_CHAR\n"; - } - if($row->V_DATE != $v_date) { - echo " DATE fail\n"; - echo " in: $v_date\n"; - echo " out: $row->V_DATE\n"; - } - if($row->V_DECIMAL != $v_decimal) { - echo " DECIMAL fail\n"; - echo " in: $v_decimal\n"; - echo " out: $row->V_DECIMAL\n"; - } - if(abs($row->V_DOUBLE - $v_double) > abs($v_double / 1E15)) { - echo " DOUBLE fail\n"; - echo " in: $v_double\n"; - echo " out: $row->V_DOUBLE\n"; - } - if(abs($row->V_FLOAT - $v_float) > abs($v_float / 1E7)) { - echo " FLOAT fail\n"; - echo " in: $v_float\n"; - echo " out: $row->V_FLOAT\n"; - } - if($row->V_INTEGER != $v_integer) { - echo " INTEGER fail\n"; - echo " in: $v_integer\n"; - echo " out: $row->V_INTEGER\n"; - } - if ($row->V_NUMERIC != $v_numeric) { - echo " NUMERIC fail\n"; - echo " in: $v_numeric\n"; - echo " out: $row->V_NUMERIC\n"; - } - if ($row->V_SMALLINT != $v_smallint) { - echo " SMALLINT fail\n"; - echo " in: $v_smallint\n"; - echo " out: $row->V_SMALLINT\n"; - } - if ($row->V_VARCHAR != $v_varchar) { - echo " VARCHAR fail:\n"; - echo " in: $v_varchar\n"; - echo " out: $row->V_VARCHAR\n"; - } - ibase_free_result($sel); - }/* for($iter)*/ - - echo "select\n"; - for($iter = 0; $iter < 3; $iter++) { - /* prepare data */ - $v_char = rand_str(1000); - $v_date = (int)rand_number(10,0,0); - $v_decimal = rand_number(12,3); - $v_double = rand_number(20); - $v_float = rand_number(7); - $v_integer = rand_number(9,0); - $v_numeric = rand_number(4,2); - $v_smallint = rand_number(5) % 32767; - $v_varchar = rand_str(10000); - - /* clear table*/ - ibase_query("delete from test6"); - - /* make one record */ - ibase_query("insert into test6 - (iter, v_char,v_date,v_decimal, - v_integer,v_numeric,v_smallint,v_varchar) - values (666, '$v_char',?,$v_decimal, $v_integer, - $v_numeric, $v_smallint, '$v_varchar')",$v_date); - - /* test all types */ - if(!($sel = ibase_query( - "select iter from test6 where v_char = ?", $v_char)) || - !ibase_fetch_row($sel)) { - echo "CHAR fail\n"; - } - ibase_free_result($sel); - if(!($sel = ibase_query( - "select iter from test6 where v_date = ?", $v_date)) || - !ibase_fetch_row($sel)) { - echo "DATE fail\n"; - } - ibase_free_result($sel); - if(!($sel = ibase_query( - "select iter from test6 where v_decimal = ?", $v_decimal)) || - !ibase_fetch_row($sel)) { - echo "DECIMAL fail\n"; - } - ibase_free_result($sel); - if(!($sel = ibase_query( - "select iter from test6 where v_integer = ?", $v_integer)) || - !ibase_fetch_row($sel)) { - echo "INTEGER fail\n"; - } - ibase_free_result($sel); - if(!($sel = ibase_query( - "select iter from test6 where v_numeric = ?", $v_numeric)) || - !ibase_fetch_row($sel)) { - echo "NUMERIC fail\n"; - } - ibase_free_result($sel); - if(!($sel = ibase_query( - "select iter from test6 where v_smallint = ?", $v_smallint)) || - !ibase_fetch_row($sel)) { - echo "SMALLINT fail\n"; - } - ibase_free_result($sel); - if(!($sel = ibase_query( - "select iter from test6 where v_varchar = ?", $v_varchar)) || - !ibase_fetch_row($sel)) { - echo "VARCHAR fail\n"; - } - ibase_free_result($sel); - - } /*for iter*/ - - echo "prepare and exec insert\n"; - - /* prepare table */ - ibase_query("delete from test6"); - - /* prepare query */ - $query = ibase_prepare( - "insert into test6 (v_integer) values (?)"); - - for($i = 0; $i < 10; $i++) { - ibase_execute($query, $i); - } - - out_table("test6"); - - ibase_free_query($query); - - echo "prepare and exec select\n"; - - /* prepare query */ - $query = ibase_prepare("select * from test6 - where v_integer between ? and ?"); - - $low_border = 2; - $high_border = 6; - - $res = ibase_execute($query, $low_border, $high_border); - out_result($res, "test6"); - ibase_free_result($res); - - $low_border = 0; - $high_border = 4; - $res = ibase_execute($query, $low_border, $high_border); - out_result($res, "test6"); - ibase_free_result($res); - - $res = ibase_execute($query, "5", 7.499); - out_result($res, "test6"); - ibase_free_result($res); - - ibase_free_query($query); - - /* test execute procedure */ - $query = ibase_prepare("execute procedure add1(?)"); - $res = array(); - for ($i = 0; $i < 10; $i++) { - $res[] = ibase_execute($query,$i); - } - ibase_free_query($query); - foreach ($res as $r) { - out_result($r, "proc add1"); - ibase_free_result($r); - } - - ibase_close(); - echo "end of test\n"; -?> ---EXPECT-- -insert -select -prepare and exec insert ---- test6 --- - 0 - 1 - 2 - 3 - 4 - 5 - 6 - 7 - 8 - 9 ---- -prepare and exec select ---- test6 --- - 2 - 3 - 4 - 5 - 6 ---- ---- test6 --- - 0 - 1 - 2 - 3 - 4 ---- ---- test6 --- - 5 - 6 - 7 ---- ---- proc add1 --- -1 ---- ---- proc add1 --- -2 ---- ---- proc add1 --- -3 ---- ---- proc add1 --- -4 ---- ---- proc add1 --- -5 ---- ---- proc add1 --- -6 ---- ---- proc add1 --- -7 ---- ---- proc add1 --- -8 ---- ---- proc add1 --- -9 ---- ---- proc add1 --- -10 ---- -end of test diff --git a/ext/interbase/tests/007.phpt b/ext/interbase/tests/007.phpt deleted file mode 100644 index 8afe6e6ca3..0000000000 --- a/ext/interbase/tests/007.phpt +++ /dev/null @@ -1,183 +0,0 @@ ---TEST-- -InterBase: array handling ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php - - require("interbase.inc"); - - ibase_connect($test_base); - - ibase_query( - "create table test7 ( - iter integer, - v_multi integer[10,10,10], - v_char char(100)[10], - v_date timestamp[10], - v_decimal decimal(18,3)[10], - v_double double precision[10], - v_float float[10], - v_integer integer[10], - v_numeric numeric(9,2)[10], - v_smallint smallint[10], - v_varchar varchar(1000)[10] - )"); - ibase_commit(); - - /* if timefmt not supported, hide error */ - ini_set('ibase.timestampformat',"%m/%d/%Y %H:%M:%S"); - - echo "insert\n"; - - for ($i = 1; $i <= 10; ++$i) { - for ($j = 1; $j <= 10; ++$j) { - for ($k = 1; $k <= 10; ++$k) { - $v_multi[$i][$j][$k] = $i * $j * $k; - } - } - } - - for($iter = 0; $iter < 3; $iter++) { - - /* prepare data */ - $v_char = array(); - $v_date = array(); - $v_decimal = array(); - $v_double = array(); - $v_float = array(); - $v_integer = array(); - $v_numeric = array(); - $v_smallint = array(); - $v_varchar = array(); - - for ($i = 1; $i <= 10; ++$i) { - $v_char[$i] = rand_str(100); - $v_date[$i] = rand_datetime(); - $v_decimal[$i] = rand_number(18,3); - $v_double[$i] = rand_number(20); - $v_float[$i] = rand_number(7); - $v_integer[$i] = rand_number(9,0); - $v_numeric[$i] = rand_number(9,2); - $v_smallint[$i] = rand_number(5) % 32767; - $v_varchar[$i] = rand_str(1000); - } - - ibase_query("insert into test7 - (iter,v_multi,v_char,v_date,v_decimal,v_double,v_float, - v_integer,v_numeric,v_smallint,v_varchar) - values (?,?,?,?,?,?,?,?,?,?,?)", - $iter, $v_multi, $v_char, $v_date, $v_decimal, $v_double, $v_float, - $v_integer, $v_numeric, $v_smallint, $v_varchar); - $sel = ibase_query("select * from test7 where iter = $iter"); - - $row = ibase_fetch_object($sel,IBASE_FETCH_ARRAYS); - for ($i = 1; $i <= 10; ++$i) { - - if(strncmp($row->V_CHAR[$i],$v_char[$i],strlen($v_char[$i])) != 0) { - echo " CHAR[$i] fail:\n"; - echo " in: ".$v_char[$i]."\n"; - echo " out: ".$row->V_CHAR[$i]."\n"; - } - if($row->V_DATE[$i] != $v_date[$i]) { - echo " DATE[$i] fail\n"; - echo " in: ".$v_date[$i]."\n"; - echo " out: ".$row->V_DATE[$i]."\n"; - } - if($row->V_DECIMAL[$i] != $v_decimal[$i]) { - echo " DECIMAL[$i] fail\n"; - echo " in: ".$v_decimal[$i]."\n"; - echo " out: ".$row->V_DECIMAL[$i]."\n"; - } - if(abs($row->V_DOUBLE[$i] - $v_double[$i]) > abs($v_double[$i] / 1E15)) { - echo " DOUBLE[$i] fail\n"; - echo " in: ".$v_double[$i]."\n"; - echo " out: ".$row->V_DOUBLE[$i]."\n"; - } - if(abs($row->V_FLOAT[$i] - $v_float[$i]) > abs($v_float[$i] / 1E7)) { - echo " FLOAT[$i] fail\n"; - echo " in: ".$v_float[$i]."\n"; - echo " out: ".$row->V_FLOAT[$i]."\n"; - } - if($row->V_INTEGER[$i] != $v_integer[$i]) { - echo " INTEGER[$i] fail\n"; - echo " in: ".$v_integer[$i]."\n"; - echo " out: ".$row->V_INTEGER[$i]."\n"; - } - if ($row->V_NUMERIC[$i] != $v_numeric[$i]) { - echo " NUMERIC[$i] fail\n"; - echo " in: ".$v_numeric[$i]."\n"; - echo " out: ".$row->V_NUMERIC[$i]."\n"; - } - if ($row->V_SMALLINT[$i] != $v_smallint[$i]) { - echo " SMALLINT[$i] fail\n"; - echo " in: ".$v_smallint[$i]."\n"; - echo " out: ".$row->V_SMALLINT[$i]."\n"; - } - if ($row->V_VARCHAR[$i] != $v_varchar[$i]) { - echo " VARCHAR[$i] fail:\n"; - echo " in: ".$v_varchar[$i]."\n"; - echo " out: ".$row->V_VARCHAR[$i]."\n"; - } - } - ibase_free_result($sel); - }/* for($iter) */ - - echo "select\n"; - - $sel = ibase_query("SELECT v_multi[5,5,5],v_multi[10,10,10] FROM test7 WHERE iter = 0"); - print_r(ibase_fetch_row($sel)); - ibase_free_result($sel); - - for($iter = 1; $iter <= 3; $iter++) { - - if(!($sel = ibase_query( - "select iter from test7 where v_char[$iter] LIKE ?", $v_char[$iter]."%")) || - !ibase_fetch_row($sel)) { - echo "CHAR fail\n"; - } - ibase_free_result($sel); - - if(!($sel = ibase_query( - "select iter from test7 where v_date[$iter] = ?", $v_date[$iter])) || - !ibase_fetch_row($sel)) { - echo "DATE fail\n"; - } - ibase_free_result($sel); - if(!($sel = ibase_query( - "select iter from test7 where v_decimal[$iter] = ?", $v_decimal[$iter])) || - !ibase_fetch_row($sel)) { - echo "DECIMAL fail\n"; - } - ibase_free_result($sel); - if(!($sel = ibase_query( - "select iter from test7 where v_integer[$iter] = ?", $v_integer[$iter])) || - !ibase_fetch_row($sel)) { - echo "INTEGER fail\n"; - } - ibase_free_result($sel); - if(!($sel = ibase_query( - "select iter from test7 where v_numeric[$iter] = ?", $v_numeric[$iter])) || - !ibase_fetch_row($sel)) { - echo "NUMERIC fail\n"; - } - ibase_free_result($sel); - if(!($sel = ibase_query( - "select iter from test7 where v_smallint[$iter] = ?", $v_smallint[$iter])) || - !ibase_fetch_row($sel)) { - echo "SMALLINT fail\n"; - } - ibase_free_result($sel); - } - ibase_close(); - echo "end of test\n"; -?> ---EXPECT-- -insert -select -Array -( - [0] => 125 - [1] => 1000 -) -end of test diff --git a/ext/interbase/tests/008.phpt b/ext/interbase/tests/008.phpt deleted file mode 100644 index c7b01dc2ed..0000000000 --- a/ext/interbase/tests/008.phpt +++ /dev/null @@ -1,48 +0,0 @@ ---TEST-- -InterBase: event handling ---SKIPIF-- -<?php -if (PHP_OS == "WINNT") echo "skip"; -include("skipif.inc"); -?> ---FILE-- -<?php - -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 diff --git a/ext/interbase/tests/bug45373.phpt b/ext/interbase/tests/bug45373.phpt deleted file mode 100644 index 57ac126d07..0000000000 --- a/ext/interbase/tests/bug45373.phpt +++ /dev/null @@ -1,47 +0,0 @@ ---TEST-- -Bug #45373 (php crash on query with errors in params) ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php - - require("interbase.inc"); - - $db = ibase_connect($test_base); - - - $sql = "select * from test1 where i = ? and c = ?"; - - $q = ibase_prepare($db, $sql); - $r = ibase_execute($q, 1, 'test table not created with isql'); - var_dump(ibase_fetch_assoc($r)); - ibase_free_result($r); - - $r = ibase_execute($q, 1, 'test table not created with isql', 1); - var_dump(ibase_fetch_assoc($r)); - ibase_free_result($r); - - $r = ibase_execute($q, 1); - var_dump(ibase_fetch_assoc($r)); - -?> ---EXPECTF-- -array(2) { - ["I"]=> - int(1) - ["C"]=> - string(32) "test table not created with isql" -} - -Notice: ibase_execute(): Statement expects 2 arguments, 3 given in %s on line %d -array(2) { - ["I"]=> - int(1) - ["C"]=> - string(32) "test table not created with isql" -} - -Warning: ibase_execute(): Statement expects 2 arguments, 1 given in %s on line %d - -Warning: ibase_fetch_assoc() expects parameter 1 to be resource, bool given in %s on line %d -NULL diff --git a/ext/interbase/tests/bug45575.phpt b/ext/interbase/tests/bug45575.phpt deleted file mode 100644 index ca0fa831e0..0000000000 --- a/ext/interbase/tests/bug45575.phpt +++ /dev/null @@ -1,22 +0,0 @@ ---TEST-- -Bug #45575 (Segfault with invalid non-string as event handler callback) ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php - -require("interbase.inc"); - -$db = ibase_connect($test_base); - -function foobar($var) { var_dump($var); return true; } - -ibase_set_event_handler($db, null, 'TEST1'); -ibase_set_event_handler($db, 1, 'TEST1'); -ibase_set_event_handler('foobar', 'TEST1'); - -?> ---EXPECTF-- -Warning: ibase_set_event_handler(): Callback argument is not a callable function in %s on line %d - -Warning: ibase_set_event_handler(): Callback argument 1 is not a callable function in %s on line %d diff --git a/ext/interbase/tests/bug46247.phpt b/ext/interbase/tests/bug46247.phpt deleted file mode 100644 index f682ff66f0..0000000000 --- a/ext/interbase/tests/bug46247.phpt +++ /dev/null @@ -1,35 +0,0 @@ ---TEST-- -Bug #46247 (ibase_set_event_handler() is allowing to pass callback without event) ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php - -require("interbase.inc"); - -$db = ibase_connect($test_base); - -function test() { } - -ibase_set_event_handler(); - -ibase_set_event_handler('test', 1); -ibase_set_event_handler($db, 'test', 1); -ibase_set_event_handler(NULL, 'test', 1); - - -ibase_set_event_handler('foo', 1); -ibase_set_event_handler($db, 'foo', 1); -ibase_set_event_handler(NULL, 'foo', 1); - -?> ---EXPECTF-- -Warning: Wrong parameter count for ibase_set_event_handler() in %s on line %d - -Warning: ibase_set_event_handler(): supplied argument is not a valid InterBase link resource in %s on line %d - -Warning: ibase_set_event_handler(): Callback argument foo is not a callable function in %s on line %d - -Warning: ibase_set_event_handler(): Callback argument foo is not a callable function in %s on line %d - -Warning: ibase_set_event_handler(): supplied argument is not a valid InterBase link resource in %s on line %d diff --git a/ext/interbase/tests/bug46543.phpt b/ext/interbase/tests/bug46543.phpt deleted file mode 100644 index 88f38a6bd1..0000000000 --- a/ext/interbase/tests/bug46543.phpt +++ /dev/null @@ -1,28 +0,0 @@ ---TEST-- -Bug #46543 (ibase_trans() memory leaks when using wrong parameters) ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php - -require("interbase.inc"); - -@ibase_close(); - -ibase_trans(1); -ibase_trans(); -ibase_trans('foo'); -ibase_trans(fopen(__FILE__, 'r')); - -$x = ibase_connect($test_base); -ibase_trans(1, 2, $x, $x, 3); - -?> ---EXPECTF-- -Warning: ibase_trans(): supplied resource is not a valid Firebird/InterBase link resource in %sbug46543.php on line %d - -Warning: ibase_trans(): supplied resource is not a valid Firebird/InterBase link resource in %sbug46543.php on line %d - -Warning: ibase_trans(): supplied resource is not a valid Firebird/InterBase link resource in %sbug46543.php on line %d - -Warning: ibase_trans(): supplied resource is not a valid Firebird/InterBase link resource in %sbug46543.php on line %d diff --git a/ext/interbase/tests/ibase_affected_rows_001.phpt b/ext/interbase/tests/ibase_affected_rows_001.phpt deleted file mode 100644 index 398a84c8bb..0000000000 --- a/ext/interbase/tests/ibase_affected_rows_001.phpt +++ /dev/null @@ -1,32 +0,0 @@ ---TEST-- -ibase_affected_rows(): Basic test ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php - -require("interbase.inc"); - -$x = ibase_connect($test_base); - -ibase_query($x, 'INSERT INTO test1 VALUES (1, 100)'); -ibase_query($x, 'INSERT INTO test1 VALUES (10000, 100)'); - -ibase_query($x, 'UPDATE test1 SET i = 10000'); -var_dump(ibase_affected_rows($x)); - - -ibase_query($x, 'UPDATE test1 SET i = 10000 WHERE i = 2.0'); -var_dump(ibase_affected_rows($x)); - -ibase_query($x, 'UPDATE test1 SET i ='); -var_dump(ibase_affected_rows($x)); - - -?> ---EXPECTF-- -int(3) -int(0) - -Warning: ibase_query(): Dynamic SQL Error SQL error code = -104 %s on line %d -int(0) diff --git a/ext/interbase/tests/ibase_close_001.phpt b/ext/interbase/tests/ibase_close_001.phpt deleted file mode 100644 index 80c17314d0..0000000000 --- a/ext/interbase/tests/ibase_close_001.phpt +++ /dev/null @@ -1,23 +0,0 @@ ---TEST-- -ibase_close(): Basic test ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php - -require("interbase.inc"); - -$x = ibase_connect($test_base); -var_dump(ibase_close($x)); -var_dump(ibase_close($x)); -var_dump(ibase_close()); -var_dump(ibase_close('foo')); - -?> ---EXPECTF-- -bool(true) -bool(true) -bool(true) - -Warning: ibase_close() expects parameter 1 to be resource, string given in %s on line %d -NULL diff --git a/ext/interbase/tests/ibase_drop_db_001.phpt b/ext/interbase/tests/ibase_drop_db_001.phpt deleted file mode 100644 index 5aabb8bffe..0000000000 --- a/ext/interbase/tests/ibase_drop_db_001.phpt +++ /dev/null @@ -1,31 +0,0 @@ ---TEST-- -ibase_drop_db(): Basic test ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php - -require("interbase.inc"); - -unlink($file = tempnam('/tmp',"php_ibase_test")); - - -$db = ibase_query(IBASE_CREATE, - sprintf("CREATE SCHEMA '%s' USER '%s' PASSWORD '%s' DEFAULT CHARACTER SET %s",$file, - $user, $password, ($charset = ini_get('ibase.default_charset')) ? $charset : 'NONE')); - -var_dump($db); -var_dump(ibase_drop_db($db)); -var_dump(ibase_drop_db(1)); -var_dump(ibase_drop_db(NULL)); - -?> ---EXPECTF-- -resource(%d) of type (Firebird/InterBase link) -bool(true) - -Warning: ibase_drop_db() expects parameter 1 to be resource, int given in %s on line %d -NULL - -Warning: ibase_drop_db() expects parameter 1 to be resource, null given in %s on line %d -NULL diff --git a/ext/interbase/tests/ibase_errmsg_001.phpt b/ext/interbase/tests/ibase_errmsg_001.phpt deleted file mode 100644 index ad0e827f98..0000000000 --- a/ext/interbase/tests/ibase_errmsg_001.phpt +++ /dev/null @@ -1,22 +0,0 @@ ---TEST-- -ibase_errmsg(): Basic test ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php - -require("interbase.inc"); - -$x = ibase_connect($test_base); - -ibase_query('SELECT Foobar'); -var_dump(ibase_errmsg()); - -ibase_close($x); -var_dump(ibase_errmsg()); - -?> ---EXPECTF-- -Warning: ibase_query(): Dynamic SQL Error SQL error code = -104 %s on line %d -string(%d) "Dynamic SQL Error SQL error code = -104 %s" -bool(false) diff --git a/ext/interbase/tests/ibase_free_query_001.phpt b/ext/interbase/tests/ibase_free_query_001.phpt deleted file mode 100644 index 069f0f0424..0000000000 --- a/ext/interbase/tests/ibase_free_query_001.phpt +++ /dev/null @@ -1,28 +0,0 @@ ---TEST-- -ibase_free_query(): Basic test ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php - -require("interbase.inc"); - -$x = ibase_connect($test_base); - -$q =ibase_prepare($x, 'SELECT 1 FROM test1 WHERE i = ?'); -$q =ibase_prepare($x, 'SELECT 1 FROM test1 WHERE i = ?'); -$q = ibase_prepare($x, 'SELECT 1 FROM test1 WHERE i = ?'); - -var_dump(ibase_free_query($q)); -var_dump(ibase_free_query($q)); -var_dump(ibase_free_query($x)); - -?> ---EXPECTF-- -bool(true) - -Warning: ibase_free_query(): supplied resource is not a valid Firebird/InterBase query resource in %s on line %d -bool(false) - -Warning: ibase_free_query(): supplied resource is not a valid Firebird/InterBase query resource in %s on line %d -bool(false) diff --git a/ext/interbase/tests/ibase_num_fields_001.phpt b/ext/interbase/tests/ibase_num_fields_001.phpt deleted file mode 100644 index 3c4074e244..0000000000 --- a/ext/interbase/tests/ibase_num_fields_001.phpt +++ /dev/null @@ -1,25 +0,0 @@ ---TEST-- -ibase_num_fields(): Basic test ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php - -require("interbase.inc"); - -$x = ibase_connect($test_base); - -var_dump(ibase_num_fields(ibase_query('SELECT * FROM test1'))); - -var_dump(ibase_num_fields(1)); -var_dump(ibase_num_fields()); - -?> ---EXPECTF-- -int(2) - -Warning: ibase_num_fields() expects parameter 1 to be resource, int given in %s on line %d -NULL - -Warning: ibase_num_fields() expects exactly 1 parameter, 0 given in %s on line %d -NULL diff --git a/ext/interbase/tests/ibase_num_params_001.phpt b/ext/interbase/tests/ibase_num_params_001.phpt deleted file mode 100644 index 709c9b769b..0000000000 --- a/ext/interbase/tests/ibase_num_params_001.phpt +++ /dev/null @@ -1,32 +0,0 @@ ---TEST-- -ibase_num_params(): Basic test ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php - -require("interbase.inc"); - -$x = ibase_connect($test_base); - -$rs = ibase_prepare('SELECT * FROM test1 WHERE 1 = ? AND 2 = ?'); -var_dump(ibase_num_params($rs)); - -$rs = ibase_prepare('SELECT * FROM test1 WHERE 1 = ? AND 2 = ?'); -var_dump(ibase_num_params()); - -$rs = ibase_prepare('SELECT * FROM test1 WHERE 1 = ? AND 2 = ? AND 3 = :x'); -var_dump(ibase_num_params($rs)); - - -?> ---EXPECTF-- -int(2) - -Warning: ibase_num_params() expects exactly 1 parameter, 0 given in %s on line %d -NULL - -Warning: ibase_prepare(): Dynamic SQL Error SQL error code = -206 %s in %s on line %d - -Warning: ibase_num_params() expects parameter 1 to be resource, bool given in %s on line %d -NULL diff --git a/ext/interbase/tests/ibase_param_info_001.phpt b/ext/interbase/tests/ibase_param_info_001.phpt deleted file mode 100644 index 31fe196ce6..0000000000 --- a/ext/interbase/tests/ibase_param_info_001.phpt +++ /dev/null @@ -1,53 +0,0 @@ ---TEST-- -ibase_param_info(): Basic test ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php - -require("interbase.inc"); - -$x = ibase_connect($test_base); - -$rs = ibase_prepare('SELECT * FROM test1 WHERE 1 = ? AND 2 = ?'); -var_dump(ibase_param_info($rs, 1)); - -print "---\n"; - -var_dump(ibase_param_info($rs, 100)); - -print "---\n"; - -var_dump(ibase_param_info(100)); - - -?> ---EXPECTF-- -array(10) { - [0]=> - string(0) "" - ["name"]=> - string(0) "" - [1]=> - string(0) "" - ["alias"]=> - string(0) "" - [2]=> - string(0) "" - ["relation"]=> - string(0) "" - [3]=> - string(1) "4" - ["length"]=> - string(1) "4" - [4]=> - string(7) "INTEGER" - ["type"]=> - string(7) "INTEGER" -} ---- -bool(false) ---- - -Warning: ibase_param_info() expects exactly 2 parameters, 1 given in %s on line %d -NULL diff --git a/ext/interbase/tests/ibase_rollback_001.phpt b/ext/interbase/tests/ibase_rollback_001.phpt deleted file mode 100644 index 3cde5e9d46..0000000000 --- a/ext/interbase/tests/ibase_rollback_001.phpt +++ /dev/null @@ -1,41 +0,0 @@ ---TEST-- -ibase_rollback(): Basic test ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php - -require("interbase.inc"); - -$x = ibase_connect($test_base); - -ibase_query('INSERT INTO test1 VALUES (100, 2)'); -ibase_query('INSERT INTO test1 VALUES (100, 2)'); -ibase_query('INSERT INTO test1 VALUES (100, 2)'); - -$rs = ibase_query('SELECT COUNT(*) FROM test1 WHERE i = 100'); -var_dump(ibase_fetch_row($rs)); - -var_dump(ibase_rollback($x)); - -$rs = ibase_query('SELECT COUNT(*) FROM test1 WHERE i = 100'); -var_dump(ibase_fetch_row($rs)); - -var_dump(ibase_rollback($x)); -var_dump(ibase_rollback()); - -?> ---EXPECTF-- -array(1) { - [0]=> - int(3) -} -bool(true) -array(1) { - [0]=> - int(0) -} -bool(true) - -Warning: ibase_rollback(): invalid transaction handle (expecting explicit transaction start) in %s on line %d -bool(false) diff --git a/ext/interbase/tests/ibase_trans_001.phpt b/ext/interbase/tests/ibase_trans_001.phpt deleted file mode 100644 index cceb60e9a1..0000000000 --- a/ext/interbase/tests/ibase_trans_001.phpt +++ /dev/null @@ -1,21 +0,0 @@ ---TEST-- -ibase_trans(): Basic test ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php - -require("interbase.inc"); - -$x = ibase_connect($test_base); -var_dump(ibase_trans($x)); -var_dump(ibase_trans(1)); -var_dump(ibase_close()); -var_dump(ibase_close($x)); - -?> ---EXPECTF-- -resource(%d) of type (Firebird/InterBase transaction) -resource(%d) of type (Firebird/InterBase transaction) -bool(true) -bool(true) diff --git a/ext/interbase/tests/ibase_trans_002.phpt b/ext/interbase/tests/ibase_trans_002.phpt deleted file mode 100644 index be7c073ca3..0000000000 --- a/ext/interbase/tests/ibase_trans_002.phpt +++ /dev/null @@ -1,34 +0,0 @@ ---TEST-- -ibase_trans(): Basic operations ---SKIPIF-- -<?php include("skipif.inc"); ?> ---FILE-- -<?php - -require("interbase.inc"); - -$x = ibase_connect($test_base); - -$trans = ibase_trans(IBASE_DEFAULT, $x); -$sth = ibase_prepare($trans, 'INSERT INTO test1 VALUES (?, ?)'); - -$res = ibase_execute($sth, 100, 100); -var_dump($res); - -ibase_commit($trans); - -$rs = ibase_query($x, 'SELECT * FROM test1 WHERE i = 100'); -var_dump(ibase_fetch_assoc($rs)); - -ibase_free_query($sth); -unset($res); - -?> ---EXPECT-- -int(1) -array(2) { - ["I"]=> - int(100) - ["C"]=> - string(3) "100" -} diff --git a/ext/interbase/tests/interbase.inc b/ext/interbase/tests/interbase.inc deleted file mode 100644 index eb762b5d90..0000000000 --- a/ext/interbase/tests/interbase.inc +++ /dev/null @@ -1,120 +0,0 @@ -<?php - -srand((double)microtime()*1000000); - -$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(sys_get_temp_dir(),"php_ibase_test")); - -function init_db() -{ - global $test_base, $user, $password; - - $test_db = ibase_query(IBASE_CREATE, - sprintf("CREATE SCHEMA '%s' USER '%s' PASSWORD '%s' DEFAULT CHARACTER SET %s",$test_base, - $user, $password, ($charset = ini_get('ibase.default_charset')) ? $charset : 'NONE')); - $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(); - -function out_table($table_name) -{ - echo "--- $table_name ---\n"; - $res = ibase_query("select * from $table_name"); - while ($r = ibase_fetch_row($res)) { - echo join("\t",$r)."\t\n"; - } - ibase_free_result($res); - echo "---\n"; -} - -function out_result($result, $table_name = "") -{ - echo "--- $table_name ---\n"; - while ($r = ibase_fetch_row($result)) { - echo join("\t",$r)."\t\n"; - } - echo "---\n"; -} - -function out_result_trap_error($result, $table_name = "") -{ - echo "--- $table_name ---\n"; - while ($r = @ibase_fetch_row($result)) { - echo join("\t",$r)."\t\n"; - } - echo "errmsg [" . ibase_errmsg() . "]\n"; - echo "---\n"; -} - -/* M/D/Y H:M:S */ -function rand_datetime() -{ - return sprintf("%02d/%02d/%4d %02d:%02d:%02d", - rand()%12+1, rand()%28+1, rand()%100+1910, - rand()%24, rand()%60, rand()%60); -} - -/* random binary string */ -function rand_binstr($max_len) -{ - $len = rand() % $max_len; - $s = ""; - while($len--) { - $s .= sprintf("%c", rand() % 256); - } - return $s; -} - -function rand_str($max_len) -{ - $len = rand() % $max_len; - $s = ""; - while ($len--) { - $s .= sprintf("%c", rand() % 26 + 65); - } - return $s; -} - -function rand_number($len , $prec = -1, $sign = 1) -{ - if ($prec == -1) { - $n = substr(rand() . rand(), 0, rand() % $len + 1); - if (strlen($n) < $len) { - $n .= "." . substr(rand(), 0, rand() % ($len - strlen($n)) + 1); - } - } else if ($prec == 0) { - $n = substr(rand() . rand(), 0, rand() % $len + 1); - } else if (($prec - $len) == 0) { - $n = substr(rand() . rand(), 0, 1); - $n .= "." . substr(rand(), 0, $prec); - } else { - $n = substr(rand() . rand(), 0, rand() % ($len - $prec) + 1); - $n .= "." . substr(rand(), 0, $prec); - } - if ($sign && (rand() % 3 == 0)) { - $n = "-" .$n; - } - return $n; -} - -?> diff --git a/ext/interbase/tests/skipif.inc b/ext/interbase/tests/skipif.inc deleted file mode 100644 index c854f5bc99..0000000000 --- a/ext/interbase/tests/skipif.inc +++ /dev/null @@ -1,8 +0,0 @@ -<?php - -if (!extension_loaded("interbase")) print "skip interbase extension not available"; -require("interbase.inc"); -if(!@ibase_connect($test_base)){ - die("skip cannot connect"); -} -?> |