import java.sql.*;

/** Query tenant login + lobster template for simulate probe. */
public class ProbeSimulateContext {
    private static final String MASTER =
            "jdbc:mysql://cq-cdb-8fjmemkb.sql.tencentcdb.com:27220/ylrz_saas?useSSL=false&serverTimezone=GMT%2B8";
    private static final String USER = "root";
    private static final String PWD = "Ylrz_1q2w3e4r5t6y";

    public static void main(String[] args) throws Exception {
        Class.forName("com.mysql.cj.jdbc.Driver");
        try (Connection c = DriverManager.getConnection(MASTER, USER, PWD);
             Statement st = c.createStatement()) {
            System.out.println("=== tenant_info ===");
            try (ResultSet rs = st.executeQuery(
                    "SELECT tenant_code, tenant_name, db_name, status FROM tenant_info WHERE status=1 ORDER BY id LIMIT 10")) {
                while (rs.next()) {
                    System.out.println(rs.getString("tenant_code") + "\t" + rs.getString("tenant_name")
                            + "\tdb=" + rs.getString("db_name"));
                }
            } catch (Exception e) {
                System.out.println("tenant_info: " + e.getMessage());
            }
            System.out.println("\n=== sys_company (master) ===");
            try (ResultSet rs = st.executeQuery(
                    "SELECT company_id, tenant_code, company_name FROM sys_company WHERE del_flag='0' LIMIT 10")) {
                while (rs.next()) {
                    System.out.println("company=" + rs.getLong("company_id")
                            + "\ttenant=" + rs.getString("tenant_code")
                            + "\t" + rs.getString("company_name"));
                }
            } catch (Exception e) {
                System.out.println("sys_company: " + e.getMessage());
            }
        }

        String tenantDb = args.length > 0 ? args[0] : "fs_tenant_cs1";
        String jdbc = "jdbc:mysql://cq-cdb-8fjmemkb.sql.tencentcdb.com:27220/" + tenantDb
                + "?useSSL=false&serverTimezone=GMT%2B8&characterEncoding=utf8";
        System.out.println("\n=== tenant db: " + tenantDb + " ===");
        try (Connection tc = DriverManager.getConnection(jdbc, USER, PWD);
             Statement st = tc.createStatement()) {
            System.out.println("-- sys_user (admin) --");
            try (ResultSet rs = st.executeQuery(
                    "SELECT user_id, user_name, nick_name, status FROM sys_user WHERE del_flag='0' AND user_name='admin' LIMIT 3")) {
                while (rs.next()) {
                    System.out.println("user=" + rs.getLong("user_id") + "\t" + rs.getString("user_name")
                            + "\t" + rs.getString("nick_name") + "\tstatus=" + rs.getString("status"));
                }
            }
            System.out.println("-- company_workflow_lobster --");
            try (ResultSet rs = st.executeQuery(
                    "SELECT id, template_name, company_id, status, industry_type FROM company_workflow_lobster "
                            + "WHERE del_flag=0 ORDER BY id DESC LIMIT 8")) {
                while (rs.next()) {
                    System.out.println("id=" + rs.getLong("id") + "\tstatus=" + rs.getInt("status")
                            + "\tcompany=" + rs.getLong("company_id")
                            + "\tindustry=" + rs.getString("industry_type")
                            + "\t" + rs.getString("template_name"));
                }
            } catch (Exception e) {
                System.out.println("lobster table: " + e.getMessage());
            }
        }
    }
}