Safe Haskell	Safe-Inferred
Language	Haskell2010

Lsql.Csv.Core.Tables

Description

This module contains the definition of Value, Table, and Column, classes over them, and functions 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] The table names [Column] The columns of the 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 #

A single column of a table

Constructors

Column
Fields [String] The names of the column [Value] The 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 #

The 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]	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 Source #

Cross joins two Tables into one.

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

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

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

Sorts a Table according to given Columns.

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

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

Returns Table with same metadata as the 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 a Column.

showColumn :: Column -> [String] Source #

Converts Column to the list of String from its data.

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

A function for applying a single argument function to a Column

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

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

class Boolable a where Source #

Class for converting a value to a 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 #