Add sample schedule script and update README on how to schedule runs #129
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: commcare-export tests | |
| on: | |
| pull_request: | |
| branches: | |
| - master | |
| env: | |
| DB_USER: db_user | |
| DB_PASSWORD: Password123 | |
| jobs: | |
| test: | |
| runs-on: ubuntu-22.04 | |
| services: | |
| mssql: | |
| image: mcr.microsoft.com/mssql/server:2017-latest | |
| env: | |
| SA_PASSWORD: ${{ env.DB_PASSWORD }} | |
| ACCEPT_EULA: 'Y' | |
| ports: | |
| - 1433:1433 | |
| postgres: | |
| image: postgres | |
| env: | |
| POSTGRES_PASSWORD: ${{ env.DB_PASSWORD }} | |
| POSTGRES_USER: ${{ env.DB_USER }} | |
| options: >- | |
| --health-cmd pg_isready | |
| --health-interval 10s | |
| --health-timeout 5s | |
| --health-retries 5 | |
| ports: | |
| - 5432:5432 | |
| strategy: | |
| matrix: | |
| python-version: ['3.8', '3.9', '3.10', '3.11', '3.12'] | |
| steps: | |
| - uses: actions/checkout@v3 | |
| with: | |
| fetch-depth: 50 | |
| - run: git fetch --tags origin # So we can use git describe. actions/checkout@v3 does not pull tags. | |
| # MySQL set up | |
| - run: sudo service mysql start # Ubuntu already includes mysql no need to use service | |
| - run: mysql -uroot -proot -e "CREATE USER '${{ env.DB_USER }}'@'%';" | |
| - run: mysql -uroot -proot -e "GRANT ALL PRIVILEGES ON *.* TO '${{ env.DB_USER }}'@'%';" | |
| - uses: actions/setup-python@v4 | |
| with: | |
| python-version: ${{ matrix.python-version }} | |
| - run: sudo apt-get install pandoc | |
| - run: pip install --upgrade pip | |
| - run: pip install setuptools | |
| - run: python setup.py sdist | |
| - run: pip install dist/* | |
| - run: pip install pymysql psycopg2 pyodbc | |
| - run: pip install coverage coveralls | |
| - run: pip install mypy | |
| - run: pip install pytest | |
| - run: pip install -e ".[test]" | |
| - run: coverage run setup.py test | |
| env: | |
| POSTGRES_URL: postgresql://${{ env.DB_USER }}:${{ env.DB_PASSWORD }}@localhost/ | |
| MYSQL_URL: mysql+pymysql://${{ env.DB_USER }}:@localhost/ | |
| MSSQL_URL: mssql+pyodbc://sa:${{ env.DB_PASSWORD }}@localhost/ | |
| HQ_USERNAME: ${{ secrets.HQ_USERNAME }} | |
| HQ_API_KEY: ${{ secrets.HQ_API_KEY }} | |
| - run: mypy --install-types --non-interactive @mypy_typed_modules.txt | |
| - run: coverage lcov -o coverage/lcov.info | |
| - name: Coveralls | |
| uses: coverallsapp/github-action@v2 | |
| with: | |
| github-token: | |
| ${{ secrets.GITHUB_TOKEN }} |