feat(utils): Add function to clean database and truncate all tables #108
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: CI | |
| on: | |
| push: | |
| branches: [main] | |
| pull_request: | |
| env: | |
| # app | |
| APP_PORT: 80 | |
| APP_ENV: 'development' | |
| APP_URL: 'localhost' | |
| # redis | |
| REDIS_HOST: 'redis' | |
| REDIS_PORT: 6379 | |
| REDIS_PASSWORD: 'password' | |
| # database | |
| DB_PORT: 5432 | |
| DB_HOST: 'postgres' | |
| DB_USERNAME: 'username' | |
| DB_PASSWORD: 'password' | |
| DB_DATABASE: 'database' | |
| EMAIL_HOST: 'mailhot' | |
| EMAIL_PORT: 1025 | |
| EMAIL_ALIAS: '[email protected]' | |
| EMAIL_AUTH_EMAIL: '[email protected]' | |
| EMAIL_AUTH_PASS: 'password' | |
| # twilio | |
| TWILIO_ACCOUNT_SID: '' | |
| TWILIO_AUTH_TOKEN: '' | |
| TWILIO_FROM_PHONE_NUMBER: '' | |
| TWILIO_PHONE_NUMBER: '' | |
| jobs: | |
| test: | |
| name: Unit tests | |
| runs-on: ubuntu-latest | |
| strategy: | |
| matrix: | |
| node-version: [22.x] | |
| steps: | |
| - uses: actions/checkout@v3 | |
| - name: Use Node.js ${{ matrix.node-version }} | |
| uses: actions/setup-node@v3 | |
| with: | |
| node-version: ${{ matrix.node-version }} | |
| cache: 'npm' | |
| - name: Create .env file from .env.example | |
| run: cp .env.example .env | |
| - name: Install dependencies | |
| run: npm i | |
| - name: Test codes | |
| run: npm run test:coverage | |
| lint: | |
| name: ESLint | |
| runs-on: ubuntu-latest | |
| strategy: | |
| matrix: | |
| node-version: [22.x] | |
| steps: | |
| - uses: actions/checkout@v3 | |
| - name: Use Node.js ${{ matrix.node-version }} | |
| uses: actions/setup-node@v3 | |
| with: | |
| node-version: ${{ matrix.node-version }} | |
| cache: 'npm' | |
| - name: Install dependencies | |
| run: npm i | |
| - name: Lint codes | |
| run: npm run lint | |
| format: | |
| needs: [lint, test] | |
| name: Prettier format | |
| runs-on: ubuntu-latest | |
| permissions: | |
| contents: write | |
| strategy: | |
| matrix: | |
| node-version: [22.x] | |
| steps: | |
| - uses: actions/checkout@v3 | |
| - name: Use Node.js ${{ matrix.node-version }} | |
| uses: actions/setup-node@v3 | |
| with: | |
| node-version: ${{ matrix.node-version }} | |
| cache: 'npm' | |
| - name: Install dependencies | |
| run: npm i | |
| - name: Format codes | |
| run: npm run format | |
| - name: Commit changes | |
| uses: stefanzweifel/git-auto-commit-action@v4 | |
| with: | |
| commit_message: 'style: format codes' | |
| env: | |
| GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }} | |
| # deploy: | |
| # needs: [test, lint, format] | |
| # name: Deploy to Production | |
| # runs-on: ubuntu-latest | |
| # if: github.event_name == 'push' && github.ref == 'refs/heads/main' | |
| # environment: | |
| # name: production | |
| # url: https://commit.jaw.dev/ | |
| # steps: | |
| # - name: Check out repository | |
| # uses: actions/checkout@v3 | |
| # - name: Set up Docker Buildx | |
| # uses: docker/setup-buildx-action@v2 | |
| # - name: Login to Container Registry | |
| # uses: docker/login-action@v2 | |
| # with: | |
| # registry: ghcr.io | |
| # username: ${{ github.repository_owner }} | |
| # password: ${{ secrets.GH_TOKEN }} | |
| # - name: Preset Image Name | |
| # run: echo "IMAGE_URL=$(echo ghcr.io/${{ github.repository_owner }}/${{ github.event.repository.name }}:$(echo ${{ github.sha }} | cut -c1-7) | tr '[:upper:]' '[:lower:]')" >> $GITHUB_ENV | |
| # - name: Build and push Docker Image | |
| # uses: docker/build-push-action@v4 | |
| # with: | |
| # context: . | |
| # file: ./Dockerfile.prod | |
| # push: true | |
| # tags: ${{ env.IMAGE_URL }} | |
| # - name: Deploy Image to Server | |
| # uses: caprover/[email protected] | |
| # with: | |
| # server: '${{ secrets.CAPROVER_SERVER }}' | |
| # app: '${{ secrets.APP_NAME }}' | |
| # token: '${{ secrets.APP_TOKEN }}' | |
| # image: ${{ env.IMAGE_URL }} |