Safe Haskell	None
Language	Haskell2010

Database.Beam.Backend.SQL.AST

Description

This module implements an AST type for SQL92. It allows us to realize the call structure of the builders defined in Database.Beam.Backend.SQL.SQL92

Documentation

data Command Source #

Constructors

SelectCommand Select
InsertCommand Insert
UpdateCommand Update
DeleteCommand Delete

Instances

Instances details

IsSql92Syntax Command Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Associated Types

type Sql92SelectSyntax Command
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql92SelectSyntax Command = Select
type Sql92InsertSyntax Command
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql92InsertSyntax Command = Insert
type Sql92UpdateSyntax Command
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql92UpdateSyntax Command = Update
type Sql92DeleteSyntax Command
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql92DeleteSyntax Command = Delete

Methods

selectCmd :: Sql92SelectSyntax Command -> Command Source #

insertCmd :: Sql92InsertSyntax Command -> Command Source #

updateCmd :: Sql92UpdateSyntax Command -> Command Source #

deleteCmd :: Sql92DeleteSyntax Command -> Command Source #

Show Command Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

showsPrec :: Int -> Command -> ShowS #

show :: Command -> String #

showList :: [Command] -> ShowS #

Eq Command Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

(==) :: Command -> Command -> Bool #

(/=) :: Command -> Command -> Bool #

type Sql92DeleteSyntax Command Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql92DeleteSyntax Command = Delete

type Sql92InsertSyntax Command Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql92InsertSyntax Command = Insert

type Sql92SelectSyntax Command Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql92SelectSyntax Command = Select

type Sql92UpdateSyntax Command Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql92UpdateSyntax Command = Update

data Select Source #

Constructors

Select
Fields selectTable :: SelectTable selectOrdering :: [Ordering] selectLimit :: Maybe Integer selectOffset :: Maybe Integer

Instances

Instances details

IsSql92SelectSyntax Select Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Associated Types

type Sql92SelectSelectTableSyntax Select
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql92SelectSelectTableSyntax Select = SelectTable
type Sql92SelectOrderingSyntax Select
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql92SelectOrderingSyntax Select = Ordering

Methods

selectStmt :: Sql92SelectSelectTableSyntax Select -> [Sql92SelectOrderingSyntax Select] -> Maybe Integer -> Maybe Integer -> Select Source #

Show Select Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

showsPrec :: Int -> Select -> ShowS #

show :: Select -> String #

showList :: [Select] -> ShowS #

Eq Select Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

(==) :: Select -> Select -> Bool #

(/=) :: Select -> Select -> Bool #

type Sql92SelectOrderingSyntax Select Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql92SelectOrderingSyntax Select = Ordering

type Sql92SelectSelectTableSyntax Select Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql92SelectSelectTableSyntax Select = SelectTable

data SelectTable Source #

Constructors

SelectTable
Fields selectQuantifier :: Maybe SetQuantifier selectProjection :: Projection selectFrom :: Maybe From selectWhere :: Maybe Expression selectGrouping :: Maybe Grouping selectHaving :: Maybe Expression
UnionTables Bool SelectTable SelectTable
IntersectTables Bool SelectTable SelectTable
ExceptTable Bool SelectTable SelectTable

Instances

Instances details

IsSql92SelectTableSyntax SelectTable Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Associated Types

type Sql92SelectTableSelectSyntax SelectTable
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql92SelectTableSelectSyntax SelectTable = Select
type Sql92SelectTableExpressionSyntax SelectTable
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql92SelectTableExpressionSyntax SelectTable = Expression
type Sql92SelectTableProjectionSyntax SelectTable
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql92SelectTableProjectionSyntax SelectTable = Projection
type Sql92SelectTableFromSyntax SelectTable
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql92SelectTableFromSyntax SelectTable = From
type Sql92SelectTableGroupingSyntax SelectTable
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql92SelectTableGroupingSyntax SelectTable = Grouping
type Sql92SelectTableSetQuantifierSyntax SelectTable
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql92SelectTableSetQuantifierSyntax SelectTable = SetQuantifier

Show SelectTable Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

showsPrec :: Int -> SelectTable -> ShowS #

show :: SelectTable -> String #

showList :: [SelectTable] -> ShowS #

Eq SelectTable Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

(==) :: SelectTable -> SelectTable -> Bool #

(/=) :: SelectTable -> SelectTable -> Bool #

type Sql92SelectTableExpressionSyntax SelectTable Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql92SelectTableExpressionSyntax SelectTable = Expression

type Sql92SelectTableFromSyntax SelectTable Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql92SelectTableFromSyntax SelectTable = From

type Sql92SelectTableGroupingSyntax SelectTable Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql92SelectTableGroupingSyntax SelectTable = Grouping

type Sql92SelectTableProjectionSyntax SelectTable Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql92SelectTableProjectionSyntax SelectTable = Projection

type Sql92SelectTableSelectSyntax SelectTable Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql92SelectTableSelectSyntax SelectTable = Select

