limoncello-php-dist / passport

     *

     * @return string[]

     */

    protected function readBelongsToManyRelationshipIdentifiers(

        $identifier,

        string $intTableName,

        string $intPrimaryKeyName,

        string $intForeignKeyName

    ): array {

        $connection = $this->getConnection();

        $query      = $connection->createQueryBuilder();

        $query

            ->select($intForeignKeyName)

            ->from($intTableName)

            ->where($intPrimaryKeyName . '=' . $this->createTypedParameter($query, $identifier));

        $statement = $query->execute();

        $statement->setFetchMode(PDO::FETCH_NUM);

        $result = array_column($statement->fetchAll(), 0);

        return $result;

    }

    /**

     * @param string|int $identifier

     *

     * @return string[]

     */

    protected function readHasManyRelationshipColumn(

        $identifier,

        string $hasManyTableName,

        string $hasManyColumn,

        string $hasManyFkName

    ): array {

        $connection = $this->getConnection();

        $query      = $connection->createQueryBuilder();

        $query

            ->select($hasManyColumn)

            ->from($hasManyTableName)

            ->where($hasManyFkName . '=' . $this->createTypedParameter($query, $identifier));

        $statement = $query->execute();

        $statement->setFetchMode(PDO::FETCH_NUM);

        $result = array_column($statement->fetchAll(), 0);

        return $result;

    }

    /**

     * @param string     $intTableName