fix: install libpq5 runtime in API prod Docker stage

psycopg2 compiled against libpq-dev in the build stage now has its runtime dependency (libpq5) available in the prod stage. Co-Authored-By: Paperclip <noreply@paperclip.ing>
Merge pull request #125 from cartsnitch/fix/alembic-percent-escape
2026-04-04 10:51:57 +00:00 · 2026-04-04 06:36:51 +00:00 · 2026-04-04 06:31:48 +00:00 · 2026-04-04 06:23:34 +00:00
3 changed files with 4 additions and 2 deletions
@@ -12,6 +12,8 @@ RUN pip install --no-cache-dir --prefix=/install .

 FROM python:3.12-slim AS prod

+RUN apt-get update && apt-get install -y --no-install-recommends libpq5 && rm -rf /var/lib/apt/lists/*
+
 WORKDIR /app
 RUN adduser --system --group --uid 1000 app
 COPY --from=build /install /usr/local
@@ -18,7 +18,7 @@ if not db_url:
        "CARTSNITCH_DATABASE_URL_SYNC must be set. "
        "Example: postgresql://user:pass@localhost:5432/cartsnitch"
    )
-config.set_main_option("sqlalchemy.url", db_url)
+config.set_main_option("sqlalchemy.url", db_url.replace("%", "%%"))

 target_metadata = Base.metadata

@@ -14,7 +14,7 @@ if config.config_file_name is not None:

 db_url = os.environ.get("CARTSNITCH_DATABASE_URL_SYNC")
 if db_url:
-    config.set_main_option("sqlalchemy.url", db_url)
+    config.set_main_option("sqlalchemy.url", db_url.replace("%", "%%"))

 target_metadata = Base.metadata
Author	SHA1	Message	Date
Barcode Betty	a25b673dd6	fix: install libpq5 runtime in API prod Docker stage psycopg2 compiled against libpq-dev in the build stage now has its runtime dependency (libpq5) available in the prod stage. Co-Authored-By: Paperclip <noreply@paperclip.ing>	2026-04-04 10:51:57 +00:00
cartsnitch-cto[bot]	4e003ba3d0	Merge pull request #125 from cartsnitch/fix/alembic-percent-escape fix(api): escape percent signs in alembic database URL	2026-04-04 06:36:51 +00:00
Barcode Betty	4996ff7432	fix(api): escape percent signs in alembic database URL for configparser CNPG-generated passwords containing URL-encoded chars (e.g. %2B, %2F) cause configparser.BasicInterpolation to fail with "invalid interpolation syntax". Escaping % as %% prevents this. Co-Authored-By: Paperclip <noreply@paperclip.ing>	2026-04-04 06:31:48 +00:00
cartsnitch-cto[bot]	ffc6c7960d	fix(api): add server_default to users.email_inbound_token (#123 ) fix(api): add server_default to users.email_inbound_token	2026-04-04 06:23:34 +00:00