ezsystems / ezpublish-kernel

    /**

     * {@inheritdoc}

     */

    public function getNotificationById(int $notificationId): array

    {

        $query = $this->connection->createQueryBuilder();

        $query

            ->select(...$this->getColumns())

            ->from(self::TABLE_NOTIFICATION)

            ->where($query->expr()->eq(self::COLUMN_ID, ':id'));

        $query->setParameter(':id', $notificationId, PDO::PARAM_INT);

        return $query->execute()->fetchAll(PDO::FETCH_ASSOC);

    }

    /**

     * {@inheritdoc}

    /**

     * {@inheritdoc}

     */

    public function countUserPreferences(int $userId): int

    {

        $query = $this->connection->createQueryBuilder();

        $query

            ->select(

                $this->connection->getDatabasePlatform()->getCountExpression(self::COLUMN_ID)

            )

            ->from(self::TABLE_USER_PREFERENCES)

            ->where($query->expr()->eq(self::COLUMN_USER_ID, ':user_id'))

            ->setParameter(':user_id', $userId, ParameterType::INTEGER);

        return (int) $query->execute()->fetchColumn();

    }

    private function getColumns(): array

    {