tortoise/tortoise-orm

Feature request: filter like and ilike

Open

#421 geöffnet am 29. Mai 2020

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

Repository-Metriken

Stars
 (3.863 Stars)
PR-Merge-Metriken
 (Durchschn. Merge 15T 7h) (9 gemergte PRs in 30 T)

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