Add # Entires to Charts #18
Workflow file for this run
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: | |
| 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' | |
| build_and_publish: | |
| runs-on: ubuntu-latest | |
| needs: tests | |
| if: github.event_name == 'push' && github.ref == 'refs/heads/main' | |
| steps: | |
| - uses: actions/checkout@v3 | |
| - name: Build and push the image | |
| run: | | |
| docker login --username thearyadev --password ${{ secrets.GH_PAT }} ghcr.io | |
| docker build . --tag ghcr.io/thearyadev/top500-aggregator:latest | |
| docker push ghcr.io/thearyadev/top500-aggregator:latest |