GO4SQL

README

GO4SQL

GO4SQL is an open source project to write in-memory SQL engine using nothing but Golang.

HOW TO USE

You can compile the project with go build, this will create GO4SQL binary. You can eithier specify file path with ./GO4SQL -file file_path, that will read the the input data directly into the program. Also with ./GO4SQL -stream you can run the program in stream mode, then you provide SQL commands in your console (from standard input).

FUNCTIONALITY

• CREATE TABLE - you can create table with name table1 using command: CREATE TABLE table1( one TEXT , two INT);. First column is called one and it contains strings, second one is called two and it contains integers.
• INSERT INTO - you can insert values into table called table1 with command INSERT INTO table1 VALUES( 'hello', 1);. Please note that the number or arguments and types of the values must be the same as you declared.
• SELECT FROM - you can either select everything from table1 with SELECT * FROM table1; command. Or you can specify column names that you're intrest in: SELECT one, two FROM table1;, note that culumn names must be the same as you declared and duplicated column names will be ignored.

UNIT TESTS

To run all the tests locally use "go clean -testcache; go test ./..." in root directory.