Moduleopaleye-0.10.8.0Haskell2010

Opaleye.Sql

Contents

Synopsis

Showing SQL

valueshowSql :: Default Unpackspec fields fields => Select fields -> Maybe String

Show the SQL query string generated from the Select.

When Nothing is returned it means that the Select returns zero rows.

Example type specialization:

showSql :: Select (Field a, Field b) -> Maybe String

Assuming the makeAdaptorAndInstanceInferrable splice has been run for the product type Foo:

showSql :: Select (Foo (Field a) (Field b) (Field c)) -> Maybe String

valueshowSqlUnopt

Show the unoptimized SQL query string generated from the Select.

valueshowSqlExplicit :: Unpackspec fields b -> Select fields -> Maybe String

valueshowSqlUnoptExplicit :: Unpackspec fields b -> Select fields -> Maybe String