added database checker

1 files changed, 32 insertions, 0 deletions

diff --git a/.github/workflows/test-database.yaml b/.github/workflows/test-database.yaml
new file mode 100644
index 0000000..b119682
--- /dev/null
+++ b/.github/workflows/test-database.yaml
@@ -0,0 +1,32 @@
+name: Python package
+
+on: [push]
+
+jobs:
+  build:
+
+    runs-on: ubuntu-latest
+    strategy:
+      matrix:
+        python-version: [3.7]
+
+    steps:
+    - uses: actions/checkout@v2
+    - name: Set up Python ${{ matrix.python-version }}
+      uses: actions/setup-python@v2
+      with:
+        python-version: ${{ matrix.python-version }}
+    - name: Install dependencies
+      run: |
+        python -m pip install --upgrade pip
+        pip install flake8 mysql-connector-python-rf mysql
+        if [ -f requirements.txt ]; then pip install -r requirements.txt; fi
+    - name: Lint script with flake8
+      run: |
+        # stop the build if there are Python syntax errors or undefined names
+        flake8 ./app/dbTestFiller.py --count --select=E9,F63,F7,F82 --show-source --statistics
+        # exit-zero treats all errors as warnings. The GitHub editor is 127 chars wide
+        flake8 ./app/dbTestFiller.py --count --exit-zero --max-complexity=10 --max-line-length=127 --statistics
+    - name: Run Database-Filler script
+      run: |
+      python ./app/dbTestFiller.py
\ No newline at end of file