addiks / symfony_rdm

Tests/DataLoader/SimpleSelectDataLoaderTest.php

<?php
/**
 * Copyright (C) 2018 Gerrit Addiks.
 * This package (including this file) was released under the terms of the GPL-3.0.
 * You should have received a copy of the GNU General Public License along with this program.
 * If not, see <http://www.gnu.org/licenses/> or send me a mail so i can send you a copy.
 * @license GPL-3.0
 * @author Gerrit Addiks <gerrit@addiks.de>
 */

namespace Addiks\RDMBundle\Tests\DataLoader;

use Addiks\RDMBundle\DataLoader\SimpleSelectDataLoader;
use Addiks\RDMBundle\Mapping\Drivers\MappingDriverInterface;
use Addiks\RDMBundle\Tests\Hydration\EntityExample;
use Addiks\RDMBundle\Mapping\ChoiceMapping;
use Addiks\RDMBundle\ValueResolver\ValueResolverInterface;

The type Addiks\RDMBundle\ValueResolver\ValueResolverInterface was not found. Maybe you did not declare it correctly or list all dependencies?

use Doctrine\ORM\EntityManagerInterface;
use Doctrine\ORM\Mapping\ClassMetadata;
use Doctrine\DBAL\Connection;
use Doctrine\DBAL\Query\QueryBuilder;
use Doctrine\ORM\Query\Expr;
use Doctrine\DBAL\Driver\Statement;
use PHPUnit\Framework\TestCase;
use Doctrine\ORM\UnitOfWork;
use Addiks\RDMBundle\Tests\Hydration\ServiceExample;
use Addiks\RDMBundle\Mapping\MappingInterface;
use Addiks\RDMBundle\Mapping\EntityMappingInterface;
use Doctrine\DBAL\Schema\Column;
use Doctrine\ORM\Mapping\ClassMetadataFactory;
use Doctrine\DBAL\Types\Type;

final class SimpleSelectLoaderTest extends TestCase
{

    /**
     * @var SimpleSelectDataLoader
     */
    private $dataLoader;

    /**
     * @var MappingDriverInterface
     */
    private $mappingDriver;

    /**
     * @var ValueResolverInterface
     */
    private $valueResolver;

The private property $valueResolver is not used, and could be removed.

    /**
     * @var ClassMetadata
     */
    private $classMetaData;

    /**
     * @var Connection
     */
    private $connection;

    /**
     * @var QueryBuilder
     */
    private $queryBuilder;

    /**
     * @var Expr
     */
    private $expr;

    /**
     * @var Statement
     */
    private $statement;

    /**
     * @var EntityManagerInterface
     */
    private $entityManager;

    /**
     * @var UnitOfWork
     */
    private $unitOfWork;

    /**
     * @var EntityMappingInterface
     */
    private $entityMapping;

    /**
     * @var ChoiceMapping
     */
    private $mappings = array();

    public function setUp(): void
    {
        $this->mappingDriver = $this->createMock(MappingDriverInterface::class);

It seems like $this->createMock(Addiks\RDMBundle\Mapping\Drivers\MappingDriverInterface::class) of type PHPUnit\Framework\MockObject\MockObject is incompatible with the declared type Addiks\RDMBundle\Mapping\Drivers\MappingDriverInterface of property $mappingDriver.

        $this->connection = $this->createMock(Connection::class);

It seems like $this->createMock(Doctrine\DBAL\Connection::class) of type PHPUnit\Framework\MockObject\MockObject is incompatible with the declared type Doctrine\DBAL\Connection of property $connection.

        $this->queryBuilder = $this->createMock(QueryBuilder::class);

It seems like $this->createMock(Doctrine\DBAL\Query\QueryBuilder::class) of type PHPUnit\Framework\MockObject\MockObject is incompatible with the declared type Doctrine\DBAL\Query\QueryBuilder of property $queryBuilder.

        $this->expr = $this->createMock(Expr::class);

It seems like $this->createMock(Doctrine\ORM\Query\Expr::class) of type PHPUnit\Framework\MockObject\MockObject is incompatible with the declared type Doctrine\ORM\Query\Expr of property $expr.

        $this->statement = $this->createMock(Statement::class);

It seems like $this->createMock(Doctrine\DBAL\Driver\Statement::class) of type PHPUnit\Framework\MockObject\MockObject is incompatible with the declared type Doctrine\DBAL\Driver\Statement of property $statement.

        $this->entityManager = $this->createMock(EntityManagerInterface::class);

It seems like $this->createMock(Doctrine\ORM\EntityManagerInterface::class) of type PHPUnit\Framework\MockObject\MockObject is incompatible with the declared type Doctrine\ORM\EntityManagerInterface of property $entityManager.

        $this->unitOfWork = $this->createMock(UnitOfWork::class);

It seems like $this->createMock(Doctrine\ORM\UnitOfWork::class) of type PHPUnit\Framework\MockObject\MockObject is incompatible with the declared type Doctrine\ORM\UnitOfWork of property $unitOfWork.

        $this->entityMapping = $this->createMock(EntityMappingInterface::class);

It seems like $this->createMock(Addiks\RDMBundle\Mapping\EntityMappingInterface::class) of type PHPUnit\Framework\MockObject\MockObject is incompatible with the declared type Addiks\RDMBundle\Mapping\EntityMappingInterface of property $entityMapping.

        $this->dataLoader = new SimpleSelectDataLoader(
            $this->mappingDriver,
            1

The call to Addiks\RDMBundle\DataLoader\SimpleSelectDataLoader::__construct() has too many arguments starting with 1.

        );

        $this->classMetaData = new ClassMetadata(EntityExample::class);
        $this->classMetaData->table = ['name' => 'some_table'];
        $this->classMetaData->identifier = ["id"];
        $this->classMetaData->fieldMappings = [
            "id" => [
                'columnName' => 'id'
            ]
        ];

        $this->mappings['foo'] = $this->createMock(MappingInterface::class);
        $this->mappings['bar'] = $this->createMock(MappingInterface::class);

        $this->mappingDriver->method("loadRDMMetadataForClass")->willReturn($this->entityMapping);
        $this->entityManager->method("getClassMetadata")->willReturn($this->classMetaData);
        $this->entityManager->method("getConnection")->willReturn($this->connection);
        $this->entityManager->method("getUnitOfWork")->willReturn($this->unitOfWork);
        $this->entityManager->method('getMetadataFactory')->willReturn($this->createMock(ClassMetadataFactory::class));
        $this->connection->method('createQueryBuilder')->willReturn($this->queryBuilder);
        $this->queryBuilder->method('expr')->willReturn($this->expr);
        $this->queryBuilder->method('execute')->willReturn($this->statement);
    }

