Safe Haskell	Safe-Inferred
Language	Haskell2010

Lsql.Csv.Core.Functions

Description

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

Synopsis

data Arg
- = Function Function
- | Symbol String
- | Value Value
data Function
- = AritmeticF AritmeticF
- | AggregateF AggregateF
- | LogicF LogicF
data AritmeticF
- = 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
- = And Arg Arg
- | Or Arg Arg
- | Not Arg
data AggregateF
- = Cat [Arg]
- | Sum [Arg]
- | Avg [Arg]
- | Count [Arg]
- | Min [Arg]
- | Max [Arg]
data Printable
- = ColumnP Column
- | ValueP Value
genStrCols :: [Printable] -> [[String]]
getCols :: [Printable] -> [Column]
getTable :: [String] -> [Printable] -> Table
printTable :: Table -> [Printable]
unionAggCols :: [[Printable]] -> [Printable]
appendArg :: Arg -> Arg -> Arg
catterate :: [Arg] -> Arg
eval :: SymbolMap -> Arg -> Printable
evalAggregateFunctions :: SymbolMap -> Arg -> Arg
containsAggregateF :: Arg -> Bool

Documentation

data Arg Source #

A syntax tree element

Constructors

Function Function	A call of function
Symbol String	A reference to a column
Value Value	A constant

data Function Source #

A syntax tree element

Constructors

AritmeticF AritmeticF	An arithmetic function
AggregateF AggregateF	An aggregate function
LogicF LogicF	A logical function

data AritmeticF Source #

A 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 Source #

A syntax tree element

Constructors

And Arg Arg
Or Arg Arg
Not Arg

data AggregateF Source #

A syntax tree element

Constructors

Cat [Arg]
Sum [Arg]
Avg [Arg]
Count [Arg]
Min [Arg]
Max [Arg]

data Printable Source #

A data type for a single Column or a single Arg

Constructors

ColumnP Column
ValueP Value

Instances

Instances details

Show Printable Source #
Instance details Defined in Lsql.Csv.Core.Functions Methods showsPrec :: Int -> Printable -> ShowS # show :: Printable -> String # showList :: [Printable] -> ShowS #
Eq Printable Source #
Instance details Defined in Lsql.Csv.Core.Functions Methods (==) :: Printable -> Printable -> Bool # (/=) :: Printable -> Printable -> Bool #
Ord Printable Source #
Instance details 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]] Source #

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

getCols :: [Printable] -> [Column] Source #

Converts a list of Printable to a list of Column.

getTable Source #

Arguments

:: [String]	The names of the table
-> [Printable]	The columns of the table
-> Table

Converts a list of Printable to a Table.

printTable :: Table -> [Printable] Source #

Converts a Table to a list of ColumnP Printables.

unionAggCols :: [[Printable]] -> [Printable] Source #

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

appendArg :: Arg -> Arg -> Arg Source #

Appends two arguments together.

catterate :: [Arg] -> Arg Source #

Appends a list of arguments together.

eval :: SymbolMap -> Arg -> Printable Source #

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

evalAggregateFunctions :: SymbolMap -> Arg -> Arg Source #

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

containsAggregateF :: Arg -> Bool Source #

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