SQLAlchemy教程（三）复杂查询

这章节要操作的数据 

 多条件查询，可以在表达式中各种and，ro方式进行查询

from sqlalchemy.orm import sessionmaker
from sqlalchemy import create_engine
from sqlalchemy.sql import text
from s1 import models

engine = create_engine('sqlite:///test.db')
Session = sessionmaker(bind=engine)
session = Session()

row1 = session.query(models.Users).filter(text("nid>:value or age>:age")).params(value=9,age=30).all()
row_list = [row.name for row in row1]
print(row_list)

try:
    session.commit()
except Exception as e:
    print(e)

session.close()

#结果
['警皇', '猪皇', '沙加特', '春丽', '桑切尔夫', '隆', '肯', '豪鬼', '骨裂']

between函数，查询某一列和某一列之间的数据

from sqlalchemy.orm import sessionmaker
from sqlalchemy import create_engine
from sqlalchemy.sql import text
from s1 import models

engine = create_engine('sqlite:///test.db')
Session = sessionmaker(bind=engine)
session = Session()

row1 = session.query(models.Users).filter(models.Users.name.between('春丽','骨裂')).all()
row_list = [row.name for row in row1]
print(row_list)
try:
    session.commit()
except Exception as e:
    print(e)

session.close()

#结果
['春丽', '桑切尔夫', '沙加特', '猪皇', '肯', '警皇', '豪鬼', '阿比盖尔', '隆', '骨裂']

查询包含与不包含