cwms-database/.github/workflows/build-and-test.yml at 2cd617b65ff332a5b896efb1877f3107cbdcd4c5 · HydrologicEngineeringCenter/cwms-database · 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
---
name: Build And Test CWMS Database
on:
  push:
    branches:
      - main
  pull_request:
    branches:
      - main

jobs:
  build:
    name: build and test
    runs-on: ubuntu-latest
    steps:
      - name: checkout code
        uses: actions/checkout@v4.2.2
      - name: Clean Runner
        uses: ./.github/actions/clean-runner
      - name: setup java
        uses: actions/setup-java@v4.6.0
        with:
          distribution: 'temurin'
          java-version: '8'
      - name: Start Database
        uses: ./.github/actions/start-database
      - name: Run Tests
        working-directory: schema
        run: ant test -Dbuilduser.overrides=build/overrides.external.xml -Doracle.image=gvenzl/oracle-free:23.6-full-faststart
      - name: Generate Bundle (docs and schemas)
        working-directory: schema
        run: ant bundle -Dbuilduser.overrides=build/overrides.external.xml -Doracle.image=gvenzl/oracle-free:23.6-full-faststart
      - name: Remove database container
        if: success() || failure() # always run even if the previous step fails
        working-directory: schema
        run: ant docker.killdb -Dbuilduser.overrides=build/overrides.external.xml -Doracle.image=gvenzl/oracle-free:23.6-full-faststart
      - name: Publish Test Report
        uses: mikepenz/action-junit-report@v5
        if: success() || failure() # always run even if the previous step fails
        with:
          annotate_only: true
          include_passed: true
          report_paths: 'schema/build/test*.xml'
      - name: Upload Build Logs
        if: success() || failure() # always run even if the previous step fails
        uses: actions/upload-artifact@v4.6.0
        with:
          name: build_logs-testdb
          path: ./**/*.log
  ready-database:
    # This step doesn't rely on the creation of the database created
    # for testing and can be done separately.
    name: Create Ready-Database
    runs-on: ubuntu-latest
    steps:
      - name: checkout code
        uses: actions/checkout@v4.2.2
      - name: Clean Runner
        uses: ./.github/actions/clean-runner
      - name: setup java
        uses: actions/setup-java@v4.6.0
        with:
          distribution: 'temurin'
          java-version: '8'
      - name: Build Ready Database
        working-directory: schema
        run: ant docker.create_ready_database -Doracle.image=gvenzl/oracle-free:23.6-full-faststart
      - name: Upload Build Logs
        if: success() || failure() # always run even if the previous step fails
        uses: actions/upload-artifact@v4.6.0
        with:
          name: build_logs-ready-database
          path: ./**/*.log
  rds-variations:
    name: Test RDS deployment tweaks
    runs-on: ubuntu-latest
    steps:
      - name: checkout code
        uses: actions/checkout@v4.2.2
      - name: Clean Runner
        uses: ./.github/actions/clean-runner
      - name: setup java
        uses: actions/setup-java@v4.6.0
        with:
          distribution: 'temurin'
          java-version: '8'
      - name: Setup Oracle Tools
        uses: ./.github/actions/setup-oracle-clients
      - name: Install Schema using RDS variations (no direct sys)
        working-directory: schema
        run: ant docker.install.rds
      - name: Upload Build Logs
        if: success() || failure() # always run even if the previous step fails
        uses: actions/upload-artifact@v4.6.0
        with:
          name: build_logs-rds-database
          path: ./**/*.log