Portability	portable
Stability	experimental
Maintainer	keithshep@gmail.com

Database.TxtSushi.SQLParser

Description

Module for parsing SQL

Synopsis

Documentation

allMaybeTableNames :: Maybe TableExpression -> [String]Source

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

parseSelectStatement :: GenParser Char st SelectStatement Source

Parses a SQL select statement

data SelectStatement Source

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]

Instances

Eq SelectStatement
Ord SelectStatement
Show SelectStatement

data TableExpression Source

Constructors

TableIdentifier
Fields tableName :: String maybeTableAlias :: Maybe String
InnerJoin
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

Instances

Eq TableExpression
Ord TableExpression
Show TableExpression

data ColumnIdentifier Source

Constructors

ColumnIdentifier
Fields maybeTableName :: Maybe String columnId :: String

Instances

Eq ColumnIdentifier
Ord ColumnIdentifier
Show ColumnIdentifier

prettyFormatColumn :: ColumnIdentifier -> String Source

I wanted to leave the default Show, but I also wanted a pretty print, so here it is!

data ColumnSelection Source

Constructors

AllColumns
AllColumnsFrom
Fields sourceTableName :: String
ExpressionColumn
Fields expression :: Expression maybeColumnAlias :: Maybe String

Instances

Eq ColumnSelection
Ord ColumnSelection
Show ColumnSelection

expressionIdentifier :: Expression -> ColumnIdentifier Source

data Expression Source

Constructors

FunctionExpression
Fields sqlFunction :: SQLFunction functionArguments :: [Expression]
ColumnExpression
Fields column :: ColumnIdentifier
StringConstantExpression
Fields stringConstant :: String
IntegerConstantExpression
Fields intConstant :: Int
RealConstantExpression
Fields realConstant :: Double

Instances

Eq Expression
Ord Expression
Show Expression

data OrderByItem Source

Constructors

OrderByItem
Fields orderExpression :: Expression orderAscending :: Bool

Instances

Eq OrderByItem
Ord OrderByItem
Show OrderByItem

prettyFormatWithArgs :: SQLFunction -> [Expression] -> String Source

data SQLFunction Source

Constructors

SQLFunction
Fields functionName :: String minArgCount :: Int argCountIsFixed :: Bool

Instances

Eq SQLFunction
Ord SQLFunction
Show SQLFunction

withTrailing :: Monad m => m a -> m b -> m bSource

withoutTrailing :: Show s => GenParser tok st s -> GenParser tok st a -> GenParser tok st aSource

isAggregate :: SQLFunction -> Bool Source

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

selectStatementContainsAggregates :: SelectStatement -> Bool Source

avgFunction :: SQLFunction Source

countFunction :: SQLFunction Source

firstFunction :: SQLFunction Source

lastFunction :: SQLFunction Source

maxFunction :: SQLFunction Source

minFunction :: SQLFunction Source

sumFunction :: SQLFunction Source

concatenateFunction :: SQLFunction Source

absFunction :: SQLFunction Source

upperFunction :: SQLFunction Source

lowerFunction :: SQLFunction Source

trimFunction :: SQLFunction Source

substringFromFunction :: SQLFunction Source

SUBSTRING(extraction_string FROM starting_position [FOR length] [COLLATE collation_name]) TODO implement COLLATE part

substringFromToFunction :: SQLFunction Source

multiplyFunction :: SQLFunction Source

divideFunction :: SQLFunction Source

plusFunction :: SQLFunction Source

minusFunction :: SQLFunction Source

negateFunction :: SQLFunction Source

isFunction :: SQLFunction Source

isNotFunction :: SQLFunction Source

lessThanFunction :: SQLFunction Source

lessThanOrEqualToFunction :: SQLFunction Source

greaterThanFunction :: SQLFunction Source

greaterThanOrEqualToFunction :: SQLFunction Source

andFunction :: SQLFunction Source

orFunction :: SQLFunction Source

notFunction :: SQLFunction Source

regexMatchFunction :: SQLFunction Source

maybeReadInt :: String -> Maybe Int Source

returns an int if it can be read from the string

maybeReadReal :: String -> Maybe Double Source

returns a real if it can be read from the string