Skip to content

Bump download artifact #5

Bump download artifact

Bump download artifact #5

Workflow file for this run

# Workflow derived from https://github.com/r-lib/actions/tree/v2/examples
# Need help debugging build failures? Start at https://github.com/r-lib/actions#where-to-find-help
on:
push:
#branches: [main, master]
branches: [results-data-model]
pull_request:
branches: [main, master]
release:
types: [published]
workflow_dispatch:
name: pkgdown.yaml
permissions: read-all
jobs:
pkgdown:
runs-on: ubuntu-latest
# Only restrict concurrency for non-PR jobs
#concurrency:
# group: pkgdown-${{ github.event_name != 'pull_request' || github.run_id }}
env:
GITHUB_PAT: ${{ secrets.GITHUB_TOKEN }}
permissions:
contents: write
services:
postgres:
image: postgres:latest
env:
POSTGRES_DB: mydb
POSTGRES_USER: user
POSTGRES_PASSWORD: password
POSTGRES_HOST: postgres
POSTGRES_PORT: 5432
ports:
- 5432:5432
options: --name postgres --health-cmd pg_isready --health-interval 10s --health-timeout 5s --health-retries 5
steps:
- name: Checkout repository
uses: actions/checkout@v4
- name: Setup Pandoc
uses: r-lib/actions/setup-pandoc@v2
- name: Setup R
uses: r-lib/actions/setup-r@v2
with:
use-public-rspm: true
- name: Setup R Dependencies
uses: r-lib/actions/setup-r-dependencies@v2
with:
extra-packages: any::pkgdown, local::.
needs: website
- name: Build site
run: pkgdown::build_site_github_pages(new_process = FALSE, install = FALSE)
shell: Rscript {0}
- name: Wait for PostgreSQL to be ready
run: |
until pg_isready -h 127.0.0.1 -p 5432 -U myuser; do
echo "Waiting for postgres...";
sleep 3;
done
- name: Run SQL Script
run: |
PGPASSWORD=password psql -h 127.0.0.1 -U user -d mydb -f extras/rdms/full_data_model_pg.sql
- name: Configure SchemaSpy environment
run: |
sudo apt-get update
sudo apt-get install default-jdk -y
sudo apt-get install postgresql-client -y
- name: Download PostgreSQL JDBC Driver
run: |
wget https://jdbc.postgresql.org/download/postgresql-42.2.24.jar -O $HOME/postgresql-jdbc.jar
- name: Execute SchemaSpy
run: |
java -jar extras/rdms/schemaspy-6.2.4.jar -vizjs -dp $HOME -configFile extras/rdms/schemaspy-config.properties -meta extras/rdms/schema_meta.xml -debug
- name: Upload artifact
uses: actions/upload-artifact@v4
with:
name: documentation-artifact
path: docs/results-schema
- name: download documentation
uses: actions/download-artifact@v4
with:
name: documentation-artifact
path: docs/results-schema
- name: Deploy to GitHub pages 🚀
#if: github.event_name != 'pull_request'
uses: JamesIves/[email protected]
with:
clean: false
branch: gh-pages
folder: docs