Backend-Service/Dockerfile.library-artwork-url-backfill at main · WXYC/Backend-Service · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
#Build stage
FROM node:24-alpine AS builder

ARG NPM_TOKEN
WORKDIR /library-artwork-url-backfill-builder

COPY ./.npmrc ./
COPY ./package.json ./package-lock.json ./
COPY ./tsconfig.base.json ./
COPY ./shared/database ./shared/database
COPY ./shared/lml-client ./shared/lml-client
COPY ./shared/metadata ./shared/metadata
COPY ./jobs/library-artwork-url-backfill ./jobs/library-artwork-url-backfill

RUN npm ci && npm run build --workspace=@wxyc/database --workspace=@wxyc/lml-client --workspace=@wxyc/metadata --workspace=@wxyc/library-artwork-url-backfill

#Production stage
FROM node:24-alpine AS prod

ARG NPM_TOKEN
WORKDIR /library-artwork-url-backfill

COPY ./.npmrc ./
COPY ./package* ./
COPY ./jobs/library-artwork-url-backfill/package* ./jobs/library-artwork-url-backfill/
COPY ./shared/database/package* ./shared/database/
COPY ./shared/lml-client/package* ./shared/lml-client/
COPY ./shared/metadata/package* ./shared/metadata/

# `@wxyc/lml-client` declares `@wxyc/shared` as a registry dependency
# (GitHub Packages, `@wxyc:registry` in `.npmrc`). Without NPM_TOKEN +
# .npmrc the prod stage's npm install 401s on @wxyc/shared. Mirrors the
# pattern in Dockerfile.backend / Dockerfile.flowsheet-metadata-backfill.
RUN npm install --omit=dev && rm -f .npmrc

COPY --from=builder ./library-artwork-url-backfill-builder/jobs/library-artwork-url-backfill/dist ./jobs/library-artwork-url-backfill/dist
COPY --from=builder ./library-artwork-url-backfill-builder/shared/database/dist ./shared/database/dist
COPY --from=builder ./library-artwork-url-backfill-builder/shared/lml-client/dist ./shared/lml-client/dist
COPY --from=builder ./library-artwork-url-backfill-builder/shared/metadata/dist ./shared/metadata/dist

# Long-running per-statement timeout: per-row UPDATEs are tiny (single-column,
# id-equality WHERE) but the SELECT batch joins library to artists; a tightly
# scoped 5s default is overkill for the latter and the former. The flowsheet-
# metadata-backfill precedent uses 300s; keep parity. Disable per-statement
# timeouts and rely on the orchestrator's per-LML-call abort signal for the
# only operation that can actually exceed seconds.
ENV DB_STATEMENT_TIMEOUT_MS=300000

# Async commit: each per-row UPDATE returns as soon as the WAL hits the OS
# buffer rather than waiting for fsync. Safe because the WHERE filter is
# idempotent (`artwork_url IS NULL`); any work lost to an RDS crash is picked
# up on the next sweep. Saves per-batch latency at the cost of a tiny RPO.
ENV DB_SYNCHRONOUS_COMMIT=off

# Identifies the connection in pg_stat_activity during incident triage.
ENV DB_APPLICATION_NAME=wxyc-library-artwork-url-backfill

CMD ["npm", "start", "--workspace=@wxyc/library-artwork-url-backfill"]