TRAKT V1.2

Website built using Django + React via webpack.

Running Locally

Setup gcloud account and credentials

gcloud lives in ~/.config/gcloud/ all your authentication credentials can be found in that folder. The following commands are meant to ensure you have all necessary creds to either deploy or run the app locally. Use gcloud config list to list the current authentication configuration.

set desired project, in this case it would be 'trakt-183713'

gcloud project list
gcloud config set project [PROJECT-ID]

set desired account to ACTIVE

gcloud auth list
gcloud config set account scott.m.campbell11@gmail.com

If needed, create an additional 'config' account and make ACTIVE

gcloud config list
gcloud config configurations create trakt-config

Setup virtual environment

install python 3.6 globally with homebrew

brew install python3

navigate to project directory
create virtual env with python 3.6

virtualenv --python=python3.6 env

install python dependancies with pip

pip install -r requirements.txt

Install React/Node dependencies

npm install

Start the django server

python manage.py runserver

run the --watch command on webpack to auto generate new bundle.js files when changes are detected in your code. Terminal command located in package.json.

npm start

manually compile JavaScript files with

npm pack

local sqlite3 db authentication

username: scottcampbell password: developer password

local postgres db authentication

username: scottc11 password: music password with caps and num

test users

username: John last_name: Lennon password: Test1234 email: lennon@thebeatles.com

DEPLOY APP TO HEROKU

Copy local static folder and upload to cloud storage static folder

python manage.py collectstatic
gsutil rsync -R static/ gs://trakt/static

deploy the app

heroku git:remote -a trakt-app-1 # if heroku not already set as remote
heroku login
git push heroku testbranch:master OR git push heroku master

creds --> developer password, developer email

git push heroku master

Continuously monitor the status of your database

watch heroku pg:info

POSTGRESQL

install

brew install postgres

run the following command to start Postgres as a background service

brew services start postgresql

list all available postgres databases

psql --list

Create database

createdb database_name -U user_name

Load a dump into database

psql databasename < data_base_dump

Select database

psql db-name

Exit out of the postgres user's shell session to get back to your regular user's shell session:

exit

\q

dump a postgres db

pg_dump -Fc -U scottcampbell traktdev > nameoffile.dump

Upload this file to AWS bucket, then use the AWS dump file to restore Heroku Apps database located at the DATABASE_URL env variable

heroku pg:backups:restore 'https://s3.us-east-2.amazonaws.com/trakt-aws/updatedtraktdb.dump' DATABASE_URL

To connect to gcloud cloud SQL client, run this

gcloud auth login
gcloud config set project <PROJECT_ID>
gcloud sql instances describe <INSTANCE_NAME>

Initialize gcloud Cloud SQL instance (hint: you will need the 'cloud_sql_proxy' exec file)

./cloud_sql_proxy -instances="essy-178102:us-central1:essy-db"=tcp:5432

This step establishes a connection from your local computer to your Cloud SQL instance for local testing purposes.

Write google app default credentials

gcloud auth application-default

setting CORS on Google Cloud Storage

guide --> https://cloud.google.com/storage/docs/cross-origin

gsutil cors set cors-json-file.json gs://trakt
gsutil cors set cors-json-file.json gs://trakt-dev

scottc11/trakt