Database.HsSqlPpp.Quote

A quasiquoter for SQL. Antiquoting is a bit inconsistent.

Example:

import Database.HsSqlPpp.Ast
import Database.HsSqlPpp.Quote
import Database.HsSqlPpp.Annotation

test :: Statement
test = [$sqlStmt|

  create table $n(tablename) (
   $m(varname) $n(typename)
  );

        |]
  where
    tablename = [sqlName| my_table |]
    varname = [sqlNameComponent| my_field |]
    typename = [sqlName| text |]

See http://jakewheat.github.com/hssqlppp/QuasiQuoteTests.html for more simple examples

The splices are:

• $e(scalarexpression)
• $s(string)
• $t(triggerevent)
• $s(statement)
• $n(name)
• $m(namecomponent)

You can use $m() in a name context, and $n() or $m() in a scalar expression context. You can only use a single variable name in a splice atm.

Documentation

sqlStmts :: QuasiQuoter

quotes Statements

sqlStmt :: QuasiQuoter

quotes a single Statement

pgsqlStmts :: QuasiQuoter

quotes plpgsql Statements

pgsqlStmt :: QuasiQuoter

quotes a plpgsql Statement

sqlExpr :: QuasiQuoter

quotes a ScalarExpr

sqlName :: QuasiQuoter

quotes a Name

sqlNameComponent :: QuasiQuoter

quotes a Name