cloudbuild.yaml

# https://cloud.google.com/build/docs/configuring-builds/substitute-variable-values

steps:
  - id: build-api
    name: docker
    args:
      - build
      - '--no-cache'
      - '-t'
      - $_IMAGE_NAME
      - .

  - id: push
    name: docker
    args:
      - push
      - $_IMAGE_NAME

  # https://cloud.google.com/build/docs/configuring-builds/pass-data-between-steps
  - id: add-config
    name: 'gcr.io/google.com/cloudsdktool/cloud-sdk:slim'
    entrypoint: bash
    args:
      - '-c'
      - |
        gcloud secrets versions access latest --secret=${_VSCHEDULERC_KEY} \
        > /workspace/.vschedulerc.toml

  # https://cloud.google.com/sql/docs/mysql/connect-build#connect_to
  - id: migration
    name: $_IMAGE_NAME
    secretEnv: ['DATABASE_URL']
    entrypoint: bash
    dir: /app
    args:
      - '-c'
      - |
        cp /workspace/.vschedulerc.toml .vschedulerc.toml

        wget https://dl.google.com/cloudsql/cloud_sql_proxy.linux.amd64 --quiet -O \
          cloud_sql_proxy

        chmod +x cloud_sql_proxy
        mkdir /cloudsql

        ./cloud_sql_proxy -instances=${_SQL_CONNECTION_NAME} -dir=/cloudsql \
          & sleep 2;

        echo /cloudsql/${_SQL_CONNECTION_NAME}
        ls -al /cloudsql/${_SQL_CONNECTION_NAME}

        yarn workspace @neet/vschedule-api run prisma migrate deploy
        yarn workspace @neet/vschedule-api run prisma db seed

  - id: deploy
    name: 'gcr.io/google.com/cloudsdktool/cloud-sdk:slim'
    entrypoint: gcloud
    args:
      - run
      - services
      - update
      - $_SERVICE_NAME
      - '--platform=managed'
      - '--image=$_IMAGE_NAME'
      - '--region=$_DEPLOY_REGION'
      - '--quiet'

images:
  - $_IMAGE_NAME

options:
  substitutionOption: ALLOW_LOOSE
  dynamicSubstitutions: true

availableSecrets:
  secretManager:
    - versionName: projects/$PROJECT_ID/secrets/${_DATABASE_URL_KEY}/versions/latest
      env: DATABASE_URL