ezsystems / ezpublish-kernel

     * @covers \eZ\Publish\Core\Persistence\Legacy\Content\Location\Gateway\DoctrineDatabase::untrashLocation

     * @dataProvider getUntrashedLocationValues

     */

    public function testUntrashLocationDefault($property, $value)

    {

        $this->insertDatabaseFixture(__DIR__ . '/_fixtures/full_example_tree.php');

        $handler = $this->getLocationGateway();

        $handler->trashLocation(71);

        $handler->untrashLocation(71);

        $query = $this->handler->createSelectQuery();

        $this->assertQueryResult(

            [[$value]],

            $query

                ->select($property)

                ->from('ezcontentobject_tree')

                ->where($query->expr->in('contentobject_id', [69]))

        );

    }

    /**

     * @covers \eZ\Publish\Core\Persistence\Legacy\Content\Location\Gateway\DoctrineDatabase::untrashLocation

     * @covers \eZ\Publish\Core\Persistence\Legacy\Content\Type\Gateway\DoctrineDatabase::setCommonTypeColumns

     * @dataProvider getTypeUpdateExpectations

     */

    public function testUpdateType($fieldName, $expectedValue)

    {

        $this->insertDatabaseFixture(

            __DIR__ . '/_fixtures/existing_types.php'

        );

        $gateway = $this->getGateway();

        $type = $this->getUpdateTypeFixture();

        $gateway->updateType(1, 0, $type);

        $this->assertQueryResult(

            [

                [

                    $fieldName => $expectedValue,

                ],

            ],

            $this->getDatabaseHandler()

                ->createSelectQuery()

                ->select(

                    $fieldName

                )->from('ezcontentclass')

                ->where('id = 1 AND version = 0'),

            "Incorrect value stored for '{$fieldName}'."

        );

    }

    /**

     * @covers \eZ\Publish\Core\Persistence\Legacy\Content\Type\Gateway\DoctrineDatabase::deleteTypeNameData