Database.TxtSushi.SQLExpression

SQL Expressions

Documentation

allMaybeTableNames :: Maybe TableExpression -> [String]

convenience function for extracting all of the table names used by the given table expression

data SelectStatement

represents a select statement TODO this should be moved inside the TableExpression type

Constructors

SelectStatement

Fields

columnSelections :: [ColumnSelection]

maybeFromTable :: Maybe TableExpression

maybeWhereFilter :: Maybe Expression

maybeGroupByHaving :: Maybe ([Expression], Maybe Expression)

orderByItems :: [OrderByItem]

data TableExpression

Constructors

TableIdentifier

Fields

tableName :: String

maybeTableAlias :: Maybe String

InnerJoin

Fields

leftJoinTable :: TableExpression

rightJoinTable :: TableExpression

onCondition :: Expression

maybeTableAlias :: Maybe String

OuterJoin

Fields

leftJoinTable :: TableExpression

rightJoinTable :: TableExpression

onCondition :: Expression

maybeTableAlias :: Maybe String

CrossJoin

Fields

leftJoinTable :: TableExpression

rightJoinTable :: TableExpression

maybeTableAlias :: Maybe String

SelectExpression

Fields

selectStatement :: SelectStatement

maybeTableAlias :: Maybe String

data ColumnIdentifier

Constructors

ColumnIdentifier

Fields

maybeTableName :: Maybe String

columnId :: String

Instances

Eq ColumnIdentifier

data ColumnSelection

Constructors

AllColumns

AllColumnsFrom

Fields

sourceTableName :: String

ExpressionColumn

Fields

expression :: Expression

maybeColumnAlias :: Maybe String

ExpressionColumnRange

Fields

binding :: ColumnIdentifier

range :: ColumnRange

expression :: Expression

data Expression

Constructors

FunctionExpression

Fields

sqlFunction :: SQLFunction

functionArguments :: [Expression]

stringRepresentation :: String

ColumnExpression

Fields

column :: ColumnIdentifier

stringRepresentation :: String

StringConstantExpression

Fields

stringConstant :: String

stringRepresentation :: String

IntConstantExpression

Fields

intConstant :: Int

stringRepresentation :: String

RealConstantExpression

Fields

realConstant :: Double

stringRepresentation :: String

BoolConstantExpression

Fields

boolConstant :: Bool

stringRepresentation :: String

data SQLFunction

Constructors

SQLFunction

Fields

functionName :: String

minArgCount :: Int

argCountIsFixed :: Bool

functionGrammar :: String

functionDescription :: String

applyFunction :: [EvaluatedExpression] -> EvaluatedExpression

data OrderByItem

Constructors

OrderByItem

Fields

orderExpression :: Expression

orderAscending :: Bool

data ColumnRange

Constructors

ColumnRange

Fields

maybeStart :: Maybe ColumnIdentifier

maybeEnd :: Maybe ColumnIdentifier

isAggregate :: SQLFunction -> Bool

an aggregate function is one whose min function count is 1 and whose arg count is not fixed

selectStatementContainsAggregates :: SelectStatement -> Bool

expressionToString :: Expression -> String

columnToString :: ColumnIdentifier -> String