Craft Beer Brewery Database - Project Description

ABC Craft Beers new database management system, which hopes to enhance resource efficiency, customer order tracking, and the brewing processes.

Project Resources:

 

 

Run Locally

Clone the project

  git clone https://github.com/CrafDb-Team/crafdb

Go to the project directory

  cd crafdb

Install liquibase

  wget -O- https://repo.liquibase.com/liquibase.asc | gpg --dearmor > liquibase-keyring.gpg && \
  cat liquibase-keyring.gpg | sudo tee /usr/share/keyrings/liquibase-keyring.gpg > /dev/null && \
  echo 'deb [arch=amd64 signed-by=/usr/share/keyrings/liquibase-keyring.gpg] https://repo.liquibase.com stable main' | sudo tee /etc/apt/sources.list.d/liquibase.list

Create a liquibase.properties file

  echo "changelog-file: <changelog_file>" >> liquibase.properties
  echo "url: jdbc:postgresql://<db_url>:<port>/<db_name>" >> liquibase.properties
  echo "username: <db_username>" >> liquibase.properties
  echo "password: <db_password>" >> liquibase.properties

Run migration

  liquibase update