    /**
     * @test
     */
    public function loadsDataFromDatabase()
    {
        /** @var array $expectedData */
        $expectedData = array(
            'foo_column' => 'Lorem ipsum',
            'bar_column' => 'dolor sit amet'
        );

        $this->classMetaData->identifier = ["id", "secondId"];
        $this->classMetaData->fieldMappings = [
            "id"  => ['columnName' => 'id'],
            "secondId"  => ['columnName' => 'secondId'],
            "faz" => ['columnName' => 'faz']
        ];

        $this->queryBuilder->expects($this->once())->method('from')->with($this->equalTo('some_table'));

The method expects() does not exist on Doctrine\DBAL\Query\QueryBuilder.

        $this->queryBuilder->expects($this->exactly(2))->method('andWhere')->with($this->equalTo("*eq-return*"));
        $this->queryBuilder->expects($this->exactly(2))->method('addSelect');
        $this->queryBuilder->expects($this->once())->method('setMaxResults')->with($this->equalTo(1));

        $this->statement->method('fetch')->willReturn($expectedData);

The method method() does not exist on Doctrine\DBAL\Driver\Statement.

        /** @var ServiceExample $fazService */
        $fazService = $this->createMock(ServiceExample::class);

        $entity = new EntityExample(null, null, null, $fazService, null, "second_id");
        $entity->id = "123";

        $this->expr->expects($this->exactly(2))->method("eq")->willReturn("*eq-return*")->withConsecutive(

The method expects() does not exist on Doctrine\ORM\Query\Expr.

            ['id', '123'],
            ['secondId', "'second_id'"]
        );

        /** @var Column $columnA */
        $columnA = $this->createMock(Column::class);
        $columnA->method('getName')->willReturn("id");

The method method() does not exist on Doctrine\DBAL\Schema\Column.

        /** @var Column $columnA */
        $columnB = $this->createMock(Column::class);
        $columnB->method('getName')->willReturn("secondId");

        $this->entityMapping->method('collectDBALColumns')->willReturn([

The method method() does not exist on Addiks\RDMBundle\Mapping\EntityMappingInterface.

            $columnA,
            $columnB
        ]);

        /** @var array $actualData */
        $actualData = $this->dataLoader->loadDBALDataForEntity($entity, $this->entityManager);

        $this->assertEquals($expectedData, $actualData);
    }

    /**
     * @test
     */
    public function shouldNotLoadEntityWithoutId()
    {
        /** @var array $expectedData */
        $expectedData = array();

        $this->classMetaData->identifier = [];

        $this->queryBuilder->expects($this->never())->method('from');

        $this->statement->method('fetch')->willReturn($expectedData);

        $entity = new EntityExample();
        $entity->id = "some_id";

        $this->expr->method("eq")->willReturn("*eq-return*");

The method method() does not exist on Doctrine\ORM\Query\Expr.

        /** @var array $actualData */
        $actualData = $this->dataLoader->loadDBALDataForEntity($entity, $this->entityManager);

        $this->assertEquals($expectedData, $actualData);
    }

