include TRANSLATIONS_DIR as environment variable in the Docker image

Dockerfile

-FROM python:3.11
+FROM python:3.11-alpine
 
 ARG ARTIFACT_VERSION
 
+RUN apk add gcc libc-dev libffi-dev
 RUN pip install \
     --pre \
     --extra-index-url https://artifactory.software.geant.org/artifactory/api/pypi/geant-swd-pypi/simple \
+    --target /app \
     geant-service-orchestrator==${ARTIFACT_VERSION}
 
+WORKDIR /app
+
 # Create the directory for the configuration and copy the example config into it
 # NOTE: a real config must be mounted at /etc/gso/config.json when running the container
 RUN mkdir -p /etc/gso
 COPY gso/oss-params-example.json /etc/gso/config.json
 
 # Expose port 8080 for the FastAPI application
 EXPOSE 8080
@@ -18,4+22,4 @@
 # The app reads the configuration from this location.
 # No need to set environment variables in your docker-compose.
 ENV OSS_PARAMS_FILENAME=/etc/gso/config.json
+# Set the environment variable for the translations directory
+ENV TRANSLATIONS_DIR=/app/gso/translations/
+# Run database migrations
+RUN mv gso/migrations gso/migrations_temp
+RUN PYTHONPATH=. python gso/main.py db init
+RUN rm -rf gso/migrations && mv gso/migrations_temp gso/migrations
+RUN PYTHONPATH=. python gso/main.py db upgrade heads
 
 # Start the FastAPI application
-CMD ["uvicorn", "gso.main:app", "--host", "0.0.0.0", "--port", "8080"]
+CMD ["python", "-m", "uvicorn", "gso.main:app", "--host", "0.0.0.0", "--port", "8080"]