type Sql92SelectTableSetQuantifierSyntax SelectTable Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql92SelectTableSetQuantifierSyntax SelectTable = SetQuantifier

data Insert Source #

Constructors

Insert
Fields insertTable :: TableName insertFields :: [Text] insertValues :: InsertValues

Instances

Instances details

IsSql92InsertSyntax Insert Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Associated Types

type Sql92InsertValuesSyntax Insert
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql92InsertValuesSyntax Insert = InsertValues
type Sql92InsertTableNameSyntax Insert
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql92InsertTableNameSyntax Insert = TableName

Methods

insertStmt :: Sql92InsertTableNameSyntax Insert -> [Text] -> Sql92InsertValuesSyntax Insert -> Insert Source #

Show Insert Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

showsPrec :: Int -> Insert -> ShowS #

show :: Insert -> String #

showList :: [Insert] -> ShowS #

Eq Insert Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

(==) :: Insert -> Insert -> Bool #

(/=) :: Insert -> Insert -> Bool #

type Sql92InsertTableNameSyntax Insert Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql92InsertTableNameSyntax Insert = TableName

type Sql92InsertValuesSyntax Insert Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql92InsertValuesSyntax Insert = InsertValues

data InsertValues Source #

Constructors

InsertValues
Fields insertValuesExpressions :: [[Expression]]
InsertSelect
Fields insertSelectStmt :: Select

Instances

Instances details

IsSql92InsertValuesSyntax InsertValues Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Associated Types

type Sql92InsertValuesExpressionSyntax InsertValues
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql92InsertValuesExpressionSyntax InsertValues = Expression
type Sql92InsertValuesSelectSyntax InsertValues
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql92InsertValuesSelectSyntax InsertValues = Select

Methods

insertSqlExpressions :: [[Sql92InsertValuesExpressionSyntax InsertValues]] -> InsertValues Source #

insertFromSql :: Sql92InsertValuesSelectSyntax InsertValues -> InsertValues Source #

Show InsertValues Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

showsPrec :: Int -> InsertValues -> ShowS #

show :: InsertValues -> String #

showList :: [InsertValues] -> ShowS #

Eq InsertValues Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

(==) :: InsertValues -> InsertValues -> Bool #

(/=) :: InsertValues -> InsertValues -> Bool #

type Sql92InsertValuesExpressionSyntax InsertValues Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql92InsertValuesExpressionSyntax InsertValues = Expression

type Sql92InsertValuesSelectSyntax InsertValues Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql92InsertValuesSelectSyntax InsertValues = Select

data Update Source #

Constructors

Update
Fields updateTable :: TableName updateFields :: [(FieldName, Expression)] updateWhere :: Maybe Expression

Instances

Instances details

IsSql92UpdateSyntax Update Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Associated Types

type Sql92UpdateTableNameSyntax Update
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql92UpdateTableNameSyntax Update = TableName
type Sql92UpdateFieldNameSyntax Update
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql92UpdateFieldNameSyntax Update = FieldName
type Sql92UpdateExpressionSyntax Update
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql92UpdateExpressionSyntax Update = Expression

Methods

updateStmt :: Sql92UpdateTableNameSyntax Update -> [(Sql92UpdateFieldNameSyntax Update, Sql92UpdateExpressionSyntax Update)] -> Maybe (Sql92UpdateExpressionSyntax Update) -> Update Source #

Show Update Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

showsPrec :: Int -> Update -> ShowS #

show :: Update -> String #

showList :: [Update] -> ShowS #

Eq Update Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

(==) :: Update -> Update -> Bool #

(/=) :: Update -> Update -> Bool #

type Sql92UpdateExpressionSyntax Update Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql92UpdateExpressionSyntax Update = Expression

type Sql92UpdateFieldNameSyntax Update Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql92UpdateFieldNameSyntax Update = FieldName

type Sql92UpdateTableNameSyntax Update Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql92UpdateTableNameSyntax Update = TableName

data Delete Source #

Constructors

Delete
Fields deleteTable :: TableName deleteAlias :: Maybe Text deleteWhere :: Maybe Expression

Instances

Instances details

IsSql92DeleteSyntax Delete Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Associated Types

type Sql92DeleteTableNameSyntax Delete
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql92DeleteTableNameSyntax Delete = TableName
type Sql92DeleteExpressionSyntax Delete
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql92DeleteExpressionSyntax Delete = Expression

Methods

deleteStmt :: Sql92DeleteTableNameSyntax Delete -> Maybe Text -> Maybe (Sql92DeleteExpressionSyntax Delete) -> Delete Source #

deleteSupportsAlias :: Proxy Delete -> Bool Source #

Show Delete Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

showsPrec :: Int -> Delete -> ShowS #

show :: Delete -> String #

showList :: [Delete] -> ShowS #

Eq Delete Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

(==) :: Delete -> Delete -> Bool #

(/=) :: Delete -> Delete -> Bool #

