# Example base image for Node.js applications
FROM node:20-alpine AS base

# Set working directory
WORKDIR /app

# Install dependencies
RUN apk add --no-cache libc6-compat
RUN npm install -g pnpm turbo

# Set environment variables
ENV NODE_ENV=production
ENV PORT=3000

# Set health check
HEALTHCHECK --interval=30s --timeout=10s --start-period=5s --retries=3 \
  CMD wget -qO- http://localhost:$PORT/api/health || exit 1

# Set user to non-root
USER node

# Expose port
EXPOSE $PORT

# Command is set in the app-specific Dockerfile

# Example Dockerfile for a Next.js application
FROM moodmnky/base-node:20 AS builder

# Copy package files
COPY --chown=node:node package.json pnpm-lock.yaml ./
COPY --chown=node:node apps/web/package.json ./apps/web/
COPY --chown=node:node packages/ui/package.json ./packages/ui/
COPY --chown=node:node packages/config/package.json ./packages/config/

# Install dependencies
RUN pnpm install --frozen-lockfile

# Copy source code
COPY --chown=node:node . .

# Build application
RUN pnpm turbo run build --filter=web...

# Production image
FROM moodmnky/base-node:20 AS runner

# Copy built application
COPY --from=builder --chown=node:node /app/apps/web/.next/standalone ./
COPY --from=builder --chown=node:node /app/apps/web/.next/static ./apps/web/.next/static
COPY --from=builder --chown=node:node /app/apps/web/public ./apps/web/public

# Set environment variables
ENV NODE_ENV production
ENV PORT 3000

# Start the application
CMD ["node", "apps/web/server.js"]

# Create a new migration
pnpm supabase:migration create add_user_preferences

# Apply migrations to local development
pnpm supabase:migration up

# Generate migration from current database state
pnpm supabase:migration dump

-- Adding a new table
create table if not exists public.user_preferences (
  id uuid primary key default uuid_generate_v4(),
  user_id uuid references public.users not null,
  preference_key text not null,
  preference_value jsonb not null,
  created_at timestamp with time zone default now(),
  updated_at timestamp with time zone default now(),
  unique(user_id, preference_key)
);

-- Add RLS policies
alter table public.user_preferences enable row level security;

create policy "Users can view their own preferences"
  on public.user_preferences for select
  using (auth.uid() = user_id);
  
create policy "Users can insert their own preferences"
  on public.user_preferences for insert
  with check (auth.uid() = user_id);
  
create policy "Users can update their own preferences"
  on public.user_preferences for update
  using (auth.uid() = user_id);

-- Step 1: Add new column without constraints
alter table public.users add column display_name text;

-- Step 2: Populate the new column
update public.users set display_name = username where display_name is null;

-- Step 3: Add constraints after data is populated
alter table public.users alter column display_name set not null;

-- Step 1: Deprecate in code (no longer write to column)
-- Step 2: After release, drop column
alter table public.users drop column if exists legacy_field;

# Example blue-green service configuration
apiVersion: v1
kind: Service
metadata:
  name: web-app
  namespace: mood-mnky-production
spec:
  selector:
    app: web-app
    version: green  # Switch between blue and green
  ports:
  - port: 80
    targetPort: 3000

# Example Kubernetes manifest for canary deployment
apiVersion: networking.k8s.io/v1
kind: Ingress
metadata:
  name: web-app
  namespace: mood-mnky-production
  annotations:
    nginx.ingress.kubernetes.io/canary: "true"
    nginx.ingress.kubernetes.io/canary-weight: "20"
spec:
  rules:
  - host: moodmnky.co
    http:
      paths:
      - path: /
        pathType: Prefix
        backend:
          service:
            name: web-app-canary
            port:
              number: 80

# Example Kubernetes deployment with rolling update strategy
apiVersion: apps/v1
kind: Deployment
metadata:
  name: web-app
  namespace: mood-mnky-production
spec:
  replicas: 3
  strategy:
    type: RollingUpdate
    rollingUpdate:
      maxSurge: 1
      maxUnavailable: 0
  # ... rest of deployment configuration