export PROJECT_ID=ngx-starter-kit
export COMPUTE_REGION=us-west2
export COMPUTE_ZONE=us-west2-a
export MACHINE_TYPE=db-f1-micro
export DISK_SIZE=10GB
export NETWORK_NAME=ngx-network
export SUBNET_NAME=ngx-subnet
export INSTANCE_NAME=ngxdb
export DATABASE_NAME=postgres
export DATABASE_VERSION=POSTGRES_11_1

gcloud config set project $PROJECT_ID
gcloud config set compute/zone $COMPUTE_ZONE

gcloud sql instances create ${INSTANCE_NAME} \
  --project ${PROJECT_ID}
  --tier ${MACHINE_TYPE} \
  --region ${COMPUTE_REGION} \
  --storage-type HDD \
  --storage-size ${DISK_SIZE} \
  --network ${NETWORK_NAME}  \
  --database-version ${DATABASE_VERSION}

# Verify
gcloud sql instances describe ${INSTANCE_NAME}

gcloud sql users set-password postgres \
    --instance=${INSTANCE_NAME} --prompt-for-password

# Listing your databases
gcloud sql databases list --instance=${INSTANCE_NAME}
gcloud sql users list --instance=${INSTANCE_NAME}

gcloud sql databases create keycloak --instance=${INSTANCE_NAME} --charset=UTF8 --collation=en_US.UTF8

 gcloud sql connect ngxdb --user=postgres --quiet

# Warning: All data on an instance, including backups, is permanently lost when that instance is deleted.
gcloud sql databases delete ${DATABASE_NAME} --instance=${INSTANCE_NAME} --project ${PROJECT_ID}
gcloud sql instances delete ${INSTANCE_NAME} --project ${PROJECT_ID}