import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;

/** Minimal wx_sop / qw_sop stubs for lobster travel validation on incomplete tenant DBs. */
public class ApplySopValidationStubs {
    private static final String URL = "jdbc:mysql://cq-cdb-8fjmemkb.sql.tencentcdb.com:27220/ylrz_saas"
            + "?useSSL=false&serverTimezone=GMT%2B8&allowMultiQueries=true";
    private static final String USER = "root";
    private static final String PWD = "Ylrz_1q2w3e4r5t6y";

    public static void main(String[] args) throws Exception {
        try (Connection c = DriverManager.getConnection(URL, USER, PWD);
             Statement st = c.createStatement()) {
            st.execute("CREATE TABLE IF NOT EXISTS wx_sop ("
                    + "id BIGINT AUTO_INCREMENT PRIMARY KEY,"
                    + "name VARCHAR(255), filter_type INT, select_tags VARCHAR(2000),"
                    + "exclude_tags VARCHAR(2000), temp_id VARCHAR(100), company_id BIGINT,"
                    + "is_fixed INT, expiry_time INT, start_time DATE, account_ids VARCHAR(2000),"
                    + "create_time DATETIME DEFAULT CURRENT_TIMESTAMP, create_by VARCHAR(255),"
                    + "update_time DATETIME, update_by VARCHAR(255), status INT, remark VARCHAR(500),"
                    + "KEY idx_temp_company (company_id, temp_id)"
                    + ") ENGINE=InnoDB DEFAULT CHARSET=utf8mb4");
            st.execute("CREATE TABLE IF NOT EXISTS qw_sop ("
                    + "id VARCHAR(100) NOT NULL PRIMARY KEY,"
                    + "name VARCHAR(255), status INT, type INT, temp_id VARCHAR(100),"
                    + "company_id BIGINT, create_time DATETIME DEFAULT CURRENT_TIMESTAMP,"
                    + "KEY idx_temp_company (company_id, temp_id)"
                    + ") ENGINE=InnoDB DEFAULT CHARSET=utf8mb4");
            st.execute("DELETE FROM wx_sop WHERE company_id=338 AND temp_id='LOBSTER_TRAVEL_POST_BOOKING_WX'");
            st.execute("INSERT INTO wx_sop (name, temp_id, company_id, status) VALUES "
                    + "('Lobster travel validation stub', 'LOBSTER_TRAVEL_POST_BOOKING_WX', 338, 1)");
            st.execute("DELETE FROM qw_sop WHERE company_id=338 AND temp_id='LOBSTER_TRAVEL_POST_BOOKING'");
            st.execute("INSERT INTO qw_sop (id, name, temp_id, company_id, status, type) VALUES "
                    + "('lobster-travel-val-qw', 'Lobster travel validation stub', "
                    + "'LOBSTER_TRAVEL_POST_BOOKING', 338, 1, 2)");
            System.out.println("SOP stub tables seeded for company 338");
        }
    }
}