run/init-db/job.yaml

# Copyright 2024 Google LLC
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this file except in compliance with the License.
# You may obtain a copy of the License at
#
#      http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
# See the License for the specific language governing permissions and
# limitations under the License.

apiVersion: run.googleapis.com/v1
kind: Job
metadata:
  name: init-db
  labels:
    cloud.googleapis.com/location: __REGION__
spec:
  template:
    metadata:
      annotations:
        run.googleapis.com/network-interfaces: '[{"network":"production-network","subnetwork":"run-subnet"}]'
        run.googleapis.com/vpc-access-egress: all-traffic
    spec:
      template:
        spec:
          serviceAccountName: cloud-run-sa
          containers:
          - name: init-db
            image: __REGION__-docker.pkg.dev/__PROJECT__/default-repository/init-db:latest
            env:
            - name: DB_HOST
              valueFrom:
                secretKeyRef:
                  name: db-host
                  key: latest
            - name: DB_USER
              valueFrom:
                secretKeyRef:
                  name: db-admin-user
                  key: latest
            - name: APP_USER
              valueFrom:
                secretKeyRef:
                  name: db-iam-user
                  key: latest
            - name: DB_PASS
              valueFrom:
                secretKeyRef:
                  name: db-admin-pass
                  key: latest
            - name: DB_NAME
              valueFrom:
                secretKeyRef:
                  name: db-name
                  key: latest
            resources:
              limits:
                cpu: "1"
                memory: 2Gi
              requests:
                cpu: "1"
                memory: 2Gi