Safe Haskell	Safe-Inferred
Language	Haskell2010

Opaleye.Internal.HaskellDB.PrimQuery

Documentation

type TableName = String Source #

type Attribute = String Source #

type Name = String Source #

type Scheme = [Attribute] Source #

type Assoc = [(Attribute, PrimExpr)] Source #

data Symbol Source #

Constructors

Symbol String Tag

Instances

Instances details

Read Symbol Source #
Instance details Defined in Opaleye.Internal.HaskellDB.PrimQuery Methods readsPrec :: Int -> ReadS Symbol # readList :: ReadS [Symbol] # readPrec :: ReadPrec Symbol # readListPrec :: ReadPrec [Symbol] #
Show Symbol Source #
Instance details Defined in Opaleye.Internal.HaskellDB.PrimQuery Methods showsPrec :: Int -> Symbol -> ShowS # show :: Symbol -> String # showList :: [Symbol] -> ShowS #

data PrimExpr Source #

Constructors

AttrExpr Symbol
BaseTableAttrExpr Attribute
CompositeExpr PrimExpr Attribute	Composite Type Query
BinExpr BinOp PrimExpr PrimExpr
UnExpr UnOp PrimExpr
AggrExpr AggrDistinct AggrOp PrimExpr [OrderExpr] (Maybe PrimExpr)
WndwExpr WndwOp Partition
ConstExpr Literal
CaseExpr [(PrimExpr, PrimExpr)] PrimExpr
ListExpr (NonEmpty PrimExpr)
ParamExpr (Maybe Name) PrimExpr
FunExpr Name [PrimExpr]
CastExpr Name PrimExpr	Cast an expression to a given type.
DefaultInsertExpr
ArrayExpr [PrimExpr]	ARRAY[..]
RangeExpr String BoundExpr BoundExpr
ArrayIndex PrimExpr PrimExpr

Instances

Instances details

Read PrimExpr Source #
Instance details Defined in Opaleye.Internal.HaskellDB.PrimQuery Methods readsPrec :: Int -> ReadS PrimExpr # readList :: ReadS [PrimExpr] # readPrec :: ReadPrec PrimExpr # readListPrec :: ReadPrec [PrimExpr] #
Show PrimExpr Source #
Instance details Defined in Opaleye.Internal.HaskellDB.PrimQuery Methods showsPrec :: Int -> PrimExpr -> ShowS # show :: PrimExpr -> String # showList :: [PrimExpr] -> ShowS #

data Literal Source #

Constructors

NullLit
DefaultLit	represents a default value
BoolLit Bool
StringLit String
ByteStringLit ByteString
IntegerLit Integer
DoubleLit Double
NumericLit Scientific
OtherLit String	used for hacking in custom SQL

Instances

Instances details

Read Literal Source #
Instance details Defined in Opaleye.Internal.HaskellDB.PrimQuery Methods readsPrec :: Int -> ReadS Literal # readList :: ReadS [Literal] # readPrec :: ReadPrec Literal # readListPrec :: ReadPrec [Literal] #
Show Literal Source #
Instance details Defined in Opaleye.Internal.HaskellDB.PrimQuery Methods showsPrec :: Int -> Literal -> ShowS # show :: Literal -> String # showList :: [Literal] -> ShowS #

data BinOp Source #

Constructors

