Gecko [ www.foryou-vip.com ]

Name	Size	Permission	Date
bug41996.phpt	491 B	-rw-rw-r--	2022-10-31 11:36
bug44301.phpt	811 B	-rw-rw-r--	2022-10-31 11:36
bug46274.phpt	1.46 KB	-rw-rw-r--	2022-10-31 11:36
bug46274_2.phpt	1.66 KB	-rw-rw-r--	2022-10-31 11:36
bug54379.phpt	1.12 KB	-rw-rw-r--	2022-10-31 11:36
bug57702.phpt	4.25 KB	-rw-rw-r--	2022-10-31 11:36
bug60994.phpt	4.71 KB	-rw-rw-r--	2022-10-31 11:36
bug_33707.phpt	697 B	-rw-rw-r--	2022-10-31 11:36
checkliveness.phpt	1.16 KB	-rw-rw-r--	2022-10-31 11:36
common.phpt	701 B	-rw-rw-r--	2022-10-31 11:36
pdo_oci_attr_action.phpt	1.18 KB	-rw-rw-r--	2022-10-31 11:36
pdo_oci_attr_autocommit_1.phpt	1.65 KB	-rw-rw-r--	2022-10-31 11:36
pdo_oci_attr_autocommit_2.phpt	3.52 KB	-rw-rw-r--	2022-10-31 11:36
pdo_oci_attr_autocommit_3.phpt	1.29 KB	-rw-rw-r--	2022-10-31 11:36
pdo_oci_attr_case.phpt	1.81 KB	-rw-rw-r--	2022-10-31 11:36
pdo_oci_attr_client.phpt	975 B	-rw-rw-r--	2022-10-31 11:36
pdo_oci_attr_client_identifier.phpt	1.38 KB	-rw-rw-r--	2022-10-31 11:36
pdo_oci_attr_client_info.phpt	1.27 KB	-rw-rw-r--	2022-10-31 11:36
pdo_oci_attr_drivername.phpt	420 B	-rw-rw-r--	2022-10-31 11:36
pdo_oci_attr_module.phpt	1.06 KB	-rw-rw-r--	2022-10-31 11:36
pdo_oci_attr_nulls_1.phpt	1.38 KB	-rw-rw-r--	2022-10-31 11:36
pdo_oci_attr_prefetch_1.phpt	1.54 KB	-rw-rw-r--	2022-10-31 11:36
pdo_oci_attr_prefetch_2.phpt	1.18 KB	-rw-rw-r--	2022-10-31 11:36
pdo_oci_attr_server.phpt	856 B	-rw-rw-r--	2022-10-31 11:36
pdo_oci_class_constants.phpt	1.32 KB	-rw-rw-r--	2022-10-31 11:36
pdo_oci_fread_1.phpt	5.19 KB	-rw-rw-r--	2022-10-31 11:36
pdo_oci_quote1.phpt	2.54 KB	-rw-rw-r--	2022-10-31 11:36
pdo_oci_stmt_getcolumnmeta.phpt	10.35 KB	-rw-rw-r--	2022-10-31 11:36
pdo_oci_stream_1.phpt	3.38 KB	-rw-rw-r--	2022-10-31 11:36
pdo_oci_stream_2a.phpt	2.2 KB	-rw-rw-r--	2022-10-31 11:36
pdo_oci_stream_2b.phpt	1.82 KB	-rw-rw-r--	2022-10-31 11:36
pdo_oci_templob_1.phpt	2.53 KB	-rw-rw-r--	2022-10-31 11:36
pecl_bug_11345.phpt	734 B	-rw-rw-r--	2022-10-31 11:36
pecl_bug_6364.phpt	1.55 KB	-rw-rw-r--	2022-10-31 11:36

Rename

--TEST--
PDO OCI: Inserts 10K with 1 number and 2 LOB columns (stress test)
--SKIPIF--
<?php
if (!extension_loaded('pdo') || !extension_loaded('pdo_oci')) die('skip not loaded');
if (getenv('SKIP_SLOW_TESTS')) die('skip slow tests excluded by request');
require(__DIR__.'/../../pdo/tests/pdo_test.inc');
PDOTest::skip();
?>
--FILE--
<?php

require(__DIR__ . '/../../pdo/tests/pdo_test.inc');

$db = PDOTest::factory();

$query = "begin execute immediate 'drop table pdo_oci_stream_2'; exception when others then if sqlcode <> -942 then raise; end if; end;";
$stmt = $db->prepare($query);
$stmt->execute();

$query = "create table pdo_oci_stream_2 (id number, data1 blob, data2 blob)";
$stmt = $db->prepare($query);
$stmt->execute();

function do_insert($db, $id, $data1, $data2)
{
    $db->beginTransaction();
    $stmt = $db->prepare("insert into pdo_oci_stream_2 (id, data1, data2) values (:id, empty_blob(), empty_blob()) returning data1, data2 into :blob1, :blob2");
    $stmt->bindParam(':id', $id);
    $stmt->bindParam(':blob1', $blob1, PDO::PARAM_LOB);
    $stmt->bindParam(':blob2', $blob2, PDO::PARAM_LOB);
    $blob1 = null;
    $blob2 = null;
    $stmt->execute();

fwrite($blob1, $data1);
    fclose($blob1);
    fwrite($blob2, $data2);
    fclose($blob2);
    $db->commit();
}

$a1 = str_repeat('a', 4086);
$a2 = str_repeat('b', 4087);
$a3 = str_repeat('c', 4088);
$a4 = str_repeat('d', 4089);
$a5 = str_repeat('e', 4090);
$a6 = str_repeat('f', 4091);
$a7 = str_repeat('g', 4092);
$a8 = str_repeat('h', 4093);
$a9 = str_repeat('i', 4094);
$a10 = str_repeat('j', 4095);

printf("Inserting 10000 Records ... ");
for($i=0; $i<1000; $i++) {
    do_insert($db, $i * 10 + 1, $a1, $a10);
    do_insert($db, $i * 10 + 2, $a2, $a9);
    do_insert($db, $i * 10 + 3, $a3, $a8);
    do_insert($db, $i * 10 + 4, $a4, $a7);
    do_insert($db, $i * 10 + 5, $a5, $a6);
    do_insert($db, $i * 10 + 6, $a6, $a5);
    do_insert($db, $i * 10 + 7, $a7, $a4);
    do_insert($db, $i * 10 + 8, $a8, $a3);
    do_insert($db, $i * 10 + 9, $a9, $a2);
    do_insert($db, $i * 10 + 10, $a10, $a1);
}
printf("Done\n");

/* Cleanup is done in pdo_oci_stream_2b.phpt */
//$db->exec("drop table pdo_oci_stream_2");

?>
--EXPECT--
Inserting 10000 Records ... Done