opaleye-0.2: An SQL-generating DSL targeting PostgreSQL

Safe Haskell	Safe-Inferred
Language	Haskell98

Opaleye.Internal.Sql

Documentation

data Select Source

Constructors

SelectFrom From
Table SqlTable
SelectJoin Join
SelectValues Values
SelectBinary Binary

Instances

data From Source

Constructors

From
Fields attrs :: [(SqlExpr, Maybe SqlColumn)] tables :: [Select] criteria :: [SqlExpr] groupBy :: [SqlExpr] orderBy :: [(SqlExpr, SqlOrder)] limit :: Maybe Int offset :: Maybe Int

Instances

data Join Source

Constructors

Join
Fields jJoinType :: JoinType jAttrs :: [(SqlExpr, Maybe SqlColumn)] jTables :: (Select, Select) jCond :: SqlExpr

Instances

data Values Source

Constructors

Values
Fields vAttrs :: [(SqlExpr, Maybe SqlColumn)] vValues :: [[SqlExpr]]

Instances

data Binary Source

Constructors

Binary
Fields bOp :: BinOp bSelect1 :: Select bSelect2 :: Select

Instances

data JoinType Source

Constructors

Instances

data BinOp Source

Constructors

Except
Union
UnionAll

Instances

data TableName Source

Constructors

data Returning a Source

Constructors

Returning a [SqlExpr]

sqlQueryGenerator :: PrimQueryFold Select Source

sql :: (PrimQuery, [PrimExpr]) -> Select Source

unit :: Select Source

baseTable :: String -> [(Symbol, PrimExpr)] -> Select Source

product :: NonEmpty Select -> [PrimExpr] -> Select Source

aggregate :: [(Symbol, Maybe AggrOp, PrimExpr)] -> Select -> Select Source

aggrExpr :: Maybe AggrOp -> PrimExpr -> PrimExpr Source

order :: [OrderExpr] -> Select -> Select Source

limit_ :: LimitOp -> Select -> Select Source

join :: JoinType -> [(Symbol, PrimExpr)] -> PrimExpr -> Select -> Select -> Select Source

values :: [Symbol] -> [[PrimExpr]] -> Select Source

binary :: BinOp -> [(Symbol, (PrimExpr, PrimExpr))] -> (Select, Select) -> Select Source

joinType :: JoinType -> JoinType Source

binOp :: BinOp -> BinOp Source

newSelect :: From Source

sqlExpr :: PrimExpr -> SqlExpr Source