import cn.iocoder.yudao.framework.mybatis.core.type.LongListTypeHandler;
import cn.iocoder.yudao.framework.mybatis.core.type.StringListTypeHandler;
import java.lang.reflect.Proxy;
import java.sql.*;
import java.io.*;
import java.util.*;

class VerifyFollowUpFields {
    public static void main(String[] args) throws Exception {
        var longHandler = new LongListTypeHandler();
        var stringHandler = new StringListTypeHandler();
        for (String value : List.of("[]", "", "1,2")) {
            ResultSet mock = (ResultSet) Proxy.newProxyInstance(VerifyFollowUpFields.class.getClassLoader(),
                    new Class[]{ResultSet.class}, (proxy, method, parameters) -> value);
            try {
                System.out.println("LongList input='" + value + "' result=" + longHandler.getResult(mock, "ids"));
            } catch (Exception error) {
                System.out.println("LongList input='" + value + "' exception=" + error.getClass().getSimpleName() + ": " + error.getMessage());
            }
        }
        String password = new BufferedReader(new InputStreamReader(System.in)).readLine();
        try (Connection connection = DriverManager.getConnection("jdbc:mysql://36.213.150.237:10000/mom-hm?useUnicode=true&characterEncoding=UTF-8&connectTimeout=15000&socketTimeout=60000&allowPublicKeyRetrieval=true&useSSL=false", "root", password);
             Statement statement = connection.createStatement();
             ResultSet rows = statement.executeQuery("SELECT id, business_ids, contact_ids, pic_urls, creator FROM crm_follow_up_record WHERE deleted=0 AND biz_type=2 AND biz_id=1 ORDER BY id DESC LIMIT 20")) {
            int count=0;
            while (rows.next()) {
                longHandler.getResult(rows, "business_ids");
                longHandler.getResult(rows, "contact_ids");
                stringHandler.getResult(rows, "pic_urls");
                String creator = rows.getString("creator");
                if (creator != null && !creator.isEmpty()) Long.valueOf(creator);
                count++;
            }
            System.out.println("Customer 1 page field conversion passed; rows=" + count);
        }
    }
}