package study.u42;

import java.sql.DriverManager;

/** Called by run.py only after the same run reported successful schema creation. */
public final class U42Cleanup {
    public static void main(String[] args) throws Exception {
        if (args.length != 1 || !args[0].matches("study_u42_[0-9a-f]{12}")) throw new IllegalArgumentException("invalid schema");
        String user = System.getenv().getOrDefault("U42_MYSQL_USER", "root");
        String password = System.getenv().getOrDefault("U42_MYSQL_PASSWORD", "");
        String url = "jdbc:mysql://127.0.0.1:3306/?sslMode=DISABLED&allowPublicKeyRetrieval=true&connectTimeout=5000&socketTimeout=5000";
        try (var c=DriverManager.getConnection(url,user,password); var s=c.createStatement()) {
            s.executeUpdate("DROP DATABASE IF EXISTS `" + args[0] + "`");
            try (var rs=s.executeQuery("SELECT SCHEMA_NAME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME='" + args[0] + "'")) {
                if (rs.next()) throw new IllegalStateException("owned schema cleanup failed");
            }
        }
        System.out.println("U42 emergency-cleanup=PASS own-schema=removed");
    }
}