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]