FASTapi sqlalchemy 的一些写法

1. join

db.query(YourModelA).join(YourModelA)...

2. and、or

from sqlalchemy import and_, or_

db.query(YourModel).filter(and_(condition1,condition1...))...

3. offset、limit

db.query(YourModel).filter(...).offset(1).limit(1).all()

4. is null 、is not null

db.query(YourModel).filter(model.column.is_(None))...
db.query(YourModel).filter(model.column.isnot(None))...

5. in 、not in

db.query(YourModel).filter(model.column.in_([1,2,3]))...
db.query(YourModel).filter(model.column.notin_([1,2,3]))...

6. between

from sqlalchemy import between

db.query(YourModel).filter(model.column.between(1,100))...

7. 函数

from sqlalchemy import func

db.query(func.max(model.column)).one()

其他函数