Documentation

sampleCommands is for debugging purposes.

Column stores a column in a table as a list of its values along with the datatype and name of column

newColumn Returns new column (Maybe Column) First argument is name of column Second argument is datatype Third argument is list of values

Table stores a map of columns (key is column Name) with table name and list of names of columns

newTable returns new table (Maybe Table) First argument is table name Second argument is (list of colNames, Map of those colnames -> Columns)

Database stores a database with a name and map of tables indexed by their names

newDatabase returns new database (Maybe Database) First argument is datbase name Second argument map of tables indexed by their names

Datatype is for datatype in a column

containsTable is True if database contains table, o/w False First argument is tableName Second argument is database object (Maybe database)

containsColumn returns True if table within database contains a column, o/w false First argument is column name Second argument is database (Maybe Database) Third argument is table name

getTable returns table from database (Maybe Table) First argument is table name Second argument is database (Maybe Database)

count returns the number of entries in a table First argument is table (Maybe Table)

getColumn returns column in specific table of a database (Maybe Column) First argument is name of column (String) Second argument is table (Maybe Table)

addNewTable adds an empty table to database and returns new database (Maybe Database) First argument is tableName (String) Second argument is database (Maybe Database)

addColumnToTable adds a column to a table and returns new table (Table) First argument is column name (String) Second argument is column datatype (Datatype) Third argumenr is old table (Table)

addColumn adds a column to specific table in database and returns new database (Maybe Database) First argument is column name (String) Second argumenr is column datatype (Datatype) Third argumenr is database (Maybe Database) Fourth argumenr is table name (String)

insertOne inserts one entry in one column of one table in a database First argument is value (String) Second argument is it's datatype (Datatype) Third argument is old database (Maybe Database) Fourth argument is table name (String) Fifth argumenr is column name (String)

isValidDatatype checks if datatypes corresponding to column names list are in sync with the table in database or not. Returns true if they both conform First argumenr is table (Maybe Table) Second argument is list of column names [String] Third argument is list of datatypes [Datatype]

addPrimaryKeyToTable adds one primary key to a table First argument is a table (Table)

addPrimaryKey adds one primary key to table in database First argument is database (Maybe Database) Second argument is table name (String)

insert inserts an entry (row) in database -> table and returns new database First argumenr is list of colNames [String] Second argument is corresponding list of values [String] Third argumenr is corresponding list of datatypes [Datatype] Fourth argument old database (Maybe Database) Fifth argument is table name (String)

insertDefault inserts an entry in the default column order. This does not check for datatype as of now. First argument is list of values Second argument is old database Third argument is tableName

getColList is a Utility function for find*

findEntryAtIndex finds entry at index in table and returns as [tuples] where tuple = (col name, col type, col value) First argument is tableName Second argument is database Third argument is index

litValue is a utility function to support evaluation of ValueExpr on columns (which are stored as String)

find finds all entries in (db -> table) with value, datype and returns as [entries] where entry=[tuples] where tuple = (col name, col type, col value) First argument is value (Right) ValueExpr that evaluates to true or false Second argument is database (Maybe Database) Third argument is table name

deleteFromList is a utility function to delete an entry from a list

deleteEntryAtIndex deletes an entry from the table First argument is the index in table for the entry to be deleted Second argument is the database (Maybe Database) Third argument is table name

deleteEntryAtIndices is used to delete multiple entries from a specific table of a database First argument is list of indices [Int] Second argument is database (Maybe Database) Third argumenr is table name (String)

delete deletes all entries that follow a specific condition from a table First argument is condition Second argument is Maybe Database Third argument is table name (String)

orderBy orders the entries given by find based on the value given by expression First argument is the expression that gives the deciding value Second argument is the entrylist returned by find / select

select selects specific columns from the output of find/orderBy and returns list of entries with those columns only First argument is column alias (if new name of the columns is needed, then this is used). If this is empty, all columns with default names are returned Second argument is output of find/orderBy