Case Insensitive Flask-SQLAlchemy Query

I'm using Flask-SQLAlchemy to query from a database of users; however, while

    user = models.User.query.filter_by(username="ganye").first()

will return

    <User u'ganye'>

doing

    user = models.User.query.filter_by(username="GANYE").first()

returns

    None

I'm wondering if there's a way to query the database in a case insensitive way, so that the second example will still return

    <User u'ganye'>

You can do it by using either the lower or upper functions in your filter:

    from sqlalchemy import func
    user = models.User.query.filter(func.lower(User.username) == func.lower("GaNyE")).first()

Another option is to do searching using ilike instead of like:

    .query.filter(Model.column.ilike("ganye"))

From: stackoverflow.com/q/16573095

Back to homepage or read more recommendations: