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