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 __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, )