import java.sql.*;

public class FinalVerify {
    static final String M = "jdbc:mysql://cq-cdb-8fjmemkb.sql.tencentcdb.com:27220/ylrz_saas?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai&useSSL=false";
    static final String T = "jdbc:mysql://cq-cdb-8fjmemkb.sql.tencentcdb.com:27220/fs_tenant_t202606174488?useUnicode=true&characterEncoding=utf-8&serverTimezone=Asia/Shanghai&useSSL=false";
    static final String U = "root"; static final String P = "Ylrz_1q2w3e4r5t6y";

    public static void main(String[] a) throws Exception {
        Class.forName("com.mysql.cj.jdbc.Driver");

        System.out.println("MASTER:");
        try (Connection c = DriverManager.getConnection(M,U,P); Statement s = c.createStatement()) {
            System.out.println("  tenant_sys_menu lobster count: "+cnt(s,"tenant_sys_menu"));
            System.out.println("  tenant_company_menu lobster count: "+cnt(s,"tenant_company_menu"));
            System.out.println("  tcm 29941: "+exists(s,"tenant_company_menu",29941)+"  29950: "+exists(s,"tenant_company_menu",29950));
            System.out.println("  tsm 29941: "+exists(s,"tenant_sys_menu",29941)+"  29950: "+exists(s,"tenant_sys_menu",29950));
            System.out.println("  sys_menu 29941: "+exists(s,"sys_menu",29941)+"  29950: "+exists(s,"sys_menu",29950));
        }

        System.out.println("\nTENANT (fs_tenant_t202606174488):");
        try (Connection c = DriverManager.getConnection(T,U,P); Statement s = c.createStatement()) {
            System.out.println("  sys_menu: "+cnt(s,"sys_menu"));
            System.out.println("  company_menu: "+cnt(s,"company_menu"));
            System.out.println("  cp 29941: "+exists(s,"company_menu",29941)+"  29950: "+exists(s,"company_menu",29950));
            System.out.println("  sm 29941: "+exists(s,"sys_menu",29941)+"  29950: "+exists(s,"sys_menu",29950));
        }
        System.out.println("\nDONE");
    }
    static int cnt(Statement s, String t) throws SQLException {
        ResultSet r = s.executeQuery("SELECT COUNT(1) FROM "+t+" WHERE menu_id BETWEEN 29900 AND 29999"); r.next(); return r.getInt(1);
    }
    static String exists(Statement s, String t, int id) throws SQLException {
        ResultSet r = s.executeQuery("SELECT menu_id,menu_name FROM "+t+" WHERE menu_id="+id);
        return r.next() ? r.getString(1)+"("+r.getString(2)+")" : "MISSING";
    }
}