44 lines
1.1 KiB
YAML
44 lines
1.1 KiB
YAML
name: Database dump
|
|
|
|
# This workflow is triggered manually
|
|
on:
|
|
workflow_dispatch:
|
|
inputs:
|
|
appenv:
|
|
description: 'Database environment to dump'
|
|
required: true
|
|
type: choice
|
|
options:
|
|
- prod
|
|
- staging
|
|
- testing
|
|
default: testing
|
|
|
|
permissions: read-all
|
|
|
|
jobs:
|
|
deploy:
|
|
if: github.event_name == 'workflow_dispatch'
|
|
|
|
name: Dumping the database
|
|
runs-on: ubuntu-latest
|
|
|
|
steps:
|
|
- name: Environment message
|
|
run: echo "Dumping the database for the ${{ github.event.inputs.appenv }} environment."
|
|
|
|
# https://github.com/actions/checkout
|
|
- name: Checkout repo
|
|
uses: actions/checkout@v5
|
|
|
|
# https://github.com/appleboy/ssh-action
|
|
- name: Run the database dump
|
|
uses: appleboy/ssh-action@v1
|
|
with:
|
|
host: ${{ secrets.DB_DUMP_HOST }}
|
|
port: ${{ secrets.DB_DUMP_PORT }}
|
|
username: ${{ secrets.DB_DUMP_USERNAME }}
|
|
key: ${{ secrets.DB_DUMP_SSHKEY }}
|
|
script: |
|
|
bash ${{ secrets.DB_DUMP_PATH_SCRIPT }} ${{ github.event.inputs.appenv }}
|