type Sql92DeleteExpressionSyntax Delete Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql92DeleteExpressionSyntax Delete = Expression

type Sql92DeleteTableNameSyntax Delete Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql92DeleteTableNameSyntax Delete = TableName

data FieldName Source #

Constructors

QualifiedField Text Text
UnqualifiedField Text

Instances

Instances details

IsSql92FieldNameSyntax FieldName Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods qualifiedField :: Text -> Text -> FieldName Source # unqualifiedField :: Text -> FieldName Source #
Show FieldName Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods showsPrec :: Int -> FieldName -> ShowS # show :: FieldName -> String # showList :: [FieldName] -> ShowS #
Eq FieldName Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods (==) :: FieldName -> FieldName -> Bool # (/=) :: FieldName -> FieldName -> Bool #

data ComparatorQuantifier Source #

Constructors

ComparatorQuantifierAny
ComparatorQuantifierAll

Instances

Instances details

IsSql92QuantifierSyntax ComparatorQuantifier Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods quantifyOverAll :: ComparatorQuantifier Source # quantifyOverAny :: ComparatorQuantifier Source #
Show ComparatorQuantifier Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods showsPrec :: Int -> ComparatorQuantifier -> ShowS # show :: ComparatorQuantifier -> String # showList :: [ComparatorQuantifier] -> ShowS #
Eq ComparatorQuantifier Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods (==) :: ComparatorQuantifier -> ComparatorQuantifier -> Bool # (/=) :: ComparatorQuantifier -> ComparatorQuantifier -> Bool #

data ExtractField Source #

Constructors

ExtractFieldTimeZoneHour
ExtractFieldTimeZoneMinute
ExtractFieldDateTimeYear
ExtractFieldDateTimeMonth
ExtractFieldDateTimeDay
ExtractFieldDateTimeHour
ExtractFieldDateTimeMinute
ExtractFieldDateTimeSecond

Instances

Instances details

IsSql92ExtractFieldSyntax ExtractField Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods secondsField :: ExtractField Source # minutesField :: ExtractField Source # hourField :: ExtractField Source # dayField :: ExtractField Source # monthField :: ExtractField Source # yearField :: ExtractField Source #
Show ExtractField Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods showsPrec :: Int -> ExtractField -> ShowS # show :: ExtractField -> String # showList :: [ExtractField] -> ShowS #
Eq ExtractField Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods (==) :: ExtractField -> ExtractField -> Bool # (/=) :: ExtractField -> ExtractField -> Bool #

data DataType Source #

Instances

Instances details

IsSql2008BigIntDataTypeSyntax DataType Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods bigIntType :: DataType Source #
IsSql92DataTypeSyntax DataType Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods domainType :: Text -> DataType Source # charType :: Maybe Word -> Maybe Text -> DataType Source # varCharType :: Maybe Word -> Maybe Text -> DataType Source # nationalCharType :: Maybe Word -> DataType Source # nationalVarCharType :: Maybe Word -> DataType Source # bitType :: Maybe Word -> DataType Source # varBitType :: Maybe Word -> DataType Source # numericType :: Maybe (Word, Maybe Word) -> DataType Source # decimalType :: Maybe (Word, Maybe Word) -> DataType Source # intType :: DataType Source # smallIntType :: DataType Source # floatType :: Maybe Word -> DataType Source # doubleType :: DataType Source # realType :: DataType Source # dateType :: DataType Source # timeType :: Maybe Word -> Bool -> DataType Source # timestampType :: Maybe Word -> Bool -> DataType Source #
IsSql99DataTypeSyntax DataType Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods characterLargeObjectType :: DataType Source # binaryLargeObjectType :: DataType Source # booleanType :: DataType Source # arrayType :: DataType -> Int -> DataType Source # rowType :: [(Text, DataType)] -> DataType Source #
Show DataType Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods showsPrec :: Int -> DataType -> ShowS # show :: DataType -> String # showList :: [DataType] -> ShowS #
Eq DataType Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods (==) :: DataType -> DataType -> Bool # (/=) :: DataType -> DataType -> Bool #

data SetQuantifier Source #

Constructors

SetQuantifierAll
SetQuantifierDistinct

Instances

Instances details

IsSql92AggregationSetQuantifierSyntax SetQuantifier Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods setQuantifierDistinct :: SetQuantifier Source # setQuantifierAll :: SetQuantifier Source #
Show SetQuantifier Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods showsPrec :: Int -> SetQuantifier -> ShowS # show :: SetQuantifier -> String # showList :: [SetQuantifier] -> ShowS #
Eq SetQuantifier Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods (==) :: SetQuantifier -> SetQuantifier -> Bool # (/=) :: SetQuantifier -> SetQuantifier -> Bool #

data Expression Source #

Constructors

