IHP.QueryBuilder.HasqlCompiler

Description

This module compiles QueryBuilder queries to Hasql's Snippet type for execution with prepared statements.

Synopsis

toSnippet :: forall {k} (table :: Symbol) queryBuilderProvider (joinRegister :: k). (KnownSymbol table, HasQueryBuilder queryBuilderProvider joinRegister) => queryBuilderProvider table -> Snippet
buildSnippet :: SQLQuery -> Snippet
snippetToSQL :: Snippet -> Text
compileOperator :: FilterOperator -> Text

Documentation

toSnippet :: forall {k} (table :: Symbol) queryBuilderProvider (joinRegister :: k). (KnownSymbol table, HasQueryBuilder queryBuilderProvider joinRegister) => queryBuilderProvider table -> Snippet Source #

Compile a QueryBuilder to a Hasql Snippet

Build a Snippet from a compiled SQLQuery

Extract the SQL ByteString from a Snippet (for testing purposes)

This converts a Snippet to a Statement and extracts the SQL text. Useful for verifying the hasql compilation path in tests.

Compiles a FilterOperator to its SQL representation