def validate_email(self, email): conn = sql.connect('matcha\\users.db') cur = conn.cursor() cur.execute("SELECT * FROM users WHERE email=:email", {'email': email.data}) user_data = cur.fetchone() conn.close() if user_data: raise ValidationError( 'That email is taken. Please choose a different one.')
def validate_username(self, username): conn = sql.connect('matcha\\users.db') cur = conn.cursor() cur.execute("SELECT * FROM users WHERE username=:username", {'username': username.data}) user_data = cur.fetchone() conn.close() if user_data: raise ValidationError( 'That username is taken. Please choose a different one.')
def validate_email(self, email): conn = sql.connect('matcha\\users.db') cur = conn.cursor() cur.execute("SELECT * FROM users WHERE email=:email", {'email': email.data}) user_data = cur.fetchone() conn.close() if user_data is None: raise ValidationError( 'No account with that email. Please check email again or register.' )
def load_user(id): conn = sql.connect('matcha\\users.db') cur = conn.cursor() cur.execute("SELECT * from users where email = (?)", [id]) userrow = cur.fetchone() # print ('id ', id) # print ('fetchone ', userrow) # userid = userrow[0] # or whatever the index position is user = User(userrow[0], userrow[1], userrow[2], userrow[3], userrow[4], userrow[5], userrow[6], userrow[7], userrow[8], userrow[9], userrow[10], userrow[11], userrow[12], userrow[13], userrow[14], userrow[15], userrow[16], userrow[17], userrow[18], userrow[19], userrow[20], userrow[21], userrow[22], userrow[23], userrow[24]) # print('return id', user) return (user)