def get_single_number_reach(self, fkremotedestination): sql = 'SELECT enablesinglenumberreach FROM remotedestinationdynamic WHERE fkremotedestination = "%(fkremotedestination)s"' return self._genresult(self._exec(sql % dict(fkremotedestination=utils.uuid(fkremotedestination))))
def update_bfcp(self, fkenduser, bfcp): sql = 'UPDATE device SET enablebfcp = "%(bfcp)s" WHERE pkid = "%(fkenduser)s"' self._execupdate(sql % dict(fkenduser=utils.uuid(fkenduser), bfcp=self._tobool(bfcp)))
def set_single_number_reach(self, fkremotedestination, value): sql = 'UPDATE remotedestinationdynamic SET enablesinglenumberreach = "%(value)s" WHERE fkremotedestination = "%(fkremotedestination)s"' self._execupdate(sql % dict(fkremotedestination=utils.uuid(fkremotedestination), value=self._tobool(value)))
def remove_cups(self, fkenduser): sql = 'DELETE FROM enduserlicense WHERE fkenduser = "******"' self._execupdate(sql % dict(fkenduser=utils.uuid(fkenduser)))
def update_cups(self, fkenduser, cupc): sql = 'UPDATE enduserlicense SET enablecupc = "%(cupc)s" WHERE fkenduser = "******"' self._execupdate(sql % dict(fkenduser=utils.uuid(fkenduser), cupc=self._tobool(cupc)))
def has_cups_cupc(self, fkenduser): sql = 'SELECT * FROM enduserlicense WHERE fkenduser="******"' return self._genresult(self._exec(sql % dict(fkenduser=utils.uuid(fkenduser))))
def insert_cups(self, fkenduser, cupc): sql = 'INSERT INTO enduserlicense (fkenduser, enablecups, enablecupc) VALUES ("%(fkenduser)s", "t", "%(cupc)s")' self._execupdate(sql % dict(fkenduser=utils.uuid(fkenduser), cupc=self._tobool(cupc)))
def get_single_number_reach(self, fkremotedestination): sql = 'SELECT enablesinglenumberreach FROM remotedestinationdynamic WHERE fkremotedestination = "%(fkremotedestination)s"' return self._genresult( self._exec( sql % dict(fkremotedestination=utils.uuid(fkremotedestination))))
def user_phone_association(self, fkenduser): sql = 'SELECT * FROM extensionmobilitydynamic WHERE fkenduser="******"' return self._genresultlist(self._exec(sql % dict(fkenduser=utils.uuid(fkenduser))))
def update_bfcp(self, fkenduser, bfcp): sql = 'UPDATE device SET enablebfcp = "%(bfcp)s" WHERE pkid = "%(fkenduser)s"' self._execupdate( sql % dict(fkenduser=utils.uuid(fkenduser), bfcp=self._tobool(bfcp)))
def set_single_number_reach(self, fkremotedestination, value): sql = 'UPDATE remotedestinationdynamic SET enablesinglenumberreach = "%(value)s" WHERE fkremotedestination = "%(fkremotedestination)s"' self._execupdate( sql % dict(fkremotedestination=utils.uuid(fkremotedestination), value=self._tobool(value)))
def update_cups(self, fkenduser, cupc): sql = 'UPDATE enduserlicense SET enablecupc = "%(cupc)s" WHERE fkenduser = "******"' self._execupdate( sql % dict(fkenduser=utils.uuid(fkenduser), cupc=self._tobool(cupc)))
def insert_cups(self, fkenduser, cupc): sql = 'INSERT INTO enduserlicense (fkenduser, enablecups, enablecupc) VALUES ("%(fkenduser)s", "t", "%(cupc)s")' self._execupdate( sql % dict(fkenduser=utils.uuid(fkenduser), cupc=self._tobool(cupc)))
def has_cups_cupc(self, fkenduser): sql = 'SELECT * FROM enduserlicense WHERE fkenduser="******"' return self._genresult( self._exec(sql % dict(fkenduser=utils.uuid(fkenduser))))
def user_phone_association(self, fkenduser): sql = 'SELECT * FROM extensionmobilitydynamic WHERE fkenduser="******"' return self._genresultlist( self._exec(sql % dict(fkenduser=utils.uuid(fkenduser))))