cvs: php-src /ext/sqlite3/tests sqlite3_02_open.phpt sqlite3_31_changes.phpt sqlite3_31_open.phpt sqlite3_32_changes.phpt
sqlite3_32_createAggregate_paramCount.phpt sqlite3_32_last_insert_rowid_param.phpt sqlite3_33_createAggregate_notcallable.phpt
sqlite3_33_load_extension_param.phpt sqlite3_33_reset.phpt sqlite3_34_load_extension_ext_dir.phpt sqlite3_close_error.phpt
sqlite3_close_with_params.phpt sqlite3_enable_exceptions.phpt sqlite3_exec_wrongparams.phpt sqlite3_lasterrorcode_with_params.phpt
sqlite3_lasterrormsg_with_params.phpt sqlite3_loadextension_with_wrong_param.phpt sqlite3_open_empty_string.phpt sqlite3_openblob_wrongparams.phpt
sqlite3_prepare_faultystmt.phpt sqlite3_prepare_with_empty_string.phpt sqlite3_prepare_wrongparams.phpt sqlite3_prepared_stmt_clear_with_params.phpt
sqlite3_query_error.phpt sqlite3_querysingle_error.phpt sqlite3_version_noparam.phpt sqlite3result_fetcharray_with_two_params_fails.phpt
sqlite3result_numcolumns_error.phpt sqlite3r! esult_reset_with_params_fails.phpt sqlite3stmt_reset_params.phpt
| From: | Felipe Pena | Date: | Sun, 17 May 2009 16:51:23 +0000 |
| Subject: | cvs: php-src /ext/sqlite3/tests sqlite3_02_open.phpt sqlite3_31_changes.phpt sqlite3_31_open.phpt sqlite3_32_changes.phpt sqlite3_32_createAggregate_paramCount.phpt sqlite3_32_last_insert_rowid_param.phpt sqlite3_33_createAggregate_notcallable.phpt sqlite3_33_load_extension_param.phpt sqlite3_33_reset.phpt sqlite3_34_load_extension_ext_dir.phpt sqlite3_close_error.phpt sqlite3_close_with_params.phpt sqlite3_enable_exceptions.phpt sqlite3_exec_wrongparams.phpt sqlite3_lasterrorcode_with_params.phpt sqlite3_lasterrormsg_with_params.phpt sqlite3_loadextension_with_wrong_param.phpt sqlite3_open_empty_string.phpt sqlite3_openblob_wrongparams.phpt sqlite3_prepare_faultystmt.phpt sqlite3_prepare_with_empty_string.phpt sqlite3_prepare_wrongparams.phpt sqlite3_prepared_stmt_clear_with_params.phpt sqlite3_query_error.phpt sqlite3_querysingle_error.phpt sqlite3_version_noparam.phpt sqlite3result_fetcharray_with_two_params_fails.phpt sqlite3result_numcolumns_error.phpt sqlite3r! esult_reset_with_params_fails.phpt sqlite3stmt_reset_params.phpt |
||
| Groups: | php.cvs | ||
| Request: | Send a blank email to php-cvs+get-57928@lists.php.net to get a copy of this message | ||
felipe Sun May 17 16:51:23 2009 UTC
Added files:
/php-src/ext/sqlite3/tests sqlite3_02_open.phpt
sqlite3_31_changes.phpt
sqlite3_31_open.phpt
sqlite3_32_changes.phpt
sqlite3_32_createAggregate_paramCount.phpt
sqlite3_32_last_insert_rowid_param.phpt
sqlite3_33_createAggregate_notcallable.phpt
sqlite3_33_load_extension_param.phpt
sqlite3_33_reset.phpt
sqlite3_34_load_extension_ext_dir.phpt
sqlite3_close_error.phpt
sqlite3_close_with_params.phpt
sqlite3_enable_exceptions.phpt
sqlite3_exec_wrongparams.phpt
sqlite3_lasterrorcode_with_params.phpt
sqlite3_lasterrormsg_with_params.phpt
sqlite3_loadextension_with_wrong_param.phpt
sqlite3_open_empty_string.phpt
sqlite3_openblob_wrongparams.phpt
sqlite3_prepare_faultystmt.phpt
sqlite3_prepare_with_empty_string.phpt
sqlite3_prepare_wrongparams.phpt
sqlite3_prepared_stmt_clear_with_params.phpt
sqlite3_query_error.phpt
sqlite3_querysingle_error.phpt
sqlite3_version_noparam.phpt
sqlite3result_fetcharray_with_two_params_fails.phpt
sqlite3result_numcolumns_error.phpt
sqlite3result_reset_with_params_fails.phpt
sqlite3stmt_reset_params.phpt
Log:
- New tests (testfest BelgiumUG)
http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_02_open.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_02_open.phpt +++ php-src/ext/sqlite3/tests/sqlite3_02_open.phpt --TEST-- SQLite3::open test, testing for function parameters --CREDITS-- Felix De Vliegher # Belgian PHP Testfest 2009 --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php try { $db = new SQLite3(); } catch (Exception $e) { var_dump($e->getMessage()); } ?> --EXPECTF-- %string|unicode%(60) "SQLite3::__construct() expects at least 1 parameter, 0 given" http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_31_changes.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_31_changes.phpt +++ php-src/ext/sqlite3/tests/sqlite3_31_changes.phpt --TEST-- SQLite3::changes (parameters) tests --CREDITS-- Ward Hus #@PHP TESTFEST 2009 (BELGIUM) --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); var_dump($db); var_dump($db->changes()); echo "Done\n"; ?> --EXPECTF-- object(SQLite3)#1 (0) { } int(0) Done http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_31_open.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_31_open.phpt +++ php-src/ext/sqlite3/tests/sqlite3_31_open.phpt --TEST-- SQLite3::re-initialize object tests --CREDITS-- Jelle Lampaert #Belgian Testfest 2009 --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php try { $db = new SQLite3('db1.db'); $db->open('db1.db'); } catch (Exception $ex) { var_dump($ex->getMessage()); } ?> --EXPECTF-- %string|unicode%(29) "Already initialised DB Object" http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_32_changes.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_32_changes.phpt +++ php-src/ext/sqlite3/tests/sqlite3_32_changes.phpt --TEST-- SQLite3::changes empty str tests --CREDITS-- Ward Hus #@ PHP TESTFEST 2009 (BELGIUM) --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); //$db = new SQLite3('mysqlitedb.db'); $db->exec('CREATE TABLE pageView(id INTEGER PRIMARY KEY, page CHAR(256), access INTEGER(10))'); $db->exec('INSERT INTO pageView (page, access) VALUES (\'test\', \'000000\')'); echo $db->changes("dummy"); ?> --EXPECTF-- Warning: SQLite3::changes() expects exactly 0 parameters, 1 given in %s on line %d http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_32_createAggregate_paramCount.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_32_createAggregate_paramCount.phpt +++ php-src/ext/sqlite3/tests/sqlite3_32_createAggregate_paramCount.phpt --TEST-- SQLite3::createAggregate Test that an error is thrown when no parameters are present --CREDIT-- James Cauwelier # Belgium PHP TestFest --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); $db->createAggregate (); $db->close(); echo "Done" ?> --EXPECTF-- Warning: SQLite3::createAggregate() expects at least 3 parameters, 0 given in %s on line %d Done http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_32_last_insert_rowid_param.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_32_last_insert_rowid_param.phpt +++ php-src/ext/sqlite3/tests/sqlite3_32_last_insert_rowid_param.phpt --TEST-- SQLite3::lastInsertRowID parameter test --CREDITS-- Jelle Lampaert #Belgian Testfest 2009 --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); echo "Creating Table\n"; var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)')); echo "Inserting data\n"; var_dump($db->exec('INSERT INTO test (time, id) VALUES(2, 1)')); echo "Request last inserted id\n"; try { $db->lastInsertRowID(""); } catch (Exception $ex) { var_dump($ex->getMessage()); } echo "Closing database\n"; var_dump($db->close()); echo "Done"; ?> --EXPECTF-- Creating Table bool(true) Inserting data bool(true) Request last inserted id Warning: SQLite3::lastInsertRowID() expects exactly 0 parameters, %d given in %s on line %d Closing database bool(true) Done http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_33_createAggregate_notcallable.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_33_createAggregate_notcallable.phpt +++ php-src/ext/sqlite3/tests/sqlite3_33_createAggregate_notcallable.phpt --TEST-- SQLite3::createAggregate() Test whether a supplied PHP function is valid when using in an aggregate function --CREDIT-- James Cauwelier # Belgium PHP TestFest (2009) --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php function aggregate_step ($var) { return $var; } function aggregate_final ($var) { return $var; } $db = new SQLite3(':memory:'); $db->createAggregate ('TESTAGGREGATE', 'aggregate_test_step', 'aggregate_final'); $db->createAggregate ('TESTAGGREGATE2', 'aggregate_step', 'aggregate_test_final'); var_dump($db->createAggregate ('TESTAGGREGATE3', 'aggregate_step', 'aggregate_final')); $db->close(); echo "Done" ?> --EXPECTF-- Warning: SQLite3::createAggregate(): Not a valid callback function aggregate_test_step in %s on line %d Warning: SQLite3::createAggregate(): Not a valid callback function aggregate_test_final in %s on line %d bool(true) Done http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_33_load_extension_param.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_33_load_extension_param.phpt +++ php-src/ext/sqlite3/tests/sqlite3_33_load_extension_param.phpt --TEST-- SQLite3::loadExtension with empty extension test --CREDITS-- Jelle Lampaert #Belgian Testfest 2009 --INI-- sqlite3.extension_dir=/tmp --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); try { $db->loadExtension(""); } catch (Extension $ex) { var_dump($ex->getMessage()); } ?> --EXPECTF-- Warning: SQLite3::loadExtension(): Empty string as an extension in %s on line %d http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_33_reset.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_33_reset.phpt +++ php-src/ext/sqlite3/tests/sqlite3_33_reset.phpt --TEST-- SQLite3:: reset --CREDITS-- Ward Hus & James Cauwelier #@ PHP TESTFEST 2009 (BELGIUM) --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); $db->exec('CREATE TABLE foo (id INTEGER, bar STRING)'); $db->exec("INSERT INTO foo (id, bar) VALUES (1, 'This is a test')"); $stmt = $db->prepare('SELECT bar FROM foo WHERE id=:id'); $stmt->bindValue(':id', 1, SQLITE3_INTEGER); $stmt->reset("dummy"); $stmt->reset(); //var_dump($db); //var_dump($db->close()); echo "Done\n"; ?> --EXPECTF-- Warning: SQLite3Stmt::reset() expects exactly 0 parameters, 1 given in %s on line %d Done http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_34_load_extension_ext_dir.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_34_load_extension_ext_dir.phpt +++ php-src/ext/sqlite3/tests/sqlite3_34_load_extension_ext_dir.phpt --TEST-- SQLite3::loadExtension with disabled extensions --CREDITS-- Jelle Lampaert #Belgian Testfest 2009 --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); try { $db->loadExtension(""); } catch (Extension $ex) { var_dump($ex->getMessage()); } ?> --EXPECTF-- Warning: SQLite3::loadExtension(): SQLite Extension are disabled in %s on line %d http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_close_error.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_close_error.phpt +++ php-src/ext/sqlite3/tests/sqlite3_close_error.phpt --TEST-- SQLite3::close parameters --CREDITS-- Jachim Coudenys # TestFest 2009 Belgium --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); echo 'Testing SQLite3 close with one parameter' . PHP_EOL; $db->close('parameter'); echo "Done"; ?> --EXPECTF-- Testing SQLite3 close with one parameter Warning: SQLite3::close() expects exactly 0 parameters, 1 given in %s on line %d Done http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_close_with_params.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_close_with_params.phpt +++ php-src/ext/sqlite3/tests/sqlite3_close_with_params.phpt --TEST-- SQLite3::close test with parameters --CREDITS-- Thijs Feryn <thijs@feryn.eu> #TestFest PHPBelgium 2009 --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); var_dump($db->close('invalid argument')); echo "Done\n"; ?> --EXPECTF-- Warning: SQLite3::close() expects exactly 0 parameters, 1 given in %s on line %d NULL Done http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_enable_exceptions.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_enable_exceptions.phpt +++ php-src/ext/sqlite3/tests/sqlite3_enable_exceptions.phpt --TEST-- SQLite3::enableExceptions test --CREDITS-- Thijs Feryn <thijs@feryn.eu> #TestFest PHPBelgium 2009 --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); var_dump($db->enableExceptions(true)); try{ $db->query("SELECT * FROM non_existent_table"); } catch(Exception $e) { echo $e->getMessage().PHP_EOL; } var_dump($db->enableExceptions(false)); $db->query("SELECT * FROM non_existent_table"); var_dump($db->enableExceptions("wrong_type","wrong_type")); echo "Closing database\n"; var_dump($db->close()); echo "Done\n"; ?> --EXPECTF-- NULL no such table: non_existent_table NULL Warning: SQLite3::query(): no such table: non_existent_table in %s on line %d Warning: SQLite3::enableExceptions() expects at most 1 parameter, 2 given in %s on line %d NULL Closing database bool(true) Done http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_exec_wrongparams.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_exec_wrongparams.phpt +++ php-src/ext/sqlite3/tests/sqlite3_exec_wrongparams.phpt --TEST-- SQLite3::exec test, testing for wrong type parameters --CREDITS-- Michelangelo van Dam # Belgian PHP Testfest 2009 --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); $db->exec(array ('a','b','c'), 20090509); ?> --EXPECTF-- Warning: SQLite3::exec() expects exactly 1 parameter, 2 given in %s on line %d http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_lasterrorcode_with_params.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_lasterrorcode_with_params.phpt +++ php-src/ext/sqlite3/tests/sqlite3_lasterrorcode_with_params.phpt --TEST-- SQLite3::lastErrorCode test with parameters --CREDITS-- Thijs Feryn <thijs@feryn.eu> #TestFest PHPBelgium 2009 --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); var_dump($db->lastErrorCode('invalid argument')); echo "Done\n"; ?> --EXPECTF-- Warning: SQLite3::lastErrorCode() expects exactly 0 parameters, 1 given in %s on line %d NULL Done http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_lasterrormsg_with_params.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_lasterrormsg_with_params.phpt +++ php-src/ext/sqlite3/tests/sqlite3_lasterrormsg_with_params.phpt --TEST-- SQLite3::lastErrorMsg test with parameters --CREDITS-- Thijs Feryn <thijs@feryn.eu> #TestFest PHPBelgium 2009 --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); var_dump($db->lastErrorMsg('invalid argument')); echo "Done\n"; ?> --EXPECTF-- Warning: SQLite3::lastErrorMsg() expects exactly 0 parameters, 1 given in %s on line %d NULL Done http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_loadextension_with_wrong_param.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_loadextension_with_wrong_param.phpt +++ php-src/ext/sqlite3/tests/sqlite3_loadextension_with_wrong_param.phpt --TEST-- SQLite3::loadExtension test with wrong parameter type --CREDITS-- Thijs Feryn <thijs@feryn.eu> #TestFest PHPBelgium 2009 --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); var_dump($db->loadExtension(array())); echo "Done\n"; ?> --EXPECTF-- Warning: SQLite3::loadExtension() expects parameter 1 to be %binary_string_optional%, array given in %s on line %d NULL Done http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_open_empty_string.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_open_empty_string.phpt +++ php-src/ext/sqlite3/tests/sqlite3_open_empty_string.phpt --TEST-- SQLite3::open test with empty string argument via the constructor --CREDITS-- Thijs Feryn <thijs@feryn.eu> #TestFest PHPBelgium 2009 --FILE-- <?php try{ $db = new SQLite3(''); } catch(Exception $e) { echo $e->getMessage().PHP_EOL; } echo "Done\n"; ?> --EXPECTF-- Unable to expand filepath Done http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_openblob_wrongparams.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_openblob_wrongparams.phpt +++ php-src/ext/sqlite3/tests/sqlite3_openblob_wrongparams.phpt --TEST-- SQLite3::blobOpen test, testing stream with wrong parameter count --CREDITS-- Michelangelo van Dam # Belgian PHP Testfest 2009 --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php class SQLite3_Test_Stream { private $position; public static $string_length = 10; public static $string = "abcdefg\0hi"; public function stream_open($path, $mode, $options, &$opened_path) { $this->position = 0; return true; } public function stream_read($count) { $ret = substr(self::$string, $this->position, $count); $this->position += strlen($ret); return $ret; } public function stream_write($data) { return 0; } public function stream_stat() { return array('size' => self::$string_length); } public function stream_tell() { return $this->position; } public function stream_eof() { return ($this->position >= self::$string_length); } } $db = new SQLite3(':memory:'); stream_wrapper_register('sqliteBlobTest', "SQLite3_Test_Stream") or die("Unable to register sqliteBlobTest stream"); echo "Creating table: " . var_export($db->exec('CREATE TABLE test (id STRING, data BLOB)'),true) . "\n"; echo "PREPARING insert\n"; $insert_stmt = $db->prepare("INSERT INTO test (id, data) VALUES (?, ?)"); echo "BINDING Parameters:\n"; var_dump($insert_stmt->bindValue(1, 'a', SQLITE3_TEXT)); var_dump($insert_stmt->bindValue(2, 'TEST TEST', SQLITE3_BLOB)); $insert_stmt->execute(); echo "Closing statement: " . var_export($insert_stmt->close(), true) . "\n"; echo "Open BLOB with wrong parameter count\n"; $stream = $db->openBlob(); var_dump($stream); echo "Done\n"; ?> --EXPECTF-- Creating table: true PREPARING insert BINDING Parameters: bool(true) bool(true) Closing statement: true Open BLOB with wrong parameter count Warning: SQLite3::openBlob() expects at least 3 parameters, 0 given in %s on line %d NULL Done http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_prepare_faultystmt.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_prepare_faultystmt.phpt +++ php-src/ext/sqlite3/tests/sqlite3_prepare_faultystmt.phpt --TEST-- SQLite3::prepare test, testing for faulty statement --CREDITS-- Michelangelo van Dam # Belgian PHP Testfest 2009 --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); $db->exec('CREATE TABLE foo (id INTEGER, bar STRING)'); $db->exec("INSERT INTO foo (id, bar) VALUES (1, 'This is a test')"); $stmt = $db->prepare('SELECT foo FROM bar'); var_dump($stmt); ?> --EXPECTF-- Warning: SQLite3::prepare(): Unable to prepare statement: 1, no such table: bar in %s on line %d bool(false) http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_prepare_with_empty_string.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_prepare_with_empty_string.phpt +++ php-src/ext/sqlite3/tests/sqlite3_prepare_with_empty_string.phpt --TEST-- SQLite3::prepare test with empty string argument --CREDITS-- Thijs Feryn <thijs@feryn.eu> #TestFest PHPBelgium 2009 --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); var_dump($db->prepare('')); echo "Done\n"; ?> --EXPECTF-- bool(false) Done http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_prepare_wrongparams.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_prepare_wrongparams.phpt +++ php-src/ext/sqlite3/tests/sqlite3_prepare_wrongparams.phpt --TEST-- SQLite3::prepare test, testing for wrong parameters --CREDITS-- Michelangelo van Dam # Belgian PHP Testfest 2009 --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); $db->exec('CREATE TABLE foo (id INTEGER, bar STRING)'); $db->exec("INSERT INTO foo (id, bar) VALUES (1, 'This is a test')"); $stmt = $db->prepare(); ?> --EXPECTF-- Warning: SQLite3::prepare() expects exactly 1 parameter, 0 given in %s on line %d http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_prepared_stmt_clear_with_params.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_prepared_stmt_clear_with_params.phpt +++ php-src/ext/sqlite3/tests/sqlite3_prepared_stmt_clear_with_params.phpt --TEST-- SQLite3Stmt::clear test with parameters --CREDITS-- Thijs Feryn <thijs@feryn.eu> #TestFest PHPBelgium 2009 --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); define('TIMENOW', time()); echo "Creating Table\n"; $db->exec('CREATE TABLE test (time INTEGER, id STRING)'); echo "INSERT into table\n"; var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')")); echo "SELECTING results\n"; $stmt = $db->prepare("SELECT * FROM test WHERE id = ? ORDER BY id ASC"); var_dump($stmt->clear('invalid argument')); echo "Closing database\n"; var_dump($db->close()); echo "Done\n"; ?> --EXPECTF-- Creating Table INSERT into table bool(true) SELECTING results Warning: SQLite3Stmt::clear() expects exactly 0 parameters, 1 given in %s on line %d NULL Closing database bool(true) Done http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_query_error.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_query_error.phpt +++ php-src/ext/sqlite3/tests/sqlite3_query_error.phpt --TEST-- SQLite3::query parameters --CREDITS-- Jachim Coudenys # TestFest 2009 Belgium --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); echo 'Testing SQLite3 query without parameters' . PHP_EOL; $db->query(); echo 'Testing SQLite3 query with one array parameter' . PHP_EOL; $db->query(array()); echo 'Testing SQLite3 qeury with empty string parameter' . PHP_EOL; var_dump($db->query('')); echo "Done"; ?> --EXPECTF-- Testing SQLite3 query without parameters Warning: SQLite3::query() expects exactly 1 parameter, 0 given in %s on line %d Testing SQLite3 query with one array parameter Warning: SQLite3::query() expects parameter 1 to be %binary_string_optional%, array given in %s on line %d Testing SQLite3 qeury with empty string parameter bool(false) Done http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_querysingle_error.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_querysingle_error.phpt +++ php-src/ext/sqlite3/tests/sqlite3_querysingle_error.phpt --TEST-- SQLite3::query parameters --CREDITS-- Jachim Coudenys # TestFest 2009 Belgium --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); echo 'Testing SQLite3 querySingle without parameters' . PHP_EOL; $db->querySingle(); echo 'Testing SQLite3 querySingle with one array parameter' . PHP_EOL; $db->querySingle(array()); echo 'Testing SQLite3 qeurySingle with empty string parameter' . PHP_EOL; var_dump($db->querySingle('')); echo "Done"; ?> --EXPECTF-- Testing SQLite3 querySingle without parameters Warning: SQLite3::querySingle() expects at least 1 parameter, 0 given in %s on line %d Testing SQLite3 querySingle with one array parameter Warning: SQLite3::querySingle() expects parameter 1 to be %binary_string_optional%, array given in %s on line %d Testing SQLite3 qeurySingle with empty string parameter bool(false) Done http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_version_noparam.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_version_noparam.phpt +++ php-src/ext/sqlite3/tests/sqlite3_version_noparam.phpt --TEST-- SQLite3::version test, testing for missing function parameters --CREDITS-- Michelangelo van Dam # Belgian PHP Testfest 2009 --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php var_dump(SQLite3::version('dummy')); ?> --EXPECTF-- Warning: SQLite3::version() expects exactly 0 parameters, 1 given in %s on line %d NULL http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3result_fetcharray_with_two_params_fails.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3result_fetcharray_with_two_params_fails.phpt +++ php-src/ext/sqlite3/tests/sqlite3result_fetcharray_with_two_params_fails.phpt --TEST-- SQLite3Result::fetchArray() test, testing two params causes a failure --CREDITS-- Michelangelo van Dam # Belgian PHP Testfest 2009 --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); $db->exec('CREATE TABLE foo (bar STRING)'); $db->exec("INSERT INTO foo (bar) VALUES ('This is a test')"); $db->exec("INSERT INTO foo (bar) VALUES ('This is another test')"); $result = $db->query('SELECT bar FROM foo'); var_dump($result->fetchArray(1,2)); ?> --EXPECTF-- Warning: SQLite3Result::fetchArray() expects at most 1 parameter, 2 given in %s on line %d NULL http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3result_numcolumns_error.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3result_numcolumns_error.phpt +++ php-src/ext/sqlite3/tests/sqlite3result_numcolumns_error.phpt --TEST-- SQLite3Result::numColumns parameters --CREDITS-- Jachim Coudenys # TestFest 2009 Belgium --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); echo 'Creating Table' . PHP_EOL; var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)')); echo 'Inserting data' . PHP_EOL; var_dump($db->exec('INSERT INTO test (time, id) VALUES(2, 1)')); echo 'Fetching number of columns' . PHP_EOL; $result = $db->query('SELECT id FROM test'); var_dump($result->numColumns('time')); echo 'Done'; ?> --EXPECTF-- Creating Table bool(true) Inserting data bool(true) Fetching number of columns Warning: SQLite3Result::numColumns() expects exactly 0 parameters, 1 given in %s on line %d NULL Done http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3result_reset_with_params_fails.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3result_reset_with_params_fails.phpt +++ php-src/ext/sqlite3/tests/sqlite3result_reset_with_params_fails.phpt --TEST-- SQLite3Result::reset test, testing an exception is raised when calling reset with parameters --CREDITS-- Michelangelo van Dam # Belgian PHP Testfest 2009 --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); $db->exec('CREATE TABLE foo (bar STRING)'); $db->exec("INSERT INTO foo (bar) VALUES ('This is a test')"); $db->exec("INSERT INTO foo (bar) VALUES ('This is another test')"); $result = $db->query('SELECT bar FROM foo'); $result->reset(1); ?> --EXPECTF-- Warning: SQLite3Result::reset() expects exactly 0 parameters, 1 given in %s on line %d http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3stmt_reset_params.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3stmt_reset_params.phpt +++ php-src/ext/sqlite3/tests/sqlite3stmt_reset_params.phpt --TEST-- SQLite3Stmt::reset with parameter test --CREDITS-- Jelle Lampaert #Belgian Testfest 2009 --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); echo "Creating Table\n"; var_dump($db->exec('CREATE TABLE foobar (id INTEGER, name STRING)')); echo "INSERT into table\n"; var_dump($db->exec("INSERT INTO foobar (id, name) VALUES (1, 'john')")); $query = "SELECT name FROM foobar WHERE id = 1"; echo "Prepare query\n"; $stmt = $db->prepare($query); echo "Reset query\n"; try { $stmt->reset("foo"); } catch (Exception $ex) { var_dump($ex->getMessage()); } echo "Closing database\n"; $stmt = null; $result = null; var_dump($db->close()); echo "Done\n"; ?> --EXPECTF-- Creating Table bool(true) INSERT into table bool(true) Prepare query Reset query Warning: SQLite3Stmt::reset() expects exactly 0 parameters, %d given in %s on line %d Closing database bool(true) Done
http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_02_open.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_02_open.phpt +++ php-src/ext/sqlite3/tests/sqlite3_02_open.phpt --TEST-- SQLite3::open test, testing for function parameters --CREDITS-- Felix De Vliegher # Belgian PHP Testfest 2009 --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php try { $db = new SQLite3(); } catch (Exception $e) { var_dump($e->getMessage()); } ?> --EXPECTF-- %string|unicode%(60) "SQLite3::__construct() expects at least 1 parameter, 0 given" http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_31_changes.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_31_changes.phpt +++ php-src/ext/sqlite3/tests/sqlite3_31_changes.phpt --TEST-- SQLite3::changes (parameters) tests --CREDITS-- Ward Hus #@PHP TESTFEST 2009 (BELGIUM) --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); var_dump($db); var_dump($db->changes()); echo "Done\n"; ?> --EXPECTF-- object(SQLite3)#1 (0) { } int(0) Done http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_31_open.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_31_open.phpt +++ php-src/ext/sqlite3/tests/sqlite3_31_open.phpt --TEST-- SQLite3::re-initialize object tests --CREDITS-- Jelle Lampaert #Belgian Testfest 2009 --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php try { $db = new SQLite3('db1.db'); $db->open('db1.db'); } catch (Exception $ex) { var_dump($ex->getMessage()); } ?> --EXPECTF-- %string|unicode%(29) "Already initialised DB Object" http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_32_changes.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_32_changes.phpt +++ php-src/ext/sqlite3/tests/sqlite3_32_changes.phpt --TEST-- SQLite3::changes empty str tests --CREDITS-- Ward Hus #@ PHP TESTFEST 2009 (BELGIUM) --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); //$db = new SQLite3('mysqlitedb.db'); $db->exec('CREATE TABLE pageView(id INTEGER PRIMARY KEY, page CHAR(256), access INTEGER(10))'); $db->exec('INSERT INTO pageView (page, access) VALUES (\'test\', \'000000\')'); echo $db->changes("dummy"); ?> --EXPECTF-- Warning: SQLite3::changes() expects exactly 0 parameters, 1 given in %s on line %d http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_32_createAggregate_paramCount.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_32_createAggregate_paramCount.phpt +++ php-src/ext/sqlite3/tests/sqlite3_32_createAggregate_paramCount.phpt --TEST-- SQLite3::createAggregate Test that an error is thrown when no parameters are present --CREDIT-- James Cauwelier # Belgium PHP TestFest --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); $db->createAggregate (); $db->close(); echo "Done" ?> --EXPECTF-- Warning: SQLite3::createAggregate() expects at least 3 parameters, 0 given in %s on line %d Done http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_32_last_insert_rowid_param.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_32_last_insert_rowid_param.phpt +++ php-src/ext/sqlite3/tests/sqlite3_32_last_insert_rowid_param.phpt --TEST-- SQLite3::lastInsertRowID parameter test --CREDITS-- Jelle Lampaert #Belgian Testfest 2009 --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); echo "Creating Table\n"; var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)')); echo "Inserting data\n"; var_dump($db->exec('INSERT INTO test (time, id) VALUES(2, 1)')); echo "Request last inserted id\n"; try { $db->lastInsertRowID(""); } catch (Exception $ex) { var_dump($ex->getMessage()); } echo "Closing database\n"; var_dump($db->close()); echo "Done"; ?> --EXPECTF-- Creating Table bool(true) Inserting data bool(true) Request last inserted id Warning: SQLite3::lastInsertRowID() expects exactly 0 parameters, %d given in %s on line %d Closing database bool(true) Done http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_33_createAggregate_notcallable.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_33_createAggregate_notcallable.phpt +++ php-src/ext/sqlite3/tests/sqlite3_33_createAggregate_notcallable.phpt --TEST-- SQLite3::createAggregate() Test whether a supplied PHP function is valid when using in an aggregate function --CREDIT-- James Cauwelier # Belgium PHP TestFest (2009) --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php function aggregate_step ($var) { return $var; } function aggregate_final ($var) { return $var; } $db = new SQLite3(':memory:'); $db->createAggregate ('TESTAGGREGATE', 'aggregate_test_step', 'aggregate_final'); $db->createAggregate ('TESTAGGREGATE2', 'aggregate_step', 'aggregate_test_final'); var_dump($db->createAggregate ('TESTAGGREGATE3', 'aggregate_step', 'aggregate_final')); $db->close(); echo "Done" ?> --EXPECTF-- Warning: SQLite3::createAggregate(): Not a valid callback function aggregate_test_step in %s on line %d Warning: SQLite3::createAggregate(): Not a valid callback function aggregate_test_final in %s on line %d bool(true) Done http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_33_load_extension_param.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_33_load_extension_param.phpt +++ php-src/ext/sqlite3/tests/sqlite3_33_load_extension_param.phpt --TEST-- SQLite3::loadExtension with empty extension test --CREDITS-- Jelle Lampaert #Belgian Testfest 2009 --INI-- sqlite3.extension_dir=/tmp --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); try { $db->loadExtension(""); } catch (Extension $ex) { var_dump($ex->getMessage()); } ?> --EXPECTF-- Warning: SQLite3::loadExtension(): Empty string as an extension in %s on line %d http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_33_reset.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_33_reset.phpt +++ php-src/ext/sqlite3/tests/sqlite3_33_reset.phpt --TEST-- SQLite3:: reset --CREDITS-- Ward Hus & James Cauwelier #@ PHP TESTFEST 2009 (BELGIUM) --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); $db->exec('CREATE TABLE foo (id INTEGER, bar STRING)'); $db->exec("INSERT INTO foo (id, bar) VALUES (1, 'This is a test')"); $stmt = $db->prepare('SELECT bar FROM foo WHERE id=:id'); $stmt->bindValue(':id', 1, SQLITE3_INTEGER); $stmt->reset("dummy"); $stmt->reset(); //var_dump($db); //var_dump($db->close()); echo "Done\n"; ?> --EXPECTF-- Warning: SQLite3Stmt::reset() expects exactly 0 parameters, 1 given in %s on line %d Done http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_34_load_extension_ext_dir.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_34_load_extension_ext_dir.phpt +++ php-src/ext/sqlite3/tests/sqlite3_34_load_extension_ext_dir.phpt --TEST-- SQLite3::loadExtension with disabled extensions --CREDITS-- Jelle Lampaert #Belgian Testfest 2009 --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); try { $db->loadExtension(""); } catch (Extension $ex) { var_dump($ex->getMessage()); } ?> --EXPECTF-- Warning: SQLite3::loadExtension(): SQLite Extension are disabled in %s on line %d http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_close_error.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_close_error.phpt +++ php-src/ext/sqlite3/tests/sqlite3_close_error.phpt --TEST-- SQLite3::close parameters --CREDITS-- Jachim Coudenys # TestFest 2009 Belgium --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); echo 'Testing SQLite3 close with one parameter' . PHP_EOL; $db->close('parameter'); echo "Done"; ?> --EXPECTF-- Testing SQLite3 close with one parameter Warning: SQLite3::close() expects exactly 0 parameters, 1 given in %s on line %d Done http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_close_with_params.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_close_with_params.phpt +++ php-src/ext/sqlite3/tests/sqlite3_close_with_params.phpt --TEST-- SQLite3::close test with parameters --CREDITS-- Thijs Feryn <thijs@feryn.eu> #TestFest PHPBelgium 2009 --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); var_dump($db->close('invalid argument')); echo "Done\n"; ?> --EXPECTF-- Warning: SQLite3::close() expects exactly 0 parameters, 1 given in %s on line %d NULL Done http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_enable_exceptions.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_enable_exceptions.phpt +++ php-src/ext/sqlite3/tests/sqlite3_enable_exceptions.phpt --TEST-- SQLite3::enableExceptions test --CREDITS-- Thijs Feryn <thijs@feryn.eu> #TestFest PHPBelgium 2009 --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); var_dump($db->enableExceptions(true)); try{ $db->query("SELECT * FROM non_existent_table"); } catch(Exception $e) { echo $e->getMessage().PHP_EOL; } var_dump($db->enableExceptions(false)); $db->query("SELECT * FROM non_existent_table"); var_dump($db->enableExceptions("wrong_type","wrong_type")); echo "Closing database\n"; var_dump($db->close()); echo "Done\n"; ?> --EXPECTF-- NULL no such table: non_existent_table NULL Warning: SQLite3::query(): no such table: non_existent_table in %s on line %d Warning: SQLite3::enableExceptions() expects at most 1 parameter, 2 given in %s on line %d NULL Closing database bool(true) Done http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_exec_wrongparams.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_exec_wrongparams.phpt +++ php-src/ext/sqlite3/tests/sqlite3_exec_wrongparams.phpt --TEST-- SQLite3::exec test, testing for wrong type parameters --CREDITS-- Michelangelo van Dam # Belgian PHP Testfest 2009 --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); $db->exec(array ('a','b','c'), 20090509); ?> --EXPECTF-- Warning: SQLite3::exec() expects exactly 1 parameter, 2 given in %s on line %d http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_lasterrorcode_with_params.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_lasterrorcode_with_params.phpt +++ php-src/ext/sqlite3/tests/sqlite3_lasterrorcode_with_params.phpt --TEST-- SQLite3::lastErrorCode test with parameters --CREDITS-- Thijs Feryn <thijs@feryn.eu> #TestFest PHPBelgium 2009 --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); var_dump($db->lastErrorCode('invalid argument')); echo "Done\n"; ?> --EXPECTF-- Warning: SQLite3::lastErrorCode() expects exactly 0 parameters, 1 given in %s on line %d NULL Done http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_lasterrormsg_with_params.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_lasterrormsg_with_params.phpt +++ php-src/ext/sqlite3/tests/sqlite3_lasterrormsg_with_params.phpt --TEST-- SQLite3::lastErrorMsg test with parameters --CREDITS-- Thijs Feryn <thijs@feryn.eu> #TestFest PHPBelgium 2009 --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); var_dump($db->lastErrorMsg('invalid argument')); echo "Done\n"; ?> --EXPECTF-- Warning: SQLite3::lastErrorMsg() expects exactly 0 parameters, 1 given in %s on line %d NULL Done http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_loadextension_with_wrong_param.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_loadextension_with_wrong_param.phpt +++ php-src/ext/sqlite3/tests/sqlite3_loadextension_with_wrong_param.phpt --TEST-- SQLite3::loadExtension test with wrong parameter type --CREDITS-- Thijs Feryn <thijs@feryn.eu> #TestFest PHPBelgium 2009 --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); var_dump($db->loadExtension(array())); echo "Done\n"; ?> --EXPECTF-- Warning: SQLite3::loadExtension() expects parameter 1 to be %binary_string_optional%, array given in %s on line %d NULL Done http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_open_empty_string.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_open_empty_string.phpt +++ php-src/ext/sqlite3/tests/sqlite3_open_empty_string.phpt --TEST-- SQLite3::open test with empty string argument via the constructor --CREDITS-- Thijs Feryn <thijs@feryn.eu> #TestFest PHPBelgium 2009 --FILE-- <?php try{ $db = new SQLite3(''); } catch(Exception $e) { echo $e->getMessage().PHP_EOL; } echo "Done\n"; ?> --EXPECTF-- Unable to expand filepath Done http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_openblob_wrongparams.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_openblob_wrongparams.phpt +++ php-src/ext/sqlite3/tests/sqlite3_openblob_wrongparams.phpt --TEST-- SQLite3::blobOpen test, testing stream with wrong parameter count --CREDITS-- Michelangelo van Dam # Belgian PHP Testfest 2009 --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php class SQLite3_Test_Stream { private $position; public static $string_length = 10; public static $string = "abcdefg\0hi"; public function stream_open($path, $mode, $options, &$opened_path) { $this->position = 0; return true; } public function stream_read($count) { $ret = substr(self::$string, $this->position, $count); $this->position += strlen($ret); return $ret; } public function stream_write($data) { return 0; } public function stream_stat() { return array('size' => self::$string_length); } public function stream_tell() { return $this->position; } public function stream_eof() { return ($this->position >= self::$string_length); } } $db = new SQLite3(':memory:'); stream_wrapper_register('sqliteBlobTest', "SQLite3_Test_Stream") or die("Unable to register sqliteBlobTest stream"); echo "Creating table: " . var_export($db->exec('CREATE TABLE test (id STRING, data BLOB)'),true) . "\n"; echo "PREPARING insert\n"; $insert_stmt = $db->prepare("INSERT INTO test (id, data) VALUES (?, ?)"); echo "BINDING Parameters:\n"; var_dump($insert_stmt->bindValue(1, 'a', SQLITE3_TEXT)); var_dump($insert_stmt->bindValue(2, 'TEST TEST', SQLITE3_BLOB)); $insert_stmt->execute(); echo "Closing statement: " . var_export($insert_stmt->close(), true) . "\n"; echo "Open BLOB with wrong parameter count\n"; $stream = $db->openBlob(); var_dump($stream); echo "Done\n"; ?> --EXPECTF-- Creating table: true PREPARING insert BINDING Parameters: bool(true) bool(true) Closing statement: true Open BLOB with wrong parameter count Warning: SQLite3::openBlob() expects at least 3 parameters, 0 given in %s on line %d NULL Done http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_prepare_faultystmt.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_prepare_faultystmt.phpt +++ php-src/ext/sqlite3/tests/sqlite3_prepare_faultystmt.phpt --TEST-- SQLite3::prepare test, testing for faulty statement --CREDITS-- Michelangelo van Dam # Belgian PHP Testfest 2009 --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); $db->exec('CREATE TABLE foo (id INTEGER, bar STRING)'); $db->exec("INSERT INTO foo (id, bar) VALUES (1, 'This is a test')"); $stmt = $db->prepare('SELECT foo FROM bar'); var_dump($stmt); ?> --EXPECTF-- Warning: SQLite3::prepare(): Unable to prepare statement: 1, no such table: bar in %s on line %d bool(false) http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_prepare_with_empty_string.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_prepare_with_empty_string.phpt +++ php-src/ext/sqlite3/tests/sqlite3_prepare_with_empty_string.phpt --TEST-- SQLite3::prepare test with empty string argument --CREDITS-- Thijs Feryn <thijs@feryn.eu> #TestFest PHPBelgium 2009 --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); var_dump($db->prepare('')); echo "Done\n"; ?> --EXPECTF-- bool(false) Done http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_prepare_wrongparams.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_prepare_wrongparams.phpt +++ php-src/ext/sqlite3/tests/sqlite3_prepare_wrongparams.phpt --TEST-- SQLite3::prepare test, testing for wrong parameters --CREDITS-- Michelangelo van Dam # Belgian PHP Testfest 2009 --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); $db->exec('CREATE TABLE foo (id INTEGER, bar STRING)'); $db->exec("INSERT INTO foo (id, bar) VALUES (1, 'This is a test')"); $stmt = $db->prepare(); ?> --EXPECTF-- Warning: SQLite3::prepare() expects exactly 1 parameter, 0 given in %s on line %d http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_prepared_stmt_clear_with_params.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_prepared_stmt_clear_with_params.phpt +++ php-src/ext/sqlite3/tests/sqlite3_prepared_stmt_clear_with_params.phpt --TEST-- SQLite3Stmt::clear test with parameters --CREDITS-- Thijs Feryn <thijs@feryn.eu> #TestFest PHPBelgium 2009 --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); define('TIMENOW', time()); echo "Creating Table\n"; $db->exec('CREATE TABLE test (time INTEGER, id STRING)'); echo "INSERT into table\n"; var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')")); echo "SELECTING results\n"; $stmt = $db->prepare("SELECT * FROM test WHERE id = ? ORDER BY id ASC"); var_dump($stmt->clear('invalid argument')); echo "Closing database\n"; var_dump($db->close()); echo "Done\n"; ?> --EXPECTF-- Creating Table INSERT into table bool(true) SELECTING results Warning: SQLite3Stmt::clear() expects exactly 0 parameters, 1 given in %s on line %d NULL Closing database bool(true) Done http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_query_error.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_query_error.phpt +++ php-src/ext/sqlite3/tests/sqlite3_query_error.phpt --TEST-- SQLite3::query parameters --CREDITS-- Jachim Coudenys # TestFest 2009 Belgium --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); echo 'Testing SQLite3 query without parameters' . PHP_EOL; $db->query(); echo 'Testing SQLite3 query with one array parameter' . PHP_EOL; $db->query(array()); echo 'Testing SQLite3 qeury with empty string parameter' . PHP_EOL; var_dump($db->query('')); echo "Done"; ?> --EXPECTF-- Testing SQLite3 query without parameters Warning: SQLite3::query() expects exactly 1 parameter, 0 given in %s on line %d Testing SQLite3 query with one array parameter Warning: SQLite3::query() expects parameter 1 to be %binary_string_optional%, array given in %s on line %d Testing SQLite3 qeury with empty string parameter bool(false) Done http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_querysingle_error.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_querysingle_error.phpt +++ php-src/ext/sqlite3/tests/sqlite3_querysingle_error.phpt --TEST-- SQLite3::query parameters --CREDITS-- Jachim Coudenys # TestFest 2009 Belgium --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); echo 'Testing SQLite3 querySingle without parameters' . PHP_EOL; $db->querySingle(); echo 'Testing SQLite3 querySingle with one array parameter' . PHP_EOL; $db->querySingle(array()); echo 'Testing SQLite3 qeurySingle with empty string parameter' . PHP_EOL; var_dump($db->querySingle('')); echo "Done"; ?> --EXPECTF-- Testing SQLite3 querySingle without parameters Warning: SQLite3::querySingle() expects at least 1 parameter, 0 given in %s on line %d Testing SQLite3 querySingle with one array parameter Warning: SQLite3::querySingle() expects parameter 1 to be %binary_string_optional%, array given in %s on line %d Testing SQLite3 qeurySingle with empty string parameter bool(false) Done http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3_version_noparam.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3_version_noparam.phpt +++ php-src/ext/sqlite3/tests/sqlite3_version_noparam.phpt --TEST-- SQLite3::version test, testing for missing function parameters --CREDITS-- Michelangelo van Dam # Belgian PHP Testfest 2009 --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php var_dump(SQLite3::version('dummy')); ?> --EXPECTF-- Warning: SQLite3::version() expects exactly 0 parameters, 1 given in %s on line %d NULL http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3result_fetcharray_with_two_params_fails.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3result_fetcharray_with_two_params_fails.phpt +++ php-src/ext/sqlite3/tests/sqlite3result_fetcharray_with_two_params_fails.phpt --TEST-- SQLite3Result::fetchArray() test, testing two params causes a failure --CREDITS-- Michelangelo van Dam # Belgian PHP Testfest 2009 --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); $db->exec('CREATE TABLE foo (bar STRING)'); $db->exec("INSERT INTO foo (bar) VALUES ('This is a test')"); $db->exec("INSERT INTO foo (bar) VALUES ('This is another test')"); $result = $db->query('SELECT bar FROM foo'); var_dump($result->fetchArray(1,2)); ?> --EXPECTF-- Warning: SQLite3Result::fetchArray() expects at most 1 parameter, 2 given in %s on line %d NULL http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3result_numcolumns_error.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3result_numcolumns_error.phpt +++ php-src/ext/sqlite3/tests/sqlite3result_numcolumns_error.phpt --TEST-- SQLite3Result::numColumns parameters --CREDITS-- Jachim Coudenys # TestFest 2009 Belgium --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); echo 'Creating Table' . PHP_EOL; var_dump($db->exec('CREATE TABLE test (time INTEGER, id STRING)')); echo 'Inserting data' . PHP_EOL; var_dump($db->exec('INSERT INTO test (time, id) VALUES(2, 1)')); echo 'Fetching number of columns' . PHP_EOL; $result = $db->query('SELECT id FROM test'); var_dump($result->numColumns('time')); echo 'Done'; ?> --EXPECTF-- Creating Table bool(true) Inserting data bool(true) Fetching number of columns Warning: SQLite3Result::numColumns() expects exactly 0 parameters, 1 given in %s on line %d NULL Done http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3result_reset_with_params_fails.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3result_reset_with_params_fails.phpt +++ php-src/ext/sqlite3/tests/sqlite3result_reset_with_params_fails.phpt --TEST-- SQLite3Result::reset test, testing an exception is raised when calling reset with parameters --CREDITS-- Michelangelo van Dam # Belgian PHP Testfest 2009 --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); $db->exec('CREATE TABLE foo (bar STRING)'); $db->exec("INSERT INTO foo (bar) VALUES ('This is a test')"); $db->exec("INSERT INTO foo (bar) VALUES ('This is another test')"); $result = $db->query('SELECT bar FROM foo'); $result->reset(1); ?> --EXPECTF-- Warning: SQLite3Result::reset() expects exactly 0 parameters, 1 given in %s on line %d http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite3/tests/sqlite3stmt_reset_params.phpt?view=markup&rev=1.1 Index: php-src/ext/sqlite3/tests/sqlite3stmt_reset_params.phpt +++ php-src/ext/sqlite3/tests/sqlite3stmt_reset_params.phpt --TEST-- SQLite3Stmt::reset with parameter test --CREDITS-- Jelle Lampaert #Belgian Testfest 2009 --SKIPIF-- <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> --FILE-- <?php $db = new SQLite3(':memory:'); echo "Creating Table\n"; var_dump($db->exec('CREATE TABLE foobar (id INTEGER, name STRING)')); echo "INSERT into table\n"; var_dump($db->exec("INSERT INTO foobar (id, name) VALUES (1, 'john')")); $query = "SELECT name FROM foobar WHERE id = 1"; echo "Prepare query\n"; $stmt = $db->prepare($query); echo "Reset query\n"; try { $stmt->reset("foo"); } catch (Exception $ex) { var_dump($ex->getMessage()); } echo "Closing database\n"; $stmt = null; $result = null; var_dump($db->close()); echo "Done\n"; ?> --EXPECTF-- Creating Table bool(true) INSERT into table bool(true) Prepare query Reset query Warning: SQLite3Stmt::reset() expects exactly 0 parameters, %d given in %s on line %d Closing database bool(true) Done