[SQLAlchemy] ORM filter, filter_by 비교

1. 선요약

### SELECT * FROM users Where users.name = 'Kim';

# filter_by
session.query(Users).filter_by(name='Kim')

# filter
session.query(Users).filter(Users.name == 'Kim')

 

 

2. OR, NOR, Not Equals, Like 같은 복잡한 쿼리를 표현하려면 filter 를 사용해야합니다.

# OR
session.query(Users).filter(or_(Users.name='Kim', Users.email='minjaekim@gmail.com'))

# AND
session.query(Users).filter(and_(Users.name='Kim', Users.email='minjaekim@gmail.com'))

# LIKE
session.query(Users).filter(Users.name.like('%minjae%'))