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) 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([]))