I am testing Python ORM where clause matching two column name, with single column matching works.
with two column matching its giving the error message.
row = session.execute(select(User).where(User.name == "squidward") and User.fullname='Squidward Tentacles')
How to match two column in SQLAlchemy
ORM?
Thanks
>Solution :
Use the and_
element to combine expressions in a clause.
import sqlalchemy as sa
row = session.execute(select(User).where(
sa.and_(
User.name == "squidward",
User.fullname == 'Squidward Tentacles'
)
)