Method updateSequence

lib/Db/ThresholdMapper.php:155–164

* Update the sequence of one threshold * * @param int $thresholdId * @param int $sequence * @return bool * @throws Exception */

(int $thresholdId, int $sequence)

     * @throws Exception
     */
    public function updateSequence(int $thresholdId, int $sequence)
    {
        $sql = $this->db->getQueryBuilder();
        $sql->update(self::TABLE_NAME)
            ->set('sequence', $sql->createNamedParameter($sequence))
            ->where($sql->expr()->eq('id', $sql->createNamedParameter($thresholdId)))
            ->andWhere($sql->expr()->eq('user_id', $sql->createNamedParameter($this->userId)));
        $sql->executeStatement();
        return true;
    }
}