import hashlib
import pymysql


def signup(user_id, password):
    user_id_bytes = user_id.encode('utf-8')
    password_bytes = password.encode('utf-8')

    user_id_salt = hashlib.md5(user_id_bytes).hexdigest()
    user_id_salt_bytes = user_id_salt.encode('utf-8')

    digest = hashlib.pbkdf2_hmac('sha256', password_bytes, user_id_bytes, 1)

    db = pymysql.connect(host = "localhost", user="root", password = "tjddnjs2011")
    cursor = db.cursor()
    cursor.execute("USE interview_salt_project")
    cursor.execute("""CREATE TABLE if not exists user(
    id INT NOT NULL AUTO_INCREMENT,
    user_id VARCHAR(20) NOT NULL,
    password VARCHAR(20) NOT NULL,
    user_id_salt LONGTEXT NOT NULL,
    digest LONGTEXT NOT NULL,
    PRIMARY KEY(id));
    """)

    sql = "INSERT INTO user (user_id, password, user_id_salt, digest) VALUES(%s, %s, %s, %s);"
    val = (user_id, password, str(user_id_salt), str(digest))
    cursor.execute(sql,val)
    db.commit()
    db.close()


def login(user_id, password):
    pass

signup('1', '양념감자1')