Return to large_objects.phpt CVS log

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

Annotation of embedaddon/php/ext/pdo_pgsql/tests/large_objects.phpt, revision 1.1

1.1     ! misho       1: --TEST--
        !             2: PDO PgSQL Large Objects
        !             3: --SKIPIF--
        !             4: <?php # vim:se ft=php:
        !             5: if (!extension_loaded('pdo') || !extension_loaded('pdo_pgsql')) die('skip not loaded');
        !             6: require dirname(__FILE__) . '/config.inc';
        !             7: require dirname(__FILE__) . '/../../../ext/pdo/tests/pdo_test.inc';
        !             8: PDOTest::skip();
        !             9: ?>
        !            10: --FILE--
        !            11: <?php
        !            12: require dirname(__FILE__) . '/../../../ext/pdo/tests/pdo_test.inc';
        !            13: $db = PDOTest::test_factory(dirname(__FILE__) . '/common.phpt');
        !            14: $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        !            15: $db->setAttribute(PDO::ATTR_STRINGIFY_FETCHES, false);
        !            16: 
        !            17: $db->exec('CREATE TABLE test (blobid integer not null primary key, bloboid OID)');
        !            18: 
        !            19: $db->beginTransaction();
        !            20: $oid = $db->pgsqlLOBCreate();
        !            21: try {
        !            22: $stm = $db->pgsqlLOBOpen($oid, 'w+b');
        !            23: fwrite($stm, "Hello dude\n");
        !            24: 
        !            25: $stmt = $db->prepare("INSERT INTO test (blobid, bloboid) values (?, ?)");
        !            26: $stmt->bindValue(1, 1);
        !            27: /* bind as LOB; the oid from the pgsql stream will be inserted instead
        !            28:  * of the stream contents. Binding other streams will attempt to bind
        !            29:  * as bytea, and will most likely lead to an error.
        !            30:  * You can also just bind the $oid in as a string. */
        !            31: $stmt->bindParam(2, $stm, PDO::PARAM_LOB);
        !            32: $stmt->execute();
        !            33: $stm = null;
        !            34: 
        !            35: /* Pull it out */
        !            36: $stmt = $db->prepare("SELECT * from test");
        !            37: $stmt->bindColumn('bloboid', $lob, PDO::PARAM_LOB);
        !            38: $stmt->execute();
        !            39: echo "Fetching:\n";
        !            40: while (($row = $stmt->fetch(PDO::FETCH_ASSOC))) {
        !            41:        var_dump($row['blobid']);
        !            42:        var_dump(stream_get_contents($lob));
        !            43: }
        !            44: echo "Fetched!\n";
        !            45: 
        !            46: /* Try again, with late bind */
        !            47: $stmt = $db->prepare("SELECT * from test");
        !            48: $stmt->execute();
        !            49: $stmt->bindColumn('bloboid', $lob, PDO::PARAM_LOB);
        !            50: echo "Fetching late bind:\n";
        !            51: while (($row = $stmt->fetch(PDO::FETCH_ASSOC))) {
        !            52:        var_dump($row['blobid']);
        !            53:        var_dump(is_int($row['bloboid']));
        !            54: }
        !            55: echo "Fetched!\n";
        !            56: 
        !            57: /* Try again, with NO  bind */
        !            58: $stmt = $db->prepare("SELECT * from test");
        !            59: $stmt->execute();
        !            60: $stmt->bindColumn('bloboid', $lob, PDO::PARAM_LOB);
        !            61: echo "Fetching NO bind:\n";
        !            62: while (($row = $stmt->fetch(PDO::FETCH_ASSOC))) {
        !            63:        var_dump($row['blobid']);
        !            64:        var_dump(is_int($row['bloboid']));
        !            65: }
        !            66: echo "Fetched!\n";
        !            67: 
        !            68: } catch (Exception $e) {
        !            69:        /* catch exceptions so that we can guarantee to clean
        !            70:         * up the LOB */
        !            71:        echo "Exception! at line ", $e->getLine(), "\n";
        !            72:        var_dump($e->getMessage());
        !            73: }
        !            74: 
        !            75: /* Now to remove the large object from the database, so it doesn't
        !            76:  * linger and clutter up the storage */
        !            77: $db->pgsqlLOBUnlink($oid);
        !            78: 
        !            79: ?>
        !            80: --EXPECT--
        !            81: Fetching:
        !            82: int(1)
        !            83: string(11) "Hello dude
        !            84: "
        !            85: Fetched!
        !            86: Fetching late bind:
        !            87: int(1)
        !            88: bool(true)
        !            89: Fetched!
        !            90: Fetching NO bind:
        !            91: int(1)
        !            92: bool(true)
        !            93: Fetched!