def __updatePrefixQuery(self,tariff_id,prefix_id,prefix_code,prefix_name,cpm,free_second,min_duration,round_to):
return ibs_db.createUpdateQuery("tariff_prefix_list",{"prefix_code":dbText(prefix_code),
"prefix_name":dbText(prefix_name),
"cpm":cpm,
"free_seconds":free_second,
"min_duration":min_duration,
"round_to":round_to},"prefix_id=%s"%prefix_id)
def __updateGroupQuery(self, group_id, group_name, comment, owner_id):
return ibs_db.createUpdateQuery(
"groups", {
"group_name": dbText(group_name),
"comment": dbText(comment),
"owner_id": owner_id
}, "group_id=%s" % group_id)
def updateVoIPUserAttrsToNullQuery(self,user_id):
"""
update voip_username to null, we run into unique constraint violation, when updating multiple
users. So we update them to null and then update to new username
"""
return ibs_db.createUpdateQuery("voip_users",{"voip_username":"******"}
,"user_id=%s"%user_id)
def __updateLeafQuery(self,leaf_id,leaf_name,default_rate_kbits,default_ceil_kbits,total_rate_kbits,total_ceil_kbits):
return ibs_db.createUpdateQuery("bw_leaf",{ "leaf_name":dbText(leaf_name),
"default_rate_kbits":default_rate_kbits,
"default_ceil_kbits":default_ceil_kbits,
"total_rate_kbits":total_rate_kbits,
"total_ceil_kbits":total_ceil_kbits}
,"leaf_id=%s"%leaf_id)
def updateDefsQuery(self):
"""
return an update query to change value(s) of "var_name" in "defs" table
"""
from core.db import ibs_db
return ibs_db.createUpdateQuery("defs",{"value":dbText(pickle.dumps(self.value))},
"name=%s"%dbText(self.name))
def updateVoIPUserAttrsQuery(self,user_id,voip_username,voip_password):
"""
update user voip attributes in "voip_users" table
"""
return ibs_db.createUpdateQuery("voip_users",{"voip_username":dbText(voip_username),
"voip_password":dbText(voip_password),
},"user_id=%s"%user_id)
def __updatePortQuery(self, ras_id, port_name, phone, _type, comment):
return ibs_db.createUpdateQuery(
"ras_ports", {
"port_name": dbText(port_name),
"phone": dbText(phone),
"type": dbText(_type),
"comment": dbText(comment)
}, "ras_id=%s and port_name=%s" % (ras_id, dbText(port_name)))
def updateUserAttrQuery(self,user_id,attr_name,attr_value):
"""
XXX:change to use stored procedures
"""
return ibs_db.createUpdateQuery("user_attrs",{"attr_value":dbText(attr_value)}
,"attr_name=%s and user_id=%s"%
(dbText(attr_name),user_id)
)
def __updateRasQuery(self,ras_id,ras_ip,ras_type,radius_secret):
"""
return query for updating ras with id "ras_id"
"""
return ibs_db.createUpdateQuery("ras",{"ras_ip":dbText(ras_ip),
"ras_type":dbText(ras_type),
"radius_secret":dbText(radius_secret)
},"ras_id=%s"%ras_id)
def __updateBwStaticIPQuery(self, static_ip_id, ip_addr, tx_leaf_id,
rx_leaf_id):
return ibs_db.createUpdateQuery(
"bw_static_ip", {
"ip": dbText(ip_addr),
"transmit_leaf_id": tx_leaf_id,
"receive_leaf_id": rx_leaf_id
}, "bw_static_ip_id=%s" % static_ip_id)
def updateVoIPUserAttrsToNullQuery(self, user_id):
"""
update voip_username to null, we run into unique constraint violation, when updating multiple
users. So we update them to null and then update to new username
"""
return ibs_db.createUpdateQuery("voip_users",
{"voip_username": "******"},
"user_id=%s" % user_id)
def updateDefsQuery(self):
"""
return an update query to change value(s) of "var_name" in "defs" table
"""
from core.db import ibs_db
return ibs_db.createUpdateQuery(
"defs", {"value": dbText(pickle.dumps(self.value))},
"name=%s" % dbText(self.name))
def __updatePrefixQuery(self,tariff_id,prefix_id,prefix_code,prefix_name,cpm,free_second,min_duration,round_to,min_chargable_duration):
return ibs_db.createUpdateQuery("tariff_prefix_list",{"prefix_code":dbText(prefix_code),
"prefix_name":dbText(prefix_name),
"cpm":cpm,
"free_seconds":free_second,
"min_duration":min_duration,
"round_to":round_to,
"min_chargable_duration":min_chargable_duration},"prefix_id=%s"%prefix_id)
def updateNormalUserAttrsQuery(self, user_id, normal_username, normal_password):
"""
update user normal attributes in "normal_users" table
"""
return ibs_db.createUpdateQuery(
"normal_users",
{"normal_username": dbText(normal_username), "normal_password": dbText(normal_password)},
"user_id=%s" % user_id,
)
def updateVoIPUserAttrsQuery(self, user_id, voip_username, voip_password):
"""
update user voip attributes in "voip_users" table
"""
return ibs_db.createUpdateQuery(
"voip_users", {
"voip_username": dbText(voip_username),
"voip_password": dbText(voip_password),
}, "user_id=%s" % user_id)
def __updateServiceQuery(self, leaf_service_id, protocol, _filter,
rate_kbits, ceil_kbits):
return ibs_db.createUpdateQuery(
"bw_leaf_services", {
"protocol": dbText(protocol),
"filter": dbText(_filter),
"rate_kbits": rate_kbits,
"ceil_kbits": ceil_kbits
}, "leaf_service_id=%s" % leaf_service_id)
def __updateVoIPChargeRuleQuery(self,rule_obj):
"""
return query for inserting rule_obj properties into charge_rules table
"""
ras_id=self.__convertRasID(rule_obj.getRasID())
return ibs_db.createUpdateQuery("voip_charge_rules",{"start_time":dbText(rule_obj.start_time),
"end_time":dbText(rule_obj.end_time),
"ras_id":ras_id,
"tariff_id":rule_obj.tariff_id,
},"charge_rule_id=%s"%rule_obj.getRuleID())
def __updateLeafQuery(self, leaf_id, leaf_name, default_rate_kbits,
default_ceil_kbits, total_rate_kbits,
total_ceil_kbits):
return ibs_db.createUpdateQuery(
"bw_leaf", {
"leaf_name": dbText(leaf_name),
"default_rate_kbits": default_rate_kbits,
"default_ceil_kbits": default_ceil_kbits,
"total_rate_kbits": total_rate_kbits,
"total_ceil_kbits": total_ceil_kbits
}, "leaf_id=%s" % leaf_id)
def __updateVoIPChargeRuleQuery(self, rule_obj):
"""
return query for inserting rule_obj properties into charge_rules table
"""
ras_id = self.__convertRasID(rule_obj.getRasID())
return ibs_db.createUpdateQuery(
"voip_charge_rules", {
"start_time": dbText(rule_obj.start_time),
"end_time": dbText(rule_obj.end_time),
"ras_id": ras_id,
"tariff_id": rule_obj.tariff_id,
}, "charge_rule_id=%s" % rule_obj.getRuleID())
def __updateRasQuery(self, ras_id, ras_ip, ras_description, ras_type,
radius_secret, comment):
"""
return query for updating ras with id "ras_id"
"""
return ibs_db.createUpdateQuery(
"ras", {
"ras_ip": dbText(ras_ip),
"ras_description": dbText(ras_description),
"ras_type": dbText(ras_type),
"radius_secret": dbText(radius_secret),
"comment": dbText(comment)
}, "ras_id=%s" % ras_id)
def __updateInternetChargeRuleQuery(self,rule_obj):
"""
return query for inserting rule_obj properties into charge_rules table
"""
ras_id=self.__convertRasID(rule_obj.getRasID())
return ibs_db.createUpdateQuery("internet_charge_rules",{"start_time":dbText(rule_obj.start_time),
"end_time":dbText(rule_obj.end_time),
"cpm":float(rule_obj.cpm),
"cpk":float(rule_obj.cpk),
"assumed_kps":integer(rule_obj.assumed_kps),
"bandwidth_limit_kbytes":integer(rule_obj.bandwidth_limit),
"ras_id":ras_id,
"bw_transmit_leaf_id":dbNull(rule_obj.bw_tx_leaf_id),
"bw_receive_leaf_id":dbNull(rule_obj.bw_rx_leaf_id),
},"charge_rule_id=%s"%rule_obj.getRuleID())
def updateQuery(self, ibs_query, src, action, **args):
group_obj = group_main.getLoader().getGroupByName(self.group_name)
for user_id in args["users"]:
ibs_query += ibs_db.createUpdateQuery(
"users", {"group_id": group_obj.getGroupID()},
"user_id=%s" % user_id)
if defs.USER_AUDIT_LOG:
ibs_query += user_main.getUserAuditLogManager(
).userAuditLogQuery(
args["admin_obj"].getAdminID(), True, user_id, "group",
args["users"]
[user_id].getBasicUser().getGroupObj().getGroupName(),
self.group_name)
return ibs_query
def __updateInternetChargeRuleQuery(self, rule_obj):
"""
return query for inserting rule_obj properties into charge_rules table
"""
ras_id = self.__convertRasID(rule_obj.getRasID())
return ibs_db.createUpdateQuery(
"internet_charge_rules", {
"start_time": dbText(rule_obj.start_time),
"end_time": dbText(rule_obj.end_time),
"cpm": float(rule_obj.cpm),
"cpk": float(rule_obj.cpk),
"assumed_kps": integer(rule_obj.assumed_kps),
"bandwidth_limit_kbytes": integer(rule_obj.bandwidth_limit),
"ras_id": ras_id,
"bw_transmit_leaf_id": dbNull(rule_obj.bw_tx_leaf_id),
"bw_receive_leaf_id": dbNull(rule_obj.bw_rx_leaf_id),
}, "charge_rule_id=%s" % rule_obj.getRuleID())
def updateQuery(self, ibs_query, src, action, **args):
admin_obj = admin_main.getLoader().getAdminByName(self.admin_name)
for user_id in args["users"]:
ibs_query += ibs_db.createUpdateQuery("users", {"owner_id": admin_obj.getAdminID()}, "user_id=%s" % user_id)
return ibs_query
def __updateInfoQuery(self, admin_id, name, comment):
return ibs_db.createUpdateQuery("admins", {
"name": dbText(name),
"comment": dbText(comment)
}, "admin_id=%s" % admin_id)
def __updateAttributeQuery(self,ras_id,attr_name,attr_value):
return ibs_db.createUpdateQuery("ras_attrs",{"attr_value":dbText(attr_value)},
"ras_id=%s and attr_name=%s"%(ras_id,dbText(attr_name)))
def __reActiveRasQuery(self,ras_id):
return ibs_db.createUpdateQuery("ras",{"active":dbText("t")},"ras_id=%s"%ras_id)
def __delAdminUpdateAdminDepositChangersQuery(self, admin_id):
return ibs_db.createUpdateQuery("admin_deposit_change",
{"admin_id": 0},
"admin_id = %s" % admin_id)
def __updateTariffQuery(self,tariff_id,tariff_name,comment):
return ibs_db.createUpdateQuery("voip_charge_rule_tariff",
{"tariff_name":dbText(tariff_name),
"comment":dbText(comment)},
"tariff_id=%s"%tariff_id)
def __updateBwStaticIPQuery(self,static_ip_id,ip_addr,tx_leaf_id,rx_leaf_id):
return ibs_db.createUpdateQuery("bw_static_ip",{"ip":dbText(ip_addr),
"transmit_leaf_id":tx_leaf_id,
"receive_leaf_id":rx_leaf_id},
"bw_static_ip_id=%s"%static_ip_id)
def __updatePoolQuery(self,ippool_id,ippool_name,comment):
return ibs_db.createUpdateQuery("ippool",{"ippool_name":dbText(ippool_name),
"ippool_comment":dbText(comment)},
"ippool_id=%s"%ippool_id)
def __delAdminUpdateUserAuditLogAdmins(self, admin_id):
return ibs_db.createUpdateQuery("user_audit_log", {"admin_id": 0},
"admin_id = %s" % admin_id)
def __updateGroupQuery(self,group_id,group_name,comment,owner_id):
return ibs_db.createUpdateQuery("groups",{"group_name":dbText(group_name),
"comment":dbText(comment),
"owner_id":owner_id
},"group_id=%s"%group_id)
def __updatePermValueQuery(self, admin_id, perm_name, perm_value):
return ibs_db.createUpdateQuery("admin_perms",
{"perm_value": dbText(perm_value)},
"perm_name=%s" % dbText(perm_name))
def __updateServiceQuery(self,leaf_service_id,protocol,_filter,rate_kbits,ceil_kbits):
return ibs_db.createUpdateQuery("bw_leaf_services",{"protocol":dbText(protocol),
"filter":dbText(_filter),
"rate_kbits":rate_kbits,
"ceil_kbits":ceil_kbits}
,"leaf_service_id=%s"%leaf_service_id)
def consumeDepositQuery(self, admin_id, deposit):
return ibs_db.createUpdateQuery("admins",
{"deposit": "deposit - %s" % deposit},
"admin_id=%s" % admin_id)
def __changeCreditQuery(self,user_ids,credit):
where_clause=" or ".join(map(lambda user_id:"user_id = %s"%user_id,user_ids))
return ibs_db.createUpdateQuery("users",{"credit":"credit+%s"%credit},where_clause)
def __updatePortQuery(self,ras_id,port_name,phone,_type,comment):
return ibs_db.createUpdateQuery("ras_ports",{"port_name":dbText(port_name),
"phone":dbText(phone),
"type":dbText(_type),
"comment":dbText(comment)
},"ras_id=%s and port_name=%s"%(ras_id,dbText(port_name)))
def __delAdminUpdateAdminLockersQuery(self, admin_id):
return ibs_db.createUpdateQuery("admin_locks", {"locker_admin_id": 0},
"locker_admin_id = %s" % admin_id)
def __updateInterfaceQuery(self,interface_id,interface_name,comment):
return ibs_db.createUpdateQuery("bw_interface",{"interface_name":dbText(interface_name),
"comment":dbText(comment)},"interface_id=%s"%interface_id)
def __updateInfoQuery(self,admin_id,name,comment):
return ibs_db.createUpdateQuery("admins",{"name":dbText(name),
"comment":dbText(comment)},"admin_id=%s"%admin_id)
def updateValueQuery(self, value):
return ibs_db.createUpdateQuery("ibs_states", {"value": dbText(value)},
"name=%s" % dbText(self.state_name))
def __updatePoolQuery(self, ippool_id, ippool_name, comment):
return ibs_db.createUpdateQuery("ippool", {
"ippool_name": dbText(ippool_name),
"ippool_comment": dbText(comment)
}, "ippool_id=%s" % ippool_id)
def __updatePasswordDB(self, user_id, password):
db_main.getHandle().transactionQuery(
ibs_db.createUpdateQuery("voip_users",
{"voip_password": dbText(password)},
"user_id=%s" % user_id))
def __delAdminUpdateGroupOwnersQuery(self, admin_id):
return ibs_db.createUpdateQuery("groups", {"owner_id": 0},
"owner_id = %s" % admin_id)
def __updatePlanUserAttrsQuery(self,user_id,mac,ip,ras_id):
return ibs_db.createUpdateQuery("persistent_lan_users",{"persistent_lan_mac":dbText(mac),
"persistent_lan_ip":dbText(ip),
"persistent_lan_ras_id":ras_id},
"user_id=%s"%user_id)
def __commitCreditQuery(self,used_credit):
return ibs_db.createUpdateQuery("users",{"credit":"credit - %s"%used_credit},"user_id=%s"%self.getUserID())
def updateGroupAttrQuery(self,group_id,attr_name,attr_value):
return ibs_db.createUpdateQuery("group_attrs",{"attr_value":dbText(attr_value)},
"group_id=%s and attr_name=%s"%(to_int(group_id,"group id"),dbText(attr_name)))
def updateQuery(self,ibs_query,src,action,**args):
group_obj=group_main.getLoader().getGroupByName(self.group_name)
for user_id in args["users"]:
ibs_query+=ibs_db.createUpdateQuery("users",{"group_id":group_obj.getGroupID()},"user_id=%s"%user_id)
return ibs_query
def __changePermValueQuery(self, admin_id, perm_name, perm_value):
return ibs_db.createUpdateQuery(
"admin_perms", {"perm_value": dbText(perm_value)},
"perm_name=%s and admin_id=%s" % (dbText(perm_name), admin_id))
def __updateNodeQuery(self,node_id,rate_kbits,ceil_kbits):
return ibs_db.createUpdateQuery("bw_node",{"rate_kbits":rate_kbits,
"ceil_kbits":ceil_kbits},"node_id=%s"%node_id)
def __changePermValueQuery(self,admin_id,perm_name,perm_value):
return ibs_db.createUpdateQuery("admin_perms",
{"perm_value":dbText(perm_value)},
"perm_name=%s"%dbText(perm_name))
def __delAdminUpdateAdminCreatorsQuery(self, admin_id):
return ibs_db.createUpdateQuery("admins", {"creator_id": 0},
"creator_id = %s" % admin_id)
def consumeDepositQuery(self,admin_id,deposit):
return ibs_db.createUpdateQuery("admins",
{"deposit":"deposit - %s"%deposit},
"admin_id=%s"%admin_id)
def __updateAttributeQuery(self, ras_id, attr_name, attr_value):
return ibs_db.createUpdateQuery(
"ras_attrs", {"attr_value": dbText(attr_value)},
"ras_id=%s and attr_name=%s" % (ras_id, dbText(attr_name)))
def __updateInterfaceQuery(self, interface_id, interface_name, comment):
return ibs_db.createUpdateQuery(
"bw_interface", {
"interface_name": dbText(interface_name),
"comment": dbText(comment)
}, "interface_id=%s" % interface_id)
def __updateNodeQuery(self, node_id, rate_kbits, ceil_kbits):
return ibs_db.createUpdateQuery("bw_node", {
"rate_kbits": rate_kbits,
"ceil_kbits": ceil_kbits
}, "node_id=%s" % node_id)
def __updateTariffQuery(self,tariff_id,tariff_name,comment):
return ibs_db.createUpdateQuery("voip_charge_rule_tariff",
{"tariff_name":dbText(tariff_name),
"comment":dbText(comment)},
"tariff_id=%s"%tariff_id)
def __updatePlanUserAttrsQuery(self, user_id, mac, ip, ras_id):
return ibs_db.createUpdateQuery(
"persistent_lan_users",
{"persistent_lan_mac": dbText(mac), "persistent_lan_ip": dbText(ip), "persistent_lan_ras_id": ras_id},
"user_id=%s" % user_id,
)
