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]
