Sqlalchemy Fuzzystrmatch with Postgres extension

Question

I am using the Postgres extension fuzzystrmatch. I want to replicate this (query) to the sqlalchemy ORM.

Example

SELECT * FROM mymodel WHERE soundex(denomination, 'PHONE') > 0.4;

That the match limit can be changed.

In sqlalchemy I am doing like this, but it does not work:

MyModel.query.filter(func.soundex(MyModel.denomination) == func.soundex('PHONE') > 0.4).all()

Any ideas?

Andronicus · Accepted Answer · 2020-01-06 19:18:39Z

1

You can execute it as a raw sql:

with engine.connect() as con:
    rs = con.execute("""SELECT * FROM mymodel WHERE SIMILARITY(denomination, 'PHONE') > 0.4""")

answered Jan 6, 2020 at 19:18

Andronicus

26.2k18 gold badges55 silver badges92 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Bennison J Over a year ago

Additionally, I need to add one more point to this answer, need to create the following extension first to work this these similarity queries. CREATE EXTENSION IF NOT EXISTS pg_trgm;

Collectives™ on Stack Overflow

Sqlalchemy Fuzzystrmatch with Postgres extension

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related