ExpressionValue Value
ExpressionDefault
ExpressionRow [Expression]
ExpressionIn Expression [Expression]
ExpressionInSelect Expression Select
ExpressionIsNull Expression
ExpressionIsNotNull Expression
ExpressionIsTrue Expression
ExpressionIsNotTrue Expression
ExpressionIsFalse Expression
ExpressionIsNotFalse Expression
ExpressionIsUnknown Expression
ExpressionIsNotUnknown Expression
ExpressionCase [(Expression, Expression)] Expression
ExpressionCoalesce [Expression]
ExpressionNullIf Expression Expression
ExpressionFieldName FieldName
ExpressionBetween Expression Expression Expression
ExpressionBinOp Text Expression Expression
ExpressionCompOp Text (Maybe ComparatorQuantifier) Expression Expression
ExpressionUnOp Text Expression
ExpressionPosition Expression Expression
ExpressionCast Expression DataType
ExpressionExtract ExtractField Expression
ExpressionCharLength Expression
ExpressionOctetLength Expression
ExpressionBitLength Expression
ExpressionAbs Expression
ExpressionLower Expression
ExpressionUpper Expression
ExpressionTrim Expression
ExpressionNamedFunction Text
ExpressionFunctionCall Expression [Expression]
ExpressionInstanceField Expression Text
ExpressionRefField Expression Text
ExpressionCountAll
ExpressionAgg Text (Maybe SetQuantifier) [Expression]
ExpressionBuiltinFunction Text [Expression]
ExpressionSubquery Select
ExpressionUnique Select
ExpressionDistinct Select
ExpressionExists Select
ExpressionOver Expression WindowFrame
ExpressionCurrentTimestamp

Instances

Instances details

IsSql2003EnhancedNumericFunctionsAggregationExpressionSyntax Expression Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

stddevPopE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression Source #

stddevSampE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression Source #

varPopE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression Source #

varSampE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression Source #

covarPopE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression -> Expression Source #

covarSampE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression -> Expression Source #

corrE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression -> Expression Source #

regrSlopeE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression -> Expression Source #

regrInterceptE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression -> Expression Source #

regrCountE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression -> Expression Source #

regrRSquaredE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression -> Expression Source #

regrAvgXE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression -> Expression Source #

regrAvgYE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression -> Expression Source #

regrSXXE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression -> Expression Source #

regrSXYE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression -> Expression Source #

regrSYYE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression -> Expression Source #

IsSql2003EnhancedNumericFunctionsExpressionSyntax Expression Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

lnE :: Expression -> Expression Source #

expE :: Expression -> Expression Source #

sqrtE :: Expression -> Expression Source #

ceilE :: Expression -> Expression Source #

floorE :: Expression -> Expression Source #

powerE :: Expression -> Expression -> Expression Source #

IsSql2003ExpressionSyntax Expression Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Associated Types

type Sql2003ExpressionWindowFrameSyntax Expression
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql2003ExpressionWindowFrameSyntax Expression = WindowFrame

Methods

overE :: Expression -> Sql2003ExpressionWindowFrameSyntax Expression -> Expression Source #

rowNumberE :: Expression Source #

IsSql2003LeadAndLagExpressionSyntax Expression Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

leadE :: Expression -> Maybe Expression -> Maybe Expression -> Expression Source #

lagE :: Expression -> Maybe Expression -> Maybe Expression -> Expression Source #

IsSql2003NthValueExpressionSyntax Expression Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

nthValueE :: Expression -> Expression -> Expression Source #

IsSql2003NtileExpressionSyntax Expression Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

ntileE :: Expression -> Expression Source #

IsSql92AggregationExpressionSyntax Expression Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Associated Types

type Sql92AggregationSetQuantifierSyntax Expression
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql92AggregationSetQuantifierSyntax Expression = SetQuantifier

Methods

countAllE :: Expression Source #

countE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression Source #

avgE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression Source #

maxE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression Source #

minE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression Source #

sumE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression Source #

IsSql92ExpressionSyntax Expression Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Associated Types

type Sql92ExpressionQuantifierSyntax Expression
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql92ExpressionQuantifierSyntax Expression = ComparatorQuantifier
type Sql92ExpressionValueSyntax Expression
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql92ExpressionValueSyntax Expression = Value
type Sql92ExpressionSelectSyntax Expression
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql92ExpressionSelectSyntax Expression = Select
type Sql92ExpressionFieldNameSyntax Expression
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql92ExpressionFieldNameSyntax Expression = FieldName
type Sql92ExpressionCastTargetSyntax Expression
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql92ExpressionCastTargetSyntax Expression = DataType
type Sql92ExpressionExtractFieldSyntax Expression
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql92ExpressionExtractFieldSyntax Expression = ExtractField

Methods

valueE :: Sql92ExpressionValueSyntax Expression -> Expression Source #

rowE :: [Expression] -> Expression Source #

quantifierListE :: [Expression] -> Expression Source #

coalesceE :: [Expression] -> Expression Source #

caseE :: [(Expression, Expression)] -> Expression -> Expression Source #

fieldE :: Sql92ExpressionFieldNameSyntax Expression -> Expression Source #

