Please feel free to communicate with us in anytime :)
In this project we are trying to demonstrate some core features in bash scripting such as:
- sourcing in bash
- awk in bash
- sed in bash
- Make sure to set the project path in .bashrc
export PATH=$PATH:/"project_path_inside_your_machine"- Make sure that all files has the execution premission
- In your local terminal type the following:
MainMenu.shBasically there are two levels:
- Upperlayer level
- Database level
- Table level
First, the engine will create a directory Called "DB" and this is the upper layer directory which will store database directories. Second, the database directories which will contains the tables. Third, the tables level, in every table creation in DBMS, the engine will actually create two files:
- MetaData file
- Data file
- It represents table schema informations like (column names, type of that column(String, Integer), which column is the primary key)
- It represents the actual data stored by you
In this engine we offer one primary key for every single table, composite primary keys are not yet available
- You will have two menus
| Create Database | Create a directory to store tables |
| Connect to Database | Once you type the database name, system will check if database's dirctory is existed or not, if it is there, engine will enter to the table menu |
| Show Databases | Simply display all Database directories |
| Drop Database | In case you want to remove a specific Database, once you type the database name it removes its directory |
| Exit | A Safe exit from the engine |
| Create New Table | Create a new table inside the existing database directory |
| List Tables | Simply display all tables names |
| Drop Table | In case you want to remove an existing table, once you type the database name it removes its directory |
| Insert Into Table | Just like any database engine if you want to add new record to the table, you just specify all values base on table schema |
| Select From Table | you have multiple options in case you want to see the data (1- All records 2-Specific Column 3-Specifc Column 4-With Condition |
| Delete From Table | delete a record inside a specific table based on a column value |
| Update Table | Edit any record based on any column and set the new value |
| Exit | A Safe exit from the table menu and get back to database menu |