def select_admin_by_username(username): mp = MysqlOp() return mp.select_one( "SELECT id, username FROM `user` WHERE username = %s AND id IN " "(SELECT user_roles.user_id FROM user_roles WHERE user_roles.role_id IN " "(SELECT role.id FROM role WHERE role.`name` = 'admin'))", (username))
def select_role_id_by_userid(name): mp = MysqlOp() return mp.select_one('SELECT role.id as id FROM role WHERE `name` = %s', (name, ))
def select_user_by_username(username): mp = MysqlOp() return mp.select_one( 'SELECT id, username, password FROM `user` WHERE username = %s', (username))