betweenE :: Expression -> Expression -> Expression -> Expression Source #

andE :: Expression -> Expression -> Expression Source #

orE :: Expression -> Expression -> Expression Source #

addE :: Expression -> Expression -> Expression Source #

subE :: Expression -> Expression -> Expression Source #

mulE :: Expression -> Expression -> Expression Source #

divE :: Expression -> Expression -> Expression Source #

likeE :: Expression -> Expression -> Expression Source #

modE :: Expression -> Expression -> Expression Source #

overlapsE :: Expression -> Expression -> Expression Source #

nullIfE :: Expression -> Expression -> Expression Source #

positionE :: Expression -> Expression -> Expression Source #

eqE :: Maybe (Sql92ExpressionQuantifierSyntax Expression) -> Expression -> Expression -> Expression Source #

neqE :: Maybe (Sql92ExpressionQuantifierSyntax Expression) -> Expression -> Expression -> Expression Source #

ltE :: Maybe (Sql92ExpressionQuantifierSyntax Expression) -> Expression -> Expression -> Expression Source #

gtE :: Maybe (Sql92ExpressionQuantifierSyntax Expression) -> Expression -> Expression -> Expression Source #

leE :: Maybe (Sql92ExpressionQuantifierSyntax Expression) -> Expression -> Expression -> Expression Source #

geE :: Maybe (Sql92ExpressionQuantifierSyntax Expression) -> Expression -> Expression -> Expression Source #

eqMaybeE :: Expression -> Expression -> Expression -> Expression Source #

neqMaybeE :: Expression -> Expression -> Expression -> Expression Source #

castE :: Expression -> Sql92ExpressionCastTargetSyntax Expression -> Expression Source #

notE :: Expression -> Expression Source #

negateE :: Expression -> Expression Source #

isNullE :: Expression -> Expression Source #

isNotNullE :: Expression -> Expression Source #

isTrueE :: Expression -> Expression Source #

isNotTrueE :: Expression -> Expression Source #

isFalseE :: Expression -> Expression Source #

isNotFalseE :: Expression -> Expression Source #

isUnknownE :: Expression -> Expression Source #

isNotUnknownE :: Expression -> Expression Source #

charLengthE :: Expression -> Expression Source #

octetLengthE :: Expression -> Expression Source #

bitLengthE :: Expression -> Expression Source #

lowerE :: Expression -> Expression Source #

upperE :: Expression -> Expression Source #

trimE :: Expression -> Expression Source #

absE :: Expression -> Expression Source #

extractE :: Sql92ExpressionExtractFieldSyntax Expression -> Expression -> Expression Source #

existsE :: Sql92ExpressionSelectSyntax Expression -> Expression Source #

uniqueE :: Sql92ExpressionSelectSyntax Expression -> Expression Source #

subqueryE :: Sql92ExpressionSelectSyntax Expression -> Expression Source #

currentTimestampE :: Expression Source #

defaultE :: Expression Source #

inE :: Expression -> [Expression] -> Expression Source #

inSelectE :: Expression -> Sql92ExpressionSelectSyntax Expression -> Expression Source #

IsSql99AggregationExpressionSyntax Expression Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

everyE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression Source #

someE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression Source #

anyE :: Maybe (Sql92AggregationSetQuantifierSyntax Expression) -> Expression -> Expression Source #

IsSql99ExpressionSyntax Expression Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

distinctE :: Sql92ExpressionSelectSyntax Expression -> Expression Source #

instanceFieldE :: Expression -> Text -> Expression Source #

refFieldE :: Expression -> Text -> Expression Source #

IsSql99FunctionExpressionSyntax Expression Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

functionCallE :: Expression -> [Expression] -> Expression Source #

functionNameE :: Text -> Expression Source #

Show Expression Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

showsPrec :: Int -> Expression -> ShowS #

show :: Expression -> String #

showList :: [Expression] -> ShowS #

Eq Expression Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

(==) :: Expression -> Expression -> Bool #

(/=) :: Expression -> Expression -> Bool #

type Sql2003ExpressionWindowFrameSyntax Expression Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql2003ExpressionWindowFrameSyntax Expression = WindowFrame

type Sql92AggregationSetQuantifierSyntax Expression Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql92AggregationSetQuantifierSyntax Expression = SetQuantifier

type Sql92ExpressionCastTargetSyntax Expression Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql92ExpressionCastTargetSyntax Expression = DataType

type Sql92ExpressionExtractFieldSyntax Expression Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql92ExpressionExtractFieldSyntax Expression = ExtractField

type Sql92ExpressionFieldNameSyntax Expression Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql92ExpressionFieldNameSyntax Expression = FieldName

type Sql92ExpressionQuantifierSyntax Expression Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql92ExpressionQuantifierSyntax Expression = ComparatorQuantifier

type Sql92ExpressionSelectSyntax Expression Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql92ExpressionSelectSyntax Expression = Select

type Sql92ExpressionValueSyntax Expression Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql92ExpressionValueSyntax Expression = Value

