Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:57484
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: pass (pb1.pair.com: domain damz.org designates 74.125.82.170 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <CAEakXBrh4H4f+N0XU_fPxWCnnS3eCAguD3DQwe-iyoKjWf9U+A@mail.gmail.com>
References: <CAEakXBrh4H4f+N0XU_fPxWCnnS3eCAguD3DQwe-iyoKjWf9U+A@mail.gmail.com>
Date: Mon, 23 Jan 2012 23:44:02 +0100
Message-ID: <CALWK-fiZu82X8WhnZjoh2Z20mzZxt0rv2tWE7T4JttfcTEQpJg@mail.gmail.com>
To: b dewar <macdewar@gmail.com>
Cc: internals@lists.php.net
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Subject: Re: [PHP-DEV] SQLite3 class missing createCollation()
From: damz@damz.org (Damien Tournoud)

Also see https://bugs.php.net/bug.php?id=3D55226

Same idea, but for the PDO_sqlite implementation.

Damien

On Mon, Jan 23, 2012 at 11:28 PM, b dewar <macdewar@gmail.com> wrote:
> Hi
>
> I initially sent this to php-db, but I guess it really belongs on interna=
ls.
>
> The C API for SQLite3 has an sqlite3_create_collation() feature that's
> missing from PHP's SQLite3 class API.
>
> I'm working on a patch that adds the SQLite3::createCollation(string
> collation_name, mixed callback) method.=A0 This allows registering a PHP
> function as a comparator for the database to use while collating data.
> =A0The callback passed to createCollation() should act like strcmp(),
> i.e. it should accept two strings and return an integer indicating
> their relative sort order.
>
> e.g.
>
> <?php
>
> $filenames =3D array(
> =A0 'ab1.png',
> =A0 'ab2.png',
> =A0 'ab10.png',
> =A0 'ab11.png',
> =A0 'ac.png',
> =A0 'aa.png',
> =A0 'ab3.png');
>
> $db =3D new SQLite3(':memory:');
>
> $db->createCollation('NATURAL_SORT', 'strnatcmp');
>
> $db->exec("CREATE TABLE filenames (fname varchar(32));");
>
> $stmt =3D $db->prepare("INSERT INTO filenames VALUES (?);");
> foreach($filenames as $fname){
> =A0 $stmt->bindParam(1, $fname);
> =A0 $stmt->execute();
> }
> $result =3D $db->query("SELECT fname FROM filenames ORDER BY fname
> COLLATE NATURAL_SORT;");
> while($row =3D $result->fetchArray()){
> =A0 echo $row['fname'], "\n";
> }
>
> $db->close();
>
> ?>
>
> Output:
>
> aa.png
> ab1.png
> ab2.png
> ab3.png
> ab10.png
> ab11.png
> ac.png
>
>
>
> I've built 5.3.9 with my patch on Ubuntu on x86_64, and it works as
> expected. I've never submitted a patch for PHP before, so I could use
> some advice/hand-holding on the process.
>
> Thanks,
> Brad
>
> --
> PHP Internals - PHP Runtime Development Mailing List
> To unsubscribe, visit: http://www.php.net/unsub.php
>