sqlalchemy查询MySQL视图_SQLAlchemy ORM的查询Query

Query

查询内容模型对象。指定查找这个模型中所有的对象。

模型中的属性。可以指定只查找某个模型的其中几个属性。user = session.query(User).first()

username = session.query(User.username).first()

常用的filter操作符equals：user = session.query(User).filter(User.name == "sunxiaoning").first()

not equals:query.filter(User.username != 'sunxiaoning').all()

like：query.filter(User.username.like('%ning%'))

in：query.filter(User.username.in_(['sun','xiao','ning']))

query.filter(User.username.in_(

session.query(User.username).filter(User.username.like('%sun%'))

))

not in：query.filter(~User.username.in_(['sun','xiao','ning']))

is null：query.filter(User.username==None)

# OR

query.filter(User.username.is_(None))

is not null:query.filter(User.username