Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:42487
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: error (pb1.pair.com: domain pooteeweet.org from 88.198.8.16 cause and error)
Cc: Oskar Eisemuth <patchnow@gmail.com>
Message-ID: <65868A42-9F4A-43B1-8D51-C426E24B7B0F@pooteeweet.org>
To: internals@lists.php.net
In-Reply-To: <495FCE1A.2000904@gmail.com>
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0 (Apple Message framework v930.3)
Date: Mon, 5 Jan 2009 16:32:31 +0100
References: <495FCE1A.2000904@gmail.com>
Subject: Re: [PHP-DEV] PDO: table name of field in SQLite #42589 and a new fetch style FETCH_ASSOC_TREE
From: mls@pooteeweet.org (Lukas Kahwe Smith)


On 03.01.2009, at 21:44, Oskar Eisemuth wrote:

> Hi
>
> Receiving the table name for an column is quite useful.
> It is not possible for all PDO database drivers to support this  
> functionally, still at least the SQLite version could support it  
> when Bug #42589 is resolved. ATTR_FETCH_TABLE_NAMES should be added  
> to SQLite too.

Scott said he would look into committing the patch for SQLite.

> PDO::FETCH_ASSOC_TREE
> Using the column key to build a hierarchical tree structure by using  
> the dot as delimiter for the keys.


Personally I am not such a fan of the bit-wise parameter approach.  
Then again it provides a lot of flexibility. That being said finding a  
good API for this particular feature is non trivial (maybe we can  
borrow from LINQ?). Of course having PHP do this work internally is  
more efficient than doing it in userland and I think its an often seen  
enough use case. So I guess file a feature request, ideally with a  
solid proposal for an API for this.

regards,
Lukas Kahwe Smith
mls@pooteeweet.org