Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:45705
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: pass (pb1.pair.com: domain beccati.com designates 213.92.90.60 as permitted sender)
Message-ID: <4ACF0A9F.3000804@beccati.com>
Date: Fri, 09 Oct 2009 12:04:15 +0200
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
To: Christopher Jones <christopher.jones@oracle.com>
CC: Samuel ROZE <samuel.roze@gmail.com>, internals@lists.php.net
References: <1255038690.10759.9.camel@samuel-laptop>	 <4ACE6613.808@oracle.com> <1255067917.4144.4.camel@samuel-laptop> <4ACED592.7070807@oracle.com>
In-Reply-To: <4ACED592.7070807@oracle.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Subject: Re: [PHP-DEV] Patch: Use notices in PDO
From: php@beccati.com (Matteo Beccati)

Christopher Jones ha scritto:
> 
> Samuel ROZE wrote:
>> It's a good idea.
>>
>> - PDO::NOTICES_FETCH -> PDO::NOTICES_ENABLED
>> - PDO::NOTICES_NONE  -> PDO::NOTICES_DISABLED
>>
>> That's better ?
> 
> That works.
> 
>> I see that you are from the Oracle team. Can you explain me how oracle
>> works to raise notices like PostgreSQL ? Or can you build a proof of
>> concept to get notices from Oracle ?
> 
> I'm equating your NOTICES to Oracle's DBMS_OUTPUT.  See "Getting
> Output with DBMS_OUTPUT" on p 181 of:
> 
> http://www.oracle.com/technology/tech/php/underground-php-oracle-manual.html
> 
> 
> Something similar could be coded in the PDO driver.
> 
> The amount of text output could be quite large, depending on the
> user's coding style.  Is your design extensible enough to allow for
> streaming/chunking if the interface needs to be enhanced?

How about:

PDO::NOTICES_DISABLED
PDO::NOTICES_ARRAY

to allow space for different formats (e.g. PDO::NOTICES_RESULTSET)?


> PL/SQL also has compile time warnings and errors that are handled
> differently, see "PL/SQL Success With Information Warnings" on p167.

However, having read the above chapter, it seems to me that error code
24344 with its warnings is more similar to MySQL warnings and PgSQL
notices. Which one should be automatically handled by PDO? I'd vote for
this one, leaving DBMS_OUTPUT still available by manually sending the
queries highligthed in your book.


Cheers
-- 
Matteo Beccati