StatementIteratorTest.php 2.96 KB
Newer Older
1 2
<?php

3
namespace Doctrine\DBAL\Tests\Driver;
4

5 6 7 8 9
use Doctrine\DBAL\Driver\IBMDB2\DB2Statement;
use Doctrine\DBAL\Driver\Mysqli\MysqliStatement;
use Doctrine\DBAL\Driver\OCI8\OCI8Statement;
use Doctrine\DBAL\Driver\SQLAnywhere\SQLAnywhereStatement;
use Doctrine\DBAL\Driver\SQLSrv\SQLSrvStatement;
10 11
use Doctrine\DBAL\Driver\Statement;
use Doctrine\DBAL\Driver\StatementIterator;
12 13
use Doctrine\DBAL\Portability\Statement as PortabilityStatement;
use PHPUnit\Framework\MockObject\MockObject;
14
use PHPUnit\Framework\TestCase;
15 16
use Traversable;
use function extension_loaded;
17

18
class StatementIteratorTest extends TestCase
19
{
20 21 22 23
    /**
     * @dataProvider statementProvider()
     */
    public function testGettingIteratorDoesNotCallFetch(string $class) : void
24
    {
25
        $stmt = $this->createPartialMock($class, ['fetch', 'fetchAll', 'fetchColumn']);
26 27 28
        $stmt->expects(self::never())->method('fetch');
        $stmt->expects(self::never())->method('fetchAll');
        $stmt->expects(self::never())->method('fetchColumn');
29

30 31 32 33 34 35 36 37 38 39
        $stmt->getIterator();
    }

    public function testIteratorIterationCallsFetchOncePerStep() : void
    {
        $stmt = $this->createMock(Statement::class);

        $calls = 0;
        $this->configureStatement($stmt, $calls);

40
        $stmtIterator = new StatementIterator($stmt);
41 42

        $this->assertIterationCallsFetchOncePerStep($stmtIterator, $calls);
43 44
    }

45 46 47 48 49 50 51 52 53 54 55 56 57
    /**
     * @dataProvider statementProvider()
     */
    public function testStatementIterationCallsFetchOncePerStep(string $class) : void
    {
        $stmt = $this->createPartialMock($class, ['fetch']);

        $calls = 0;
        $this->configureStatement($stmt, $calls);
        $this->assertIterationCallsFetchOncePerStep($stmt, $calls);
    }

    private function configureStatement(MockObject $stmt, int &$calls) : void
58 59
    {
        $values = ['foo', '', 'bar', '0', 'baz', 0, 'qux', null, 'quz', false, 'impossible'];
Sergei Morozov's avatar
Sergei Morozov committed
60
        $calls  = 0;
61

62
        $stmt->expects(self::exactly(10))
63
            ->method('fetch')
Sergei Morozov's avatar
Sergei Morozov committed
64
            ->willReturnCallback(static function () use ($values, &$calls) {
65 66
                $value = $values[$calls];
                $calls++;
67

68 69
                return $value;
            });
70
    }
71

Grégoire Paris's avatar
Grégoire Paris committed
72 73 74
    /**
     * @param Traversable<int, mixed> $iterator
     */
75 76 77
    private function assertIterationCallsFetchOncePerStep(Traversable $iterator, int &$calls) : void
    {
        foreach ($iterator as $i => $_) {
78
            self::assertEquals($i + 1, $calls);
79 80
        }
    }
81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103

    /**
     * @return string[][]
     */
    public static function statementProvider() : iterable
    {
        if (extension_loaded('ibm_db2')) {
            yield [DB2Statement::class];
        }

        yield [MysqliStatement::class];

        if (extension_loaded('oci8')) {
            yield [OCI8Statement::class];
        }

        yield [PortabilityStatement::class];
        yield [SQLAnywhereStatement::class];

        if (extension_loaded('sqlsrv')) {
            yield [SQLSrvStatement::class];
        }
    }
104
}