Python Flask SQLAlchemy Pagination with Search LIKE, Equals, IN, AND and OR - Datatable
Source Code : https://tutorial101.blogspot.com/2020/03/python-flask-sqlalchemy-search-like.html
Python Flask SQLAlchemy Pagination with Search LIKE, Equals, IN, AND and OR - Datatable
LIKE: query.filter(User.name.like('%ednalan%'))
equals: query.filter(User.name == 'ednalan')
IN: query.filter(User.name.in_(['rai', 'kenshin', 'Ednalan']))
AND: query.filter(User.name == 'ednalan', User.fullname == 'clyde ednalan')
OR: from sqlalchemy import or_
filter(or_(User.name == 'ednalan', User.name == 'caite'))
Python Flask tutorial Playlist : https://www.youtube.com/watch?v=zYhpx63SPKY&list=PL193izPqf5X6xTHwcfREyggNMBAXOCT8k
For more programming tutorial : https://tutorial101.blogspot.com/
