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 remove_cups(self, fkenduser):
sql = 'DELETE FROM enduserlicense WHERE fkenduser = "******"'
self._execupdate(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 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))))
