def index():
form1 = EnterDBInfo(request.form)
form2 = RetrieveDBInfo(request.form)
if request.method == 'POST' and form1.validate():
data_entered = Data(notes=form1.dbNotes.data)
try:
db.session.add(data_entered)
db.session.commit()
db.session.close()
except:
db.session.rollback()
return render_template('thanks.html', notes=form1.dbNotes.data)
if request.method == 'POST' and form2.validate():
try:
num_return = int(form2.numRetrieve.data)
query_db = Data.query.order_by(Data.id.desc()).limit(num_return)
for q in query_db:
print(q.notes)
db.session.close()
except:
db.session.rollback()
return render_template('results.html',
results=query_db,
num_return=num_return)
return render_template('index.html', form1=form1, form2=form2)
def flaskTutorial():
print "...in /test.................."
form1 = EnterDBInfo(request.form)
form2 = RetrieveDBInfo(request.form)
if request.method == 'POST' and form1.validate():
data_entered = Data(notes=form1.dbNotes.data)
try:
db.session.add(data_entered)
db.session.commit()
db.session.close()
except:
db.session.rollback()
return render_template('thanks.html', notes=form1.dbNotes.data)
if request.method == 'POST' and form2.validate():
try:
num_return = int(form2.numRetrieve.data)
query_db = Data.query.order_by(Data.id.desc()).limit(num_return)
for q in query_db:
print(q.notes)
db.session.close()
except:
db.session.rollback()
return render_template('results.html', results=query_db, num_return=num_return)
return render_template('index.html', form1=form1, form2=form2)
def index():
form1 = EnterDBInfo(request.form)
form2 = RetrieveDBInfo(request.form)
if request.method == 'POST' and form1.validate():
player_details = Player(form1.name.data, form1.amount.data,
form1.month.data, form1.year.data)
try:
db.session.add(player_details)
db.session.commit()
db.session.close()
except:
db.session.rollback()
return render_template('thanks.html', notes=form1.name.data)
if request.method == 'POST' and form2.validate():
try:
num_return = int(form2.numRetrieve.data)
query_db = Player.query.order_by(
Player.id.desc()).limit(num_return)
for q in query_db:
print(q.name + q.amount + q.month + q.year)
db.session.close()
except:
db.session.rollback()
return render_template('results.html',
results=query_db,
num_return=num_return)
return render_template('index.html', form1=form1, form2=form2)
def index():
fileForm = UploadFile(request.form)
form1 = EnterDBInfo(request.form)
form2 = RetrieveDBInfo(request.form)
if request.method == 'POST' and fileForm.validate_on_submit():
fileContents = fileForm.filePath.data
filename = secure_filename(fileContents.filename)
try:
filePath = os.path.join(application.instance_path, 'photos', filename)
fileContents.save(filePath, fileContents)
print(filePath)
print(fileContents)
with open(filePath, newline='') as csvfile:
filereader = csv.DictReader(csvfile)
for row in filereader:
print(row)
db.session.add(row)
db.session.commit()
db.session.close()
except:
db.session.rollback()
return render_template('thanks.html', notes=fileForm.filePath.data)
if request.method == 'POST' and form1.validate():
data_entered = Data(notes=form1.dbNotes.data)
try:
db.session.add(data_entered)
db.session.commit()
db.session.close()
except:
db.session.rollback()
return render_template('thanks.html', notes=form1.dbNotes.data)
if request.method == 'POST' and form2.validate():
try:
num_return = int(form2.numRetrieve.data)
query_db = Data.query.order_by(Data.id.desc()).limit(num_return)
for q in query_db:
print(q.notes)
db.session.close()
except:
db.session.rollback()
return render_template('results.html', results=query_db, num_return=num_return)
return render_template('index.html', fileForm=fileForm, form1=form1, form2=form2)
def index():
form1 = EnterDBInfo(request.form)
form2 = RetrieveDBInfo(request.form)
if request.method == 'POST' and form2.validate():
#num_return = str(form2.numRetrieve.data)
#num_return=request.form['numRetrieve_field']
#sell_name= request.form['SellerRetrieve_field']
#add_name=request.form['AddressRetrieve_field']
num_return = request.form.get('numRetrieve', "")
sell_name = request.form.get('SellerRetrieve', "")
add_name = request.form.get('AddressRetrieve', "")
#print num_return
#query_db = Data.query.order_by(Data.id.desc()).limit(num_return)
query_db = pyred.querySHOW(num_return,sell_name,add_name)
#print query_db
#for q in query_db:
# print(q.notes)
db.session.close()
try:
return render_template('results.html', results=query_db, num_return=num_return)
except:
return render_template('results1.html', results=query_db, num_return=num_return)
return render_template('index.html', form1=form1, form2=form2)
def bform():
form1 = EnterDBInfo(request.form)
if request.method == 'POST' and form1.validate():
data_entered = Data(notes = form1.dbNotes.data, wdate = form1.dbDate.data, weight_of_ort = form1.dbWeight_of_ORT.data, weight_of_compost = form1.dbWeight_of_Compost.data, groups = form1.dbGroups.data)
try:
db.session.add(data_entered)
db.session.commit()
db.session.close()
return render_template('thanks.html', notes=form1.dbNotes.data)
except Exception as e:
db.session.rollback()
print("error" ,e)
return render_template('bform.html', form1=form1)
#return render_template('thanks.html', notes=form1.dbNotes.data)
return render_template('bform.html', form1=form1)
def index():
form1 = EnterDBInfo(request.form)
form2 = RetrieveDBInfo(request.form)
if request.method == 'POST' and form1.validate():
data_entered = User(User_id=form1.dbNotes.data,
Name=form1.dbNotes2.data,
Type='Student',
Pw=form1.dbNotes3.data,
Email=form1.dbNotes4.data)
try:
db.session.add(data_entered)
db.session.commit()
db.session.close()
session['userid'] = form1.dbNotes.data
except:
db.session.rollback()
return redirect(url_for('process_upload'))
if request.method == 'POST' and form2.validate():
try:
userid = str(form2.userid.data)
password = str(form2.pw.data)
query_db = User.query.filter(User.User_id.in_([userid]),
User.Pw.in_([password]))
result = query_db.first()
if result:
print "login successfully"
session['userid'] = userid
return redirect(url_for('process_upload'))
else:
print "login failed"
return render_template('login_failed.html', studentid=userid)
db.session.close()
except:
db.session.rollback()
print "Nothing worked"
return render_template('index.html', form1=form1, form2=form2)
def index():
form1 = EnterDBInfo(request.form)
if request.method == 'POST' and form1.validate():
data_entered = Data(notes=form1.dbNotes.data,
username=form1.dbUsername.data)
try:
db.session.add(data_entered)
db.session.commit()
db.session.close()
except:
db.session.rollback()
try:
query_dbb = Data.query.order_by(Data.id.desc()).limit(10)
db.session.close()
except:
db.session.rollback()
return render_template('index.html', form1=form1, results=query_dbb)
def index():
form1 = EnterDBInfo(request.form)
if request.method == 'POST' and form1.validate():
data_entered = Data(notes=form1.dbNotes.data,
username=form1.dbUsername.data)
try:
db.session.add(data_entered)
db.session.commit()
db.session.close()
except:
db.session.rollback()
try:
query_dbb = Data.query.order_by(Data.id.desc()).limit(10)
db.session.close()
except:
db.session.rollback()
return render_template('index.html', form1=form1, results=query_dbb)
def index():
form1 = EnterDBInfo(request.form)
form2 = RetrieveDBInfo(request.form)
try:
query_db2 = Pre_req.query.order_by(Pre_req.Pre_id.desc()).limit(10)
db.session.close()
except:
db.session.rollback()
if request.method == 'POST' and form1.validate():
data_entered = User(User_id=form1.dbNotes.data,Name=form1.dbNotes2.data,Type ='Student',Pw =form1.dbNotes3.data,Email = form1.dbNotes4.data)
try:
db.session.add(data_entered)
db.session.commit()
db.session.close()
except:
db.session.rollback()
return render_template('login.html', studentid=form1.dbNotes.data,courseinfo = query_db2)
if request.method == 'POST' and form2.validate():
try:
userid = str(form2.userid.data)
password = str(form2.pw.data)
query_db = User.query.filter(User.User_id.in_([userid]),User.Pw.in_([password]))
result =query_db.first()
if result:
print "login successfully"
return render_template('login.html',studentid =userid,courseinfo = query_db2)
else:
print "login failed"
return render_template('login_failed.html',studentid =userid)
db.session.close()
except:
db.session.rollback()
return render_template('index.html', form1=form1, form2=form2)
def index():
# dynamically generate 2 forms with user request form
form1 = EnterDBInfo(request.form)
form2 = RetrieveDBInfo(request.form)
if request.method == 'POST' and form1.validate():
# specifying an id is NOT necessary, default auto_intremental by experiment.
data_entered = Data(notes=form1.dbNotes.data)
try:
db.session.add(data_entered)
db.session.commit()
db.session.close()
except:
db.session.rollback()
return render_template('thanks.html', notes=form1.dbNotes.data)
if request.method == 'POST' and form2.validate():
try:
# get the user input from form2 submitted by user
# the data is in the numRetrieve field (form contains field)
num_return = int(form2.numRetrieve.data)
# make the query with Data object is possible because:
# Data inhe db.Model generated from Flask with SQLAlchemy
# so Data has all the methods in db, which includes query
# And here onwards you can use SQLAlchemy Query interface.
query_db = Data.query.order_by(Data.id.desc()).limit(num_return)
# Each q is a Data object, Data.query returns a bunch of Data
# print each out for debugging.
for q in query_db:
print(q.id)
print(q.notes)
db.session.close()
except:
db.session.rollback()
# after everything, render the result on html page for user consumption
return render_template('results.html',
results=query_db,
num_return=num_return)
# render index page if it is a GET methodd
return render_template('index.html', form1=form1, form2=form2)
def index():
form1 = EnterDBInfo(request.form)
form2 = RetrieveDBInfo(request.form)
if request.method == 'POST' and form1.validate() and twit.verify(
form1.dbNotes.data):
user = twit.clean(form1.dbNotes.data)
data_entered = Data(notes=user)
try:
db.session.add(data_entered)
db.session.commit()
db.session.close()
except:
db.session.rollback()
big5.train_models()
tweets = twit.get_tweets(user)
result = big5.check_personality(tweets)
result['user'] = user
data_json = json.dumps(result)
loaded_data = json.loads(data_json)
return render_template('results.html', notes=loaded_data)
return render_template('index.html', form1=form1, form2=form2)
def index():
form1 = EnterDBInfo(request.form)
form2 = RetrieveDBInfo(request.form)
if request.method == 'POST' and form1.validate():
number = int(form1.dbNotes.data)
parsed = roman_parse(number)
data_entered = Data(arabic=number, roman=parsed)
try:
db.session.add(data_entered)
db.session.commit()
db.session.close()
except:
db.session.rollback()
data = 'Parsed: {} to {} '.format(number, parsed)
return render_template('thanks.html', data=data)
if request.method == 'POST' and form2.validate():
num_return = int(form2.numRetrieve.data)
query_db = Data.query.order_by(Data.id.desc()).limit(num_return)
results = [q for q in query_db] or []
if results is not []:
db.session.close()
else:
db.session.rollback()
return render_template('results.html',
results=results,
num_return=num_return)
return render_template('index.html', form1=form1, form2=form2)
def index(city='SF'):
form1 = EnterDBInfo(request.form, fld2=city)
# Remains empty on first page load
if request.method == 'POST' and form1.validate():
regional_good_venues = pickle.load( open( city+"/regional_good_venues.pickle", "rb" ) )
master_genre_map = pickle.load( open( city+"/master_genre_map.pickle", "rb" ) )
master_genre_idf = pickle.load( open( city+"/master_genre_idf.pickle", "rb" ) )
master_venue_vect = pickle.load( open( city+"/master_venue_vect.pickle", "rb" ) )
master_venue_list = pickle.load( open( city+"/master_venue_list.pickle", "rb" ) )
venue_ids = pickle.load( open( city+"/venue_ids.pickle", "rb" ) )
venue_list = pickle.load( open( city+"/venue_list.pickle", "rb" ) )
locations = pickle.load( open( city+"/locations.pickle", "rb" ) )
k_means = pickle.load( open( city+"/k_means.pickle", "rb" ) )
region_artists = pickle.load( open( city+"/regional_subset.pickle", "rb" ) )
def getEvtVector(artist_names):
ev_vector = np.array([0.] * len(master_genre_idf))
for artist in artist_names:
if artist in region_artists:
ev_vector += region_artists[artist]
return ev_vector
# One pack per artist
raw_string = form1.dbNotes.data
artists = raw_string.split(",")
venue_pack = []
pretty_artist_names = []
for artist in artists: #artists.split(","):
query_params['name'] = artist.lstrip().rstrip()
response = requests.get(endpoint, params=query_params)
full_data = response.json()
if response.json()['response']['status']['message'] != 'Success':
continue
terms = full_data['response']['artist']['terms']
pretty_artist_names.append(full_data['response']['artist']['name'])
genre_vec = [0] * len(master_genre_map)
# Loop over genres, make vector of frequencies
for term in terms:
# Get index of genre in master_genre_map
indx = getIndex(term['name'], master_genre_map)
if indx is None:
continue
# Set corresponding vector entry to value of frequency
genre_vec[indx] = term['frequency']
if norm1(genre_vec) is None:
continue
# Set key to artist name, value is array of (normalized) freqs
scaled_vec = np.array(norm1(genre_vec))
# Apply tf-idf
tfidf = scaled_vec*master_genre_idf
# Last step, normalize vector:
user_artist_vec = tfidf/np.linalg.norm(tfidf)
p_index = k_means.predict(user_artist_vec)
#con = mdb.connect('localhost', 'root', '', 'scenehash');
#cur = con.cursor()
#cur.execute("SELECT artist_id, artist FROM events")
#rows = cur.fetchall()
#for row in rows:
# print row
venues = []
best_score = 1.0
for i in range(len(master_venue_list)):
if k_means.labels_[i] == p_index[0]:
target_venue = dict()
ind = getIndex(master_venue_list[i], venue_list)
evt_details = getArtists(venue_ids[ind] )
if len(evt_details) == 0:
continue
# Find score, check if best
target_venue['score'] = cosim(user_artist_vec, getEvtVector(evt_details[2]))
#if score < best_score:
if np.isnan(target_venue['score']):
#target_venue['score'] = 1.01 #At least scores of 1.00 exist!
continue
target_venue['ven_name'] = master_venue_list[i]
target_venue['lat'] = locations[ind][0]
target_venue['lon'] = locations[ind][1]
target_venue['vid'] = venue_ids[ind]
target_venue['url'] = 'http://eventful.com/'
target_venue['evt_name'] = evt_details[0]
target_venue['evt_date'] = evt_details[1]
venues.append(target_venue)
# Sort by score
sorted_by_score = sorted(venues, key=lambda k: k['score'])
venue_pack.append(sorted_by_score)
if not venue_pack:
return render_template('index.html', form1=form1, city_region=city, message="No artists matched!", coords=json.dumps(venue_pack))
return render_template('index.html', form1=form1, city_region=city, message="",
user_artist_list=json.dumps(pretty_artist_names),
coords=json.dumps(venue_pack))
return render_template('index.html', form1=form1, message="", city_region=city, coords=json.dumps([]))
