constructive/.github/workflows/run-tests.yaml at 7755e026efb16c601a70c43ba5f50f7d74314d00 · constructive-io/constructive · 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
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
name: LaunchQL tests
on:
  push:
  workflow_dispatch:

jobs:
  container-job:
    runs-on: ubuntu-latest
    container: pyramation/node-sqitch:20.12.0

    env:
      PGHOST: pg_db
      PGPORT: 5432
      PGUSER: postgres
      PGPASSWORD: password

    services:
      pg_db:
        image: pyramation/pgvector:13.3-alpine
        env:
          POSTGRES_USER: postgres
          POSTGRES_PASSWORD: password
        options: >-
          --health-cmd pg_isready
          --health-interval 10s
          --health-timeout 5s
          --health-retries 5
        ports:
          - 5432:5432

      minio_cdn:
        image: minio/minio:edge-cicd
        env:
          MINIO_ROOT_USER: minioadmin
          MINIO_ROOT_PASSWORD: minioadmin
        ports:
          - 9000:9000
          - 9001:9001
        options: >-
          --health-cmd "curl -f http://localhost:9000/minio/health/live || exit 1"
          --health-interval 10s
          --health-timeout 5s
          --health-retries 5

    steps:
       # TODO remove deps on git config
      - name: Configure Git (for tests)
        run: |
          git config --global user.name "CI Test User"
          git config --global user.email "ci@example.com"

      - name: checkout
        uses: actions/checkout@v4

      - name: setup pnpm
        run: |
          corepack enable
          corepack prepare pnpm@9.12.1 --activate

      - name: deps
        run: pnpm install --frozen-lockfile

      - name: build
        run: pnpm run build

      - name: fix lql permissions
        run: |
          if [ -f node_modules/.bin/lql ]; then
            chmod +x node_modules/.bin/lql
          fi

      - name: seed app_user
        run: |
          pnpm exec lql admin-users bootstrap --yes
          pnpm exec lql admin-users add --test --yes
        env:
          PGHOST: pg_db
          PGPORT: 5432
          PGUSER: postgres
          PGPASSWORD: password

      - name: mime-bytes
        run: cd ./packages/mime-bytes && pnpm test

      - name: launchql/core
        run: cd ./packages/core && pnpm test

      - name: launchql/cli
        run: cd ./packages/cli && pnpm test

      - name: launchql/client
        run: cd ./packages/client && pnpm test
        env:
          TEST_DATABASE_URL: postgres://postgres:password@pg_db:5432/postgres

      - name: graphile-test
        run: |
          cd ./packages/graphile-test
          createdb graphile_test_db
          psql -f sql/test.sql graphile_test_db
          psql -f sql/roles.sql graphile_test_db
          pnpm test

      - name: pgsql-test
        run: |
          cd ./packages/pgsql-test
          pnpm test

      - name: launchql/orm
        run: cd ./packages/orm && pnpm test

      - name: launchql/url-domains
        run: cd ./packages/url-domains && pnpm test

      - name: launchql/uuid-hash
        run: cd ./packages/uuid-hash && pnpm test

      - name: launchql/uuid-stream
        run: cd ./packages/uuid-stream && pnpm test

      - name: launchql/introspectron
        run: cd ./packages/introspectron && pnpm test

      - name: launchql/query-builder
        run: cd ./packages/query-builder && pnpm test

      - name: launchql/query
        run: cd ./packages/query && pnpm test

      - name: launchql/launchql-gen
        run: cd ./packages/launchql-gen && pnpm test

      - name: launchql/pg-ast
        run: cd ./packages/pg-ast && pnpm test

      - name: launchql/pg-codegen
        run: cd ./packages/pg-codegen && pnpm test

      - name: launchql-gen
        run: cd ./packages/launchql-gen && pnpm test

      - name: launchql/content-type-stream
        run: cd ./packages/content-type-stream && pnpm test

      - name: launchql/s3-streamer
        run: cd ./packages/s3-streamer && pnpm test
        env:
          MINIO_ENDPOINT: http://minio_cdn:9000
          AWS_ACCESS_KEY: minioadmin
          AWS_SECRET_KEY: minioadmin
          AWS_REGION: us-east-1
          BUCKET_NAME: test-bucket

      - name: launchql/upload-names
        run: cd ./packages/upload-names && pnpm test