Add deploy preview db #2
Workflow file for this run
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name: Deploy Preview | |
| on: [pull_request] | |
| env: | |
| GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }} # Required for commenting on pull requests for private repos | |
| NEON_API_KEY: ${{ secrets.NEON_API_KEY }} # You can generate a an API key in your account settings | |
| NEON_DATABASE_USERNAME: ${{ secrets.NEON_DATABASE_USERNAME }} # change this to your database username | |
| NEON_PROJECT_ID: ${{ secrets.NEON_PROJECT_ID }} # You can find this in your project settings | |
| VERCEL_TOKEN: ${{ secrets.VERCEL_TOKEN }} | |
| jobs: | |
| deploy-preview: | |
| permissions: write-all | |
| runs-on: ubuntu-latest | |
| steps: | |
| - uses: actions/checkout@v4 | |
| - name: Get branch name | |
| id: branch-name | |
| uses: tj-actions/branch-names@v8 | |
| - name: Create Neon Branch | |
| id: create-branch | |
| uses: neondatabase/create-branch-action@v5 | |
| with: | |
| project_id: ${{ env.NEON_PROJECT_ID }} | |
| parent: main | |
| branch_name: preview/pr-${{ github.event.number }}-${{ steps.branch-name.outputs.current_branch }} | |
| username: ${{ env.NEON_DATABASE_USERNAME }} | |
| api_key: ${{ env.NEON_API_KEY }} | |
| - name: Run Migrations | |
| run: | | |
| touch .env | |
| echo DATABASE_URL=${{ steps.create-branch.outputs.db_url_with_pooler }}?sslmode=require >> .env | |
| echo DIRECT_URL=${{ steps.create-branch.outputs.db_url }}?sslmode=require >> .env | |
| npm run db:generate | |
| npm run db:push | |
| - name: Install Vercel CLI | |
| run: npm install --global vercel@latest | |
| - name: Pull Vercel Environment Information | |
| run: vercel pull --yes --environment=preview --token=${{ env.VERCEL_TOKEN }} | |
| - name: Build Project Artifacts | |
| run: vercel build --token=${{ env.VERCEL_TOKEN }} | |
| - name: Deploy Preview to Vercel | |
| id: deploy | |
| run: echo preview_url=$(vercel deploy --prebuilt --token=${{ env.VERCEL_TOKEN }}) >> $GITHUB_OUTPUT | |
| - name: Comment on Pull Request | |
| uses: thollander/actions-comment-pull-request@v2 | |
| with: | |
| GITHUB_TOKEN: ${{ env.GITHUB_TOKEN }} | |
| message: | | |
| Vercel Preview URL :rocket: : ${{ steps.deploy.outputs.preview_url }} | |
| Neon branch :elephant: : https://console.neon.tech/app/projects/${{ env.NEON_PROJECT_ID }}/branches/${{ steps.create-branch.outputs.branch_id }} |