def perf_searchVolumeStatic(request):
resource_id = ''
if request.GET.has_key('resource_id'):
resource_id = request.GET['resource_id']
if request.POST.has_key('resource_id'):
resource_id = request.POST['resource_id']
counter_name = 'cpu_util'
if request.GET.has_key('counter_name'):
counter_name = request.GET['counter_name']
if request.POST.has_key('counter_name'):
counter_name = request.POST['counter_name']
print(counter_name)
tmpDate = DateTimeUtil.dayBefore(7)
result = {}
catagories = []
series = []
tmpMax = {}
tmpMaxList = []
# tmpMin={}
# tmpMinList=[]
# tmpAvg={}
# tmpAvgList=[]
#find volumes by instanceid
volumeList = volumes.objects.all().using('cinder').filter(
instance_uuid=resource_id)
print(volumeList)
tmpVolumeIds = []
for vol in volumeList:
tmpVolumeIds.append(vol.id)
statList = MongoEngineUtil.findStaticsByTimestampAndCounter_nameAndResourceId(
tmpDate, counter_name, tmpVolumeIds)
for stat in statList:
str = DateTimeUtil.datetime_toString(stat.timestamp, "%Y-%m-%d")
catagories.append(str)
tmpMaxList.append(stat.max)
tmpMax['data'] = tmpMaxList
tmpMax['type'] = 'line'
tmpMax['name'] = 'max'
series.append(tmpMax)
result['categories'] = catagories
result['series'] = series
# print(staticsList)
return HttpResponse(json.dumps(result))
def perf_searchVolumeStatic(request):
resource_id=''
if request.GET.has_key('resource_id'):
resource_id=request.GET['resource_id'];
if request.POST.has_key('resource_id'):
resource_id=request.POST['resource_id'];
counter_name='cpu_util'
if request.GET.has_key('counter_name'):
counter_name=request.GET['counter_name'];
if request.POST.has_key('counter_name'):
counter_name=request.POST['counter_name'];
print(counter_name)
tmpDate=DateTimeUtil.dayBefore(7);
result={}
catagories=[]
series=[]
tmpMax={}
tmpMaxList=[]
# tmpMin={}
# tmpMinList=[]
# tmpAvg={}
# tmpAvgList=[]
#find volumes by instanceid
volumeList=volumes.objects.all().using('cinder').filter(instance_uuid=resource_id)
print(volumeList)
tmpVolumeIds=[]
for vol in volumeList:
tmpVolumeIds.append(vol.id)
statList=MongoEngineUtil.findStaticsByTimestampAndCounter_nameAndResourceId(tmpDate,counter_name,tmpVolumeIds)
for stat in statList:
str=DateTimeUtil.datetime_toString(stat.timestamp,"%Y-%m-%d")
catagories.append(str)
tmpMaxList.append(stat.max)
tmpMax['data']=tmpMaxList
tmpMax['type']='line'
tmpMax['name']='max'
series.append(tmpMax)
result['categories']=catagories
result['series']=series
# print(staticsList)
return HttpResponse(json.dumps(result))
def perf_searchStaticByVm(request):
resource_id = ''
if request.GET.has_key('resource_id'):
resource_id = request.GET['resource_id']
if request.POST.has_key('resource_id'):
resource_id = request.POST['resource_id']
print(resource_id)
tmpDate = DateTimeUtil.dayBefore(7)
counter_name = 'cpu_util'
if request.GET.has_key('counter_name'):
counter_name = request.GET['counter_name']
if request.POST.has_key('counter_name'):
counter_name = request.POST['counter_name']
print(counter_name)
#staticsList=mongoUtil.findStaticsByTimestampAndCounter_name(timestamp,counter_name,0,10)
# staticsList=mongoUtil.findLimitStaticsByTimestampAndCounter_name(timestamp,counter_name,1)
# resource_id='7dcc77ae-6bc6-44fe-a24b-f6580f9fcce1'
# res=MongoEngineUtil.findResourcesById('7dcc77ae-6bc6-44fe-a24b-f6580f9fcce1')
# print(res)
resList = [resource_id]
staticsList = MongoEngineUtil.findStaticsByTimestampAndCounter_nameAndResourceId(
tmpDate, counter_name, resList)
result = {}
catagories = []
series = []
tmpMax = {}
tmpMaxList = []
tmpMin = {}
tmpMinList = []
tmpAvg = {}
tmpAvgList = []
for stat in staticsList:
str = DateTimeUtil.datetime_toString(stat.timestamp, "%Y-%m-%d")
catagories.append(str)
tmpMaxList.append(stat.max)
tmpMinList.append(stat.min)
tmpAvgList.append(stat.avg)
tmpMax['data'] = tmpMaxList
tmpMax['type'] = 'line'
tmpMax['name'] = 'max'
tmpMin['data'] = tmpMinList
tmpMin['type'] = 'line'
tmpMin['name'] = 'min'
tmpAvg['data'] = tmpAvgList
tmpAvg['type'] = 'line'
tmpAvg['name'] = 'avg'
series.append(tmpMax)
series.append(tmpMin)
series.append(tmpAvg)
# result['legends']=['ggg']
# result['categories']=[1,2,3]
# result['series']=[55,2,45]
# for stat in staticsList:
result['categories'] = catagories
result['series'] = series
# print(staticsList)
return HttpResponse(json.dumps(result))
def perf_searchStaticByVm(request):
resource_id=''
if request.GET.has_key('resource_id'):
resource_id=request.GET['resource_id'];
if request.POST.has_key('resource_id'):
resource_id=request.POST['resource_id'];
print(resource_id)
tmpDate=DateTimeUtil.dayBefore(7);
counter_name='cpu_util'
if request.GET.has_key('counter_name'):
counter_name=request.GET['counter_name'];
if request.POST.has_key('counter_name'):
counter_name=request.POST['counter_name'];
print(counter_name)
#staticsList=mongoUtil.findStaticsByTimestampAndCounter_name(timestamp,counter_name,0,10)
# staticsList=mongoUtil.findLimitStaticsByTimestampAndCounter_name(timestamp,counter_name,1)
# resource_id='7dcc77ae-6bc6-44fe-a24b-f6580f9fcce1'
# res=MongoEngineUtil.findResourcesById('7dcc77ae-6bc6-44fe-a24b-f6580f9fcce1')
# print(res)
resList=[resource_id]
staticsList=MongoEngineUtil.findStaticsByTimestampAndCounter_nameAndResourceId(tmpDate,counter_name,resList)
result={}
catagories=[]
series=[]
tmpMax={}
tmpMaxList=[]
tmpMin={}
tmpMinList=[]
tmpAvg={}
tmpAvgList=[]
for stat in staticsList:
str=DateTimeUtil.datetime_toString(stat.timestamp,"%Y-%m-%d")
catagories.append(str)
tmpMaxList.append(stat.max)
tmpMinList.append(stat.min)
tmpAvgList.append(stat.avg)
tmpMax['data']=tmpMaxList
tmpMax['type']='line'
tmpMax['name']='max'
tmpMin['data']=tmpMinList
tmpMin['type']='line'
tmpMin['name']='min'
tmpAvg['data']=tmpAvgList
tmpAvg['type']='line'
tmpAvg['name']='avg'
series.append(tmpMax)
series.append(tmpMin)
series.append(tmpAvg)
# result['legends']=['ggg']
# result['categories']=[1,2,3]
# result['series']=[55,2,45]
# for stat in staticsList:
result['categories']=catagories
result['series']=series
# print(staticsList)
return HttpResponse(json.dumps(result))