diff options
Diffstat (limited to 'ext/sqlite3/tests/sqlite3_13_skip_all_cleanup.phpt')
-rw-r--r-- | ext/sqlite3/tests/sqlite3_13_skip_all_cleanup.phpt | 45 |
1 files changed, 45 insertions, 0 deletions
diff --git a/ext/sqlite3/tests/sqlite3_13_skip_all_cleanup.phpt b/ext/sqlite3/tests/sqlite3_13_skip_all_cleanup.phpt new file mode 100644 index 0000000..573d87f --- /dev/null +++ b/ext/sqlite3/tests/sqlite3_13_skip_all_cleanup.phpt @@ -0,0 +1,45 @@ +--TEST-- +SQLite3::query Skip all cleanup +--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); +} +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" +} +array(2) { + [0]=> + int(%d) + [1]=> + string(1) "b" +} +Done |