def add_months(sourcedate, months):
month = sourcedate.month - 1 + months
year = int(sourcedate.year + month / 12)
month = month % 12 + 1
day = min(sourcedate.day, calendar.monthrange(year, month)[1])
return datetime.date(year, month, day)
class cpumem_api():
def get(self):
self.set_header("Content-Type", "application/json")
# this_time = add_months(datetime.datetime.today(), -2)
# years = this_time.strftime('%Y')
# month = this_time.strftime('%m')
# index = int(int(month) - 1)
# for this_month in month_list:
# this_month = month_list[index]
# index = index + 1
today = datetime.datetime.today()
this_list = []
month_count = 0
while month_count < 2:
day = today - relativedelta(months=month_count)
this_list.append(day.strftime('%Y%m'))
month_count += 1
results = {}
cpus = []
mems = []
for item in this_list:
sql = """
SELECT avg(sy+us+id) FROM his_cpu_mon_%s
""" % item
cpu = list(self.pg.db.query(sql))
cpus.append(apu)
sql = """
SELECT avg(us) FROM his_mem_mon_%s
""" % item
mem = list(self.pg.db.query(sql))
mems.append(mem)
results['cpus'] = cpus
results['mems'] = mems
data = json.dumps({"data": results}, cls=public_bz.ExtEncoder)
self.write(data)
month = sourcedate.month - 1 + months
year = int(sourcedate.year + month / 12)
month = month % 12 + 1
day = min(sourcedate.day, calendar.monthrange(year, month)[1])
return datetime.date(year, month, day)
class cpumem_api():
def get(self):
self.set_header("Content-Type", "application/json")
# this_time = add_months(datetime.datetime.today(), -2)
# years = this_time.strftime('%Y')
# month = this_time.strftime('%m')
# index = int(int(month) - 1)
# for this_month in month_list:
# this_month = month_list[index]
# index = index + 1
today = datetime.datetime.today()
this_list = []
month_count = 0
while month_count < 2:
day = today - relativedelta(months=month_count)
this_list.append(day.strftime('%Y%m'))
month_count += 1
results = {}
cpus = []
mems = []
for item in this_list:
sql = """
SELECT avg(sy+us+id) FROM his_cpu_mon_%s
""" % item
cpu = list(self.pg.db.query(sql))
cpus.append(apu)
sql = """
SELECT avg(us) FROM his_mem_mon_%s
""" % item
mem = list(self.pg.db.query(sql))
mems.append(mem)
results['cpus'] = cpus
results['mems'] = mems
data = json.dumps({"data": results}, cls=public_bz.ExtEncoder)
self.write(data)