Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:26645
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
Received-SPF: pass (pb1.pair.com: domain googlemail.com designates 66.249.82.235 as permitted sender)
DomainKey-Status: good
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=googlemail.com;
        h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=kK39MxvWcQdnRwJbVJ6b8pbFPsg+bTTLWjtap8fci5bjyXeHCqicIkodxcsez8ZvXO2k5CdC6jdoEzqBgbFSdi/lBfSWMMSoKTB1Hh8SuBAuGx7/SPvJ8TIZWqh6kh0L4zPg/MoQj9jajYX95CqTWMaLKKILJYQ5b2rXyuSsvTA=
Message-ID: <9bb5e33f0611160752g38cdc4acy92e0f72b9aee9c8b@mail.gmail.com>
Date: Thu, 16 Nov 2006 16:52:52 +0100
To: "Wez Furlong" <kingwez@gmail.com>
Cc: internals@lists.php.net
In-Reply-To: <9bb5e33f0611160745i4ef015e7i16933d7a4904a6ff@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <9bb5e33f0611160505u2ac2b1dbt1b04feea4314331c@mail.gmail.com>
	 <4e89b4260611160629o1855ed28pf37139f1576fa99b@mail.gmail.com>
	 <9bb5e33f0611160721l6676cbe5ud0185127fad03402@mail.gmail.com>
	 <9bb5e33f0611160745i4ef015e7i16933d7a4904a6ff@mail.gmail.com>
Subject: Re: [PHP-DEV] Enable authorizer-feature in PDO_SQLITE
From: wolfshoehle@googlemail.com ("Mario Wolff")

Short test script:

<?php
$data = array( 'one', 'two', 'three', 'four', 'five', 'six');
$db = new PDO( 'sqlite::memory:');
echo "register authorizer\n";
$db->sqliteSetAuthorizer('auth');
$db->exec( "CREATE TABLE strings( a)");
$insert = $db->prepare( 'INSERT INTO strings VALUES ( ?)');
foreach ( $data as $str) {

       $insert->execute( array( $str));
}
$insert = null;
echo "unregister authorizer\n";
$db->sqliteSetAuthorizer();

function auth($type,$arga,$argb,$argc,$argd ){
    echo "$type\t$arga\t$argb\t$argc\t$argd\n";
    return true;
}
print_r( $db->query( 'SELECT sqlite_version( *);')->fetchAll( ));

?>

gives:
register authorizer
SQLITE_INSERT   sqlite_master           main
SQLITE_CREATE_TABLE     strings         main
SQLITE_UPDATE   sqlite_master   type    main
SQLITE_UPDATE   sqlite_master   name    main
SQLITE_UPDATE   sqlite_master   tbl_name        main
SQLITE_UPDATE   sqlite_master   rootpage        main
SQLITE_UPDATE   sqlite_master   sql     main
SQLITE_READ     sqlite_master   ROWID   main
SQLITE_READ     sqlite_master   name    main
SQLITE_READ     sqlite_master   rootpage        main
SQLITE_READ     sqlite_master   sql     main
SQLITE_READ     sqlite_master   tbl_name        main
SQLITE_INSERT   strings         main
unregister authorizer
Array
(
    [0] => Array
        (
            [sqlite_version( *)] => 3.3.7
            [0] => 3.3.7
        )

)