原始查询:
db_session.query(Notice).filter(Notice.subject.like("%" +query+ "%"))
我想做这样的查询:
col_name='subject'db_session.query(Notice).filter(Notice.col_name.like("%" +query+ "%"))col_name='status'status=0db_session.query(Notice).filter(Notice.col_name != 1)
col_name = 'subject'db_session.query(Notice).filter(getattr(Notice,col_name).like("%" + query + "%"))