def register():
return render_template('register.html')
if request.method == 'POST':
try:
mySQLconnect()
except Exception:
flash('The database is not availible.')
return redirect('/index')
username = request.form['username']
password = request.form['password']
passwordConfirm = request.form['confirmpassword']
email = request.form['email']
phone = request.form['phone']
cursor.execute('SELECT username FROM users WHERE username = %s', (username,))
if len(username) > 20 or len(username) < 6:
flash('Your username must be between 6 and 20 characters')
return redirect('/register')
if cursor.fetchone():
flash('Your username is already taken.')
return redirect('/register')
if password != passwordConfirm:
flash('Your passwords do not match')
return redirect('/register')
if len(password) < 6 or len(password) > 20:
flash('Your password must be between 6 and 20 characters')
return redirect('/register')
if '@' and '.' not in email:
flash('Your email is invalid')
return redirect('/register')
password = bcrypt.encrypt(password)
cursor.execute('INSERT INTO users(username,password,phone,email,confirmed,signup) VALUES(%s,%s,%s,%s,%s,%s)', (username,password,phone,email,'F',date.today()))
db.commit()
flash('Registration Complete.')
return render_template('index.html')
def track():
if request.method == 'POST':
alertPrice = request.form['alertPrice']
email = request.form['email']
phoneNumber = request.form['phone']
currency = 'USD'
try:
mySQLconnect()
cursor.execute('INSERT INTO alerts(asin, currency, alertprice, uid) VALUES(%s,%s,%s,%s)',(ASIN, currency, alertPrice, uid))
db.commit()
mySQLdisconnect()
flash('Your alert has been added')
sendConfirmmessage(phoneNumber, twilioPhoneNumber)
except:
flash('Oops, The database is not availible. Please try again later.')
return redirect('/')
def login():
if request.method == 'POST':
username = request.method['username']
password = request.method['password']
try:
mySQLconnect()
cursor.execute('SELECT password FROM users WHERE username = %s', (username,))
except:
flash('Oops, The database is not availible. Please try again later.')
return redirect('/')
if bcrypt.verify(password):
print('success')
else:
print('wrong passwrd')
mySQLdisconnect()
return redirect('index.html')
return render_template('login.html')
