opaleye-0.4.0.0: An SQL-generating DSL targeting PostgreSQL

Safe Haskell	None
Language	Haskell98

Opaleye.Internal.Sql

Documentation

data Select Source

Constructors

SelectFrom From
Table SqlTable
SelectJoin Join
SelectValues Values
SelectBinary Binary

Instances

data SelectAttrs Source

Constructors

Star
SelectAttrs (NonEmpty (SqlExpr, Maybe SqlColumn))

Instances

Show SelectAttrs

data From Source

Constructors

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

Instances

data Join Source

Constructors

Join
Fields jJoinType :: JoinType jTables :: (Select, Select) jCond :: SqlExpr

Instances

data Values Source

Constructors

Values
Fields vAttrs :: SelectAttrs 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 :: ([PrimExpr], PrimQuery, Tag) -> 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 -> 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

sqlBinding :: (Symbol, PrimExpr) -> (SqlExpr, Maybe SqlColumn) Source

ensureColumns :: [(SqlExpr, Maybe a)] -> NonEmpty (SqlExpr, Maybe a) Source