Use in-memory database for pre-commit tests

Reviewed-on: #103

.drone.yml

@@ -15,7 +15,7 @@ trigger:
 
 steps:
   - name: install-lint-test
-    image: python:3.9.21-alpine@sha256:f2f6a5627a879693b8c23e04df0b1a6aae3e09c165fa2a08f5c64b2b54c58d3c
+    image: python:3.10.18-alpine@sha256:24cab748bf7bd8e3d2f9bb4e5771f17b628417527a4e1f2c59c370c2a8a27f1c
     env:
       PYROOT: '/pyroot'
       PYTHONUSERBASE: '/pyroot'
@@ -104,7 +104,7 @@ trigger:
 
 steps:
   - name: install-lint-test
-    image: python:3.9.21-alpine@sha256:f2f6a5627a879693b8c23e04df0b1a6aae3e09c165fa2a08f5c64b2b54c58d3c
+    image: python:3.10.18-alpine@sha256:24cab748bf7bd8e3d2f9bb4e5771f17b628417527a4e1f2c59c370c2a8a27f1c
     env:
       PYROOT: '/pyroot'
       PYTHONUSERBASE: '/pyroot'

.pre-commit-config.yaml

@@ -19,7 +19,7 @@ repos:
       exclude: ^(migrations).*$
     - id: unittest
       name: unittest
-      entry: python -m unittest discover ki
+      entry: env SQLALCHEMY_DATABASE_URI=sqlite:// python -m unittest discover ki
       language: system
       exclude: .*
       always_run: true

.python-version

@@ -1 +1 @@
-3.9.21
+3.10.18

Dockerfile

@@ -2,7 +2,7 @@
 #
 # SPDX-License-Identifier: AGPL-3.0-or-later
 
-FROM python:3.9.21-alpine@sha256:f2f6a5627a879693b8c23e04df0b1a6aae3e09c165fa2a08f5c64b2b54c58d3c AS builder
+FROM python:3.10.18-alpine@sha256:24cab748bf7bd8e3d2f9bb4e5771f17b628417527a4e1f2c59c370c2a8a27f1c AS builder
 
 ENV PYROOT=/pyroot
 ENV PYTHONUSERBASE=$PYROOT
@@ -20,7 +20,7 @@ RUN PIP_USER=1 PIP_IGNORE_INSTALLED=1 pipenv install --system --deploy --ignore-
 RUN pip3 uninstall --yes pipenv
 
 
-FROM python:3.9.21-alpine@sha256:f2f6a5627a879693b8c23e04df0b1a6aae3e09c165fa2a08f5c64b2b54c58d3c AS ki-backend
+FROM python:3.10.18-alpine@sha256:24cab748bf7bd8e3d2f9bb4e5771f17b628417527a4e1f2c59c370c2a8a27f1c AS ki-backend
 
 ENV PYROOT=/pyroot
 ENV PYTHONUSERBASE=$PYROOT

Pipfile

@@ -8,7 +8,7 @@ verify_ssl = true
 name = "pypi"
 
 [packages]
-flask = "==3.1.2"
+flask = "==2.3.3"
 python-dotenv = "==1.0.1"
 flask-migrate = "==4.0.7"
 flask-sqlalchemy  = "==3.1.1"
@@ -27,7 +27,7 @@ pre-commit = "==2.21.0"
 reuse = "==4.0.3"
 
 [requires]
-python_version = "3.9"
+python_version = "3.10"
 
 [scripts]
 clean = "rm data/ki.sqlite"

Pipfile.lock

@@ -1,11 +1,11 @@
 {
     "_meta": {
         "hash": {
-            "sha256": "9dbe1a2f4aaaca2e5ea20641725c8afbdcf48ca6ac73be0314d6dba38232e8a2"
+            "sha256": "d02162eab1995247a9fd1bdd475877457c277b2a8c608a4df0366126b1051ed1"
         },
         "pipfile-spec": 6,
         "requires": {
-            "python_version": "3.9"
+            "python_version": "3.10"
         },
         "sources": [
             {

README.md

@@ -39,7 +39,7 @@ Folgende Kanäle gibt es für die Kommunikation über das Kompetenzinventar:
 
 ### Abhängigkeiten
 
-- Python 3.9
+- Python 3.10
 - [Pipenv](https://github.com/pypa/pipenv)