Return to sqlite3_openblob_wrongparams.phpt CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / sqlite3 / tests

Annotation of embedaddon/php/ext/sqlite3/tests/sqlite3_openblob_wrongparams.phpt, revision 1.1

1.1     ! misho       1: --TEST--
        !             2: SQLite3::blobOpen test, testing stream with wrong parameter count
        !             3: --CREDITS--
        !             4: Michelangelo van Dam
        !             5: # Belgian PHP Testfest 2009
        !             6: --SKIPIF--
        !             7: <?php require_once(dirname(__FILE__) . '/skipif.inc'); ?>
        !             8: --FILE--
        !             9: <?php
        !            10: class SQLite3_Test_Stream
        !            11: {
        !            12:        private $position;
        !            13:        public static $string_length = 10;
        !            14:        public static $string = "abcdefg\0hi";
        !            15: 
        !            16:        public function stream_open($path, $mode, $options, &$opened_path)
        !            17:        {
        !            18:                $this->position = 0;
        !            19:                return true;
        !            20:        }
        !            21: 
        !            22:        public function stream_read($count)
        !            23:        {
        !            24:                $ret = substr(self::$string, $this->position, $count);
        !            25:                $this->position += strlen($ret);
        !            26:                return $ret;
        !            27:        }
        !            28: 
        !            29:        public function stream_write($data)
        !            30:        {
        !            31:                return 0;
        !            32:        }
        !            33: 
        !            34:        public function stream_stat()
        !            35:        {
        !            36:                return array('size' => self::$string_length);
        !            37:        }
        !            38: 
        !            39:        public function stream_tell()
        !            40:        {
        !            41:                return $this->position;
        !            42:        }
        !            43: 
        !            44:        public function stream_eof()
        !            45:        {
        !            46:                return ($this->position >= self::$string_length);
        !            47:        }
        !            48: }
        !            49: 
        !            50: $db = new SQLite3(':memory:');
        !            51: stream_wrapper_register('sqliteBlobTest', "SQLite3_Test_Stream") or die("Unable to register sqliteBlobTest stream");
        !            52: echo "Creating table: " . var_export($db->exec('CREATE TABLE test (id STRING, data BLOB)'),true) . "\n";
        !            53: 
        !            54: echo "PREPARING insert\n";
        !            55: $insert_stmt = $db->prepare("INSERT INTO test (id, data) VALUES (?, ?)");
        !            56: 
        !            57: echo "BINDING Parameters:\n";
        !            58: var_dump($insert_stmt->bindValue(1, 'a', SQLITE3_TEXT));
        !            59: var_dump($insert_stmt->bindValue(2, 'TEST TEST', SQLITE3_BLOB));
        !            60: $insert_stmt->execute();
        !            61: echo "Closing statement: " . var_export($insert_stmt->close(), true) . "\n";
        !            62: 
        !            63: echo "Open BLOB with wrong parameter count\n";
        !            64: $stream = $db->openBlob();
        !            65: var_dump($stream);
        !            66: echo "Done\n";
        !            67: ?>
        !            68: --EXPECTF--
        !            69: Creating table: true
        !            70: PREPARING insert
        !            71: BINDING Parameters:
        !            72: bool(true)
        !            73: bool(true)
        !            74: Closing statement: true
        !            75: Open BLOB with wrong parameter count
        !            76: 
        !            77: Warning: SQLite3::openBlob() expects at least 3 parameters, 0 given in %s on line %d
        !            78: NULL
        !            79: Done