A PostgreSQL powered database with quality of life data.
export DATABASE_FILE=database.sql
export DATABASE_LOCAL=map
git pull origin master
psql -d $DATABASE_LOCAL -f $DATABASE_FILESet environmental variables.
export APP="cs467-map-server"
export DATABASE_FILE=database.sql
export DATABASE_LOCAL=map
export DATABASE_URL=postgres://$(whoami)@localhost/$DATABASE_LOCALUpdate local database
psql -d $DATABASE_LOCAL -f $DATABASE_FILEdropdb $DATABASE_LOCAL
heroku pg:pull DATABASE_URL $DATABASE_LOCAL --app $APPheroku pg:reset --confirm $APP --app $APP
heroku pg:push $DATABASE_LOCAL DATABASE_URL --app $APP# crate a database user
createuser --interactive
# create a database
createdb COOL_DATABASE
# access database
psql -d COOL_DATABASE- https://www.postgresql.org/
- https://www.postgresql.org/docs/
- https://wiki.archlinux.org/index.php/PostgreSQL
- https://devcenter.heroku.com/articles/heroku-postgresql#connecting-in-node-js
The database is updated everytime a push is made to the master branch. Build commands are defined in the Jenkinsfile, and build results can be viewed at either of the following URL's.
