ezsystems / ezpublish-kernel

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

    }

    public function deleteSection(int $id): void

    {

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

        $query

            ->delete(self::CONTENT_SECTION_TABLE)

            ->where(

                $query->expr()->eq(

                    'id',

                    $query->createPositionalParameter($id, ParameterType::INTEGER)

                )

            );

        $query->execute();

    }

    public function assignSectionToContent(int $sectionId, int $contentId): void

    {

        $this->dbPlatform = $this->connection->getDatabasePlatform();

    }

    public function load(int $userId): array

    {

        $query = $this->getLoadUserQueryBuilder();

        $query

            ->where(

                $query->expr()->eq(

                    'u.contentobject_id',

                    $query->createPositionalParameter($userId, ParameterType::INTEGER)

                )

            );

        $statement = $query->execute();

        return $statement->fetchAll(FetchMode::ASSOCIATIVE);

    }

    public function loadByLogin(string $login): array

    {

        return $statement->fetchAll(FetchMode::ASSOCIATIVE);

    }

    public function loadByLogin(string $login): array

    {

        $query = $this->getLoadUserQueryBuilder();

        $expr = $query->expr();

        $query

            ->where(

                $expr->eq(

                    $this->dbPlatform->getLowerExpression('u.login'),

                    // Index is case in-sensitive, on some db's lowercase, so we lowercase $login

                    $query->createPositionalParameter(

                        mb_strtolower($login, 'UTF-8'),

                        ParameterType::STRING

                    )

                )

            );

        return $query->execute()->fetchAll(FetchMode::ASSOCIATIVE);

    }

    public function loadByEmail(string $email): array

    {

        return $query->execute()->fetchAll(FetchMode::ASSOCIATIVE);

    }

    public function loadByEmail(string $email): array

    {

        $query = $this->getLoadUserQueryBuilder();

        $query->where(

            $query->expr()->eq(

                'u.email',

                $query->createPositionalParameter($email, ParameterType::STRING)

            )

        );

        $statement = $query->execute();

        return $statement->fetchAll(FetchMode::ASSOCIATIVE);

    }

    public function loadUserByToken(string $hash): array

    {

        $query->execute();

    }

    public function removeRoleAssignmentById(int $roleAssignmentId): void

    {

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

        $query

            ->delete('ezuser_role')

            ->where(

                $query->expr()->eq(

                    'id',

                    $query->createPositionalParameter($roleAssignmentId, ParameterType::INTEGER)

                )

            );

        $query->execute();

    }

    private function getLoadUserQueryBuilder(): QueryBuilder

    {