ylrz_saas_pharmacy/java/scripts/apply_lobster_menu_dedup.ps1

# Apply lobster company_menu dedup on master + all active tenant DBs and verify
$ErrorActionPreference = "Stop"
$scriptDir = Split-Path -Parent $MyInvocation.MyCommand.Path
$mysqlJar = "$env:USERPROFILE\.m2\repository\com\mysql\mysql-connector-j\8.0.33\mysql-connector-j-8.0.33.jar"
$javaHome = if ($env:JAVA_HOME) { $env:JAVA_HOME } else { "D:\jdk-17.0.2" }

if (-not (Test-Path $mysqlJar)) {
    Write-Host "MySQL JDBC jar missing: $mysqlJar" -ForegroundColor Red
    Write-Host "Run: mvn dependency:get -Dartifact=com.mysql:mysql-connector-j:8.0.33" -ForegroundColor Yellow
    exit 1
}

Push-Location $scriptDir
try {
    & "$javaHome\bin\javac.exe" -encoding UTF-8 ApplyLobsterMenuDedup.java
    if ($LASTEXITCODE -ne 0) { exit $LASTEXITCODE }
    & "$javaHome\bin\java.exe" -cp "$mysqlJar;." ApplyLobsterMenuDedup
    exit $LASTEXITCODE
} finally {
    Pop-Location
}