Python MysqlOp.select_one示例

示例#1

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))

示例#2

def select_role_id_by_userid(name):
    mp = MysqlOp()
    return mp.select_one('SELECT role.id as id FROM role WHERE `name` = %s',
                         (name, ))

示例#3

def select_user_by_username(username):
    mp = MysqlOp()
    return mp.select_one(
        'SELECT id, username, password FROM `user` WHERE username = %s',
        (username))