diff options
Diffstat (limited to 'ext/sqlite3/tests/sqlite3_12_unfinalized_stmt_cleanup.phpt')
-rw-r--r-- | ext/sqlite3/tests/sqlite3_12_unfinalized_stmt_cleanup.phpt | 52 |
1 files changed, 52 insertions, 0 deletions
diff --git a/ext/sqlite3/tests/sqlite3_12_unfinalized_stmt_cleanup.phpt b/ext/sqlite3/tests/sqlite3_12_unfinalized_stmt_cleanup.phpt new file mode 100644 index 0000000..2bfd0af --- /dev/null +++ b/ext/sqlite3/tests/sqlite3_12_unfinalized_stmt_cleanup.phpt @@ -0,0 +1,52 @@ +--TEST-- +SQLite3::query Unfinalized statement tests +--SKIPIF-- +<?php require_once(dirname(__FILE__) . '/skipif.inc'); ?> +--FILE-- +<?php + +require_once(dirname(__FILE__) . '/new_db.inc'); +define('TIMENOW', time()); + +echo "Creating Table\n"; +var_dump($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 . ", 'a')")); +var_dump($db->exec("INSERT INTO test (time, id) VALUES (" . TIMENOW . ", 'b')")); + +echo "SELECTING results\n"; +$results = $db->query("SELECT * FROM test ORDER BY id ASC"); +while ($result = $results->fetchArray(SQLITE3_NUM)) +{ + var_dump($result); + /* Only read one row and break */ + break; +} + +echo "Closing database\n"; +var_dump($db->close()); +echo "Check db was closed\n"; +var_dump($results->numColumns()); +echo "Done\n"; +?> +--EXPECTF-- +Creating Table +bool(true) +INSERT into table +bool(true) +bool(true) +SELECTING results +array(2) { + [0]=> + int(%d) + [1]=> + string(1) "a" +} +Closing database +bool(true) +Check db was closed + +Warning: SQLite3Result::numColumns(): The SQLite3Result object has not been correctly initialised in %s on line %d +bool(false) +Done |