SQLite API deficiency

From: 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

« previous php.internals (#9833) next »