Case insensetive distinct query in Flask sqlalchemy

Question

I'm using a query where I'm performing a distinct query on 4 columns of a table but I want to make the distinct ignore casing and remove duplicates with the same name

The query is like

PublicationFont.query.filter((PublicationFont.publication_id == id) | (PublicationFont.is_public == include_public)).distinct(PublicationFont.font_name,PublicationFont.font_family,PublicationFont.font_style,PublicationFont.font_weight).order_by(PublicationFont.font_name.asc(),PublicationFont.font_weight.desc())

I want to ignore the casing in the PublicationFont.font_name

Possible duplicate: https://stackoverflow.com/questions/16573095/case-insensitive-flask-sqlalchemy-query — Alex, Dec 01 '21 at 07:55
In that query they are lowering the value but how do I lower it inside a distinct query? — Rohan Keskar18, Dec 01 '21 at 07:56

jorzel · Answer 1 · 2021-12-01T19:58:58.657

This advice of https://stackoverflow.com/users/8368630/alex should work: Case Insensitive Flask-SQLAlchemy Query. You probably get what you want when do it like that:

PublicationFont.query.filter(
    (PublicationFont.publication_id == id) | 
    (PublicationFont.is_public == include_public)
).distinct(
    func.lower(PublicationFont.font_name),
    PublicationFont.font_family,
    PublicationFont.font_style,
    PublicationFont.font_weight
).order_by(
    PublicationFont.font_name.asc(),
    PublicationFont.font_weight.desc()
)

Case insensetive distinct query in Flask sqlalchemy

1 Answers1