Database.Relational.Documentation

Concepts

Relational Query Building DSL

Monadic Query Context Building

Monadic Operators

query

queryMaybe

on

wheres

groupBy

having

distinct

all'

(<-#)

Direct Join Operators

inner

left

right

full

on'

type JoinRestriction a b

Finalize Context

data Relation p r

relation

aggregateRelation

data UpdateTarget p r

updateTarget

data Restriction p r

restriction

Record

Record Type

data Record c t

data Flat

data Aggregated

data Exists

data OverWindow

Projection Path

data Pi r0 r1

(!)

(<.>)

Record Operators

class ShowConstantTermsSQL a

value

values

(.=.)

(.<.)

(.<=.)

(.>.)

(.>=.)

(.<>.)

and'

or'

in'

(.||.)

like

like'

(.+.)

(.-.)

(.*.)

(./.)

isNothing

isJust

fromMaybe

not'

exists

negate'

fromIntegral'

showNum

casesOrElse

case'

Aggregate and Window Functions

count

sum'

avg

max'

min'

every

any'

some'

over

rank

denseRank

rowNumber

percentRank

cumeDist

Set Operators

union

except

intersect

Maybe Records

just

flattenMaybe

(?!)

(?!?)

(<?.>)

(<?.?>)

(?+?)

negateMaybe

sumMaybe

Placeholders

placeholder

query'

left'

relation'

updateTarget'

restriction'

union'

Record Mapping

class ProductConstructor c

class ProductIsoFunctor f

class ProductIsoApplicative f

(><)

Database Statements

relationalQuery

typedInsert

typedInsertQuery

typedUpdate

typedDelete

typedKeyUpdate

derivedInsert

derivedInsertQuery

derivedUpdate

derivedDelete

Database Operations

Conversion interfaces to communicate with database

class FromSql q a

class ToSql q a

data RecordFromSql q a

data RecordToSql q a

Generalized Statement

prepareNoFetch

bind

execute

executeNoFetch

Select

prepareQuery

fetch

runQuery

runQuery'

Insert Values

prepareInsert

runInsert

Insert Select Results

prepareInsertQuery

runInsertQuery

Update

prepareUpdate

runUpdate

Delete

prepareDelete

runDelete

Update by Key

prepareKeyUpdate

bindKeyUpdate

runKeyUpdate