import java.nio.file.*;
import java.sql.*;
import java.util.*;

/**
 * One-off backfill for the development database: applies V144's create-table statements with
 * `if not exists`, taken verbatim from the migration file so the dev schema cannot drift from it.
 *
 * <p>Needed only because a server started before {@code MerchantOnboardingSchemaInitializer} learned
 * to create tables keeps running with the old code path; after a restart the initializer does this
 * by itself, and on a Flyway-managed schema (the test database) Flyway has already done it.
 *
 * <p>Additive only: it never drops or alters anything, and it refuses to touch any table that
 * already exists.
 *
 * usage: java -cp <mysql-connector-j.jar>:. ApplyV144ToDevDatabase.java [jdbcUrl]
 */
public class ApplyV144ToDevDatabase {
  public static void main(String[] args) throws Exception {
    String url = args.length > 0
        ? args[0]
        : "jdbc:mysql://127.0.0.1:8134/talent_card?useUnicode=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai&allowPublicKeyRetrieval=true&useSSL=false";
    String migration = Path.of("../../talent-card-server/src/main/resources/db/migration/V144__existing_merchant_onboarding_progress.sql").toAbsolutePath().normalize().toString();
    String[] statements = Files.readString(Path.of(migration))
        .replaceAll("(?i)create table (?!if not exists)", "create table if not exists ")
        .split(";\\s*\\n");

    try (Connection connection = DriverManager.getConnection(url, "root", "123456")) {
      for (String statement : statements) {
        if (statement.isBlank()) continue;
        try (Statement executor = connection.createStatement()) {
          executor.execute(statement);
          System.out.println("applied: " + statement.strip().split("\\n")[0]);
        }
      }
    }
  }
}