Opaleye.Internal.HaskellDB.PrimQuery

Documentation

type TableName = String

type Attribute = String

type Name = String

type Scheme = [Attribute]

type Assoc = [(Attribute, PrimExpr)]

data Symbol

Constructors

Symbol String Tag

Instances

Read Symbol

Methods

readsPrec :: Int -> ReadS Symbol

readList :: ReadS [Symbol]

readPrec :: ReadPrec Symbol

readListPrec :: ReadPrec [Symbol]

Show Symbol

Methods

showsPrec :: Int -> Symbol -> ShowS

show :: Symbol -> String

showList :: [Symbol] -> ShowS

data PrimExpr

Constructors

AttrExpr Symbol

BaseTableAttrExpr Attribute

CompositeExpr PrimExpr Attribute

Composite Type Query

BinExpr BinOp PrimExpr PrimExpr

UnExpr UnOp PrimExpr

AggrExpr AggrOp PrimExpr [OrderExpr]

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[..]

Instances

Read PrimExpr

Methods

readsPrec :: Int -> ReadS PrimExpr

readList :: ReadS [PrimExpr]

readPrec :: ReadPrec PrimExpr

readListPrec :: ReadPrec [PrimExpr]

Show PrimExpr

Methods

showsPrec :: Int -> PrimExpr -> ShowS

show :: PrimExpr -> String

showList :: [PrimExpr] -> ShowS

data Literal

Constructors

NullLit

DefaultLit

represents a default value

BoolLit Bool

StringLit String

ByteStringLit ByteString

IntegerLit Integer

DoubleLit Double

OtherLit String

used for hacking in custom SQL

Instances

Read Literal

Methods

readsPrec :: Int -> ReadS Literal

readList :: ReadS [Literal]

readPrec :: ReadPrec Literal

readListPrec :: ReadPrec [Literal]

Show Literal

Methods

showsPrec :: Int -> Literal -> ShowS

show :: Literal -> String

showList :: [Literal] -> ShowS

data BinOp

Constructors

(:==)

(:<)

(:<=)

(:>)

(:>=)

(:<>)

OpAnd

OpOr

OpLike

OpILike

OpIn

OpOther String

(:||)

(:+)

(:-)

(:*)

(:/)

OpMod

(:~)

(:&)

(:|)

(:^)

(:=)

OpAtTimeZone

(:->)

(:->>)

(:#>)

(:#>>)

(:@>)

(:<@)

(:?)

(:?|)

(:?&)

Instances

Read BinOp

Methods

readsPrec :: Int -> ReadS BinOp

readList :: ReadS [BinOp]

readPrec :: ReadPrec BinOp

readListPrec :: ReadPrec [BinOp]

Show BinOp

Methods

showsPrec :: Int -> BinOp -> ShowS

show :: BinOp -> String

showList :: [BinOp] -> ShowS

data UnOp

Constructors

OpNot

OpIsNull

OpIsNotNull

OpLength

OpAbs

OpNegate

OpLower

OpUpper

UnOpOther String

Instances

Read UnOp

Methods

readsPrec :: Int -> ReadS UnOp

readList :: ReadS [UnOp]

readPrec :: ReadPrec UnOp

readListPrec :: ReadPrec [UnOp]

Show UnOp

Methods

showsPrec :: Int -> UnOp -> ShowS

show :: UnOp -> String

showList :: [UnOp] -> ShowS

data AggrOp

Constructors

AggrCount

AggrSum

AggrAvg

AggrMin

AggrMax

AggrStdDev

AggrStdDevP

AggrVar

AggrVarP

AggrBoolOr

AggrBoolAnd

AggrArr

AggrStringAggr PrimExpr

AggrOther String

Instances

Read AggrOp

Methods

readsPrec :: Int -> ReadS AggrOp

readList :: ReadS [AggrOp]

readPrec :: ReadPrec AggrOp

readListPrec :: ReadPrec [AggrOp]

Show AggrOp

Methods

showsPrec :: Int -> AggrOp -> ShowS

show :: AggrOp -> String

showList :: [AggrOp] -> ShowS

data OrderExpr

Constructors

OrderExpr OrderOp PrimExpr

Instances

Read OrderExpr

Methods

readsPrec :: Int -> ReadS OrderExpr

readList :: ReadS [OrderExpr]

readPrec :: ReadPrec OrderExpr

readListPrec :: ReadPrec [OrderExpr]

Show OrderExpr

Methods

showsPrec :: Int -> OrderExpr -> ShowS

show :: OrderExpr -> String

showList :: [OrderExpr] -> ShowS

data OrderNulls

Constructors

NullsFirst

NullsLast

Instances

Read OrderNulls

Methods

readsPrec :: Int -> ReadS OrderNulls

readList :: ReadS [OrderNulls]

readPrec :: ReadPrec OrderNulls

readListPrec :: ReadPrec [OrderNulls]

Show OrderNulls

Methods

showsPrec :: Int -> OrderNulls -> ShowS

show :: OrderNulls -> String

showList :: [OrderNulls] -> ShowS

data OrderDirection

Constructors

OpAsc

OpDesc

Instances

Read OrderDirection

Methods

readsPrec :: Int -> ReadS OrderDirection

readList :: ReadS [OrderDirection]

readPrec :: ReadPrec OrderDirection

readListPrec :: ReadPrec [OrderDirection]

Show OrderDirection

Methods

showsPrec :: Int -> OrderDirection -> ShowS

show :: OrderDirection -> String

showList :: [OrderDirection] -> ShowS

data OrderOp

Constructors

OrderOp

Fields

• orderDirection :: OrderDirection
• orderNulls :: OrderNulls

Instances

Read OrderOp

Methods

readsPrec :: Int -> ReadS OrderOp

readList :: ReadS [OrderOp]

readPrec :: ReadPrec OrderOp

readListPrec :: ReadPrec [OrderOp]

Show OrderOp

Methods

showsPrec :: Int -> OrderOp -> ShowS

show :: OrderOp -> String

showList :: [OrderOp] -> ShowS