#!/bin/bash
MYSQL_CONTAINER=$(docker ps -q --filter ancestor=mysql:8 | head -1)
if [ -z "$MYSQL_CONTAINER" ]; then
  echo "❌ MySQL container not found"
  exit 1
fi
echo "MySQL container: $MYSQL_CONTAINER"
docker exec "$MYSQL_CONTAINER" mysql -u root -pnpm_root_password -e "
  CREATE DATABASE IF NOT EXISTS pc_builder;
  CREATE USER IF NOT EXISTS 'pcbuilder'@'%' IDENTIFIED BY 'pcbuilder_secure_pass';
  GRANT ALL PRIVILEGES ON pc_builder.* TO 'pcbuilder'@'%';
  FLUSH PRIVILEGES;
"
echo "✅ Database pc_builder created"