Website built using Django + React via webpack.
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
- 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
username: scottcampbell password: developer password
username: scottc11 password: music password with caps and num
username: John last_name: Lennon password: Test1234 email: lennon@thebeatles.com
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
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
OR
\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
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