DBMS-Bash Scripting

Implementing a databases management system using Bash Shell scripting
Explore the docs »

View Demo · Report Bug · Request Feature

From the Main menu you can do the following :

• Create Database
• List Datebases
• Connect Database
• Drop Database

After Creating a Database you can do the following :

• Create Table
• List Tables
• Drop Table
• Insert into Table
• Select From Table
• Delete From Table
• Update Table
• Export Table
• Back to main menu
• Exit

• You must enter number of columns
• Add name for each column
• Select data type for column
• Choose one column as Primay Key (If You didn't choose by default last column will be the Primay Key)

• You must enter data for Primary Key can not be empty
• You must enter valid data as data type
• You can leave non-primary column empty

• Select All table
• Select Column
• Select Row by statment

• Delete All table
• Delete Column
• Delete Rows by statment

• Update Column
• Update Rows by statment

• Export All
• Export Column
• Export Rows by statment

You should use any linux distribution (redhat, ubuntu,etc..)

Either clone this repository or fork it on GitHub and clone your fork:

git clone https://github.com/mustafaabdelbadea/DBMS-Bash-Scripting.git
cd DBMS-ShellScript

• Run the application

  chmod u+x ./dbms.sh
  chmod u+x ./colors.sh
  ./dbms.sh
  

Mustafa Abdelbadea - @mustafaabdelbadea - [email protected]
Adham Gaber - @AdhamGaber

Project Link: https://github.com/mustafaabdelbadea/DBMS-Bash-Scripting