(:==)
(:<)
(:<=)
(:>)
(:>=)
(:<>)
OpAnd
OpOr
OpLike
OpILike
OpIn
OpOther String
(:\|\|)
(:+)
(:-)
(:*)
(:/)
OpMod
(:~)
(:&)
(:\|)
(:^)
(:=)
OpAtTimeZone
(:->)
(:->>)
(:#>)
(:#>>)
(:@>)
(:<@)
(:?)
(:?\|)
(:?&)
(:&&)
(:<<)
(:>>)
(:&<)
(:&>)
(:-\|-)

Instances

Instances details

Read BinOp Source #
Instance details Defined in Opaleye.Internal.HaskellDB.PrimQuery Methods readsPrec :: Int -> ReadS BinOp # readList :: ReadS [BinOp] # readPrec :: ReadPrec BinOp # readListPrec :: ReadPrec [BinOp] #
Show BinOp Source #
Instance details Defined in Opaleye.Internal.HaskellDB.PrimQuery Methods showsPrec :: Int -> BinOp -> ShowS # show :: BinOp -> String # showList :: [BinOp] -> ShowS #

data UnOp Source #

Constructors

OpNot
OpIsNull
OpIsNotNull
OpLength
OpAbs
OpNegate
OpLower
OpUpper
UnOpOther String

Instances

Instances details

Read UnOp Source #
Instance details Defined in Opaleye.Internal.HaskellDB.PrimQuery Methods readsPrec :: Int -> ReadS UnOp # readList :: ReadS [UnOp] # readPrec :: ReadPrec UnOp # readListPrec :: ReadPrec [UnOp] #
Show UnOp Source #
Instance details Defined in Opaleye.Internal.HaskellDB.PrimQuery Methods showsPrec :: Int -> UnOp -> ShowS # show :: UnOp -> String # showList :: [UnOp] -> ShowS #

data AggrOp Source #

Constructors

AggrCount
AggrSum
AggrAvg
AggrMin
AggrMax
AggrStdDev
AggrStdDevP
AggrVar
AggrVarP
AggrBoolOr
AggrBoolAnd
AggrArr
JsonArr
AggrStringAggr PrimExpr
AggrOther String

Instances

Instances details

Read AggrOp Source #
Instance details Defined in Opaleye.Internal.HaskellDB.PrimQuery Methods readsPrec :: Int -> ReadS AggrOp # readList :: ReadS [AggrOp] # readPrec :: ReadPrec AggrOp # readListPrec :: ReadPrec [AggrOp] #
Show AggrOp Source #
Instance details Defined in Opaleye.Internal.HaskellDB.PrimQuery Methods showsPrec :: Int -> AggrOp -> ShowS # show :: AggrOp -> String # showList :: [AggrOp] -> ShowS #

data AggrDistinct Source #

Constructors

AggrDistinct
AggrAll

Instances

Instances details

Read AggrDistinct Source #
Instance details Defined in Opaleye.Internal.HaskellDB.PrimQuery Methods readsPrec :: Int -> ReadS AggrDistinct # readList :: ReadS [AggrDistinct] # readPrec :: ReadPrec AggrDistinct # readListPrec :: ReadPrec [AggrDistinct] #
Show AggrDistinct Source #
Instance details Defined in Opaleye.Internal.HaskellDB.PrimQuery Methods showsPrec :: Int -> AggrDistinct -> ShowS # show :: AggrDistinct -> String # showList :: [AggrDistinct] -> ShowS #
Eq AggrDistinct Source #
Instance details Defined in Opaleye.Internal.HaskellDB.PrimQuery Methods (==) :: AggrDistinct -> AggrDistinct -> Bool # (/=) :: AggrDistinct -> AggrDistinct -> Bool #

data Aggr Source #

Constructors

GroupBy
Aggr
Fields aggrOp :: !AggrOp aggrOrder :: ![OrderExpr] aggrDistinct :: !AggrDistinct aggrFilter :: !(Maybe PrimExpr)

Instances

Instances details

Read Aggr Source #
Instance details Defined in Opaleye.Internal.HaskellDB.PrimQuery Methods readsPrec :: Int -> ReadS Aggr # readList :: ReadS [Aggr] # readPrec :: ReadPrec Aggr # readListPrec :: ReadPrec [Aggr] #
Show Aggr Source #
Instance details Defined in Opaleye.Internal.HaskellDB.PrimQuery Methods showsPrec :: Int -> Aggr -> ShowS # show :: Aggr -> String # showList :: [Aggr] -> ShowS #

data OrderExpr Source #

Constructors

OrderExpr OrderOp PrimExpr

Instances

Instances details

Read OrderExpr Source #
Instance details Defined in Opaleye.Internal.HaskellDB.PrimQuery Methods readsPrec :: Int -> ReadS OrderExpr # readList :: ReadS [OrderExpr] # readPrec :: ReadPrec OrderExpr # readListPrec :: ReadPrec [OrderExpr] #
Show OrderExpr Source #
Instance details Defined in Opaleye.Internal.HaskellDB.PrimQuery Methods showsPrec :: Int -> OrderExpr -> ShowS # show :: OrderExpr -> String # showList :: [OrderExpr] -> ShowS #

data OrderNulls Source #

Constructors

NullsFirst
NullsLast

Instances

Instances details

Read OrderNulls Source #
Instance details Defined in Opaleye.Internal.HaskellDB.PrimQuery Methods readsPrec :: Int -> ReadS OrderNulls # readList :: ReadS [OrderNulls] # readPrec :: ReadPrec OrderNulls # readListPrec :: ReadPrec [OrderNulls] #
Show OrderNulls Source #
Instance details Defined in Opaleye.Internal.HaskellDB.PrimQuery Methods showsPrec :: Int -> OrderNulls -> ShowS # show :: OrderNulls -> String # showList :: [OrderNulls] -> ShowS #

data OrderDirection Source #

Constructors

OpAsc
OpDesc

Instances

Instances details

Read OrderDirection Source #
Instance details Defined in Opaleye.Internal.HaskellDB.PrimQuery Methods readsPrec :: Int -> ReadS OrderDirection # readList :: ReadS [OrderDirection] # readPrec :: ReadPrec OrderDirection # readListPrec :: ReadPrec [OrderDirection] #
Show OrderDirection Source #
Instance details Defined in Opaleye.Internal.HaskellDB.PrimQuery Methods showsPrec :: Int -> OrderDirection -> ShowS # show :: OrderDirection -> String # showList :: [OrderDirection] -> ShowS #

data OrderOp Source #

Constructors

OrderOp
Fields orderDirection :: OrderDirection orderNulls :: OrderNulls

Instances

Instances details

Read OrderOp Source #
Instance details Defined in Opaleye.Internal.HaskellDB.PrimQuery Methods readsPrec :: Int -> ReadS OrderOp # readList :: ReadS [OrderOp] # readPrec :: ReadPrec OrderOp # readListPrec :: ReadPrec [OrderOp] #
Show OrderOp Source #
Instance details Defined in Opaleye.Internal.HaskellDB.PrimQuery Methods showsPrec :: Int -> OrderOp -> ShowS # show :: OrderOp -> String # showList :: [OrderOp] -> ShowS #

data BoundExpr Source #

Constructors

Inclusive PrimExpr
Exclusive PrimExpr
PosInfinity
NegInfinity

Instances

Instances details

Read BoundExpr Source #
Instance details Defined in Opaleye.Internal.HaskellDB.PrimQuery Methods readsPrec :: Int -> ReadS BoundExpr # readList :: ReadS [BoundExpr] # readPrec :: ReadPrec BoundExpr # readListPrec :: ReadPrec [BoundExpr] #
Show BoundExpr Source #
Instance details Defined in Opaleye.Internal.HaskellDB.PrimQuery Methods showsPrec :: Int -> BoundExpr -> ShowS # show :: BoundExpr -> String # showList :: [BoundExpr] -> ShowS #

data WndwOp Source #

Instances

Instances details

Read WndwOp Source #
Instance details Defined in Opaleye.Internal.HaskellDB.PrimQuery Methods readsPrec :: Int -> ReadS WndwOp # readList :: ReadS [WndwOp] # readPrec :: ReadPrec WndwOp # readListPrec :: ReadPrec [WndwOp] #
Show WndwOp Source #
Instance details Defined in Opaleye.Internal.HaskellDB.PrimQuery Methods showsPrec :: Int -> WndwOp -> ShowS # show :: WndwOp -> String # showList :: [WndwOp] -> ShowS #

data Partition Source #

Constructors

Partition
Fields partitionBy :: [PrimExpr] orderBy :: [OrderExpr]

Instances

Instances details

Read Partition Source #
Instance details Defined in Opaleye.Internal.HaskellDB.PrimQuery Methods readsPrec :: Int -> ReadS Partition # readList :: ReadS [Partition] # readPrec :: ReadPrec Partition # readListPrec :: ReadPrec [Partition] #
Show Partition Source #
Instance details Defined in Opaleye.Internal.HaskellDB.PrimQuery Methods showsPrec :: Int -> Partition -> ShowS # show :: Partition -> String # showList :: [Partition] -> ShowS #

WndwRowNumber
WndwRank
WndwDenseRank
WndwPercentRank
WndwCumeDist
WndwNtile PrimExpr
WndwLag PrimExpr PrimExpr PrimExpr
WndwLead PrimExpr PrimExpr PrimExpr
WndwFirstValue PrimExpr
WndwLastValue PrimExpr
WndwNthValue PrimExpr PrimExpr
WndwAggregate AggrOp PrimExpr