Newsgroups: php.internals
Path: news.php.net
Xref: news.php.net php.internals:9834
Mailing-List: contact internals-help@lists.php.net; run by ezmlm
To: "'Stanislav Malyshev'" <stas@zend.com>,
	"'PHP Development'" <internals@lists.php.net>
Date: Thu, 13 May 2004 14:32:44 +0100
Organization: The Brain Room Ltd.
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
In-Reply-To: <Pine.LNX.4.58.0405131619310.4366@shire.zend.office>
Thread-Index: AcQ47djdrtilCPD0QWegvEp8JZxlaQAAIs6g
Message-ID: <20040513133242.6046D14880BC@mx.thebrainroom.net>
Subject: RE: [PHP-DEV] SQLite API deficiency
From: wez@thebrainroom.com ("Wez Furlong")
References: <Pine.LNX.4.58.0405131619310.4366@shire.zend.office>

I've been bitten by this too, but didn't get time to delve into it.

Can the compile/step definitely not handle multiple queries?
That's a shame :/

I'm currently in DB API mode (working on PDO), so I'll refresh my memory
and do some sqlite stuff over the next few days; if there is no way to
get the compile/step executing multiple queries, then we will need a new
function as you suggest.

--Wez.

> -----Original Message-----
> From: Stanislav Malyshev [mailto:stas@zend.com] 
> Sent: 13 May 2004 14:26
> To: PHP Development
> Subject: [PHP-DEV] SQLite API deficiency
> 
> I have discovered that SQLite function sqlite_query runs sqlite_exec 
> function if it's return value is used and 
> sqlite_compile/sqlite_step combo 
> if return value is used. I think this is a problem - if I 
> want to run some 
> pack of queries (like, create whole DB schema in one call), I 
> can do it 
> with sqlite_query - but only if I don't check the return 
> value - and thus 
> don't know if it succeeded or not! If I check the return 
> value, it runs 
> sqlite_compile/sqlite_step, which can not run multiple SQL 
> statements. 
> 
> I think this should be fixed. In order not to break BC, I 
> propose to add 
> new function to SQLite API - sqlite_exec, which - surprise! - 
> would always 
> call sqlite_exec and would return only true/false. Though, 
> the even better 
> solution would be to kill that return_value_used check 
> altogether and use 
> two separate functions always, depending on the task.
> 
> Any thoughts about this?
> -- 
> Stanislav Malyshev, Zend Products Engineer   
> stas@zend.com  http://www.zend.com/ +972-3-6139665 ext.115
> 
> -- 
> PHP Internals - PHP Runtime Development Mailing List
> To unsubscribe, visit: http://www.php.net/unsub.php
> 
>