Database.PostgreSQL.PQTypes.SQL

Documentation

data SQL

Primary SQL type that supports efficient concatenation and variable number of parameters.

Instances

Show SQL

Methods

showsPrec :: Int -> SQL -> ShowS

show :: SQL -> String

showList :: [SQL] -> ShowS

IsString SQL

Construct SQL from String.

Methods

fromString :: String -> SQL

Semigroup SQL

Methods

(<>) :: SQL -> SQL -> SQL

sconcat :: NonEmpty SQL -> SQL

stimes :: Integral b => b -> SQL -> SQL

Monoid SQL

Methods

mempty :: SQL

mappend :: SQL -> SQL -> SQL

mconcat :: [SQL] -> SQL

IsSQL SQL

Methods

withSQL :: SQL -> ParamAllocator -> (Ptr PGparam -> CString -> IO r) -> IO r

mkSQL :: Text -> SQL

Convert ByteString to SQL.

sqlParam :: (Show t, ToSQL t) => t -> SQL

Embed parameter value inside SQL.

(<?>) :: (Show t, ToSQL t) => SQL -> t -> SQL infixr 7

Embed parameter value inside existing SQL. Example:

f :: Int32 -> String -> SQL
f idx name = "SELECT foo FROM bar WHERE id =" <?> idx <+> "AND name =" <?> name

isSqlEmpty :: SQL -> Bool

Test whether an SQL is empty.