-
Notifications
You must be signed in to change notification settings - Fork 0
/
showdata.py
48 lines (40 loc) · 1.27 KB
/
showdata.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
import logging
import json
import time
import datetime
import math
import numpy as np
import matplotlib.pyplot as plt
from cassandra.cluster import Cluster
log = logging.getLogger()
log.setLevel('DEBUG')
handler = logging.StreamHandler()
handler.setFormatter(logging.Formatter("%(asctime)s [%(levelname)s] %(name)s: %(message)s"))
log.addHandler(handler)
from flask import Flask
from flask import Markup
from flask import Flask
from flask import render_template
from plotly.offline import plot
from plotly.graph_objs import Scatter
dates = []
amounts = []
app = Flask(__name__)
@app.route('/')
def results():
error = None
cluster = Cluster(['127.0.0.1'])
session = cluster.connect()
KEYSPACE = "BTC"
rows = session.execute('SELECT date, amount FROM BTC.USD')
for row in rows:
if not row.date == None:
dates.append(datetime.datetime.fromtimestamp(float(row.date)).strftime('%Y-%m-%d %H:%M:%S'))
if not row.amount == None:
amounts.append(str(row.amount))
my_plot_div = plot([Scatter(x=dates, y=amounts)], output_type='div')
return render_template('results.html',
div_placeholder=Markup(my_plot_div)
)
if __name__ == "__main__":
app.run(host='127.0.0.1', port=80)