dockerfile

# Stage 1: Build the application
FROM golang:1.25-alpine AS builder

WORKDIR /app

# Copy go.mod and go.sum first to leverage Docker layer caching
COPY go.mod go.sum ./
RUN go mod download

# Copy the rest of the application source code
COPY . .

# Build the Go application
RUN CGO_ENABLED=0 GOOS=linux go build -o /go-app ./cli/sandbox/main.go

# Stage 2: Create a minimal runtime image
FROM alpine:latest

WORKDIR /app

# Copy the built binary from the builder stage
COPY --from=builder /go-app .

# ✅ Copy SQLite/DB file from the builder stage
# Assuming your project path is: /app/pkg/db/sql/index.db
COPY --from=builder /app/pkg/db/sql/index.db /app/pkg/db/sql/index.db

# Create directory if not exists (optional edge case fix)
RUN mkdir -p /app/sql

# Expose the port your application listens on
EXPOSE 8088

# Command to run the application
CMD ["./go-app"]