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]
