ci: add DB to PR deploys (coder#8770)

bpmct · web-flow · commit 34dfbfa9d3c8 · 2023-07-27T14:50:53.000Z
* ci: add DB to PR deploys

* add bitnami remo

* fix namespace

* change ingress host

* remove wildcard host
diff --git a/.github/workflows/pr-deploy.yaml b/.github/workflows/pr-deploy.yaml
@@ -198,6 +198,18 @@ jobs:
           EOF
           kubectl apply -f ingress.yaml
 
+      - name: Set up PostgreSQL database
+        run: |
+          helm repo add bitnami https://charts.bitnami.com/bitnami
+          helm install coder-db bitnami/postgresql \
+            --namespace pr${{ env.PR_NUMBER }} \
+            --set auth.username=coder \
+            --set auth.password=coder \
+            --set auth.database=coder \
+            --set persistence.size=10Gi
+          kubectl create secret generic coder-db-url -n pr${{ env.PR_NUMBER }} \
+            --from-literal=url="postgres://coder:coder@coder-db-postgresql.pr${{ env.PR_NUMBER }}.svc.cluster.local:5432/coder?sslmode=disable"
+
       - name: Create values.yaml
         run: |
           cat <<EOF > pr-deploy-values.yaml
@@ -215,6 +227,11 @@ jobs:
                 value: "*--pr${{ env.PR_NUMBER }}.${{ secrets.PR_DEPLOYMENTS_DOMAIN }}"
               - name: "CODER_EXPERIMENTS"
                 value: "*"
+              - name: CODER_PG_CONNECTION_URL
+                valueFrom:
+                  secretKeyRef:
+                    name: coder-db-url
+                    key: url
               - name: "CODER_OAUTH2_GITHUB_ALLOW_SIGNUPS"
                 value: "true"
               - name: "CODER_OAUTH2_GITHUB_CLIENT_ID"
