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')