Lsql.Csv.Core.Tables

This module contains the definition of Value, Table, and Column, class instancies over them, functions for manipulation of them, and Boolable class definition.

Documentation

data Table

A single table of data

Constructors

Table

Fields

• [String]

  The table names

• [Column]

  The columns of the table

Instances

Show Table

Defined in Lsql.Csv.Core.Tables

Methods

showsPrec :: Int -> Table -> ShowS

show :: Table -> String

showList :: [Table] -> ShowS

data Column

A single column of a table

Constructors

Column

Fields

• [String]

  The names of the column

• [Value]

  The values of the column

Instances

Show Column

Defined in Lsql.Csv.Core.Tables

Methods

showsPrec :: Int -> Column -> ShowS

show :: Column -> String

showList :: [Column] -> ShowS

Eq Column

Defined in Lsql.Csv.Core.Tables

Methods

(==) :: Column -> Column -> Bool

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

Ord Column

Defined in Lsql.Csv.Core.Tables

Methods

compare :: Column -> Column -> Ordering

(<) :: Column -> Column -> Bool

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

(>) :: Column -> Column -> Bool

(>=) :: Column -> Column -> Bool

max :: Column -> Column -> Column

min :: Column -> Column -> Column

data Value

The representation of data in Tables

Constructors

IntValue Int

StringValue String

DoubleValue Double

BoolValue Bool

Instances

Enum Value

Defined in Lsql.Csv.Core.Tables

Methods

succ :: Value -> Value

pred :: Value -> Value

toEnum :: Int -> Value

fromEnum :: Value -> Int

enumFrom :: Value -> [Value]

enumFromThen :: Value -> Value -> [Value]

enumFromTo :: Value -> Value -> [Value]

enumFromThenTo :: Value -> Value -> Value -> [Value]

Floating Value

Defined in Lsql.Csv.Core.Tables

Methods

pi :: Value

exp :: Value -> Value

log :: Value -> Value

sqrt :: Value -> Value

(**) :: Value -> Value -> Value

logBase :: Value -> Value -> Value

sin :: Value -> Value

cos :: Value -> Value

tan :: Value -> Value

asin :: Value -> Value

acos :: Value -> Value

atan :: Value -> Value

sinh :: Value -> Value

cosh :: Value -> Value

tanh :: Value -> Value

asinh :: Value -> Value

acosh :: Value -> Value

atanh :: Value -> Value

log1p :: Value -> Value

expm1 :: Value -> Value

log1pexp :: Value -> Value

log1mexp :: Value -> Value

Num Value

Defined in Lsql.Csv.Core.Tables

Methods

(+) :: Value -> Value -> Value

(-) :: Value -> Value -> Value

(*) :: Value -> Value -> Value

negate :: Value -> Value

abs :: Value -> Value

signum :: Value -> Value

fromInteger :: Integer -> Value

Fractional Value

Defined in Lsql.Csv.Core.Tables

Methods

(/) :: Value -> Value -> Value

recip :: Value -> Value

fromRational :: Rational -> Value

Integral Value

Defined in Lsql.Csv.Core.Tables

Methods

quot :: Value -> Value -> Value

rem :: Value -> Value -> Value

div :: Value -> Value -> Value

mod :: Value -> Value -> Value

quotRem :: Value -> Value -> (Value, Value)

divMod :: Value -> Value -> (Value, Value)

toInteger :: Value -> Integer

Real Value

Defined in Lsql.Csv.Core.Tables

Methods

toRational :: Value -> Rational

RealFrac Value

Defined in Lsql.Csv.Core.Tables

Methods

properFraction :: Integral b => Value -> (b, Value)

truncate :: Integral b => Value -> b

round :: Integral b => Value -> b

ceiling :: Integral b => Value -> b

floor :: Integral b => Value -> b

Show Value

Defined in Lsql.Csv.Core.Tables

Methods

showsPrec :: Int -> Value -> ShowS

show :: Value -> String

showList :: [Value] -> ShowS

Eq Value

Defined in Lsql.Csv.Core.Tables

Methods

(==) :: Value -> Value -> Bool

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

Ord Value

Defined in Lsql.Csv.Core.Tables

Methods

compare :: Value -> Value -> Ordering

(<) :: Value -> Value -> Bool

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

(>) :: Value -> Value -> Bool

(>=) :: Value -> Value -> Bool

max :: Value -> Value -> Value

min :: Value -> Value -> Value

Boolable Value

Defined in Lsql.Csv.Core.Tables

Methods

getBool :: Value -> Bool

buildTable

Arguments

:: [String]

The names of the table

-> [[String]]

The names of the columns

-> [[Value]]

The rows of the table

-> Table

The result table

Makes a table out of rows of Value.

crossJoinTable :: Table -> Table -> Table

Cross joins two Tables into one.

filterTable :: Column -> Table -> Table

Filters out rows, where the Column is False. The rows, where the Column is True, are kept.

sortTable :: [Column] -> Table -> Table

Sorts a Table according to given Columns.

byTable :: [Column] -> Table -> [Table]

Splits a Table into multiple Tables so that rows of Columns at first argument are at each Table the same and the number of Tables is minimal. (factorization)

emptyTable :: Table -> Table

Returns Table with same metadata as the original Table, but no data (no rows).

columnNames :: Table -> [([String], Column)]

Returns pairs of names of Column and Column itself of the table.

columnValue :: Column -> [Value]

Returns all values of a Column.

showColumn :: Column -> [String]

Converts Column to the list of String from its data.

applyOp :: (Value -> Value) -> Column -> Column

A function for applying a single argument function to a Column

applyInOp :: (Value -> Value -> Value) -> Column -> Column -> Column

A function for applying a two-argument function to two Columns

class Boolable a where

Class for converting a value to a Bool

Methods

getBool :: a -> Bool

Instances

Boolable Value

Defined in Lsql.Csv.Core.Tables

Methods

getBool :: Value -> Bool