opaleye-0.4.0.0: An SQL-generating DSL targeting PostgreSQL

Safe HaskellNone
LanguageHaskell98

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

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

LeftJoin 

Instances

data BinOp Source

Constructors

Except 
Union 
UnionAll 

Instances

data TableName Source

Constructors

String 

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