newtype Projection Source #

Constructors

ProjExprs [(Expression, Maybe Text)]

Instances

Instances details

IsSql92ProjectionSyntax Projection Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Associated Types

type Sql92ProjectionExpressionSyntax Projection
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql92ProjectionExpressionSyntax Projection = Expression

Methods

projExprs :: [(Sql92ProjectionExpressionSyntax Projection, Maybe Text)] -> Projection Source #

Show Projection Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

showsPrec :: Int -> Projection -> ShowS #

show :: Projection -> String #

showList :: [Projection] -> ShowS #

Eq Projection Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

(==) :: Projection -> Projection -> Bool #

(/=) :: Projection -> Projection -> Bool #

type Sql92ProjectionExpressionSyntax Projection Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql92ProjectionExpressionSyntax Projection = Expression

data Ordering Source #

Constructors

OrderingAsc Expression
OrderingDesc Expression

Instances

Instances details

IsSql92OrderingSyntax Ordering Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Associated Types

type Sql92OrderingExpressionSyntax Ordering
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql92OrderingExpressionSyntax Ordering = Expression

Methods

ascOrdering :: Sql92OrderingExpressionSyntax Ordering -> Ordering Source #

descOrdering :: Sql92OrderingExpressionSyntax Ordering -> Ordering Source #

Show Ordering Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

showsPrec :: Int -> Ordering -> ShowS #

show :: Ordering -> String #

showList :: [Ordering] -> ShowS #

Eq Ordering Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

(==) :: Ordering -> Ordering -> Bool #

(/=) :: Ordering -> Ordering -> Bool #

type Sql92OrderingExpressionSyntax Ordering Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql92OrderingExpressionSyntax Ordering = Expression

newtype Grouping Source #

Constructors

Grouping [Expression]

Instances

Instances details

IsSql92GroupingSyntax Grouping Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Associated Types

type Sql92GroupingExpressionSyntax Grouping
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql92GroupingExpressionSyntax Grouping = Expression

Methods

groupByExpressions :: [Sql92GroupingExpressionSyntax Grouping] -> Grouping Source #

Show Grouping Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

showsPrec :: Int -> Grouping -> ShowS #

show :: Grouping -> String #

showList :: [Grouping] -> ShowS #

Eq Grouping Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

(==) :: Grouping -> Grouping -> Bool #

(/=) :: Grouping -> Grouping -> Bool #

type Sql92GroupingExpressionSyntax Grouping Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql92GroupingExpressionSyntax Grouping = Expression

data SchemaName Source #

Constructors

SchemaName Text

Instances

Instances details

IsSql92SchemaNameSyntax SchemaName Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods schemaName :: Text -> SchemaName Source #
Show SchemaName Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods showsPrec :: Int -> SchemaName -> ShowS # show :: SchemaName -> String # showList :: [SchemaName] -> ShowS #
Eq SchemaName Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods (==) :: SchemaName -> SchemaName -> Bool # (/=) :: SchemaName -> SchemaName -> Bool #
Ord SchemaName Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods compare :: SchemaName -> SchemaName -> Ordering # (<) :: SchemaName -> SchemaName -> Bool # (<=) :: SchemaName -> SchemaName -> Bool # (>) :: SchemaName -> SchemaName -> Bool # (>=) :: SchemaName -> SchemaName -> Bool # max :: SchemaName -> SchemaName -> SchemaName # min :: SchemaName -> SchemaName -> SchemaName #

data TableName Source #

Constructors

TableName (Maybe Text) Text

Instances

Instances details

IsSql92TableNameSyntax TableName Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods tableName :: Maybe Text -> Text -> TableName Source #
Show TableName Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods showsPrec :: Int -> TableName -> ShowS # show :: TableName -> String # showList :: [TableName] -> ShowS #
Eq TableName Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods (==) :: TableName -> TableName -> Bool # (/=) :: TableName -> TableName -> Bool #
Ord TableName Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods compare :: TableName -> TableName -> Ordering # (<) :: TableName -> TableName -> Bool # (<=) :: TableName -> TableName -> Bool # (>) :: TableName -> TableName -> Bool # (>=) :: TableName -> TableName -> Bool # max :: TableName -> TableName -> TableName # min :: TableName -> TableName -> TableName #

data TableSource Source #

Constructors

TableNamed TableName
TableFromSubSelect Select
TableFromValues [[Expression]]

Instances

Instances details

IsSql92TableSourceSyntax TableSource Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Associated Types

type Sql92TableSourceSelectSyntax TableSource
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql92TableSourceSelectSyntax TableSource = Select
type Sql92TableSourceExpressionSyntax TableSource
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql92TableSourceExpressionSyntax TableSource = Expression
type Sql92TableSourceTableNameSyntax TableSource
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql92TableSourceTableNameSyntax TableSource = TableName

Methods

tableNamed :: Sql92TableSourceTableNameSyntax TableSource -> TableSource Source #

