create-user-db.yml

name: Create User DB
on:
  push:
    branches:
      - feat/cloudsql-gh-action
  workflow_dispatch:


jobs:
  create-db:
    runs-on: ubuntu-latest

    steps:
      - id: 'generate-db-id'
        name: 'generate db id'
        uses: 'yakubique/random-number@v1.1'
        with:
          min: 111111
          max: 999999
      - id: 'generate-db-pw'
        uses: aammirmirza/RandomPasswordGenerator@v1.1
        with:
         length: 15
      - id: 'auth'
        name: 'auth'
        uses: 'google-github-actions/auth@v2'
        with:
         credentials_json: '${{ secrets.GCP_CREDENTIALS }}'
      - id: 'Set_up_Cloud_SDK'
        name: 'Set up Cloud SDK'
        uses: 'google-github-actions/setup-gcloud@v2'
      - name: 'Use gcloud CLI to create DB'
        run: 'gcloud sql databases create ${{ steps.generate-db-id.outputs.number }} --instance=idp-postgres-db'
      - name: 'create db user'
        run: 'gcloud sql users create ${{ steps.generate-db-id.outputs.number }} --instance=idp-postgres-db --password=${{ steps.generate-db-pw.outputs.password }}