PDOWrapperTest::setUp() - Code Metrics - Inspection of "PDOHelper -> Extra/PDOWrapper" - abterphp/qb - Measure and Improve Code Quality continuously with Scrutinizer

Passed
Push — main ( 87ff77...29cbd1 )

by Peter
created 2021-06-28 21:30 UTC
PDOWrapperTest::setUp() A

↳ Parent: PDOWrapperTest
Complexity

Conditions	1
Paths	1
Size

Total Lines	9
Code Lines	5
Duplication

Lines	0
Ratio	0 %
Importance

Changes	1
Bugs	0	Features	0
Metric	Value
cc	1
eloc	5
nc	1
nop	0
dl	0
loc	9
rs	10
c	1
b	0
f	0
<?php

declare(strict_types=1);

namespace QB\Extra;

use PDO;
use PDOStatement;
use PHPUnit\Framework\MockObject\MockObject;
use PHPUnit\Framework\TestCase;
use QB\Generic\Expr\Expr;

class PDOWrapperTest extends TestCase
{
    /** @var PDOWrapper System Under Test */
    protected PDOWrapper $sut;

    /** @var PDO|MockObject */
    protected PDO|MockObject $pdoMock;

    /**
     * @suppress PhanTypeMismatchArgument
     */
    public function setUp(): void
    {
        /** @var PDO $pdoMock */
        $pdoMock = $this->getMockBuilder(PDO::class)
            ->disableOriginalConstructor()
            ->getMock();

        $this->pdoMock = $pdoMock;
        $this->sut = new PDOWrapper($pdoMock);
    }

    /**
     * @suppress PhanTypeMismatchArgumentProbablyReal
     */
    public function testPrepareNumeric()
    {
        $sql    = '? AND ?';
        $values = [17, 23];

        $statementMock = $this->getMockBuilder(PDOStatement::class)->getMock();
        $statementMock
            ->expects($this->exactly(count($values)))
            ->method('bindParam')
            ->withConsecutive([1, 17, PDO::PARAM_INT], [2, 23, PDO::PARAM_INT]);

        $this->pdoMock->expects($this->once())->method('prepare')->with($sql)->willReturn($statementMock);
                        expects($this->once())->method('prepare')->with($sql)->willReturn($statementMock);

        $query = new Expr($sql, $values);

        $this->sut->prepare($query);
    }

    /**
     * @suppress PhanTypeMismatchArgumentProbablyReal
     */
    public function testPrepareAssoc()
    {
        $sql    = ':foo AND :bar';
        $values = ['foo' => 'bar', 'bar' => 'baz'];

        $statementMock = $this->getMockBuilder(PDOStatement::class)->getMock();
        $statementMock
            ->expects($this->exactly(count($values)))
            ->method('bindParam')
            ->withConsecutive(['foo', 'bar', PDO::PARAM_STR], ['bar', 'baz', PDO::PARAM_STR]);

        $this->pdoMock->expects($this->once())->method('prepare')->with($sql)->willReturn($statementMock);

        $query = new Expr($sql, $values);

        $this->sut->prepare($query);
    }

    /**
     * @suppress PhanTypeMismatchArgumentProbablyReal
     */
    public function testExecute()
    {
        $returnValue = true;

        $sql    = ':foo AND :bar';
        $values = ['foo' => 'bar', 'bar' => 'baz'];

        $statementMock = $this->getMockBuilder(PDOStatement::class)->getMock();
        $statementMock
            ->expects($this->exactly(count($values)))
            ->method('bindParam')
            ->withConsecutive(['foo', 'bar', PDO::PARAM_STR], ['bar', 'baz', PDO::PARAM_STR]);
        $statementMock
            ->expects($this->once())
            ->method('execute')
            ->willReturn($returnValue);

        $this->pdoMock->expects($this->once())->method('prepare')->with($sql)->willReturn($statementMock);

        $query = new Expr($sql, $values);

        $actualValue = $this->sut->execute($query);

        $this->assertSame($returnValue, $actualValue);
    }

    /**
     * @suppress PhanTypeMismatchArgumentProbablyReal
     */
    public function testFetchAll()
    {
        $returnValue = [['foo', 'bar'], ['bar', 'baz']];

        $sql    = ':foo AND :bar';
        $values = ['foo' => 'bar', 'bar' => 'baz'];

        $statementMock = $this->getMockBuilder(PDOStatement::class)->getMock();
        $statementMock
            ->expects($this->exactly(count($values)))
            ->method('bindParam')
            ->withConsecutive(['foo', 'bar', PDO::PARAM_STR], ['bar', 'baz', PDO::PARAM_STR]);
        $statementMock
            ->expects($this->once())
            ->method('execute')
            ->willReturn(true);
        $statementMock
            ->expects($this->once())
            ->method('fetchAll')
            ->willReturn($returnValue);

        $this->pdoMock->expects($this->once())->method('prepare')->with($sql)->willReturn($statementMock);

        $query = new Expr($sql, $values);

        $actualValue = $this->sut->fetchAll($query);

        $this->assertSame($returnValue, $actualValue);
    }

    /**
     * @suppress PhanTypeMismatchArgumentProbablyReal
     */
    public function testFetchColumn()
    {
        $returnValue = 123;

        $sql    = ':foo AND :bar';
        $values = ['foo' => 'bar', 'bar' => 'baz'];

        $statementMock = $this->getMockBuilder(PDOStatement::class)->getMock();
        $statementMock
            ->expects($this->exactly(count($values)))
            ->method('bindParam')
            ->withConsecutive(['foo', 'bar', PDO::PARAM_STR], ['bar', 'baz', PDO::PARAM_STR]);
        $statementMock
            ->expects($this->once())
            ->method('execute')
            ->willReturn(true);
        $statementMock
            ->expects($this->once())
            ->method('fetchColumn')
            ->willReturn($returnValue);

        $this->pdoMock->expects($this->once())->method('prepare')->with($sql)->willReturn($statementMock);

        $query = new Expr($sql, $values);

        $actualValue = $this->sut->fetchColumn($query);

        $this->assertSame($returnValue, $actualValue);
    }

    /**
     * @suppress PhanTypeMismatchArgumentProbablyReal
     */
    public function testFetch()
    {
        $returnValue = ['foo', 'bar'];

        $sql    = ':foo AND :bar';
        $values = ['foo' => 'bar', 'bar' => 'baz'];

        $statementMock = $this->getMockBuilder(PDOStatement::class)->getMock();
        $statementMock
            ->expects($this->exactly(count($values)))
            ->method('bindParam')
            ->withConsecutive(['foo', 'bar', PDO::PARAM_STR], ['bar', 'baz', PDO::PARAM_STR]);
        $statementMock
            ->expects($this->once())
            ->method('execute')
            ->willReturn(true);
        $statementMock
            ->expects($this->once())
            ->method('fetch')
            ->willReturn($returnValue);

        $this->pdoMock->expects($this->once())->method('prepare')->with($sql)->willReturn($statementMock);

        $query = new Expr($sql, $values);

        $actualValue = $this->sut->fetch($query);

        $this->assertSame($returnValue, $actualValue);
    }
}

abterphp / qb

Push — main ( 87ff77...29cbd1 )

PDOWrapperTest::setUp() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like
