OzzieFZI

• 0.1. References
• 0.2. Other cheatsheets
• 0.3. Manage multiple gcloud config configurations
  • 0.3.1. Switch gcloud context with gcloud config
• 0.4. Credentials
• 0.5. info
• 0.6. projects
• 0.7. zones & regions
• 0.8. Organization
• 0.9. billing

OzzieFZI

$ mongo "mongodb+srv://datadump-ii2on.gcp.mongodb.net/test" --authenticationDatabase admin --tls --tlsAllowInvalidCertificates --username m001-student --password m001-mongodb-basics
$ mongo "mongodb://cluster0-shard-00-00-jxeqq.mongodb.net:27017,cluster0-shard-00-01-jxeqq.mongodb.net:27017,cluster0-shard-00-02-jxeqq.mongodb.net:27017/test?replicaSet=Cluster0-shard-0" --authenticationDatabase admin --tls --tlsAllowInvalidCertificates --username m001-student --password m001-mongodb-basics

OzzieFZI

//Install postgresql through apt -- https://www.postgresql.org/download/linux/ubuntu/
//Install libpq-dev
  $ sudo apt-get install libpq-dev
//install psycopg2 through pip (assuming pip already installed)
  $ python3 -m pip install --user psycopg2 

OzzieFZI

# Simple API for database access

# adopted and modified from tutorial on https://code.tutsplus.com/tutorials/building-restful-apis-with-flask-diy--cms-26625

from flask import Flask, request, jsonify, Blueprint, abort, _request_ctx_stack
from flask_sqlalchemy import SQLAlchemy
from flask.views import MethodView
from flask_cors import cross_origin

from jose import jwt