presV-env.md

pressureVessel in Google Cloud

dependencies

Acessing cloud instance

• steps 1. 2. 3. 4.

Uploading files

• file

gcloud compute scp  E:/index.js  prokura@development-server-ubuntu-16:/home/prokura/

• folder

gcloud compute scp --recurse  E:/test  prokura@development-server-ubuntu-16:/home/prokura/

Downloading files

• file

gcloud compute scp   prokura@development-server-ubuntu-16:/home/prokura/test/index.js E:/test

• folder

gcloud compute scp --recurse prokura@development-server-ubuntu-16:/home/prokura/test E:/

Backend Packages

• selected django framework for backend

Packgae	Version
python	3.6.4
Django	2.1.1
django-cors-headers	2.4.0
djangorestframework	3.8.2
conda	4.4.10

Frontend Packages

Packgae	Version
react	3.6.4

Database Essentials

• install postgres-10

Exporting local db

• export to a file in local

pg_dump -U nic vesseldb > dbexport.pgsql

• upload file to gcloud

gcloud compute scp  dbexport.pgsql prokura@development-server-ubuntu-16:/home/prokura/db_import

• enter password on prompt prokura

Creating db

• install postgres

sudo apt-get install postgresql postgresql-contrib

• switch over to postgres account

sudo -i -u postgres

• exit out

exit

• create new role

sudo -i -u postgres
createuser --interactive

• type the username as calcgen
• create the db with dbname same as rolename

sudo -i -u postgres
createdb calcgen

• add the user as linux user

sudo add user calcgen

• create db for project

sudo -i -u calcgen
psql
createdb vesseldb
\q

• log into new db as calcgen

psql -d vesseldb

• set the password for calcgen

alter user username with encrypted password 'password';

• make migration

python manage.py migrate

• export only table data from specific table

pg_dump --data-only -U username --table=tablename sourcedb > data.sql

• import table in database

psql -U username databasename < data.sql