r1.2.0_add_user.py 文件源码

def add_default_user(conn):
    username = 'pydbvolve'
    salt = bcrypt.gensalt()
    hashpw = bcrypt.hashpw(salt, salt)
    sql = """
insert into users (id, username, hashpw, salt) values (?, ?, ?, ?);
"""
    values = (1, username, hashpw, salt)
    with conn.cursor() as cur:
        cur.execute(sql, values)
# End add_default_user