def index(self):
self.b = Bids()
#data = group_by_minute_and_count()
#print(data)
#return data
return open(os.path.join(STATIC_DIR, u'index.html'))
class Root(object):
@cherrypy.expose
def index(self):
self.b = Bids()
#data = group_by_minute_and_count()
#print(data)
#return data
return open(os.path.join(STATIC_DIR, u'index.html'))
@cherrypy.expose
def histogram(self):
engine = ds.bi_engine
conn = engine.connect()
s = bizdw_v6.lifecycle_events_subscribes.alias()
df = group_by_minute_and_count(s,conn)
sub = df['sub_count']
print(sub)
tmp_list_1 = []
tmp_list_2 = []
cum_1 = 0
cum_2 = 0
for row_num, i in enumerate(sub):
if row_num < 1440:
cum_1 = cum_1 + i
tmp_list_1.append(cum_1)
else:
cum_2 = cum_2 + i
tmp_list_2.append(cum_2)
cumulative_1 = np.array(tmp_list_1)
cumulative_2 = np.array(tmp_list_2)
diff = []
for row_num, i in enumerate(cumulative_1):
try:
diff.append(cumulative_1[row_num] - cumulative_2[row_num] + random.random())
except:
pass
l = []
for index, i in enumerate(diff):
b = []
b.append(index)
b.append(i)
l.append(b)
self.diff = l
time = []
for index, i in enumerate(df['time']):
if index % 60 == 0:
b = []
b.append(index)
p = str(i).split(" ")[1].split(":")
b.append(p[0]+":"+p[1])
time.append(b)
conn.close()
print(l)
hist_var = json.dumps(dict(title = self.diff, xaxis = time))
cherrypy.response.headers['Content-Type'] = 'application/json'
return hist_var.encode('utf8')
@cherrypy.expose
def bid(self, a_name):
cherrypy.session['a_name'] = a_name
self.b.add_bid(a_name)
current_bids = str(self.b.d)
hist_var = json.dumps(dict(title = current_bids))
cherrypy.response.headers['Content-Type'] = 'application/json'
return hist_var.encode('utf8')
