def _host_policy_update_cetp_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._cetp_policy_identity_validator(data) return "update host_policy_identity set local_fqdn={}, remote_fqdn={}, reputation={}, direction={} where " \ "id={}".format(data['local_fqdn'], data['remote_fqdn'], data['reputation'],data['direction'], id)
async def _host_policy_insert_cetp_policy_identity(self, data): ''' 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 ''' parameters = '' for policy in data: while (True): unique_id = uuid.uuid1().int >> 64 exists_check = await self._cetp_identity_check_exist_uuid( unique_id) if not exists_check: break policy = Validator._cetp_policy_identity_validator(policy) parameters += "({},{},{},{},'{}'),".format(policy['local_fqdn'], policy['remote_fqdn'], policy['reputation'], policy['direction'], unique_id) return "insert into host_policy_identity (local_fqdn, remote_fqdn, reputation, direction, uuid) values " + parameters[: -1]