Restore tienluong db from dump/snapshot file (stored in S3)

setup-tienluong-db.py

#!/usr/bin/env bash
# Run this script to prepare DB for "prod" profile.
# Require environment variable:
# AWS_ACCESS_KEY_ID
# AWS_SECRET_ACCESS_KEY
set -e

BUCKET=dtcorpbackup

echo "Get latest backup"
OBJECT="$(aws s3 ls $BUCKET --recursive | sort | tail -n 1 | awk '{print $4}')"
aws s3 cp s3://$BUCKET/$OBJECT $OBJECT

echo "Restore DB to latest backup"
cat $OBJECT | docker exec -i tienluong-db  psql -U postgres 
rm $OBJECT