Opaleye.SQLite.Internal.Sql

Documentation

data Select

Constructors

SelectFrom From

Table SqlTable

SelectJoin Join

SelectValues Values

SelectBinary Binary

Instances

Show Select

Defined in Opaleye.SQLite.Internal.Sql

Methods

showsPrec :: Int -> Select -> ShowS

show :: Select -> String

showList :: [Select] -> ShowS

data SelectAttrs

Constructors

Star

SelectAttrs (NonEmpty (SqlExpr, Maybe SqlColumn))

Instances

Show SelectAttrs

Defined in Opaleye.SQLite.Internal.Sql

Methods

showsPrec :: Int -> SelectAttrs -> ShowS

show :: SelectAttrs -> String

showList :: [SelectAttrs] -> ShowS

data From

Constructors

From

Fields

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

Instances

Show From

Defined in Opaleye.SQLite.Internal.Sql

Methods

showsPrec :: Int -> From -> ShowS

show :: From -> String

showList :: [From] -> ShowS

data Join

Constructors

Join

Fields

• jJoinType :: JoinType
• jTables :: (Select, Select)
• jCond :: SqlExpr

Instances

Show Join

Defined in Opaleye.SQLite.Internal.Sql

Methods

showsPrec :: Int -> Join -> ShowS

show :: Join -> String

showList :: [Join] -> ShowS

data Values

Constructors

Values

Fields

• vAttrs :: SelectAttrs
• vValues :: [[SqlExpr]]

Instances

Show Values

Defined in Opaleye.SQLite.Internal.Sql

Methods

showsPrec :: Int -> Values -> ShowS

show :: Values -> String

showList :: [Values] -> ShowS

data Binary

Constructors

Binary

Fields

• bOp :: BinOp
• bSelect1 :: Select
• bSelect2 :: Select

Instances

Show Binary

Defined in Opaleye.SQLite.Internal.Sql

Methods

showsPrec :: Int -> Binary -> ShowS

show :: Binary -> String

showList :: [Binary] -> ShowS

data JoinType

Constructors

LeftJoin

Instances

Show JoinType

Defined in Opaleye.SQLite.Internal.Sql

Methods

showsPrec :: Int -> JoinType -> ShowS

show :: JoinType -> String

showList :: [JoinType] -> ShowS

data BinOp

Constructors

Except

Union

UnionAll

Instances

Show BinOp

Defined in Opaleye.SQLite.Internal.Sql

Methods

showsPrec :: Int -> BinOp -> ShowS

show :: BinOp -> String

showList :: [BinOp] -> ShowS

data TableName

Constructors

String

data Returning a

Constructors

Returning a [SqlExpr]

sqlQueryGenerator :: PrimQueryFold Select

sql :: ([PrimExpr], PrimQuery, Tag) -> Select

unit :: Select

baseTable :: String -> [(Symbol, PrimExpr)] -> Select

product :: NonEmpty Select -> [PrimExpr] -> Select

aggregate :: [(Symbol, (Maybe AggrOp, PrimExpr))] -> Select -> Select

aggrExpr :: Maybe AggrOp -> PrimExpr -> PrimExpr

order :: [OrderExpr] -> Select -> Select

limit_ :: LimitOp -> Select -> Select

join :: JoinType -> PrimExpr -> Select -> Select -> Select

values :: [Symbol] -> [[PrimExpr]] -> Select

binary :: BinOp -> [(Symbol, (PrimExpr, PrimExpr))] -> (Select, Select) -> Select

joinType :: JoinType -> JoinType

binOp :: BinOp -> BinOp

newSelect :: From

sqlExpr :: PrimExpr -> SqlExpr

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

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