postgres-deploy.yaml

name: Deploy Postgres

on: push

env:
  DEPLOY_SRC: "backdb-sql tgdb-sql vkdb-sql"
  TG_SECRET_SQL: "sql/tgdb-sql/3-insert.sql"
  VK_SECRET_SQL: "sql/vkdb-sql/3-insert.sql"

jobs:
  deploy:
    if: contains(github.event.head_commit.message, '[DEPLOY]')
    runs-on: ubuntu-latest
    steps:
      - uses: actions/checkout@v4
      - uses: easingthemes/ssh-deploy@main
        with:
          REMOTE_HOST: ${{ secrets.HOST }}
          REMOTE_USER: ${{ secrets.USERNAME }}
          SSH_PRIVATE_KEY: ${{ secrets.SSH_KEY }}
          ARGS: "-rlzav --delete"
          SOURCE: ${{ env.DEPLOY_SRC }}
          TARGET: ${{ secrets.TARGET_DOCKER_COMPOSE }}/sql
      - name: Backend Database
        uses: appleboy/ssh-action@v1.0.0
        with:
          host: ${{ secrets.HOST }}
          username: ${{ secrets.USERNAME }}
          key: ${{ secrets.SSH_KEY }}
          script_stop: true
          script: |
            cd ${{ secrets.TARGET_DOCKER_COMPOSE }}
            docker exec backdb psql -U ${{ secrets.BACKDB_PG_USER }} -d ${{ secrets.BACKDB_PG_DB }} -f /docker-entrypoint-initdb.d/1-drop.sql
            docker exec backdb psql -U ${{ secrets.BACKDB_PG_USER }} -d ${{ secrets.BACKDB_PG_DB }} -f /docker-entrypoint-initdb.d/2-create.sql
            docker exec backdb psql -U ${{ secrets.BACKDB_PG_USER }} -d ${{ secrets.BACKDB_PG_DB }} -f /docker-entrypoint-initdb.d/3-insert.sql
      - name: TG Bots Database
        uses: appleboy/ssh-action@v1.0.0
        with:
          host: ${{ secrets.HOST }}
          username: ${{ secrets.USERNAME }}
          key: ${{ secrets.SSH_KEY }}
          script_stop: true
          script: |
            cd ${{ secrets.TARGET_DOCKER_COMPOSE }}
            echo "${{ secrets.TG_BOTS_TOKENS_SQL }}" > ${{ env.TG_SECRET_SQL }}
            sed -i '/DRONE_SSH_PREV_COMMAND_EXIT_CODE/d' ${{ env.TG_SECRET_SQL }}
            docker exec tgdb psql -U ${{ secrets.TGDB_PG_USER }} -d ${{ secrets.TGDB_PG_DB }} -f /docker-entrypoint-initdb.d/1-drop.sql
            docker exec tgdb psql -U ${{ secrets.TGDB_PG_USER }} -d ${{ secrets.TGDB_PG_DB }} -f /docker-entrypoint-initdb.d/2-create.sql
            docker exec tgdb psql -U ${{ secrets.TGDB_PG_USER }} -d ${{ secrets.TGDB_PG_DB }} -f /docker-entrypoint-initdb.d/3-insert.sql
      - name: VK Bots Database
        uses: appleboy/ssh-action@v1.0.0
        with:
          host: ${{ secrets.HOST }}
          username: ${{ secrets.USERNAME }}
          key: ${{ secrets.SSH_KEY }}
          script_stop: true
          script: |
            cd ${{ secrets.TARGET_DOCKER_COMPOSE }}
            echo "${{ secrets.VK_BOTS_TOKENS_SQL }}" > ${{ env.VK_SECRET_SQL }}
            sed -i '/DRONE_SSH_PREV_COMMAND_EXIT_CODE/d' ${{ env.VK_SECRET_SQL }}
            docker exec vkdb psql -U ${{ secrets.VKDB_PG_USER }} -d ${{ secrets.VKDB_PG_DB }} -f /docker-entrypoint-initdb.d/1-drop.sql
            docker exec vkdb psql -U ${{ secrets.VKDB_PG_USER }} -d ${{ secrets.VKDB_PG_DB }} -f /docker-entrypoint-initdb.d/2-create.sql
            docker exec vkdb psql -U ${{ secrets.VKDB_PG_USER }} -d ${{ secrets.VKDB_PG_DB }} -f /docker-entrypoint-initdb.d/3-insert.sql