Denis,
Could you merge the patches into a single for easier code review.
Also, the copy to/from file seems like it would just be a wrapper
against the native COPY PostgreSQL command, is there really a need to
provide a method for it?
On Mon, May 24, 2010 at 4:57 AM, Denis Gasparin <
denis.gaspa...@edistar.com > wrote:
Hi.
I developed some patches for PDO/Postgresql driver in order to add
some useful methods that were available in the original pgsql driver.
The attached patches apply on 5.3.2 and svn 5.3.x.
If needed, i have patches also for 5.2.x.
Please comment and tell me improvements or tips.
Thank you in advance,
Denis Gasparin
Documentation of the added methods follows:
pgsqlIsInTransaction()
It uses the native Postgresql functions to check transaction status..
It returns one of the following status codes:
* PDO::PGSQL_TRANSACTION_IDLE: connection in idle status
* PDO::PGSQL_TRANSACTION_ACTIVE: connection is executing a command
* PDO::PGSQL_TRANSACTION_INTRANS: connection is idle in a valid
transaction block
* PDO::PGSQL_TRANSACTION_INERROR: connection is idle, in a failed
transaction block
* PDO::PGSQL_TRANSACTION_UNKNOWN: connection is in a bad status
pgsqlCopyFromArray($table,Array $data,$delimiter,$null, Array
$fields)
It uses the native Postgresql copy construct to append $data to
$table. It returns boolean.
Parameters: * (mandatory) $table: table to append data to
* (mandatory) $data: Array of rows with data in table field order
(or as specified in the $fields array). Fields must be separated by
$delimiter or by
postgresql standard \t)
* $delimiter: alternative delimiter to use in place of the standard
postgres delimiter ("\t")
* $null: alternative string to use as null value. Default is "\N"
* $fields: array with table fields that are specified in $data
parameter
pgsqlCopyFromFile($table,$filename,$delimiter,$null,$fields)
It uses the native Postgresql copy construct to append $filename
contents to $table.
It returns boolean.
Parameters: * (mandatory) $table: table to append data to.
* (mandatory) $filename: file with contents to append to $table. See
Postgresql documentation for the format.
* $delimiter: alternative delimiter to use in place of the standard
postgres delimiter ("\t")
* $null: alternative string to use as null value. Default is "\N"
* $fields: array with table fields that are specified in $filename
file
pgsqlCopyToArray($table,$delimiter,$null,$fields)
It uses the native Postgresql copy construct to retrieve $table
contents and store them to an array.
It returns an array of rows or false in case of problems.
The format of the rows into the array is indicated in the $delimiter,
$null and $fields parameters.
Parameters: * (mandatory) $table: table to retrieve data from.
* $delimiter: alternative delimiter to use in place of the standard
postgres delimiter ("\t")
* $null: alternative string to use as null value. Default is "\N"
* $fields: array with table fields to include in the row of the
array.
pgsqlCopyToFile($table,$filename,$delimiter,$null,$fields)
It uses the native Postgresql copy construct to retrieve $table
contents and store them into a file.
It returns boolean.
The format of the rows stored into the file is indicated in the
$delimiter, $null and $fields parameters.
Parameters: * (mandatory) $table: table to retrieve data from.
* (mandatory) $filename: file where to store the contents of the
table
* $delimiter: alternative delimiter to use in place of the standard
postgres delimiter ("\t")
* $null: alternative string to use as null value. Default is "\N"
* $fields: array with table fields to include in the row of the
array.
-- PHP Internals - PHP Runtime Development Mailing List
To unsubscribe, visit: http://www.php.net/unsub.php
