From: [EMAIL PROTECTED]
Operating system:
PHP version: 4.2.3
PHP Bug Type: Feature/Change Request
Bug description: Changing PEAR::DB
I am justing getting into working with the PEAR::DB and DB_DataObjects
code.
I have some changes that I am making to PEAR::DB and would like to know
who to talk to or how I should submit those changes.
The following is what I am changing:
In PEAR::DB common.php file:
Added an new option to the $options array:
'setPrefetch' => 1
For advanced Oracle queries, you use the OCI8setPrefetch limit to > 1.
Other databases might find this useful for processing large queries if
supported by the database type.
Secondly, in PEAR::DB DB.php
I am adding a fetchStatement routine to DB_result class that supports
limiting and the rownum feature. This then calls the appropriate
$this->dbh->fetchStatement() routine.
There are others as well, adding a static variable to numCols and numRows
so that fetchStatement can load these variables, while fetchInto and
fetchRow stills functions as expected.
In DB_oci8, changed constructor to use OCI8setPrefetch based upon the
$this->option["setPrefetch"]
Created an OCI8setPrefetch function so that it can be called
specifically/dynamically when the option changes. Currently the change
only is reflected in new DB objects after setOptions is called.
As mentioned, changed numRows/numCols also in DB_oci8.
Adding DB_AUTOQUERY_DELETE to buildManipSQL.
Other changes, I am adding. Get number of rows for table in tableInfo for
oci8. Can use statistics from the table or use COUNT(*) - I will be doing
this shortly.
I am doing a very large project with PEAR::DB and DB_DataObjects using
Oracle to start, with versions running on mysql, mssql, potentially
access, db2, Sybase, etc.
In doing so, I have created an offshoot of DB_Dataobjects that will fully
sustain many Databases in the same fashion as PEAR::DB. Alan and I have
already talked about it. But I am just informing the community.
How can I submit the changes to the PEAR::DB code.
--
Edit bug report at http://bugs.php.net/?id=21418&edit=1
--
Try a CVS snapshot: http://bugs.php.net/fix.php?id=21418&r=trysnapshot
Fixed in CVS: http://bugs.php.net/fix.php?id=21418&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=21418&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=21418&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=21418&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=21418&r=support
Expected behavior: http://bugs.php.net/fix.php?id=21418&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=21418&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=21418&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=21418&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=21418&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=21418&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=21418&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=21418&r=gnused
