import flask
from flask import render_template
from flask import *
import json
import sys
from datasource import DataSource
app = flask.Flask(__name__)
db = DataSource()
#db.connect("yime2", "tablet389cow")
db.connect("bruelle", "spider268awesome")
#db.connect("allgoodm", "cow245happy")
@app.route('/')
def homePage():
return render_template('WRhomepage.html')
@app.route('/results', methods=['POST', 'GET'])
def results():
if request.method == 'POST':
result = request.form
book1ID = result['book1']
book2ID = result['book2']
bookrecs = db.getBookRecID(book1ID, book2ID)
if bookrecs == None:
return render_template('insufficientdata.html')
bookInfoList = list()
for book in bookrecs:
newbook = {}
newbook['title'] = db.getTitle(book[0])[0]
from datasource import DataSource
ds = DataSource.connect("http://www.ecb.europa.eu/stats/eurofxref/eurofxref.zip?3916cc3b0235ad119216f2cbd083f50f", format="csv")
ds.load()
#ds.print_description()
euro_usd = ds.fetch_float("USD")
date = ds.fetch("Date")
print("As of", date, ", 1 Euro =", euro_usd, "Dollars")
