hgraca / php-micro-orm

     * @covers \Hgraca\MicroOrm\DataSource\Pdo\PdoClient::createSqlFilter

     * @covers \Hgraca\MicroOrm\DataSource\Pdo\PdoClient::bindParameterList

     */

    public function insert()

    {

        $table  = 'DummyTable';

        $data = [

            'propA' => true,

            'propB' => null,

        ];

        $pdoStatementMock = Mockery::mock(PDOStatement::class);

        $this->pdo->shouldReceive('prepare')

            ->once()

            ->with('INSERT INTO `DummyTable` (`propA`, `propB`) VALUES (:propA, :propB)')

            ->andReturn($pdoStatementMock);

        $pdoStatementMock->shouldReceive('bindValue')

            ->once()->with(':propA', $data['propA'], PDO::PARAM_BOOL)->andReturn(true);

        $pdoStatementMock->shouldReceive('bindValue')

            ->once()->with(':propB', $data['propB'], PDO::PARAM_NULL)->andReturn(true);

        $pdoStatementMock->shouldReceive('execute')->once()->andReturn(true);

        $pdoStatementMock->shouldReceive('rowCount')->once()->andReturn($rowCount = 1);

        self::assertEquals($rowCount, $this->client->insert($table, $data));

    }

    /**

     * @test

     * @covers \Hgraca\MicroOrm\DataSource\Pdo\PdoClient::createSqlFilter

     * @covers \Hgraca\MicroOrm\DataSource\Pdo\PdoClient::bindParameterList

     */

    public function delete()

    {

        $table           = 'DummyTable';

        $filter = [

            'propA' => true,

            'propB' => 3,

        ];

        $pdoStatementMock = Mockery::mock(PDOStatement::class);

        $this->pdo->shouldReceive('prepare')

            ->once()

            ->with('DELETE FROM `DummyTable` WHERE `propA`=:propA_filter AND `propB`=:propB_filter')

            ->andReturn($pdoStatementMock);

        $pdoStatementMock->shouldReceive('bindValue')

            ->once()->with(':propA_filter', $filter['propA'], PDO::PARAM_BOOL)->andReturn(true);

        $pdoStatementMock->shouldReceive('bindValue')

            ->once()->with(':propB_filter', $filter['propB'], PDO::PARAM_INT)->andReturn(true);

        $pdoStatementMock->shouldReceive('execute')->once()->andReturn(true);

        $pdoStatementMock->shouldReceive('rowCount')->once()->andReturn($rowCount = 1);

        self::assertEquals($rowCount, $this->client->delete($table, $filter));

    }

    /**

     * @test