SQLite API deficiency
| From: | Stanislav Malyshev | Date: | Thu, 13 May 2004 13:25:59 +0000 |
| Subject: | SQLite API deficiency | ||
| Groups: | php.internals | ||
| Request: | Send a blank email to internals+get-9833@lists.php.net to get a copy of this message | ||
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