add new column to the user table #9
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: Preview Deployment | |
on: [pull_request] | |
env: | |
NEON_DATABASE_USERNAME: ${{ secrets.NEON_DATABASE_USERNAME }} # change this to your database username | |
GH_TOKEN: ${{ secrets.GH_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_PROJECT_ID: ${{ secrets.NEON_PROJECT_ID }} # You can find this in your project settings | |
FLY_API_TOKEN: ${{ secrets.FLY_API_TOKEN }} # You can generate a Fly API token in your account settings | |
jobs: | |
deploy-preview: | |
runs-on: ubuntu-latest | |
# Only run one deployment at a time per PR. | |
concurrency: | |
group: pr-${{ github.event.number }} | |
steps: | |
- uses: actions/checkout@v4 | |
- uses: pnpm/action-setup@v2 | |
with: | |
version: 8 | |
- name: Use Node.js 18 | |
uses: actions/setup-node@v4 | |
with: | |
node-version: 18 | |
cache: "pnpm" | |
- name: Install dependencies | |
run: pnpm install | |
- 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@v4 | |
with: | |
project_id: ${{ env.NEON_PROJECT_ID }} | |
# parent: dev # optional (defaults to your primary branch) | |
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 | |
pnpm run db:generate | |
pnpm run db:migrate | |
- name: Deploy | |
id: deploy | |
uses: superfly/[email protected] | |
with: | |
secrets: DATABASE_URL=${{ steps.create-branch.outputs.db_url }}?sslmode=require | |
- name: Comment on Pull Request | |
uses: thollander/actions-comment-pull-request@v2 | |
with: | |
GITHUB_TOKEN: ${{ env.GH_TOKEN }} | |
message: | | |
Fly Preview URL :balloon: : ${{ steps.deploy.outputs.url }} | |
Neon branch :elephant: : https://console.neon.tech/app/projects/${{ secrets.NEON_PROJECT_ID }}/branches/${{ steps.create-branch.outputs.branch_id }} |