Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add support for full text search for PostgreSQL #52

Open
Tracked by #116
RobertCraigie opened this issue Aug 26, 2021 · 0 comments
Open
Tracked by #116

Add support for full text search for PostgreSQL #52

RobertCraigie opened this issue Aug 26, 2021 · 0 comments
Labels
kind/feature A request for a new feature. level/advanced priority/high process/candidate Candidate for the next release topic: client Related to the Client API
Projects

Comments

@RobertCraigie
Copy link
Owner

RobertCraigie commented Aug 26, 2021

https://www.prisma.io/docs/concepts/components/prisma-client/full-text-search

Suggested solution

Something like the following, search should be added to StringFilter and must be an instance of String.

Should be noted that I'm not stuck on String being the name.

# NOTE: actual API is still TODO
from prisma.querying import String

await client.post.find_first(
    where={
        'content': {
            'search': String.contains('cat', 'dog'),
        },
    },
)
await client.post.find_first(
    where={
        'content': {
            # for anything we don't explicitly support
            'search': String.raw('fox \| cat'),
        },
    },
)
@RobertCraigie RobertCraigie added the kind/feature A request for a new feature. label Aug 26, 2021
@RobertCraigie RobertCraigie added this to To do in v1.0.0 via automation Feb 1, 2022
@RobertCraigie RobertCraigie added level/advanced priority/medium topic: client Related to the Client API process/candidate Candidate for the next release labels Feb 1, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
kind/feature A request for a new feature. level/advanced priority/high process/candidate Candidate for the next release topic: client Related to the Client API
Projects
v1.0.0
To do
Development

No branches or pull requests

1 participant