Lsql.Csv.Core.Functions

This module contains the syntactic tree definition and helper functions for its evaluation.

Documentation

data Arg

Syntax tree element

Constructors

Function Function

Call of function

Symbol String

Reference to a column

Value Value

Constant

data Function

Syntax tree element

Constructors

AritmeticF AritmeticF

Arithmetic function

AggregateF AggregateF

Aggregate function

LogicF LogicF

Logical function

data AritmeticF

Syntax tree element

Constructors

Sin Arg

Cos Arg

Tan Arg

Asin Arg

Acos Arg

Atan Arg

Sinh Arg

Cosh Arg

Tanh Arg

Asinh Arg

Acosh Arg

Atanh Arg

Exp Arg

Sqrt Arg

Size Arg

ToString Arg

Append Arg Arg

Round Arg

Truncate Arg

Ceiling Arg

Floor Arg

MinusS Arg

Abs Arg

Signum Arg

Negate Arg

Plus Arg Arg

Minus Arg Arg

Multiply Arg Arg

Divide Arg Arg

Power Arg Arg

Even Arg

Odd Arg

NaturalPower Arg Arg

Div Arg Arg

Quot Arg Arg

Rem Arg Arg

Mod Arg Arg

Gcd Arg Arg

Lcm Arg Arg

Less Arg Arg

LessOrEqual Arg Arg

More Arg Arg

MoreOrEqual Arg Arg

Equal Arg Arg

NotEqual Arg Arg

LeftOuterJoin Arg Arg

In Arg Arg

data LogicF

Syntax tree element

Constructors

And Arg Arg

Or Arg Arg

Not Arg

data AggregateF

Syntax tree element

Constructors

Cat [Arg]

Sum [Arg]

Avg [Arg]

Count [Arg]

Min [Arg]

Max [Arg]

data Printable

Data type for single Column or single Arg

Constructors

ColumnP Column

ValueP Value

Instances

Show Printable

Defined in Lsql.Csv.Core.Functions

Methods

showsPrec :: Int -> Printable -> ShowS

show :: Printable -> String

showList :: [Printable] -> ShowS

Eq Printable

Defined in Lsql.Csv.Core.Functions

Methods

(==) :: Printable -> Printable -> Bool

(/=) :: Printable -> Printable -> Bool

Ord Printable

Defined in Lsql.Csv.Core.Functions

Methods

compare :: Printable -> Printable -> Ordering

(<) :: Printable -> Printable -> Bool

(<=) :: Printable -> Printable -> Bool

(>) :: Printable -> Printable -> Bool

(>=) :: Printable -> Printable -> Bool

max :: Printable -> Printable -> Printable

min :: Printable -> Printable -> Printable

genStrCols :: [Printable] -> [[String]]

Converts list of Printable to list of String columns Useful for generating CSV output

getCols :: [Printable] -> [Column]

Converts list of Printable to list of Column

getTable

Arguments

:: [String]

Names of table

-> [Printable]

Columns of the table

-> Table

Converts list of Printable to a Table

printTable :: Table -> [Printable]

Converts table to list of ColumnP Printables

unionAggCols :: [[Printable]] -> [Printable]

Unions multiple first lines of lists of [Printable] into one Printable

appendArg :: Arg -> Arg -> Arg

Appends two arguments together

catterate :: [Arg] -> Arg

Appends list of arguments together

eval :: SymbolMap -> Arg -> Printable

Evaluates all nonagregate functions to Printable. Fails on aggregate function.

evalAggregateFunctions :: SymbolMap -> Arg -> Arg

Evaluates all aggregate functions. Normal functions are not evaluated if not called under other aggregate function.

containsAggregateF :: Arg -> Bool

Runs through the syntactic tree and check, whether it contains aggregate function.