tortoise/tortoise-orm

Feature request: filter like and ilike

Offen

#421 geöffnet am 29.05.2020

 (9 Kommentare) (0 Reaktionen) (1 zugewiesene Person)Python (333 Forks)batch import
enhancementgood first issue

Repository-Metriken

Stars
 (3.863 Sterne)
PR-Merge-Metriken
 (PR-Metriken ausstehend)

Beschreibung

Example of usage:

users = await User.filter(first_name__ilike="c%r")

I know this can be done with startswith and endswith, but there are cases where using the LIKE operator is better:

users = await User.filter(first_name__ilike="j_r%")

This would be used to match Jeremy, Jorge, Jordan...

Contributor Guide