BinaryTest.php 2.67 KB
Newer Older
Sergei Morozov's avatar
Sergei Morozov committed
1 2 3 4
<?php

declare(strict_types=1);

5
namespace Doctrine\DBAL\Tests\Functional\Types;
Sergei Morozov's avatar
Sergei Morozov committed
6

7
use Doctrine\DBAL\Driver\IBMDB2\Driver;
8
use Doctrine\DBAL\Driver\PDO;
Sergei Morozov's avatar
Sergei Morozov committed
9 10
use Doctrine\DBAL\ParameterType;
use Doctrine\DBAL\Schema\Table;
11
use Doctrine\DBAL\Tests\FunctionalTestCase;
12

Sergei Morozov's avatar
Sergei Morozov committed
13 14 15 16 17
use function is_resource;
use function random_bytes;
use function str_replace;
use function stream_get_contents;

18
class BinaryTest extends FunctionalTestCase
Sergei Morozov's avatar
Sergei Morozov committed
19
{
20
    protected function setUp(): void
Sergei Morozov's avatar
Sergei Morozov committed
21 22 23
    {
        parent::setUp();

24
        if ($this->connection->getDriver() instanceof PDO\OCI\Driver) {
25
            self::markTestSkipped('PDO_OCI doesn\'t support binding binary values');
26 27
        }

Sergei Morozov's avatar
Sergei Morozov committed
28 29 30 31 32 33 34 35
        $table = new Table('binary_table');
        $table->addColumn('id', 'binary', [
            'length' => 16,
            'fixed' => true,
        ]);
        $table->addColumn('val', 'binary', ['length' => 64]);
        $table->setPrimaryKey(['id']);

Sergei Morozov's avatar
Sergei Morozov committed
36
        $sm = $this->connection->getSchemaManager();
Sergei Morozov's avatar
Sergei Morozov committed
37 38 39
        $sm->dropAndCreateTable($table);
    }

40
    public function testInsertAndSelect(): void
Sergei Morozov's avatar
Sergei Morozov committed
41 42 43 44 45 46 47 48
    {
        $id1 = random_bytes(16);
        $id2 = random_bytes(16);

        $value1 = random_bytes(64);
        $value2 = random_bytes(64);

        /** @see https://bugs.php.net/bug.php?id=76322 */
49
        if ($this->connection->getDriver() instanceof Driver) {
Sergei Morozov's avatar
Sergei Morozov committed
50 51 52 53 54 55 56
            $value1 = str_replace("\x00", "\xFF", $value1);
            $value2 = str_replace("\x00", "\xFF", $value2);
        }

        $this->insert($id1, $value1);
        $this->insert($id2, $value2);

57 58
        self::assertSame($value1, $this->select($id1));
        self::assertSame($value2, $this->select($id2));
Sergei Morozov's avatar
Sergei Morozov committed
59 60
    }

61
    private function insert(string $id, string $value): void
Sergei Morozov's avatar
Sergei Morozov committed
62
    {
Sergei Morozov's avatar
Sergei Morozov committed
63
        $result = $this->connection->insert('binary_table', [
Sergei Morozov's avatar
Sergei Morozov committed
64 65 66
            'id'  => $id,
            'val' => $value,
        ], [
67 68
            ParameterType::BINARY,
            ParameterType::BINARY,
Sergei Morozov's avatar
Sergei Morozov committed
69 70 71 72 73
        ]);

        self::assertSame(1, $result);
    }

74 75 76
    /**
     * @return mixed
     */
Sergei Morozov's avatar
Sergei Morozov committed
77 78
    private function select(string $id)
    {
79
        $value = $this->connection->fetchOne(
Sergei Morozov's avatar
Sergei Morozov committed
80 81
            'SELECT val FROM binary_table WHERE id = ?',
            [$id],
82
            [ParameterType::BINARY]
Sergei Morozov's avatar
Sergei Morozov committed
83 84 85 86 87 88 89 90 91 92 93 94 95
        );

        // Currently, `BinaryType` mistakenly converts string values fetched from the DB to a stream.
        // It should be the opposite. Streams should be used to represent large objects, not binary
        // strings. The confusion comes from the PostgreSQL's type system where binary strings and
        // large objects are represented by the same BYTEA type
        if (is_resource($value)) {
            $value = stream_get_contents($value);
        }

        return $value;
    }
}