felipe Sun May 17 16:51:59 2009 UTC
Added files: (Branch: PHP_5_3)
/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 <[email protected]>
#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 <[email protected]>
#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 <[email protected]>
#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 <[email protected]>
#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 <[email protected]>
#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 <[email protected]>
#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 <[email protected]>
#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 <[email protected]>
#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
--
PHP CVS Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
