def insert_user(username, password):
mp = MysqlOp()
mp.op_sql('INSERT INTO user (username, password) VALUES (%s, %s)',
(username, user.hash_pwd(password)))
return mp.op_sql(
'INSERT INTO user_roles (user_id, role_id) VALUES (%s, %s)',
(mp.cur.lastrowid, 2))
def add_role(name):
mp = MysqlOp()
return mp.op_sql('INSERT INTO role (`name`) VALUES (%s)',
(name)), mp.cur.lastrowid
def update_password_by_username(username: str, password: str):
mp = MysqlOp()
return mp.op_sql('UPDATE user SET password = %s WHERE username = %s',
(user.hash_pwd(password), username))
