def _host_policy_update_id(self, data, id): ''' create sql statement to insert in host_ids according to given parameters. Also calls relevant validation function for fields :param kwargs:Dictionary of parameters => fqdn, msisdn, ipv4 :return: sql insert statement or raise exception in case of validation error ''' #if 'id' not in kwargs or not kwargs['id'].isdigit(): # raise API_ERROR(1005, 'Only Accepted parameter for ID is integer. ID received = {}'.format(kwargs['id'])) data = Validator._ids_validator(data) return "update host_ids set fqdn={}, msisdn={}, ipv4={}, username={} where id={}".format( data['fqdn'], data['msisdn'], data['ipv4'], data['username'], id)
async def _host_policy_insert_id(self, data): ''' create sql statement to insert in host_ids according to given parameters. Also calls relevant validation function for fields :param kwargs:Dictionary of parameters => fqdn, msisdn, ipv4 :return: sql insert statement or raise exception in case of validation error ''' parameters = '' for kwargs in data: kwargs = Validator._ids_validator(kwargs) while (True): unique_id = uuid.uuid1().int >> 64 exists_check = await self._host_check_exist_uuid(unique_id) if not exists_check: break parameters += "('{}',{},{},{},{}),".format(unique_id, kwargs['fqdn'], kwargs['msisdn'], kwargs['ipv4'], kwargs['username']) return "insert into host_ids (uuid, fqdn, msisdn, ipv4, username) values " + parameters[: -1]