ezsystems / ezpublish-kernel

    /**

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

     */

    public function testUntrashLocationNewParent()

    {

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

        $handler = $this->getLocationGateway();

        $handler->trashLocation(71);

        $handler->untrashLocation(71, 1);

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

        $this->assertQueryResult(

            array(array('228', '1', '/1/228/')),

            $query

                ->select('node_id', 'parent_node_id', 'path_string')

                ->from('ezcontentobject_tree')

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

        );

    }

    /**

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

    /**

     * @dataProvider getUpdateLocationData

     */

    public function testUpdateLocation($field, $value)

    {

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

        $handler = $this->getLocationGateway();

        $handler->update(

            new Location\UpdateStruct(

                array(

                    'priority' => 23,

                    'remoteId' => 'someNewHash',

                    'sortField' => 4,

                    'sortOrder' => 4,

                )

            ),

            70

        );

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

        $this->assertQueryResult(

            array(array($value)),

            $query

                ->select($field)

                ->from('ezcontentobject_tree')

                ->where($query->expr->in('node_id', array(70)))

        );

    }

    public static function getNodeAssignmentValues()

    {