Skip to content

Instantly share code, notes, and snippets.

@ncrmro
Last active March 21, 2019 11:49
Show Gist options
  • Save ncrmro/ceb9f54f8ee3a6098f93200bdf028643 to your computer and use it in GitHub Desktop.
Save ncrmro/ceb9f54f8ee3a6098f93200bdf028643 to your computer and use it in GitHub Desktop.
from django.contrib.postgres.search import TrigramSimilarity
from parts.models import Part
def trigram_similarity_search(similarity=0.3, search_string=""):
parts = Part.objects
parts = parts.annotate(similarity=TrigramSimilarity('name', search_string))
parts = parts.filter(similarity__gt=similarity).order_by('-similarity')
return parts
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment