servicestart/.github/workflows/setup_preview.yml at 249d51cc232c7eaa8739cd07806f313166666c08 · GTBitsOfGood/servicestart · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
name: Setup Preview

on:
  pull_request:
    branches:
      - main
    types:
      - opened
      - reopened
  workflow_dispatch:

jobs:
  create-db:
    runs-on: ubuntu-latest
    environment: "Preview"
    steps:
      - uses: actions/checkout@v7

      - name: Setup pnpm
        uses: pnpm/action-setup@v5.0.0

      - name: Install dependencies
        run: pnpm install

      - name: Load DB_URL from secrets
        run: echo "DB_URL=${{ secrets.DB_URL }}/pr${{ github.event.number }}" >> $GITHUB_ENV

      - name: Create database
        run: |
          psql "${{ secrets.DB_URL }}/postgres" -tAc "SELECT 1 FROM pg_database WHERE datname = 'pr${{ github.event.number }}'" | grep -q 1 || \
            psql "${{ secrets.DB_URL }}/postgres" -c 'create database "pr${{ github.event.number }}";'
      - name: Migrate database
        run: pnpm run db:migrate
      - name: Seed database
        # Seeding needs auth initialization, but does not reuse signed cookies.
        # Password hashes are independent of this temporary, process-only secret.
        run: BETTER_AUTH_SECRET="$(openssl rand -base64 32)" pnpm run db:seed
      - name: Setup Juno File Storage
        run: pnpm run setupJunoFileStorage
        env:
          JUNO_API_KEY: ${{ secrets.JUNO_API_KEY }}
          JUNO_BASE_URL: ${{ vars.JUNO_BASE_URL }}
          FILE_PROVIDER_NAME: ${{ vars.FILE_PROVIDER_NAME }}
          AZURE_STORAGE_ACCOUNT_NAME: ${{ vars.AZURE_STORAGE_ACCOUNT_NAME }}
          AZURE_STORAGE_ACCOUNT_KEY: ${{ secrets.AZURE_STORAGE_ACCOUNT_KEY }}
          JUNO_PROJECT_ID: ${{ secrets.JUNO_PROJECT_ID }}
          JUNO_FILE_BUCKET_PREFIX: ${{ vars.JUNO_FILE_BUCKET_PREFIX }}
          SETUP_ORGANIZATION_ID: ${{ vars.SETUP_ORGANIZATION_ID }}
      - name: Setup organization
        run: pnpm run setupOrg
        env:
          JUNO_API_KEY: ${{ secrets.JUNO_API_KEY }}
          JUNO_BASE_URL: ${{ vars.JUNO_BASE_URL }}
          FILE_PROVIDER_NAME: ${{ vars.FILE_PROVIDER_NAME }}
          AZURE_STORAGE_ACCOUNT_NAME: ${{ vars.AZURE_STORAGE_ACCOUNT_NAME }}
          AZURE_STORAGE_ACCOUNT_KEY: ${{ secrets.AZURE_STORAGE_ACCOUNT_KEY }}
          JUNO_PROJECT_ID: ${{ secrets.JUNO_PROJECT_ID }}
          JUNO_FILE_BUCKET_PREFIX: ${{ vars.JUNO_FILE_BUCKET_PREFIX }}
          SETUP_ORGANIZATION_ID: ${{ vars.SETUP_ORGANIZATION_ID }}
          SENDGRID_KEY: ${{ secrets.SENDGRID_KEY }}
          EMAIL_SENDER_DOMAIN: ${{ vars.EMAIL_SENDER_DOMAIN }}