def login(): return render_template('formulario.html') users = dbHandler.retrieveUsers() if request.method == 'POST': if users not in dbHandler.retrieveUsers(): message = 'not sure quite...you talking about' return flash(message) else: return render_template('index')
def login(): # Output message if something goes wrong msg = '' # Check if <username> and <password> POST requests exist (user submitted form) if request.method == 'POST' and 'username' in request.form and 'password' in request.form: # Create variables for easy access username = request.form['username'] password = request.form['password'] # Check if account exists using MySQL account = dbHandler.retrieveUsers(username, password) # If account exists in accounts table in out database if account: # Create session data, we can access this data in other routes session['loggedin'] = True session['id'] = account[0] # account id session['username'] = account[1] # account username session['fullname'] = account[3] # account user's fullname session['email'] = account[4] # account email session['school'] = account[5] # account school session['major'] = account[6] # account major # Redirect to home page return redirect(url_for('home')) else: # Account doesnt exist or username/password incorrect msg = 'Incorrect username/password!' # Show the login form with message (if any) return render_template('index.html', msg=msg)
def addUser(): error = None if request.method=='POST': username = request.form['username'] password = request.form['password'] thisuser = request.form['username'] users = dbHandler.retrieveUsers() x = (request.form['username'], request.form['password']) print users print x if x in users: print "error" error = 'Username already exists. Please try again.' return render_template('addUser.html', error=error) else: dbHandler.addUser(username, password) session['logged_in'] = True session['currentuser'] = thisuser g.user = username return redirect(url_for('home')) else: return render_template('addUser.html',error=error)
def home(): users = "None" if 'user' in session: #return session['user'] return redirect(url_for('admin')) if request.method == 'POST': session.pop('user', None) username = request.form['username'] password = request.form['password'] #dbHandler.insertUser(username, password) users = dbHandler.retrieveUsers(username, password, 0) error = "Invalid Credentials." if username == "" or password == "": error = "Enter Full Credentials" if users == 'True': session['user'] = username return redirect(url_for('admin')) #return render_template('upload.html', users=username) return render_template('login.html', error=error) return render_template('login.html')
def load_user(userid): users = db.retrieveUsers() users_with_id = filter(lambda x: x[0] == int(userid), users) if users_with_id: user = users_with_id[0] return User(user[0], user[1], user[3], user[4], user[5]) else: return None
def user_loader(username): users = dbHandler.retrieveUsers(username) if username != users: return None user = User() user.id = username return user
def home(): if request.method == 'POST': username = request.form['username'] password = request.form['password'] dbHandler.insertUser(username, password) users = dbHandler.retrieveUsers() return render_template('index.html', users=users) else: return render_template('index.html')
def login(): users=dbHandler.retrieveUsers() auth=request.authorization for i in range(0,len(users)): if auth.username==users[i][0] and auth.password ==users[i][1]: token=jwt.encode({'user':auth.username,'exp':datetime.datetime.utcnow()+datetime.timedelta(seconds=10)},app.config['SECRET_KEY']) return jsonify({'token':token.decode('UTF-8')}) return make_response("could not verify",401,{'WWW-Authenticate':'Basic realm="login required"'})
def home(): if request.method=='POST': username = request.form['username'] password = request.form['password'] dbHandler.insertUser(username, password) users = dbHandler.retrieveUsers() return render_template('index.html', users=users) else: return render_template('index.html')
def request_loader(request): username = request.form.get('username') users = dbHandler.retrieveUsers(username) if username != users: return None user = User() user.id = username return user
def index_page(): username = "" if session.get('logged_in') == True: username = session['username'] if request.method == 'POST': password = request.form['password'] dbHandler.addUser(username, password) user = dbHandler.retrieveUsers() return render_template('index.html', username=username) else: return render_template('index.html')
def kate_page(): if request.method == 'POST': username = request.form['username'] password = request.form['password'] dbHandler.insertUser(username, password) users = dbHandler.retrieveUsers() # conn.row_factory = sql.Row conn = psycopg2.connect(DATABASE_URL, sslmode='require') cur = conn.cursor() cur.execute("SELECT * FROM seating") people = cur.fetchall() # [(id, name, table_no)] cur.execute("SELECT name, relationship FROM people_attr") res = cur.fetchall() # scoring ... pref = {} for name, rel in res: rel = rel.lower() rels = pref.get(rel, []) rels.append(name) pref[rel] = rels pref['weight'] = { 'friend' : 2, 'acquaintance' : 1, 'empty' : 0, 'stranger' : -1, 'enemy' : -2 } table={} for (pid, name, table_no) in people: t = table.get(table_no, {'person':[]}) t['person'].append(name) table[table_no] = t rank = sort_table(pref, table) #print(rank) table_map = {} for p in people: cur.execute("SELECT relationship, class_year, major, misc FROM people_attr WHERE name LIKE '%{}%'".format(p[1])) people_list = table_map.get(p[2], []) people_list.append((p[1], cur.fetchone())) table_map[p[2]] = people_list cur.close() conn.close() print(table_map) # reorder table_map ... table_map = [ (tno,table_map[tno]) for (score,tno) in rank] empty_tables = [i for i in range(1, 10) if i not in list(zip(*table_map))[0]] return render_template("list_tables.html", all_tables=table_map, empty_tables=empty_tables)
def registro(): return render_template('registrar.html') if request.method == 'POST': username = request.form['username'] password = request.form['password'] email = request.form['email'] dbHandler.insertUser(username, password, email) users = dbHandler.retrieveUsers() return render_template('index.html', users=users) else: return render_template('registrar.html')
def login(): error = None if request.method == 'POST': users = dbHandler.retrieveUsers() x = (request.form['username'], request.form['password']) if x not in users: error = 'Invalid Credentials. Please try again.' else: session['logged_in'] = True flash('You have logged in.') return redirect(url_for('home')) return render_template('login.html', error=error)
def home(): if request.method == 'POST': username = request.form['username'] password = request.form['password'] if (dbHandler.checkUser(username, password)): session['username'] = username return redirect(url_for('dash')) #dbHandler.insertUser(session['username'], password) users = dbHandler.retrieveUsers() return render_template('index.html', users=users) else: return render_template('index.html')
def signup(): if request.method == 'POST': username = request.form['username'] password = getHash(request.form['password']) checkUsername = dbHandler.checkUsername(username) print(len(dbHandler.checkUsername(username))) if (len(checkUsername) != 0): print("Error") return render_template('login.html', checkUsername=checkUsername) else: dbHandler.insertUser(username, password) users = dbHandler.retrieveUsers(username, password) return render_template('login.html', users=users)
def login(): if request.method == 'POST': username = request.form['username'] password = getHash(request.form['password']) rows = dbHandler.retrieveUsers(username, password) if len(rows) == 1: session['authenticated'] = 'yes' response = redirect('/map', code=302) return (response) else: response = redirect('/error', code=302) return (response) else: return render_template('login.html')
def login(): error = None if request.method == 'POST': try: if str(dbhandler.retrieveUsers(request.form['username'])[0][0]) == request.form['password']: session['logged_in'] = True flash('Login successful.') return render_template('welcome.html') else: error = 'Invalid Credentials. Please try again.' except IndexError: error = 'User does not exists please register first' return render_template('login.html', error=error) return render_template('login.html', error=error)
def login(): form = UserLoginForm(request.form) if request.method == "POST" and form.validate(): st_id = form.st_id.data hashed = dbHandler.retrieveUsers(str(st_id)) m = str(form.password.data) opassword = hashlib.md5(m.encode()) hpassword = opassword.hexdigest() if str(hpassword) == str(hashed): session['logged_in'] = True return redirect(url_for('home')) else: return ('error in matching the password') else: return render_template("login.html", form=form)
def login2(): form = LoginForm() if form.validate_on_submit(): flash('Login requested for user {}, remember_me={}'.format( form.username.data, form.password.data)) global new1 new1 = print(form.username.data) global new2 new2 = print(form.password.data) dbHandler.insertUser(form.username, form.password) global users users = dbHandler.retrieveUsers() return redirect('/SearchProduct.html/') return render_template('login.html', title='login', form=form)
def register_band(): form = BandRegistrationForm(request.form) if request.method == "POST" and form.validate(): st_id = form.st_id.data band_id = form.band_id.data f_id = form.f_id.data param = form.param.data hashed = dbHandler.retrieveUsers(str(st_id)) m = str(form.password.data) opassword = hashlib.md5(m.encode()) hpassword = opassword.hexdigest() if str(hpassword) == str(hashed): dbHandler.insertBand(st_id, band_id, f_id, param) patch_pi(st_id, band_id, f_id, param) return redirect(url_for('login')) return render_template("assign.html", form=form)
def get_valid_user(username, password): users = db.retrieveUsers() user_id = -1 station_id = -1 for user in users: if user[1] == username: password_hash = user[2] if pwd_context.verify(password, password_hash): user_id = user[0] station_id = user[3] vote_url = user[4] public_key = user[5] return (user_id, station_id, vote_url, public_key) break #TODO: Error if there is no user matching return None
def login(): if request.method=='POST': username = request.form['username'] password = request.form['password'] users = dbHandler.retrieveUsers() for tup in users: if((list(tup)[0]).lower()==username.lower()): if (check_password_hash(list(tup)[1],password )): session['username']=username return redirect("/GT") else: flash('Error: Invalid Username and Password. Try Again...') return render_template('login.html') flash('Error: Invalid Username and Password. Try Again...') return render_template('login.html') else: return render_template('login.html')
def login(): if request.method == 'POST': username = request.form['username'] password = request.form['password'] user = dbHandler.retrieveUsers() udic = dict(user) print udic if username not in udic.keys(): flash('user not found!') elif password == udic[username]: session['logged_in'] = True session['username'] = username else: flash('wrong password!') return home() else: return render_template('login.html')
def home(): if request.method == 'POST': username = request.form['username'] email = request.form['email'] twitter = request.form['twitter'] if 'photo' in request.files: photo = request.files['photo'] if photo.filename != '': photo.save( os.path.join(r'C:\PYCHARM\Project\skpro\New folder', photo.filename)) file = photo.filename dbHandler.insertUser(username, email, file, twitter) users = dbHandler.retrieveUsers() return render_template('fileform2.html', users=users) else: return render_template('fileform2.html')
def login(): session['data'] = dict(login='******') if request.method == 'POST': username = request.form['username'] password = request.form['password'] user = dbHandler.retrieveUsers(username) if user: if password == user[0][1]: email = user[0][2] md5_hash_temp_code = generate_and_send_temp_code( username, email) dbHandler.insert_temp_code(username, md5_hash_temp_code) session['data'] = dict(username=username, login='******') return redirect(url_for('check_code')) else: return render_template('index.html', Passwordfalse=True) else: return render_template('index.html', loggedfalse=True) else: return render_template('index.html')
def register(): # Output message if something goes wrong msg = '' # Check if <username>, <password> and <email> POST requests exist (user submitted form) if request.method == 'POST' and 'username' in request.form and 'password' in request.form and 'email' in request.form and 'fullname' in request.form: # Create variables for easy access username = request.form['username'] password = request.form['password'] fullname = request.form['fullname'] email = request.form['email'] # Check if account exists account = dbHandler.retrieveUsers(username, password) # If account exists show error and validation checks if account: msg = 'Account already exists!' elif not re.match(r'[^@]+@[^@]+\.[^@]+', email): msg = 'Invalid email address!' elif not re.match(r'[A-Za-z0-9]+', username): msg = 'Username must contain only characters and numbers!' elif len(password) < 8: msg = 'Password must be at least 8 letters.' elif re.search('[0-9]', password) is None: msg = 'Password must contain a number.' elif re.search('[A-Z]', password) is None: msg = 'Password must contain at least one capital letter.' elif re.search('[_@$]', password) is None: msg = 'Password must contain special characters _@$.' elif not username or not password or not email: msg = 'Please fill out the form!' else: # Account doesnt exists and the form data is valid, now insert new account into accounts table dbHandler.insertUser(username, password, fullname, email) msg = 'You have successfully registered!' elif request.method == 'POST': # Form is empty...(no POST data) msg = 'Please fill out the form!' # Show registration form with message (if any) return render_template('register.html', msg=msg)
def addUser(): error = None if request.method == 'POST': username = request.form['username'] password = request.form['password'] users = dbHandler.retrieveUsers() x = request.form['username'] print x for y in users: if x in y[0]: error = 'Username already exists. Please try again.' return render_template('addUser.html', error=error) else: dbHandler.addUser(username, password) session['logged_in'] = True return redirect(url_for('home')) else: return render_template('addUser.html', error=error)
def shuttle(): if request.method == 'GET': return render_template('index.html') else: email = request.form['email'] shuttletime = request.form['shuttletime'] dbHandler.insertUser(email, shuttletime) id = dbHandler.retrieveID() for row in id: s = row #not fully functional count = dbHandler.countFunction() for row in count: if row[1] == shuttletime: if row[0] < 21: return render_template('confirmed.html') else: return render_template('waitlisted.html', id=s) users = dbHandler.retrieveUsers() return render_template('index.html', users=users)