Revert "Create snyk-security.yml (#106)" (#107) #168
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: Tests and CI | |
| on: | |
| pull_request: | |
| push: | |
| branches: | |
| - main | |
| jobs: | |
| tests: | |
| runs-on: ubuntu-latest | |
| steps: | |
| - uses: actions/checkout@v3 | |
| - name: Start MySQL Server | |
| run: docker run -d -p 3800:3306 --name mysql -e MYSQL_ROOT_PASSWORD=dbtestpassword -e MYSQL_DATABASE=ghworkflow_testdb mysql@sha256:566007208a3f1cc8f9df6b767665b5c9b800fc4fb5f863d17aa1df362880ed04 | |
| - name: Set up Python | |
| uses: actions/setup-python@v4 | |
| with: | |
| python-version: 3.11 | |
| - name: Install MySQL Client | |
| run: sudo apt-get install -y mysql-client | |
| - name: Wait for MySQL Server to Start | |
| run: sleep 10 | |
| - name: Add Testing Database | |
| run: mysql -h 127.0.0.1 -u root -pdbtestpassword -P 3800 -e "CREATE DATABASE testing_ghworkflow_testdb;" | |
| - name: Copy data into database | |
| run: mysql -h 127.0.0.1 -u root -pdbtestpassword -P 3800 ghworkflow_testdb < ./archive/latest.sql | |
| - name: Install Poetry | |
| uses: snok/install-poetry@v1 | |
| - name: Install Dependencies | |
| run: | | |
| poetry install --no-root --no-interaction | |
| - name: Run Tests | |
| run: | | |
| poetry run pytest | |
| env: | |
| MYSQLDATABASE: 'ghworkflow_testdb' | |
| MYSQLUSER: 'root' | |
| MYSQLPASSWORD: 'dbtestpassword' | |
| MYSQLHOST: 'localhost' | |
| MYSQLPORT: '3800' | |
| TESTING_MYSQLDATABASE: 'testing_ghworkflow_testdb' | |
| TESTING_MYSQLUSER: 'root' | |
| TESTING_MYSQLPASSWORD: 'dbtestpassword' | |
| TESTING_MYSQLHOST: 'localhost' | |
| TESTING_MYSQLPORT: '3800' | |
| docker-server-buildable: | |
| runs-on: ubuntu-latest | |
| steps: | |
| - uses: actions/checkout@v3 | |
| - name: Build the server image | |
| run: | | |
| docker build . --tag ghcr.io/thearyadev/top500-aggregator-server:latest --file ./Dockerfile.server | |
| docker-frontend-buildable: | |
| runs-on: ubuntu-latest | |
| steps: | |
| - uses: actions/checkout@v3 | |
| - name: Build the frontend image | |
| run: | | |
| docker build . --tag ghcr.io/thearyadev/top500-aggregator-frontend:latest --file ./Dockerfile.frontend | |
| build_and_publish: | |
| runs-on: ubuntu-latest | |
| needs: | |
| - tests | |
| - docker-server-buildable | |
| - docker-frontend-buildable | |
| if: github.event_name == 'push' && github.ref == 'refs/heads/main' | |
| steps: | |
| - uses: actions/checkout@v3 | |
| - name: Docker Login | |
| run: | | |
| docker login --username thearyadev --password ${{ secrets.GH_PAT }} ghcr.io | |
| - name: Build Frontend | |
| run: | | |
| docker build . --tag ghcr.io/thearyadev/top500-aggregator-frontend:latest --file ./Dockerfile.frontend | |
| - name: Build Server | |
| run: | | |
| docker build . --tag ghcr.io/thearyadev/top500-aggregator-server:latest --file ./Dockerfile.server | |
| - name: push images | |
| run: | | |
| docker push ghcr.io/thearyadev/top500-aggregator-frontend:latest | |
| docker push ghcr.io/thearyadev/top500-aggregator-server:latest |