def snapshot_sql(self, uuid, start=None, end=None, format='json', last=False, fields=None, offset=0):
if self.rm.sql:
offset = int(offset)
observations = self.rm.sql.get_observations(uuid, start, end, format, last, fields, offset)
data = JOb()
data.data = observations
#TODO remove the 2 below
data.next_url = "/api/snapshot_sql2?uuid=%s%s%s%s%s%s%s" % (uuid,
"&start=" + start if start else "",
"&end=" + end if end else "" ,
"&format=" + format,
"&last=" + last if last else "",
"&fields=" + fields if fields else "",
"&offset=" + str(offset + self.rm.sql.PAGINATION_LIMIT)) if len(observations) == self.rm.sql.PAGINATION_LIMIT else ""
return data.dumps()
else:
return "Error. SQL feature not enabled in Resource Management"
