trigram

Documentation

Index

• func Migrations(rollback bool) []*migrate.Migration
• func Search(ctx context.Context, qx sqlx.QueryerContext, q persistence.SearchQuery) (persistence.SearchQueryResult, error)
• func SessionParams() map[string]any

Functions

func Migrations

func Migrations(rollback bool) []*migrate.Migration

Migrations returns migrations to be applied on top of the "common" migrations for the "trigram" search module to work, the "trigram" module migration IDs range is [2000-2999]

func Search

func Search(ctx context.Context, qx sqlx.QueryerContext, q persistence.SearchQuery) (persistence.SearchQueryResult, error)

Search is an implementation of the postgres.SearchFn function based on the "pg_trgm" postgres extension. Queries are just text, no expressions are supported for now, the whole segment of text is matched against the whole query text using `trigram word similarity`, see https://www.postgresql.org/docs/current/pgtrgm.html.

func SessionParams

func SessionParams() map[string]any

SessionParams returns a map of k:v pairs, which represent DB settings to be applied as soon as the DB session is started. This may be needed to tweak parameters of the DB extension, since some controlled DB envs (e.g. RDS) do not always allow to modify system or DB settings on a permanent basis (i.e. ALTER SYSTEM/DATABASE SET..).