Safe Haskell	Safe-Inferred
Language	Haskell2010

Lsql.Csv.Core.Tables

Description

This module contains the definition of Lsql datatypes, their classes, and types Table and Column and functions over them for manipulation of them.

Synopsis

data Table = Table [String] [Column]
data Column = Column [String] [Value]
data Value
- = IntValue Int
- | StringValue String
- | DoubleValue Double
- | BoolValue Bool
buildTable :: [String] -> [[String]] -> [[Value]] -> Table
crossJoinTable :: Table -> Table -> Table
filterTable :: Column -> Table -> Table
sortTable :: [Column] -> Table -> Table
byTable :: [Column] -> Table -> [Table]
emptyTable :: Table -> Table
columnNames :: Table -> [([String], Column)]
columnValue :: Column -> [Value]
showColumn :: Column -> [String]
applyOp :: (Value -> Value) -> Column -> Column
applyInOp :: (Value -> Value -> Value) -> Column -> Column -> Column
class Boolable a where
- getBool :: a -> Bool

Documentation

data Table Source #

A single table of data

Constructors

Table
Fields [String] Table names [Column] Columns of a table

Instances

Instances details

Show Table Source #
Instance details Defined in Lsql.Csv.Core.Tables Methods showsPrec :: Int -> Table -> ShowS # show :: Table -> String # showList :: [Table] -> ShowS #

data Column Source #

Single column of table

Constructors

Column
Fields [String] Names of the column [Value] Values of the column

Instances

Instances details

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

Representation of data in tables

Constructors

IntValue Int
StringValue String
DoubleValue Double
BoolValue Bool

Instances

Instances details

Enum Value Source #
Instance details 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 Source #
Instance details 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 Source #
Instance details 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 Source #
Instance details Defined in Lsql.Csv.Core.Tables Methods (/) :: Value -> Value -> Value # recip :: Value -> Value # fromRational :: Rational -> Value #
Integral Value Source #
Instance details 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 Source #
Instance details Defined in Lsql.Csv.Core.Tables Methods toRational :: Value -> Rational #
RealFrac Value Source #
Instance details 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 Source #
Instance details Defined in Lsql.Csv.Core.Tables Methods showsPrec :: Int -> Value -> ShowS # show :: Value -> String # showList :: [Value] -> ShowS #
Eq Value Source #
Instance details Defined in Lsql.Csv.Core.Tables Methods (==) :: Value -> Value -> Bool # (/=) :: Value -> Value -> Bool #
Ord Value Source #
Instance details 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 Source #
Instance details Defined in Lsql.Csv.Core.Tables Methods getBool :: Value -> Bool Source #

buildTable Source #

Arguments

:: [String]	Names of the table
-> [[String]]	Names of columns
-> [[Value]]	Rows of the table
-> Table	Result table

Makes table out of rows of Value

crossJoinTable :: Table -> Table -> Table Source #

Cross joins two tables into one.

filterTable :: Column -> Table -> Table Source #

Filters out rows, where Column is false. The rows, where Column is true, are kept.

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

Sorts the table according to the given columns.

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

Splits the table into multiple tables so that rows of columns at first argument are at each table the same and number of tables is minimal. (factorization)

emptyTable :: Table -> Table Source #

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

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

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

columnValue :: Column -> [Value] Source #

Returns all values of the Column

showColumn :: Column -> [String] Source #

Converts column to list of string from its data

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

Function for applying single argument function to Column

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

Function for applying two argument function to two Columns

class Boolable a where Source #

Class for converting a value to Bool

Methods

getBool :: a -> Bool Source #

Instances

Instances details

Boolable Value Source #
Instance details Defined in Lsql.Csv.Core.Tables Methods getBool :: Value -> Bool Source #