def graphOfChosenStockOverTime():
# try:
conn = connect.connector()
cursor = conn.cursor()
cursor.execute("SELECT * FROM abbdaily")
row = cursor.fetchone()
# take time duration and return highest/lowest growth
# top 10 stocks on a date
dates = []
values = []
while row is not None:
dates.append(row[0].strftime('%Y-%m-%d'))
values.append(row[1])
row = cursor.fetchone()
#print (values)
# print ((dates))
plt.plot(dates, values)
plt.xticks(['dfd'], [])
#plt.show()
canvas = FigureCanvas(plt)
response = django.http.HttpResponse(content_type='image/png')
canvas.print_png(response)
return response
def retTableList():
conn = connect.connector()
cursor = conn.cursor()
cursor.execute("show tables")
row = cursor.fetchone()
allTables = []
while row is not None:
allTables.append(row[0])
row = cursor.fetchone()
return allTables
def printTop10(qu, allTables):
date = input("Enter a date : ")
date = datetime.strptime(date, "%Y-%m-%d").date(
) # <--- error here...how to convert string to datetime object???
# date = datetime.strptime(date, '%Y-%m-%d')
print(date)
# qu += "where recordtime = " + date + ";"
conn = connect.connector()
cursor = conn.cursor()
cursor.execute(qu)
row = cursor.fetchone()
print(row)
def graph2():
conn = connect.connector()
fig = Figure()
ax = fig.add_subplot(111)
cursor = conn.cursor()
cursor.execute("SELECT * FROM abbdaily")
row = cursor.fetchone()
dates = []
values = []
while row is not None:
dates.append(row[0].strftime('%Y-%m-%d'))
values.append(row[1])
row = cursor.fetchone()
ax.plot(dates, values)
#print (values)
# print ((dates))
fig.autofmt_xdate()
canvas = FigureCanvas(fig)
return canvas