#!/bin/bash

set -Eeuo pipefail

# ============================================================
# CONFIGURATION
# ============================================================

DB_NAME="posdb"

BACKUP_DIR="/var/backups/mysql"

AWS_BUCKET="ikiwae"
AWS_PATH="backupDb"
AWS_REGION="ap-southeast-1"

# ============================================================
# DATE
# ============================================================

CURRENT_DATE=$(date +"%Y%m%d")
DELETE_DATE=$(date -d "7 days ago" +"%Y%m%d")

# ============================================================
# FILE
# ============================================================

BACKUP_FILE="${DB_NAME}_${CURRENT_DATE}.sql.gz"
BACKUP_PATH="${BACKUP_DIR}/${BACKUP_FILE}"

S3_CURRENT_PATH="s3://${AWS_BUCKET}/${AWS_PATH}/${BACKUP_FILE}"

DELETE_KEY="${AWS_PATH}/${DB_NAME}_${DELETE_DATE}.sql.gz"
S3_DELETE_PATH="s3://${AWS_BUCKET}/${DELETE_KEY}"

# ============================================================
# LOG
# ============================================================

log()
{
    echo "[$(date '+%Y-%m-%d %H:%M:%S')] $1"
}

error_exit()
{
    log "ERROR: $1"
    exit 1
}

# ============================================================
# CHECK COMMAND
# ============================================================

command -v mysqldump >/dev/null 2>&1 || \
    error_exit "mysqldump tidak ditemukan."

command -v gzip >/dev/null 2>&1 || \
    error_exit "gzip tidak ditemukan."

command -v aws >/dev/null 2>&1 || \
    error_exit "AWS CLI tidak ditemukan."

# ============================================================
# CREATE BACKUP DIRECTORY
# ============================================================

mkdir -p "$BACKUP_DIR"

chmod 700 "$BACKUP_DIR"

# ============================================================
# START
# ============================================================

log "=============================================="
log "MYSQL BACKUP START"
log "Database     : $DB_NAME"
log "Current Date : $CURRENT_DATE"
log "Delete Date  : $DELETE_DATE"
log "=============================================="

# ============================================================
# 1. MYSQL DUMP + GZIP
# ============================================================

log "Starting MySQL dump..."

mysqldump \
    --single-transaction \
    --quick \
    --routines \
    --events \
    --triggers \
    --hex-blob \
    --default-character-set=utf8mb4 \
    "$DB_NAME" \
    | gzip -1 > "$BACKUP_PATH" \
    || error_exit "MySQL dump / gzip gagal."

# ============================================================
# 2. CHECK BACKUP FILE
# ============================================================

if [ ! -s "$BACKUP_PATH" ]; then
    rm -f "$BACKUP_PATH"
    error_exit "File backup kosong."
fi

BACKUP_SIZE=$(du -h "$BACKUP_PATH" | cut -f1)

log "MySQL dump selesai."
log "Backup File : $BACKUP_PATH"
log "Backup Size : $BACKUP_SIZE"

# ============================================================
# 3. UPLOAD TO AWS S3
# ============================================================

log "Uploading backup ke AWS S3..."

aws s3 cp \
    "$BACKUP_PATH" \
    "$S3_CURRENT_PATH" \
    --region "$AWS_REGION" \
    --only-show-errors \
    || error_exit "Upload ke AWS S3 gagal."

log "Upload AWS S3 selesai."

# ============================================================
# 4. VERIFY UPLOAD
# ============================================================

log "Verifying upload..."

aws s3api head-object \
    --bucket "$AWS_BUCKET" \
    --key "${AWS_PATH}/${BACKUP_FILE}" \
    --region "$AWS_REGION" \
    >/dev/null \
    || error_exit "File tidak ditemukan di AWS setelah upload."

log "Upload berhasil diverifikasi."

# ============================================================
# 5. DELETE LOCAL BACKUP
# ============================================================

log "Menghapus backup lokal..."

rm -f "$BACKUP_PATH"

log "Backup lokal dihapus."

# ============================================================
# 6. DELETE AWS BACKUP 7 DAYS AGO
# ============================================================

log "Checking backup AWS tanggal ${DELETE_DATE}..."

if aws s3api head-object \
    --bucket "$AWS_BUCKET" \
    --key "$DELETE_KEY" \
    --region "$AWS_REGION" \
    >/dev/null 2>&1
then

    log "Backup ditemukan:"
    log "$S3_DELETE_PATH"

    log "Menghapus backup AWS ${DELETE_DATE}..."

    aws s3 rm \
        "$S3_DELETE_PATH" \
        --region "$AWS_REGION" \
        --only-show-errors \
        || error_exit "Gagal menghapus backup AWS ${DELETE_DATE}."

    log "Backup AWS ${DELETE_DATE} berhasil dihapus."

else

    log "Backup AWS ${DELETE_DATE} tidak ditemukan."
    log "Tidak ada yang perlu dihapus."

fi

# ============================================================
# FINISH
# ============================================================

log "=============================================="
log "MYSQL BACKUP SUCCESS"
log "Database    : $DB_NAME"
log "Backup Date : $CURRENT_DATE"
log "Backup Size : $BACKUP_SIZE"
log "AWS File    : ${BACKUP_FILE}"
log "Deleted     : ${DB_NAME}_${DELETE_DATE}.sql.gz"
log "=============================================="

exit 0