def get_net_sample(self, req, instance_uuid):
#import ipdb; ipdb.set_trace() ### XXX BREAKPOINT
params = {}
params.update(req.GET)
start = self.time_format(params['start'])
end = self.time_format(params['end'])
session = db_api.get_session()
query = session.query(models.Net)
print "params = %s,%s" % (params['start'],params['end'])
queryList = session.query(models.Net).filter(models.Net.instance_uuid == "%s" % instance_uuid,models.Net.created_at >= "%s" % start,models.Net.created_at <= "%s" % end).group_by(models.Net.id).all()
print "*"*40,type(queryList)
print queryList
queryJson = []
for item in queryList:
queryDict = collections.OrderedDict()
#queryDict = {}
queryDict['id'] = item.id
queryDict['instance_uuid'] = item.instance_uuid
queryDict['tenant_id'] = item.tenant_id
queryDict['rx_packets_rate'] = item.rx_packets_rate
queryDict['rx_bytes_rate'] = item.rx_bytes_rate
queryDict['tx_packets_rate'] = item.tx_packets_rate
queryDict['tx_bytes_rate'] = item.tx_bytes_rate
queryDict['created_at'] = item.created_at
queryDict['updated_at'] = item.updated_at
queryJson.append(queryDict)
return queryJson
def get_mem_sample(self, req, instance_uuid):
params = {}
params.update(req.GET)
start = self.time_format(params['start'])
end = self.time_format(params['end'])
session = db_api.get_session()
query = session.query(models.Mem)
print "params = %s,%s" % (params['start'],params['end'])
queryList = session.query(models.Mem).filter(models.Mem.instance_uuid == "%s" % instance_uuid,models.Mem.created_at >= "%s" % start,models.Mem.created_at <= "%s" % end).group_by(models.Mem.id).all()
print "*"*40,type(queryList)
print queryList
queryJson = []
for item in queryList:
queryDict = collections.OrderedDict()
#queryDict = {}
queryDict['id'] = item.id
queryDict['instance_uuid'] = item.instance_uuid
queryDict['tenant_id'] = item.tenant_id
queryDict['mem_used'] = item.mem_used
queryDict['created_at'] = item.created_at
queryDict['updated_at'] = item.updated_at
queryJson.append(queryDict)
return queryJson
def get_disk_sample(self, req, instance_uuid):
params = {}
params.update(req.GET)
start_time = self.time_format(params['start'])
end_time = self.time_format(params['end'])
session = db_api.get_session()
query = session.query(models.Disk).\
filter_by(instance_uuid = instance_uuid).\
filter(models.Disk.created_at >= start_time).\
filter(models.Disk.created_at <= end_time).\
group_by(models.Disk.created_at).all()
result = []
for item in query:
result.append(item.to_dict())
return result
def save(self, session=None):
from umbrella.db.sqlalchemy import api as db_api
super(UmbrellaBase, self).save(session or db_api.get_session())
