def _host_policy_update_firewall(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
'''
#await self._host_check_exist_user(policy['fqdn'])
data = Validator._firewall_policy_validator_filter(data)
return "update firewall_policies set uuid=(select uuid from host_ids where fqdn={}),types={}, sub_type={}," \
"policy_element={} where id={}".format(data['fqdn'],data['types'],data['sub_type'], data['policy_element'], id)
def _host_policy_insert_firewall(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:
#await self._host_check_exist_user(policy['fqdn'])
policy = Validator._firewall_policy_validator_filter(policy)
parameters += "((select uuid from host_ids where fqdn={}),{},{},{}),".format(
policy['fqdn'], policy['types'], policy['sub_type'],
policy['policy_element'])
return "insert into firewall_policies (uuid, types, sub_type, policy_element) values " + parameters[:
-1]
