#!/bin/bash
echo "Stopping mariadb..."
podman stop fzx-aliyun-mariadb

echo "Removing mariadb container..."
podman rm fzx-aliyun-mariadb

echo "Removing mariadb volume..."
podman volume rm fzx-aliyun-mariadb-data

echo "Creating init scripts..."
mkdir -p /opt/fzx/infrastructure/database/mariadb/init
cat > /opt/fzx/infrastructure/database/mariadb/init/00_init.sql << 'EOF'
CREATE DATABASE IF NOT EXISTS fzx_local_life DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE DATABASE IF NOT EXISTS nacos_config DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE USER IF NOT EXISTS 'fzx_app'@'%' IDENTIFIED BY 'Fzx@2024!app';
GRANT ALL ON fzx_local_life.* TO 'fzx_app'@'%';
GRANT ALL ON nacos_config.* TO 'fzx_app'@'%';
FLUSH PRIVILEGES;
EOF

echo "Starting mariadb..."
cd /opt/fzx/deploy
podman-compose -f podman-compose.aliyun-dev.yml up -d mariadb

echo "Waiting for mariadb..."
sleep 30

echo "Verifying..."
podman exec fzx-aliyun-mariadb mysql -u fzx_app -pFzx@2024!app -e "SELECT 1;"

echo "Done!"