import re

from django.contrib.postgres.search import SearchQuery, SearchRank
from django.db.models import Count, F

from people.models import Person


def search_person_by_name(name, synonym=True):
    name = name.lower()
    name = re.sub(r"[^a-z ]", "", name)
    name = " ".join(name.strip().split())
    and_name = " & ".join(name.split(" "))
    or_name = " | ".join(name.split(" "))
    name = f"({and_name}) | ({or_name})"
    query = SearchQuery(name, search_type="raw", config="english")

    search_args = {}
    if synonym:
        search_args["name_search_vector__synonym"] = query
    else:
        search_args["name_search_vector"] = query

    qs = (
        Person.objects.annotate(membership_count=Count("memberships"))
        .filter(**search_args)
        .annotate(rank=SearchRank(F("name_search_vector"), query))
        .order_by("-rank", "membership_count")
        .defer("biography", "versions")
    )

    return qs

import re

from django.contrib.postgres.search import SearchQuery, SearchRank
from django.db.models import Count, F

from people.models import Person


def search_person_by_name(name, synonym=True):
    name = name.lower()
    name = re.sub(r"[^a-z ]", " ", name)
    name = " ".join(name.strip().split())
    and_name = " & ".join(name.split(" "))
    or_name = " | ".join(name.split(" "))
    name = f"({and_name}) | ({or_name})"
    query = SearchQuery(name, search_type="raw", config="english")

    search_args = {}
    if synonym:
        search_args["name_search_vector__synonym"] = query
    else:
        search_args["name_search_vector"] = query

    qs = (
        Person.objects.annotate(membership_count=Count("memberships"))
        .filter(**search_args)
        .annotate(rank=SearchRank(F("name_search_vector"), query))
        .order_by("-rank", "membership_count")
        .defer("biography", "versions")
    )

    return qs

Make sure we can search names with '
Make sure we can search names with '
