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)