Linux Shell Scripting Projects for Beginners – Address Database

Address Database is one of the BASH shell based Linux Shell Scripting Projects that is providing various operations to handle a particular database. Initially the data-base need to be pre-populated with some data for which the user will be provided with a set of commands (ex: add / modify / delete / search) using which he should be able to modify them. Practically database operations are performed in web applications whenever they are dealing with data. Popularly known as CRUD (Create / Read / Write / Delete) operations, they mainly help to deal with the backend database.  

The idea of this project is to implement an address book database management system using BASH Shell scripting and a local text based database. Along with this user functionality, this tool should record all the actions performed along with time-stamps for future references. Since the idea of this tool is to exposure SHELL programming, CSV file is used as a data-base storing entity. By implementing this project you will get a basic understanding of data-base operations, timeout handling, command parsing using various shell commands. By building this Linux Shell Scripting Projects you will be able to get a real feel of Automation and Application Development in Linux. 

Following are the requirements for this Linux Shell Scripting Project. They are categorized into various functional areas. 

• Activity log file:

1. 1. • Every activity while the script is to be logged in file named database .log.
      • Attach timestamp to every entry.

• Working environment settings:

1. 1. • Should create a directory called “Database” in user’s home directory structure tree, ECEP/LinuxSystems/Projects directory if it doesn’t exist.
      • Create a file named “database.csv” under Database directory if it doesn’t exist.
      • Check the existence of at least one valid data entry in database.csv.
      • If the file is empty, script should only prompt for data addition unless and until it gets a valid entry to display.

• User interface:

1. • The script should have the following functionalities as listed below

1. Add Entry
2. Search / Edit Entry

• Add Entry:

When the user selects the “Add Entry” option it should have the following fields to be added

• Name

1. Accept the user entry in any case but convert it to sentence case while storing.
2. Accept only alphabets and spaces

• E-mail

1. Accept only symbols like “.”, “_”, alphabets, and numbers. Validate for “@” and a “.” after it

• Telephone Number

1. Accept only numbers

• Mobile Number

1. Add country code (assume Indian customers)
2. Validate for 10 digit entry
3. Accept only numbers

• Place

1. Accept the user entry in any case but convert it to sentence case while storing
2. Accept only alphabets and spaces

• Message

1. Any character allowed
2. No formatting has to be done, user entry has to be captured as is.
3. Proper formatted output

When the user finishes all the above fields the information has to be stored with current “date” and “time” automatically

• Time-out:

The script should time out if the user input is absent for more than 10 seconds.

1. CRUD operations in Database
2. Commands for parsing given inputs
3. Online GDB
4. Download project document in PDF format