Web platform with DevOps features for Aang to manage his stocks

Assuming Kevin has the database running...

Push a change to GitHub to run the web app and cronjob! This also performs any database migrations for the running postgres database.

The app is reachable at kevc528.cis188.org

Go to aws.cloud.upenn.edu and login

Go to https://console.aws.amazon.com/iam/home?region=us-east-1#/users/YOUR_PENNKEY_HERE?section=security_credentials (replace YOUR_PENNKEY_HERE with your pennkey [letters, not numbers]). Create an access key and add it to the aws cli by running aws configure

Create an access key for your user, and don't close out of the confirmation window with the key visible.

Run aws configure and enter the Access Key ID and the Secret Key from the confirmation window.

To generate the kubeconfig, run aws eks --region us-east-1 update-kubeconfig --name cis188 --role-arn arn:aws:iam::474844133309:role/YOUR_PENNKEY_HERE --alias cis188, again replacing YOUR_PENNKEY_HERE with your pennkey. Next, set the default kubectl namespace with kubectl config set-context --current --namespace=YOUR_PENNKEY_HERE

Go to the repository's root directory.

Replace PENNKEY occurrences in manual-web-app-values.yaml with your own PENNKEY. Additionally, make sure to fill out email credentials and choose a JWT secret in the environment section.

Run the postgres database with helm upgrade --install db ./helm-db/

Run the web-app & cronjob with helm upgrade --install -f manual-web-app-values.yaml app ./helm-app/

This also performs any database migrations for the running postgres database.

You can end the web-app/cronjob with: helm uninstall app

and remove/clear the database with helm uninstall db

If you want to run locally with docker, make sure to change the docker-compose file to have the correct environment variables for email and email password.

When you make a change to the code, update the docker image using

docker-compose build

Run using

docker-compose up

When you make a change to models, make migrations using the following commands

docker-compose run web-app poetry run alembic revision --autogenerate

docker-compose run web-app poetry run alembic upgrade head

The Postgres admin tool can be found at localhost:5050. You can login with username admin@admin.com and password password. After logging in, you can add our database server. Make sure to use the connection tab. Remember the database was named postgres in the docker compose and the username and password are also both postgres.

Run the cronjob using

docker-compose run web-app poetry run python email_job.py