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]
