cultuurnet / udb3-php

    /**

     * @inheritdoc

     */

    public function getLabelRelations(LabelName $labelName)

    {

        $aliases = $this->getAliases();

        $whereLabelName = SchemaConfigurator::LABEL_NAME . ' = ?';

        $queryBuilder = $this->createQueryBuilder()->select($aliases)

            ->from($this->getTableName()->toNative())

            ->where($whereLabelName)

            ->setParameters([$labelName->toNative()]);

        $statement = $queryBuilder->execute();

        while ($row = $statement->fetch(\PDO::FETCH_ASSOC)) {

            $labelRelation = LabelRelation::fromRelationalData($row);

            yield $labelRelation;

        }

    }

    /**

     * @inheritdoc

    /**

     * @inheritdoc

     */

    public function getLabelRelationsForItem(StringLiteral $relationId)

    {

        $aliases = $this->getAliases();

        $whereRelationId = SchemaConfigurator::RELATION_ID . ' = ?';

        $queryBuilder = $this->createQueryBuilder()->select($aliases)

            ->from($this->getTableName()->toNative())

            ->where($whereRelationId)

            ->setParameters(

                [

                    $relationId->toNative(),

                ]

            );

        $statement = $queryBuilder->execute();

        $labelRelations = [];

        while ($row = $statement->fetch(\PDO::FETCH_ASSOC)) {

            $labelRelations[] = LabelRelation::fromRelationalData($row);

        }

        return $labelRelations;

    }

    /**

     * @return array