ci.yaml

name: CI

on:
  push:
    branches: [main]
  pull_request:
    branches: [main]

jobs:
  test:
    runs-on: ubuntu-latest
    env:
      DATABASE_URL: mysql://root:password@localhost:3307/earthworm_test 

    services:
      # 定义测试专用的 MySQL 服务
      mysql:
        image: mysql:8.3.0
        env:
          MYSQL_ROOT_PASSWORD: password
          MYSQL_DATABASE: earthworm_test
        ports:
          - 3307:3306
        options: >-
          --health-cmd="mysqladmin ping --silent"
          --health-interval=10s
          --health-timeout=5s
          --health-retries=5


    steps:
      - uses: actions/checkout@v2

      - name: Set up Node.js
        uses: actions/setup-node@v2
        with:
          node-version: "20.11.0" 

      - name: Install pnpm
        run: npm install -g pnpm

      - name: Install dependencies
        run: pnpm install

      - name: Run database initialization command
        run: pnpm db:init:test:ci

      - name: Run build schema 
        run: pnpm schema:build

      - name: Run tests
        run: pnpm test

  # lint:

  #   runs-on: ubuntu-latest

  #   steps:
  #     - uses: actions/checkout@v3

  #     - name: Use Node.js 16.14.2
  #       uses: actions/setup-node@v3
  #       with:
  #         node-version: 16.14.2

  #     - name: Setup
  #       run: npm i -g @antfu/ni

  #     - name: Install
  #       run: nci

  #     - name: Lint
  #       run: nr lint

  # build:

  #   runs-on: ubuntu-latest

  #   steps:
  #     - uses: actions/checkout@v3

  #     - name: Use Node.js 16.14.2
  #       uses: actions/setup-node@v3
  #       with:
  #         node-version: 16.14.2

  #     - name: Setup
  #       run: npm i -g @antfu/ni

  #     - name: Install
  #       run: nci

  #     - name: Build
  #       run: nr build