    /**
     * @test
     */
    public function storesDataInDatabase()
    {
        $this->mappings['faz'] = $this->createMock(MappingInterface::class);

        $this->setUp();

        $this->classMetaData->identifier = ["id", "faz"];
        $this->classMetaData->fieldMappings = [
            "id"  => ['columnName' => 'id'],
            "faz" => ['columnName' => 'faz']
        ];

        /** @var ServiceExample $fazService */
        $fazService = $this->createMock(ServiceExample::class);

        $entity = new EntityExample(null, null, null, $fazService);
        $entity->id = "some_id";
        $entity->foo = "some_ipsum_service";

It seems like 'some_ipsum_service' of type string is incompatible with the declared type Addiks\RDMBundle\Tests\Hydration\ServiceExample of property $foo.

        $entity->bar = "some_dolor_service";

It seems like 'some_dolor_service' of type string is incompatible with the declared type Addiks\RDMBundle\Tests\Hydration\ServiceExample of property $bar.

        $this->mappings['foo']->method("revertValue")->willReturn(["foo_column" => "ipsum"]);
        $this->mappings['bar']->method("revertValue")->willReturn(["bar_column" => "dolor"]);
        $this->mappings['faz']->method("revertValue")->willReturn(["faz_column" => "sit"]);

        $this->entityMapping->method('getEntityClassName')->willReturn(EntityExample::class);
        $this->entityMapping->method('getFieldMappings')->willReturn($this->mappings);
        $this->entityMapping->method('revertValue')->willReturn([
            'foo_column' => 'ipsum',
            'bar_column' => 'dolor',
            'faz_column' => 'sit'
        ]);

        $this->connection->expects($this->once())->method("update")->with(
            $this->equalTo("some_table"),
            $this->equalTo([
                'foo_column' => 'ipsum',
                'bar_column' => 'dolor',
                'faz_column' => 'sit'
            ]),
            $this->equalTo([
                'id'  => "some_id",
                'faz' => $fazService
            ])
        );

        $this->dataLoader->storeDBALDataForEntity($entity, $this->entityManager);
    }

    /**
     * @test
     */
    public function shouldNotUpdateIfDataDidNotChange()
    {
        $entity = new EntityExample();
        $entity->id = "some_id";
        $entity->foo = "some_ipsum_service";

It seems like 'some_ipsum_service' of type string is incompatible with the declared type Addiks\RDMBundle\Tests\Hydration\ServiceExample of property $foo.

        $entity->bar = "some_dolor_service";

It seems like 'some_dolor_service' of type string is incompatible with the declared type Addiks\RDMBundle\Tests\Hydration\ServiceExample of property $bar.

        $this->entityMapping->method('getEntityClassName')->willReturn(EntityExample::class);
        $this->entityMapping->method('getFieldMappings')->willReturn($this->mappings);
        $this->entityMapping->method('collectDBALColumns')->willReturn([
            new Column("foo_column", Type::getType('string')),
            new Column("bar_column", Type::getType('string')),
        ]);

        $this->mappings['foo']->method("revertValue")->willReturn(["foo_column" => "ipsum"]);
        $this->mappings['bar']->method("revertValue")->willReturn(["bar_column" => "dolor"]);

        /** @var array $map */
        $map = array(

The assignment to $map is dead and can be removed.

            "some_ipsum_service" => ["foo_column" => "ipsum"],
            "some_dolor_service" => ["bar_column" => "dolor"],
        );

#        $this->valueResolver->method("revertValue")->will($this->returnCallback(
#            function ($fieldMapping, $context, $value) use ($map) {
#                return $map[$value];
#            }
#        ));

#        $this->valueResolver->method("revertValue")->will($this->returnValueMap([
#            [$this->mappings['foo'], $entity, "some_ipsum_service", ["foo_column" => "ipsum"]],
#            [$this->mappings['bar'], $entity, "some_dolor_service", ["bar_column" => "dolor"]],
#        ]));

        $this->connection->expects($this->never())->method("update");

The method expects() does not exist on Doctrine\DBAL\Connection.

        /** @var array $expectedData */
        $expectedData = [
            'foo_column' => 'ipsum',
            'bar_column' => 'dolor'
        ];

        $this->statement->method('fetch')->willReturn($expectedData);

        $this->dataLoader->loadDBALDataForEntity($entity, $this->entityManager);
        $this->dataLoader->storeDBALDataForEntity($entity, $this->entityManager);
    }

    /**
     * @test
     */
    public function shouldRemoveDBALForEntity()
    {
        $this->dataLoader->removeDBALDataForEntity(new EntityExample(), $this->entityManager);
        $this->assertTrue(true);
    }

    /**
     * @test
     */
    public function shouldPrepareOnMetadataLoad()
    {
        $this->dataLoader->prepareOnMetadataLoad($this->entityManager, $this->classMetaData);
        $this->assertTrue(true);
    }

}