tableFromSubSelect :: Sql92TableSourceSelectSyntax TableSource -> TableSource Source #

tableFromValues :: [[Sql92TableSourceExpressionSyntax TableSource]] -> TableSource Source #

Show TableSource Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

showsPrec :: Int -> TableSource -> ShowS #

show :: TableSource -> String #

showList :: [TableSource] -> ShowS #

Eq TableSource Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

(==) :: TableSource -> TableSource -> Bool #

(/=) :: TableSource -> TableSource -> Bool #

type Sql92TableSourceExpressionSyntax TableSource Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql92TableSourceExpressionSyntax TableSource = Expression

type Sql92TableSourceSelectSyntax TableSource Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql92TableSourceSelectSyntax TableSource = Select

type Sql92TableSourceTableNameSyntax TableSource Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql92TableSourceTableNameSyntax TableSource = TableName

data From Source #

Constructors

FromTable TableSource (Maybe (Text, Maybe [Text]))
InnerJoin From From (Maybe Expression)
LeftJoin From From (Maybe Expression)
RightJoin From From (Maybe Expression)
OuterJoin From From (Maybe Expression)

Instances

Instances details

IsSql92FromSyntax From Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Associated Types

type Sql92FromTableSourceSyntax From
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql92FromTableSourceSyntax From = TableSource
type Sql92FromExpressionSyntax From
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql92FromExpressionSyntax From = Expression

Methods

fromTable :: Sql92FromTableSourceSyntax From -> Maybe (Text, Maybe [Text]) -> From Source #

innerJoin :: From -> From -> Maybe (Sql92FromExpressionSyntax From) -> From Source #

leftJoin :: From -> From -> Maybe (Sql92FromExpressionSyntax From) -> From Source #

rightJoin :: From -> From -> Maybe (Sql92FromExpressionSyntax From) -> From Source #

Show From Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

showsPrec :: Int -> From -> ShowS #

show :: From -> String #

showList :: [From] -> ShowS #

Eq From Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

(==) :: From -> From -> Bool #

(/=) :: From -> From -> Bool #

type Sql92FromExpressionSyntax From Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql92FromExpressionSyntax From = Expression

type Sql92FromTableSourceSyntax From Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql92FromTableSourceSyntax From = TableSource

data Value where Source #

Constructors

Value :: forall a. (Show a, Eq a, Typeable a) => a -> Value

Instances

Instances details

Show Value Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods showsPrec :: Int -> Value -> ShowS # show :: Value -> String # showList :: [Value] -> ShowS #
Eq Value Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods (==) :: Value -> Value -> Bool # (/=) :: Value -> Value -> Bool #
HasSqlValueSyntax Value SqlNull Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods sqlValueSyntax :: SqlNull -> Value Source #
HasSqlValueSyntax Value ByteString Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods sqlValueSyntax :: ByteString -> Value Source #
HasSqlValueSyntax Value Int16 Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods sqlValueSyntax :: Int16 -> Value Source #
HasSqlValueSyntax Value Int32 Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods sqlValueSyntax :: Int32 -> Value Source #
HasSqlValueSyntax Value Int64 Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods sqlValueSyntax :: Int64 -> Value Source #
HasSqlValueSyntax Value Word16 Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods sqlValueSyntax :: Word16 -> Value Source #
HasSqlValueSyntax Value Word32 Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods sqlValueSyntax :: Word32 -> Value Source #
HasSqlValueSyntax Value Word64 Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods sqlValueSyntax :: Word64 -> Value Source #
HasSqlValueSyntax Value Text Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods sqlValueSyntax :: Text -> Value Source #
HasSqlValueSyntax Value Day Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods sqlValueSyntax :: Day -> Value Source #
HasSqlValueSyntax Value UTCTime Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods sqlValueSyntax :: UTCTime -> Value Source #
HasSqlValueSyntax Value LocalTime Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods sqlValueSyntax :: LocalTime -> Value Source #
HasSqlValueSyntax Value TimeOfDay Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods sqlValueSyntax :: TimeOfDay -> Value Source #
HasSqlValueSyntax Value Integer Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods sqlValueSyntax :: Integer -> Value Source #
HasSqlValueSyntax Value String Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods sqlValueSyntax :: String -> Value Source #
HasSqlValueSyntax Value Bool Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods sqlValueSyntax :: Bool -> Value Source #
HasSqlValueSyntax Value Double Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods sqlValueSyntax :: Double -> Value Source #
(TypeError (PreferExplicitSize Int Int32) :: Constraint) => HasSqlValueSyntax Value Int Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods sqlValueSyntax :: Int -> Value Source #
(TypeError (PreferExplicitSize Word Word32) :: Constraint) => HasSqlValueSyntax Value Word Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods sqlValueSyntax :: Word -> Value Source #
HasSqlValueSyntax Value x => HasSqlValueSyntax Value (Maybe x) Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods sqlValueSyntax :: Maybe x -> Value Source #

data WindowFrame Source #

Constructors

