From 821e562d6ed2b4f5b9e3edcb36c3588edab7ea8c Mon Sep 17 00:00:00 2001 From: Scott MacVicar Date: Sat, 24 Jan 2009 12:17:30 +0000 Subject: [PATCH] Forgot test for the last commit --- ext/sqlite3/tests/sqlite3_30_blobopen.phpt | 50 ++++++++++++++++++++++ 1 file changed, 50 insertions(+) create mode 100644 ext/sqlite3/tests/sqlite3_30_blobopen.phpt diff --git a/ext/sqlite3/tests/sqlite3_30_blobopen.phpt b/ext/sqlite3/tests/sqlite3_30_blobopen.phpt new file mode 100644 index 0000000000..ed51153784 --- /dev/null +++ b/ext/sqlite3/tests/sqlite3_30_blobopen.phpt @@ -0,0 +1,50 @@ +--TEST-- +SQLite3::blobOpen stream test +--SKIPIF-- + +--FILE-- +exec('CREATE TABLE test (id STRING, data BLOB)')); + +echo "PREPARING insert\n"; +$insert_stmt = $db->prepare("INSERT INTO test (id, data) VALUES (?, ?)"); + +echo "BINDING Parameter\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\n"; +var_dump($insert_stmt->close()); +$stream = $db->openBlob('test', 'data', 1); +var_dump($stream); +echo "Stream Contents\n"; +var_dump(stream_get_contents($stream)); +echo "Closing Stream\n"; +var_dump(fclose($stream)); +echo "Closing database\n"; +var_dump($db->close()); +echo "Done\n"; +?> +--EXPECTF-- +Creating Table +bool(true) +PREPARING insert +BINDING Parameter +bool(true) +bool(true) +Closing statement +bool(true) +resource(%d) of type (stream) +Stream Contents +string(9) "TEST TEST" +Closing Stream +bool(true) +Closing database +bool(true) +Done -- 2.50.1