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)
