import util.user
import dataset
import models
from passlib.context import CryptContext
import time
import mailer
import first


def get_id_by_email(email):
    db = dataset.connect('mysql://choozmo:pAssw0rd@db.ptt.cx:3306/AI_anchor?charset=utf8mb4')
    user_dict = next(iter(db.query('SELECT * FROM users where email ="'+email+'"')))
    return user_dict['id']

print(get_id_by_email('ming@choozmo.com'))