1.0 patch 23 fix delete Method and add batch add room #14
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
# This workflow will build a Java project with Maven, and cache/restore any dependencies to improve the workflow execution time | |
# For more information see: https://docs.github.com/en/actions/automating-builds-and-tests/building-and-testing-java-with-maven | |
# This workflow uses actions that are not certified by GitHub. | |
# They are provided by a third-party and are governed by | |
# separate terms of service, privacy policy, and support | |
# documentation. | |
# name: Java CI with Maven | |
# on: | |
# push: | |
# branches: [ "master" ] | |
# pull_request: | |
# branches: [ "master" ] | |
# jobs: | |
# build: | |
# runs-on: ubuntu-latest | |
# steps: | |
# - name: Checkhout the repository | |
# uses: actions/checkout@v3 | |
# - name: Set up JDK 17 | |
# uses: actions/setup-java@v3 | |
# with: | |
# java-version: '17' | |
# distribution: 'temurin' | |
# cache: maven | |
# - name: Build with Maven | |
# run: mvn -B package --file pom.xml | |
# - name: Test with Maven | |
# run: mvn -B test --file pom.xml | |
# # Optional: Uploads the full dependency graph to GitHub to improve the quality of Dependabot alerts this repository can receive | |
# - name: Update dependency graph | |
# uses: advanced-security/maven-dependency-submission-action@571e99aab1055c2e71a1e2309b9691de18d6b7d6 | |
name: Java CI with PostgreSQL | |
on: | |
push: | |
branches: [ "master" ] | |
pull_request: | |
branches: [ "master" ] | |
jobs: | |
build: | |
runs-on: ubuntu-latest | |
services: | |
postgres: | |
image: postgres:14.5 | |
env: | |
POSTGRES_USER: ${{ secrets.DB_USERNAME }} | |
POSTGRES_PASSWORD: ${{ secrets.DB_PASSWORD }} | |
ports: | |
- 5432:5432 | |
options: >- | |
--health-cmd pg_isready | |
--health-interval 10s | |
--health-timeout 5s | |
--health-retries 5 | |
steps: | |
- name: Checkhout the repository | |
uses: actions/checkout@v3 | |
- name: Set up JDK 17 | |
uses: actions/setup-java@v3 | |
with: | |
java-version: '17' | |
distribution: 'temurin' | |
cache: maven | |
- name: Set up PostgreSQL | |
env: | |
PGPASSWORD: ${{ secrets.DB_PASSWORD }} | |
run: | | |
psql -h localhost -U ${{ secrets.DB_USERNAME }} -d postgres -c "DROP DATABASE IF EXISTS cs309a;" | |
psql -h localhost -U ${{ secrets.DB_USERNAME }} -d postgres -c "CREATE DATABASE cs309a;" | |
- name: Build with Maven | |
env: | |
DB_USERNAME: ${{ secrets.DB_USERNAME }} | |
DB_PASSWORD: ${{ secrets.DB_PASSWORD }} | |
run: mvn -B package -DskipTests --file pom.xml | |
- name: Run JUnit tests | |
env: | |
DB_USERNAME: ${{ secrets.DB_USERNAME }} | |
DB_PASSWORD: ${{ secrets.DB_PASSWORD }} | |
run: mvn test | |
- name: Upload test results | |
uses: actions/upload-artifact@v3 | |
with: | |
name: junit-results | |
path: target/surefire-reports | |
- name: Clean up PostgreSQL | |
env: | |
PGPASSWORD: ${{ secrets.DB_PASSWORD }} | |
run: | | |
psql -h localhost -U ${{ secrets.DB_USERNAME }} -d postgres -c "DROP DATABASE IF EXISTS cs309a;" | |
psql -h localhost -U ${{ secrets.DB_USERNAME }} -d postgres -c "CREATE DATABASE cs309a;" | |
- name: Upload PostgreSQL logs | |
uses: actions/upload-artifact@v3 | |
with: | |
name: postgres-logs | |
path: /var/log/postgresql |