def _host_policy_update_ces_policy_identity(self, data, id): ''' create sql statement to insert in host_firewall according to given parameters. Also calls relevant validation function for fields :param kwargs:Dictionary of parameters => fqdn, types, active, priority, direction, src, dst, sport, dport, protocol, target, comment, raw_data, schedule_start, schedule_end :return:sql insert statement or raise exception in case of validation error ''' data = Validator._ces_policy_identity_validator(data) return "update ces_policy_identity set host_ces_id={}, protocol={} where id={}".format( data['host_ces_id'], data['protocol'], id)
async def _host_policy_insert_ces_policy_identity(self, data): ''' create sql statement to insert in ces_policy_identity table according to given parameters. Also calls relevant validation function for fields :param kwargs:Dictionary of parameters => protocol, host_ces_id :return:sql insert statement or raise exception in case of validation error ''' parameters = '' for policy in data: while (True): unique_id = uuid.uuid1().int >> 64 exists_check = await self._ces_identity_check_exist_uuid( unique_id) if not exists_check: break policy = Validator._ces_policy_identity_validator(policy) parameters += "({},{},'{}'),".format(policy['host_ces_id'], policy['protocol'], unique_id) return "insert into ces_policy_identity (host_ces_id, protocol, uuid) values " + parameters[: -1]