deployment.yaml

apiVersion: v1
kind: Service
metadata:
  name: postgresql
spec:
  selector:
    app: postgresql
  ports:
  - port: 5432
    targetPort: 5432

---
apiVersion: v1
kind: Service
metadata:
  name: notes-app
spec:
  selector:
    app: notes-app
  ports:
  - port: 8000
    targetPort: 8000
  type: ClusterIP

--- 
apiVersion: apps/v1
kind: Deployment
metadata:
  name: postgresql
spec:
  replicas: 1
  selector:
    matchLabels:
      app: postgresql
  template:
    metadata:
      labels:
        app: postgresql
      annotations:
        # Add OpenTelemetry specific annotations
        instrumentation.opentelemetry.io/inject-python: "true"
    spec:
      containers:
      - name: postgresql
        image: dalareo/notes-db:latest
        # always pull
        imagePullPolicy: Always
        ports:
        - containerPort: 5432
        env:
        # Comprehensive OpenTelemetry Environment Variables
        - name: OTEL_SERVICE_NAME
          value: postgresql-service
        - name: OTEL_RESOURCE_ATTRIBUTES
          value: "service.name=postgresql-service,service.type=database,db.system=postgresql,db.connection_string=postgresql://django@notes:5432/notes"
        - name: OTEL_TRACES_EXPORTER
          value: otlp
        - name: OTEL_EXPORTER_OTLP_ENDPOINT
          value: "http://grafana-k8s-monitoring-alloy.grafana.svc.cluster.local:4317"
        - name: OTEL_TRACE_SAMPLING_RATE
          value: "1.0"
        
        # Database Configuration
        - name: POSTGRES_DB
          value: notes
        - name: POSTGRES_USER
          value: django
        - name: POSTGRES_PASSWORD
          value: "1234"
        - name: POSTGRES_MULTIPLE_DATABASES
          value: notes,django
        
        # Debugging and Logging
        - name: PYTHONUNBUFFERED
          value: "1"
        - name: PYTHONPATH
          value: "/root/.local/lib/python3.x/site-packages"
        
        volumeMounts:
        - name: initdb
          mountPath: /docker-entrypoint-initdb.d
        readinessProbe:
          exec:
            command:
            - pg_isready
            - -U
            - django
          initialDelaySeconds: 15
          periodSeconds: 10
      volumes:
      - name: initdb
        configMap:
          name: postgresql-init
          defaultMode: 0755

---
apiVersion: apps/v1
kind: Deployment
metadata:
  name: notes-app
spec:
  replicas: 1
  selector:
    matchLabels:
      app: notes-app
  template:
    metadata:
      labels:
        app: notes-app
      annotations:
        # Add OpenTelemetry specific annotations
        instrumentation.opentelemetry.io/inject-python: "true"
    spec:
      containers:
      - name: notes-app
        image: dalareo/notes-app:latest
        #always pull
        imagePullPolicy: Always
        ports:
        - containerPort: 8000
        env:
        # Database Connection
        - name: DB_NAME
          value: django
        - name: DB_USER
          value: django
        - name: DB_PASSWORD
          value: "1234"
        - name: DB_HOST
          value: postgresql
        - name: DB_PORT
          value: "5432"
        
        # Django and OpenTelemetry Configuration
        - name: DJANGO_SETTINGS_MODULE
          value: django_project.settings
        - name: DJANGO_LOG_LEVEL
          value: INFO
        - name: ALLOWED_HOSTS
          value: "*"
        - name: DEBUG
          value: "True"
        
        # OpenTelemetry Environment Variables
        - name: OTEL_SERVICE_NAME
          value: notes-web-service
        - name: OTEL_EXPORTER_OTLP_ENDPOINT
          value: "http://grafana-k8s-monitoring-alloy.grafana.svc.cluster.local:4317"
        - name: OTEL_TRACES_SAMPLER
          value: "always_on"
        - name: OTEL_TRACES_EXPORTER
          value: "otlp"
        - name: OTEL_PYTHON_LOG_CORRELATION
          value: "true"
        
        command: ["/bin/sh", "-c"]
        args:
        - |
          # Wait for database to be ready
          until pg_isready -h postgresql -p 5432 -U django; do
            echo "Waiting for PostgreSQL to be ready..."
            sleep 5
          done

          # Rest of your startup script
          pip install --user psycopg2-binary
          python manage.py makemigrations
          python manage.py migrate
          python manage.py runserver 0.0.0.0:8000

        readinessProbe:
          httpGet:
            path: /
            port: 8000
          initialDelaySeconds: 30
          periodSeconds: 10

---
apiVersion: v1
kind: ConfigMap
metadata:
  name: postgresql-init
data:
  create-multiple-databases.sh: |
    #!/bin/bash
    set -e
    set -u

    function create_user_and_database() {
      local database=$1
      echo "Creating database '$database'"
      psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" postgres <<-EOSQL
        SELECT 'CREATE DATABASE $database' 
        WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = '$database')\gexec
        GRANT ALL PRIVILEGES ON DATABASE $database TO $POSTGRES_USER;
    EOSQL
    }

    if [ -n "$POSTGRES_MULTIPLE_DATABASES" ]; then
      echo "Multiple database creation requested: $POSTGRES_MULTIPLE_DATABASES"
      for db in $(echo $POSTGRES_MULTIPLE_DATABASES | tr ',' ' '); do
        create_user_and_database $db
      done
      echo "Multiple databases created"
    fi
    echo "Generating sample trace"
    psql -v ON_ERROR_STOP=1 --username "$POSTGRES_USER" -c "SELECT 1" postgres