Safe Haskell | Safe-Inferred |
---|---|
Language | Haskell2010 |
Synopsis
- (@@.) :: SqlExpr (Value TsVector) -> SqlExpr (Value (TsQuery Lexemes)) -> SqlExpr (Value Bool)
- prefixAndQuery :: NonEmpty (TsQuery Words) -> SqlExpr (Value (TsQuery Lexemes))
- prefixOrQuery :: NonEmpty (TsQuery Words) -> SqlExpr (Value (TsQuery Lexemes))
- prefixAndQueryLang :: RegConfig -> NonEmpty (TsQuery Words) -> SqlExpr (Value (TsQuery Lexemes))
- prefixOrQueryLang :: RegConfig -> NonEmpty (TsQuery Words) -> SqlExpr (Value (TsQuery Lexemes))
- toSearchTerm :: Text -> Maybe (NonEmpty (TsQuery Words))
- toSearchTermWeighted :: [Weight] -> Text -> Maybe (NonEmpty (TsQuery Words))
- andWords :: NonEmpty (TsQuery Words) -> TsQuery Words
- orWords :: NonEmpty (TsQuery Words) -> TsQuery Words
- to_tsvector :: IsString a => SqlExpr (Value RegConfig) -> SqlExpr (Value a) -> SqlExpr (Value TsVector)
- to_tsquery :: SqlExpr (Value RegConfig) -> SqlExpr (Value (TsQuery Words)) -> SqlExpr (Value (TsQuery Lexemes))
- to_tsquery_en :: SqlExpr (Value (TsQuery Words)) -> SqlExpr (Value (TsQuery Lexemes))
- plainto_tsquery :: SqlExpr (Value RegConfig) -> SqlExpr (Value Text) -> SqlExpr (Value (TsQuery Lexemes))
- ts_rank :: SqlExpr (Value Weights) -> SqlExpr (Value TsVector) -> SqlExpr (Value (TsQuery Lexemes)) -> SqlExpr (Value [NormalizationOption]) -> SqlExpr (Value Double)
- ts_rank_cd :: SqlExpr (Value Weights) -> SqlExpr (Value TsVector) -> SqlExpr (Value (TsQuery Lexemes)) -> SqlExpr (Value [NormalizationOption]) -> SqlExpr (Value Double)
- setweight :: SqlExpr (Value TsVector) -> SqlExpr (Value Weight) -> SqlExpr (Value TsVector)
- tsquery_or :: SqlExpr (Value (TsQuery Lexemes)) -> SqlExpr (Value (TsQuery Lexemes)) -> SqlExpr (Value (TsQuery Lexemes))
- tsquery_and :: SqlExpr (Value (TsQuery Lexemes)) -> SqlExpr (Value (TsQuery Lexemes)) -> SqlExpr (Value (TsQuery Lexemes))
Documentation
:: SqlExpr (Value TsVector) | the document to search in |
-> SqlExpr (Value (TsQuery Lexemes)) | the query made by |
-> SqlExpr (Value Bool) |
Apply some query to a tsvector document for example:
searchCompany :: SqlExpr (Entity CompanySearchIndex) -> NonEmpty (TsQuery Words) -> SqlQuery () searchCompany company term = do let query = prefixAndQuery term norm = val [] where_ $ (company ^. CompanySearchIndexDocument) @@. query
prefixAndQuery :: NonEmpty (TsQuery Words) -> SqlExpr (Value (TsQuery Lexemes)) Source #
Deprecated: these functions are simple wrappers for to_tsquery
, use that directly instead
format the query into lexemes
the result can be used in @@.
for example:
searchCompany :: SqlExpr (Entity CompanySearchIndex) -> (NonEmpty (TsQuery Words)) -> SqlQuery () searchCompany company term = do let query = prefixAndQuery term norm = val [] where_ $ (company ^. CompanySearchIndexDocument) @@. query
this uses && to combine queries
prefixOrQuery :: NonEmpty (TsQuery Words) -> SqlExpr (Value (TsQuery Lexemes)) Source #
Deprecated: these functions are simple wrappers for to_tsquery
, use that directly instead
prefixAndQueryLang :: RegConfig -> NonEmpty (TsQuery Words) -> SqlExpr (Value (TsQuery Lexemes)) Source #
Deprecated: these functions are simple wrappers for to_tsquery
, use that directly instead
specify a language to be used with the query.
prefixOrQueryLang :: RegConfig -> NonEmpty (TsQuery Words) -> SqlExpr (Value (TsQuery Lexemes)) Source #
Deprecated: these functions are simple wrappers for to_tsquery
, use that directly instead
same as prefixAndQueryLang
but uses || to combine quereis
toSearchTerm :: Text -> Maybe (NonEmpty (TsQuery Words)) Source #
Constructs a valid search query, removes a bunch of illegal characters and splits the terms for better results. Also checks if there is anything in the search term.
using a search term is optional, but it's probably what you want. all underlying primitives are exposed.
toSearchTermWeighted :: [Weight] -> Text -> Maybe (NonEmpty (TsQuery Words)) Source #
create a search term with some weight, this allows for restricting on specific weighs. see: https://www.postgresql.org/docs/current/textsearch-controls.html#TEXTSEARCH-PARSING-QUERIES use the semigroup instance on search term to combine searchterms.
andWords :: NonEmpty (TsQuery Words) -> TsQuery Words Source #
same as prefixAndQuery
without wrapping to_tsquery
.
orWords :: NonEmpty (TsQuery Words) -> TsQuery Words Source #
same as prefixOrQuery
without wrapping to_tsquery
.
to_tsvector :: IsString a => SqlExpr (Value RegConfig) -> SqlExpr (Value a) -> SqlExpr (Value TsVector) Source #
to_tsquery :: SqlExpr (Value RegConfig) -> SqlExpr (Value (TsQuery Words)) -> SqlExpr (Value (TsQuery Lexemes)) Source #
constructs a lexeme query out of a word algebra english is the internal model used by postgres.
searchCompany :: SqlExpr (Entity CompanySearchIndex) -> Text -> SqlQuery () searchCompany company term = do let query = to_tsquery (val "english") $ val $ andWords $ prefixAndQuery term where_ $ (company ^. CompanySearchIndexDocument) @@. query
to_tsquery_en :: SqlExpr (Value (TsQuery Words)) -> SqlExpr (Value (TsQuery Lexemes)) Source #
to_tsquery
defaulted to english
searchCompany :: SqlExpr (Entity CompanySearchIndex) -> Text -> SqlQuery () searchCompany company term = do let query = to_tsquery_en $ val $ andWords $ prefixAndQuery term where_ $ (company ^. CompanySearchIndexDocument) @@. query
plainto_tsquery :: SqlExpr (Value RegConfig) -> SqlExpr (Value Text) -> SqlExpr (Value (TsQuery Lexemes)) Source #
:: SqlExpr (Value Weights) | relative weighting of a b c and d, see |
-> SqlExpr (Value TsVector) | the document to search in |
-> SqlExpr (Value (TsQuery Lexemes)) | the query made by |
-> SqlExpr (Value [NormalizationOption]) | normalization option to indicate how to deal with document length |
-> SqlExpr (Value Double) |
Organize search result by weights. This allows you to put better matching results higher. for example:
searchCompany :: SqlExpr (Entity CompanySearchIndex) -> NonEmpty (TsQuery Words) -> SqlQuery () searchCompany company term = do let query = prefixAndQuery term norm = val [] where_ $ (company ^. CompanySearchIndexDocument) @@. query orderBy [desc (ts_rank (val defaultWeights) (company ^. CompanySearchIndexDocument) query norm)]
ts_rank_cd :: SqlExpr (Value Weights) -> SqlExpr (Value TsVector) -> SqlExpr (Value (TsQuery Lexemes)) -> SqlExpr (Value [NormalizationOption]) -> SqlExpr (Value Double) Source #
setweight :: SqlExpr (Value TsVector) -> SqlExpr (Value Weight) -> SqlExpr (Value TsVector) Source #