Database.TxtSushi.SQLParser

Module for parsing SQL

Documentation

parseSelectStatement :: GenParser Char st SelectStatement

Parses a SQL select statement

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