WindowFrame
Fields windowFramePartitions :: Maybe [Expression] windowFrameOrdering :: Maybe [Ordering] windowFrameBounds :: Maybe WindowFrameBounds

Instances

Instances details

IsSql2003WindowFrameSyntax WindowFrame Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Associated Types

type Sql2003WindowFrameExpressionSyntax WindowFrame
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql2003WindowFrameExpressionSyntax WindowFrame = Expression
type Sql2003WindowFrameOrderingSyntax WindowFrame
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql2003WindowFrameOrderingSyntax WindowFrame = Ordering
type Sql2003WindowFrameBoundsSyntax WindowFrame
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql2003WindowFrameBoundsSyntax WindowFrame = WindowFrameBounds

Methods

frameSyntax :: Maybe [Sql2003WindowFrameExpressionSyntax WindowFrame] -> Maybe [Sql2003WindowFrameOrderingSyntax WindowFrame] -> Maybe (Sql2003WindowFrameBoundsSyntax WindowFrame) -> WindowFrame Source #

Show WindowFrame Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

showsPrec :: Int -> WindowFrame -> ShowS #

show :: WindowFrame -> String #

showList :: [WindowFrame] -> ShowS #

Eq WindowFrame Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

(==) :: WindowFrame -> WindowFrame -> Bool #

(/=) :: WindowFrame -> WindowFrame -> Bool #

type Sql2003WindowFrameBoundsSyntax WindowFrame Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql2003WindowFrameBoundsSyntax WindowFrame = WindowFrameBounds

type Sql2003WindowFrameExpressionSyntax WindowFrame Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql2003WindowFrameExpressionSyntax WindowFrame = Expression

type Sql2003WindowFrameOrderingSyntax WindowFrame Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql2003WindowFrameOrderingSyntax WindowFrame = Ordering

data WindowFrameBounds Source #

Constructors

WindowFrameBounds
Fields boundsFrom :: WindowFrameBound boundsTo :: Maybe WindowFrameBound

Instances

Instances details

IsSql2003WindowFrameBoundsSyntax WindowFrameBounds Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Associated Types

type Sql2003WindowFrameBoundsBoundSyntax WindowFrameBounds
Instance details Defined in Database.Beam.Backend.SQL.AST type Sql2003WindowFrameBoundsBoundSyntax WindowFrameBounds = WindowFrameBound

Methods

fromToBoundSyntax :: Sql2003WindowFrameBoundsBoundSyntax WindowFrameBounds -> Maybe (Sql2003WindowFrameBoundsBoundSyntax WindowFrameBounds) -> WindowFrameBounds Source #

Show WindowFrameBounds Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

showsPrec :: Int -> WindowFrameBounds -> ShowS #

show :: WindowFrameBounds -> String #

showList :: [WindowFrameBounds] -> ShowS #

Eq WindowFrameBounds Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

Methods

(==) :: WindowFrameBounds -> WindowFrameBounds -> Bool #

(/=) :: WindowFrameBounds -> WindowFrameBounds -> Bool #

type Sql2003WindowFrameBoundsBoundSyntax WindowFrameBounds Source #

Instance details

Defined in Database.Beam.Backend.SQL.AST

type Sql2003WindowFrameBoundsBoundSyntax WindowFrameBounds = WindowFrameBound

data WindowFrameBound Source #

Constructors

WindowFrameUnbounded
WindowFrameBoundNRows Int

Instances

Instances details

IsSql2003WindowFrameBoundSyntax WindowFrameBound Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods unboundedSyntax :: WindowFrameBound Source # nrowsBoundSyntax :: Int -> WindowFrameBound Source #
Show WindowFrameBound Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods showsPrec :: Int -> WindowFrameBound -> ShowS # show :: WindowFrameBound -> String # showList :: [WindowFrameBound] -> ShowS #
Eq WindowFrameBound Source #
Instance details Defined in Database.Beam.Backend.SQL.AST Methods (==) :: WindowFrameBound -> WindowFrameBound -> Bool # (/=) :: WindowFrameBound -> WindowFrameBound -> Bool #

DataTypeChar Bool (Maybe Word) (Maybe Text)
DataTypeNationalChar Bool (Maybe Word)
DataTypeBit Bool (Maybe Word)
DataTypeNumeric (Maybe (Word, Maybe Word))
DataTypeDecimal (Maybe (Word, Maybe Word))
DataTypeInteger
DataTypeSmallInt
DataTypeBigInt
DataTypeFloat (Maybe Word)
DataTypeReal
DataTypeDoublePrecision
DataTypeDate
DataTypeTime (Maybe Word) Bool
DataTypeTimeStamp (Maybe Word) Bool
DataTypeInterval ExtractField
DataTypeIntervalFromTo ExtractField ExtractField
DataTypeBoolean
DataTypeBinaryLargeObject
DataTypeCharacterLargeObject
DataTypeArray DataType Int
DataTypeRow [(Text, DataType)]
DataTypeDomain Text