FROM oven/bun:1-alpine AS deps
WORKDIR /app
RUN apk add --no-cache python3 make g++ nodejs npm
COPY package.json bun.lock ./
RUN bun install --frozen-lockfile
RUN npm rebuild better-sqlite3

FROM oven/bun:1-alpine AS builder
WORKDIR /app
RUN apk add --no-cache nodejs npm
COPY --from=deps /app/node_modules ./node_modules
COPY . .
RUN cp .build-db.sqlite /tmp/build.db \
 && DATABASE_PATH=/tmp/build.db bun run scripts/migrate.ts \
 && DATABASE_PATH=/tmp/build.db npm run build

FROM oven/bun:1-alpine AS runner
WORKDIR /app
RUN apk add --no-cache nodejs

ENV NODE_ENV=production
ENV HOSTNAME=0.0.0.0
ENV PORT=3000
ENV DATABASE_PATH=/app/data/rate-my-shots.db
ENV NODE_OPTIONS=--dns-result-order=ipv4first

COPY --from=builder --chown=bun:bun /app/.next/standalone ./
COPY --from=builder --chown=bun:bun /app/.next/static ./.next/static
COPY --from=builder --chown=bun:bun /app/public ./public

COPY --from=builder --chown=bun:bun /app/drizzle ./drizzle
COPY --from=builder --chown=bun:bun /app/scripts ./scripts
COPY --from=builder --chown=bun:bun /app/node_modules/drizzle-orm ./node_modules/drizzle-orm

RUN mkdir -p /app/data && chown bun:bun /app/data

USER bun

EXPOSE 3000

CMD sh -c "bun run scripts/migrate.ts && node server.js"
