HaSSQL-1.0.0: Haskell Simple Structured Query Language

Usage and Syntax

Create Table

create table <table_name> (<column_name> <datatype> ,<column_name> <datatype> ... )

Insert Record

insert into <table_name> (<column_name>,<column_name> ...) values (<value>, <value> ...)

To add entries in columns by default:

insert into <table_name> values (<value>, <<>value> ...)

Delete records

insert into <table_name> (<column_name>,<column_name> ...) values (<value>, <value> ...)

Select records

select <column_name> as <alias>, <column_name> as <alias> ... from <table_name> where <value_expession> order by <value_expession>, <value_expession> ...

select <column_name> <alias>, <column_name> <alias> ... from <table_name> where <value_expession> order by <value_expession>, <value_expession> ...

To select all columns:

select * from <table_name> where <value_expession> order by <value_expession>, <value_expession> ...<

Displaying the whole database instance

output

Exiting:

exit

Please see the README on GitHub at https://github.com/IITH-SBJoshi/haskell-8#readme

Modules

CreateParser contains functions to parse CREATE query and evaluate it.
Database The core module which manages all the data.
DeleteParser contains functions to parse DELETE query and evaluate it.
ExpressionParser contains functions to parse expressions and evaluate them.
Funcs Contains standard parsers for building up other parsers
InsertParser contains functions to parse INSERT query and evaluate it.
QueryParser contains functions to parse SELECT query and evaluate it.
SQLParser Integrate all SQL statements into a single module