SQL

Simple relational database written in Rust.

Todo

1. Add supported types
2. Fix side effects of altering the table columns

Commands

Database

1. Create new database

   CREATE DATABASE <DB_NAME>;

2. Drop database

   DROP DATABASE <DB_NAME>;

3. Switch database

   USE DATABASE <DB_NAME>;

Tables

1. Create table

   CREATE TABLE <TABLE_NAME> (
    column1 datatype,
    column2 datatype,
    column3 datatype,
   ....
   );

2. Drop table

   DROP TABLE <TABLE_NAME>;

3. Truncate table

   TRUNCATE TABLE <TABLE_NAME>;

4. Alter table

   • ADD Column

     ALTER TABLE table_name
     ADD <COL_NAME> datatype;

   • DROP COLUMN

     ALTER TABLE table_name
     DROP COLUMN column_name;

   • ALTER/MODIFY COLUMN

     ALTER TABLE table_name
     ALTER COLUMN column_name datatype;

Queries

Select

SELECT column1, column2, ...
FROM table_name;

SELECT * FROM table_name;

Insert

INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);

INSERT INTO table_name
VALUES (value1, value2, value3, ...);

Update

UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;

Delete

DELETE FROM table_name WHERE condition;

Supported Data Types

pub enum DataType {
    // Numeric datatypes
    INTEGER,
    INT,
    FLOAT,
    DEC,
    // String datatypes
    TEXT,
    VARCHAR(usize),
    ENUM(Vec<String>),
    // Bools
    BOOLEAN,
    BOOL,
}