Database migration & rollback

Two simple bash scripts for migrating the database to a new state and rolling it back to its initial state.

Requirements

• psql
• Linux distro or MacOS

Installation

Use the following commands to download and set up the scripts:

git clone https://github.com/ADA-GWU/a1-db-migration-ismayilkarimli.git $HOME/a1-db-migration-ismayilkarimli
chmod 755 $HOME/a1-db-migration-ismayilkarimli/*

Usage

Migration script:

$HOME/a1-db-migration-ismayilkarimli/migration.sh [database name]

Rollback script:

$HOME/a1-db-migration-ismayilkarimli/rollback.sh [database name]

Example:

$HOME/a1-db-migration-ismayilkarimli/migration.sh db4586
$HOME/a1-db-migration-ismayilkarimli/rollback.sh db4586

Note:

If you do not have the required database, you can create it by running the following command (ensure that there is no database with name db4586):

psql -U postgres -f $HOME/a1-db-migration-ismayilkarimli/create_db.sql