CODEWITHSUNDEEP
sqlalchemy
draxous
draxous

Reputation: 59

Flask/SQLAlchemy - WHERE NOT EXISTS

How could I translate this:

SELECT id, 
FROM user
WHERE NOT EXISTS (SELECT * 
                  FROM user_agency_assoc 
                  WHERE user.ID = user_agency_assoc.user_id)
AND user.invited_by IS NOT NULL

as an SQLAlchemy ORM query?

Upvotes: 0

Views: 2725

Answers (1)

adarsh
adarsh

Reputation: 6978

You could do something like this,

db.session.query(user.id)
.filter(
    ~user_agency_assoc.query
    .filter(user.id == user_agency_assoc.user_id)
    .exists()
)

assuming your corresponding model names are user and user_agency_assoc

Upvotes: 1

Related Questions