felixdv Wed Oct 29 11:43:33 2008 UTC
Added files:
/php-src/ext/sqlite/tests sqlite_popen_basic.phpt
sqlite_popen_error.phpt
sqlite_exec_basic.phpt
sqlite_exec_error.phpt
sqlite_session_001.phpt
sqlite_session_002.phpt
sqlite_last_error_basic.phpt
sqlite_last_error_error.phpt
Log:
Various tests for the sqlite ext.
The sqlite session tests are by Mats Lindh <mats at lindh.no>.
http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite/tests/sqlite_popen_basic.phpt?view=markup&rev=1.1
Index: php-src/ext/sqlite/tests/sqlite_popen_basic.phpt
+++ php-src/ext/sqlite/tests/sqlite_popen_basic.phpt
--TEST--
SQLite: sqlite_popen() basic tests
--SKIPIF--
<?php if (!extension_loaded("sqlite")) print "skip"; ?>
--FILE--
<?php
/* Prototype : resource sqlite_popen(string filename [, int mode [, string
&error_message]])
* Description: Opens a persistent handle to a SQLite database. Will create the
database if it does not exist.
* Source code: ext/sqlite/sqlite.c
* Alias to functions:
*/
$db1 = sqlite_popen(":memory:");
$db2 = sqlite_popen(":memory:");
var_dump($db1);
var_dump($db2);
list($resourceId1) = sscanf((string) $db1, "resource(%d) of type
(sqlite database (persistent))");
list($resourceId2) = sscanf((string) $db2, "resource(%d) of type
(sqlite database (persistent))");
var_dump($resourceId1 === $resourceId2);
?>
--EXPECTF--
resource(%d) of type (sqlite database (persistent))
resource(%d) of type (sqlite database (persistent))
bool(true)
http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite/tests/sqlite_popen_error.phpt?view=markup&rev=1.1
Index: php-src/ext/sqlite/tests/sqlite_popen_error.phpt
+++ php-src/ext/sqlite/tests/sqlite_popen_error.phpt
--TEST--
Test sqlite_popen() function : error conditions
--SKIPIF--
<?php if (!extension_loaded("sqlite")) print "skip sqlite extension not
loaded"; ?>
--FILE--
<?php
/* Prototype : resource sqlite_popen(string filename [, int mode [, string
&error_message]])
* Description: Opens a persistent handle to a SQLite database. Will create the
database if it does not exist.
* Source code: ext/sqlite/sqlite.c
* Alias to functions:
*/
$message = '';
echo "*** Testing sqlite_popen() : error conditions ***\n";
var_dump( sqlite_popen() );
var_dump( sqlite_popen(":memory:", 0666, $message, 'foobar') );
var_dump( sqlite_popen("", 0666, $message) );
var_dump( $message );
?>
===DONE===
--EXPECTF--
*** Testing sqlite_popen() : error conditions ***
Warning: sqlite_popen() expects at least 1 parameter, 0 given in %s on line %d
NULL
Warning: sqlite_popen() expects at most 3 parameters, 4 given in %s on line %d
NULL
bool(false)
NULL
===DONE===
http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite/tests/sqlite_exec_basic.phpt?view=markup&rev=1.1
Index: php-src/ext/sqlite/tests/sqlite_exec_basic.phpt
+++ php-src/ext/sqlite/tests/sqlite_exec_basic.phpt
--TEST--
Test sqlite_exec() function : basic functionality
--SKIPIF--
<?php if (!extension_loaded("sqlite")) print "skip sqlite extension not
loaded"; ?>
--FILE--
<?php
/* Prototype : boolean sqlite_exec(string query, resource db[, string
&error_message])
* Description: Executes a result-less query against a given database
* Source code: ext/sqlite/sqlite.c
* Alias to functions:
*/
echo "*** Testing sqlite_exec() : basic functionality ***\n";
// set up variables
$query = 'CREATE TABLE foobar (id INTEGER PRIMARY KEY, name CHAR(255));';
$error_message = null;
// procedural
$db = sqlite_open(':memory:');
var_dump( sqlite_exec($db, $query) );
sqlite_close($db);
// oo-style
$db = new SQLiteDatabase(':memory:');
var_dump( $db->queryExec($query, $error_message) );
?>
===DONE===
--EXPECTF--
*** Testing sqlite_exec() : basic functionality ***
bool(true)
bool(true)
===DONE===
http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite/tests/sqlite_exec_error.phpt?view=markup&rev=1.1
Index: php-src/ext/sqlite/tests/sqlite_exec_error.phpt
+++ php-src/ext/sqlite/tests/sqlite_exec_error.phpt
--TEST--
Test sqlite_exec() function : error behaviour and functionality
--SKIPIF--
<?php if (!extension_loaded("sqlite")) print "skip sqlite extension not
loaded"; ?>
--FILE--
<?php
/* Prototype : boolean sqlite_exec(string query, resource db[, string
&error_message])
* Description: Executes a result-less query against a given database
* Source code: ext/sqlite/sqlite.c
* Alias to functions:
*/
echo "*** Testing sqlite_exec() : error functionality ***\n";
// set up variables
$fail = 'CRE ATE TABLE';
$error_message = null;
// procedural
$db = sqlite_open(':memory:');
var_dump( sqlite_exec($db, $fail, $error_message) );
var_dump( $error_message );
var_dump( sqlite_exec($db) );
sqlite_close($db);
// oo-style
$db = new SQLiteDatabase(':memory:');
var_dump( $db->queryExec($fail, $error_message, 'fooparam') );
?>
===DONE===
--EXPECTF--
*** Testing sqlite_exec() : error functionality ***
Warning: sqlite_exec(): near "CRE": syntax error in %s on line %d
bool(false)
%string|unicode%(24) "near "CRE": syntax error"
Warning: sqlite_exec() expects at least 2 parameters, 1 given in %s on line %d
NULL
Warning: SQLiteDatabase::queryExec() expects at most 2 parameters, 3 given in
%s on line %d
NULL
===DONE===
http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite/tests/sqlite_session_001.phpt?view=markup&rev=1.1
Index: php-src/ext/sqlite/tests/sqlite_session_001.phpt
+++ php-src/ext/sqlite/tests/sqlite_session_001.phpt
--TEST--
sqlite, session storage test
--CREDITS--
Mats Lindh <mats at lindh.no>
#Testfest php.no
--INI--
session.save_handler = sqlite
--SKIPIF--
if (!extension_loaded("session"))
{
die("skip Session module not loaded");
}
if (!extension_loaded("sqlite"))
{
die("skip Session module not loaded");
}
--FILE--
<?php
/* Description: Tests that sqlite can be used as a session save handler
* Source code: ext/sqlite/sess_sqlite.c
*/
ob_start();
session_save_path(__DIR__ . "/sessiondb.sdb");
// create the session and set a session value
session_start();
$_SESSION["test"] = "foo_bar";
// close the session and unset the value
session_write_close();
unset($_SESSION["test"]);
var_dump(isset($_SESSION["test"]));
// start the session again and check that we have the proper value
session_start();
var_dump($_SESSION["test"]);
ob_end_flush();
?>
--EXPECTF--
bool(false)
%unicode|string%(7) "foo_bar"
--CLEAN--
<?php
unlink(__DIR__ . "/sessiondb.sdb")
?>
http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite/tests/sqlite_session_002.phpt?view=markup&rev=1.1
Index: php-src/ext/sqlite/tests/sqlite_session_002.phpt
+++ php-src/ext/sqlite/tests/sqlite_session_002.phpt
--TEST--
sqlite, session destroy test
--CREDITS--
Mats Lindh <mats at lindh.no>
#Testfest php.no
--INI--
session.save_handler = sqlite
--SKIPIF--
if (!extension_loaded("session"))
{
die("skip Session module not loaded");
}
if (!extension_loaded("sqlite"))
{
die("skip sqlite module not loaded");
}
--FILE--
<?php
/* Description: Tests that sqlite will destroy a session when used as a session
handler
* Source code: ext/sqlite/sess_sqlite.c
*/
ob_start();
session_save_path(__DIR__ . "/sessiondb.sdb");
// start a session and save a value to it before commiting the session to the
database
session_start();
$_SESSION["test"] = "foo_bar";
session_write_close();
// remove the session value
unset($_SESSION["test"]);
var_dump(isset($_SESSION["test"]));
// start the session again and destroy it
session_start();
var_dump($_SESSION["test"]);
session_destroy();
session_write_close();
unset($_SESSION["test"]);
// check that the session has been destroyed
session_start();
var_dump(isset($_SESSION["test"]));
ob_end_flush();
?>
--EXPECTF--
bool(false)
%unicode|string%(7) "foo_bar"
bool(false)
--CLEAN--
<?php
unlink(__DIR__ . "/sessiondb.sdb")
?>
http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite/tests/sqlite_last_error_basic.phpt?view=markup&rev=1.1
Index: php-src/ext/sqlite/tests/sqlite_last_error_basic.phpt
+++ php-src/ext/sqlite/tests/sqlite_last_error_basic.phpt
--TEST--
Test sqlite_last_error() function : basic functionality
--SKIPIF--
<?php if (!extension_loaded("sqlite")) print "skip sqlite extension not
loaded"; ?>
--FILE--
<?php
/* Prototype : int sqlite_last_error(resource db)
* Description: Returns the error code of the last error for a database.
* Source code: ext/sqlite/sqlite.c
* Alias to functions:
*/
echo "*** Testing sqlite_last_error() : basic functionality ***\n";
// set up variables
$query = 'CREATE TAB LE foobar (id INTEGER PRIMARY KEY, name CHAR(255));';
$query_ok = 'CREATE TABLE foobar (id INTEGER, name CHAR(255));';
// procedural
$db = sqlite_open(':memory:');
var_dump( sqlite_last_error($db) === SQLITE_OK );
sqlite_exec($db, $query);
var_dump( sqlite_last_error($db) === SQLITE_ERROR );
sqlite_exec($db, $query_ok);
var_dump( sqlite_last_error($db) === SQLITE_OK );
sqlite_close($db);
// oo-style
$db = new SQLiteDatabase(':memory:');
$db->queryExec($query);
var_dump( $db->lastError() === SQLITE_ERROR );
$db->queryExec($query_ok);
var_dump( $db->lastError() === SQLITE_OK );
?>
===DONE===
--EXPECTF--
*** Testing sqlite_last_error() : basic functionality ***
bool(true)
Warning: sqlite_exec(): near "TAB": syntax error in %s on line %d
bool(true)
bool(true)
Warning: SQLiteDatabase::queryExec(): near "TAB": syntax error in %s on line %d
bool(true)
bool(true)
===DONE===
http://cvs.php.net/viewvc.cgi/php-src/ext/sqlite/tests/sqlite_last_error_error.phpt?view=markup&rev=1.1
Index: php-src/ext/sqlite/tests/sqlite_last_error_error.phpt
+++ php-src/ext/sqlite/tests/sqlite_last_error_error.phpt
--TEST--
Test sqlite_last_error() function : error conditions
--SKIPIF--
<?php if (!extension_loaded("sqlite")) print "skip sqlite extension not
loaded"; ?>
--FILE--
<?php
/* Prototype : int sqlite_last_error(resource db)
* Description: Returns the error code of the last error for a database.
* Source code: ext/sqlite/sqlite.c
* Alias to functions:
*/
echo "*** Testing sqlite_last_error() : error conditions ***\n";
// Zero arguments
echo "\n-- Testing sqlite_last_error() function with Zero arguments --\n";
var_dump( sqlite_last_error() );
//Test sqlite_last_error with one more than the expected number of arguments
echo "\n-- Testing sqlite_last_error() function with more than expected no. of
arguments --\n";
$db = sqlite_open(':memory:');
$extra_arg = 10;
var_dump( sqlite_last_error($db, $extra_arg) );
sqlite_close($db);
$db = new SQLiteDatabase(':memory:');
var_dump( $db->lastError($extra_arg) );
?>
===DONE===
--EXPECTF--
*** Testing sqlite_last_error() : error conditions ***
-- Testing sqlite_last_error() function with Zero arguments --
Warning: sqlite_last_error() expects exactly 1 parameter, 0 given in %s on line
%d
NULL
-- Testing sqlite_last_error() function with more than expected no. of
arguments --
Warning: sqlite_last_error() expects exactly 1 parameter, 2 given in %s on line
%d
NULL
Warning: SQLiteDatabase::lastError() expects exactly 0 parameters, 1 given in
%s on line %d
NULL
===DONE===
--
PHP CVS Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
