
apiVersion: v1
kind: Secret
metadata:
name: mini-project-secret
namespace: default
data:
DB_HOST: bXlzcWwtMC5teXNxbC5kZWZhdWx0LnN2Yy5jbHVzdGVyLmxvY2Fs
DB_USER: cm9vdA==
DB_PASS: c3BhcnRh
DB_DATABASE: c3BhcnRh

apiVersion: batch/v1
kind: Job
metadata:
name: eightzero-delete-job
namespace: default
spec:
template:
spec:
containers:
- name: mysql-client
image: mysql:8.0
env:
- name: MYSQL_HOST
valueFrom:
secretKeyRef:
name: mini-project-secret
key: DB_HOST
- name: MYSQL_USER
valueFrom:
secretKeyRef:
name: mini-project-secret
key: DB_USER
- name: MYSQL_PASSWORD
valueFrom:
secretKeyRef:
name: mini-project-secret
key: DB_PASS
- name: MYSQL_DATABASE
valueFrom:
secretKeyRef:
name: mini-project-secret
key: DB_DATABASE
command: ["sh", "-c", "mysql -h$MYSQL_HOST -u$MYSQL_USER -p$MYSQL_PASSWORD $MYSQL_DATABASE -e \"DELETE FROM users WHERE user_code = '00000000';\""]
restartPolicy: Never




apiVersion: batch/v1
kind: CronJob
metadata:
name: eightzero-delete-cronjob
namespace: default
spec:
schedule: "*/1 * * * *"
jobTemplate:
spec:
template:
spec:
containers:
- name: mysql-client
image: mysql:8.0
env:
- name: MYSQL_HOST
valueFrom:
secretKeyRef:
name: mini-project-secret
key: DB_HOST
- name: MYSQL_USER
valueFrom:
secretKeyRef:
name: mini-project-secret
key: DB_USER
- name: MYSQL_PASSWORD
valueFrom:
secretKeyRef:
name: mini-project-secret
key: DB_PASS
- name: MYSQL_DATABASE
valueFrom:
secretKeyRef:
name: mini-project-secret
key: DB_DATABASE
command: ["sh", "-c", "mysql -h$MYSQL_HOST -u$MYSQL_USER -p$MYSQL_PASSWORD $MYSQL_DATABASE -e \"DELETE FROM users WHERE user_code = '00000000';\""]
restartPolicy: Never
successfulJobsHistoryLimit: 3
failedJobsHistoryLimit: 3

