def _host_policy_update_ces_policies(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_policies_validator(data)
return "update ces_policies set types={}, policy_element={} where id={}".format(
data['types'], data['policy_element'], id)
async def _host_policy_insert_ces_policies(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:
exists_check = await self._ces_identity_check_exist_uuid(
policy['uuid'])
if not exists_check:
raise API_ERROR(
1005,
'Unique ID does not exists = {}'.format(policy['uuid']))
policy = Validator._cetp_policies_validator(policy)
parameters += "({},{},{}),".format(policy['uuid'], policy['types'],
policy['policy_element'])
return "insert into ces_policies (uuid, types, policy_element) values " + parameters[:
-1]
