sync-db.yml

name: Sync database from prod to dev
on:
  schedule:
    - cron: '*/30 * * * *' # Every minute 0 (every hour)

concurrency:
  group: sync-database

jobs:
  sync-db:
    runs-on: ubuntu-latest
    steps:
      - uses: actions/checkout@v4
        with:
          submodules: true

      - name: Set up Python 3.9
        uses: actions/setup-python@v5
        with:
          python-version: 3.9

      - name: Install dependencies
        run: |
          python -m pip install --upgrade pip
          pip install ansible==6.4.0 requests

      - name: set ansible config secrets
        env:
          ANSIBLE_VAULT_PASSWORD: ${{ secrets.ANSIBLE_VAULT_PASSWORD }}
        run: |
          echo "$ANSIBLE_VAULT_PASSWORD" > .ansible-vault-password

      - name: Load ssh key
        uses: webfactory/ssh-agent@v0.9.0
        with:
          ssh-private-key: ${{ secrets.AUTOMATION_SSH_KEY }}

      - name: run playbook
        run: |
          ansible-playbook -i environments/prod/hosts sync-backup-database.yml \
            --vault-password-file .ansible-vault-password \
            --tags sync-db \
            --extra-vars "ansible_user=automation"
        env:
          ANSIBLE_HOST_KEY_CHECKING: 'False'