import java.sql.*;

public class VerifyLobsterMenus {
    public static void main(String[] args) throws Exception {
        String db = args.length > 0 ? args[0] : "fs_tenant_cs1";
        String url = "jdbc:mysql://cq-cdb-8fjmemkb.sql.tencentcdb.com:27220/" + db
                + "?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8";
        try (Connection c = DriverManager.getConnection(url, "root", "Ylrz_1q2w3e4r5t6y");
             Statement s = c.createStatement()) {
            ResultSet rs = s.executeQuery(
                    "SELECT COUNT(*) FROM (SELECT path,component,company_id,COUNT(*) cnt "
                            + "FROM company_menu WHERE parent_id=29900 AND menu_type='C' "
                            + "GROUP BY path,component,company_id HAVING cnt>1) t");
            rs.next();
            System.out.println("DB=" + db + " duplicate_groups=" + rs.getInt(1));

            rs = s.executeQuery(
                    "SELECT menu_id, HEX(menu_name) AS hex_name, menu_name, path FROM company_menu "
                            + "WHERE menu_id IN (32481, 29949, 29950)");
            while (rs.next()) {
                System.out.println("key " + rs.getLong(1) + " hex=" + rs.getString(2)
                        + " name=" + rs.getString(3) + " path=" + rs.getString(4));
            }

            rs = s.executeQuery(
                    "SELECT menu_id, menu_name, path FROM company_menu "
                            + "WHERE parent_id=29900 AND visible='0' AND status='0' AND menu_type='C' "
                            + "ORDER BY order_num, menu_id");
            int n = 0;
            while (rs.next()) {
                n++;
                System.out.println(rs.getLong(1) + "\t" + rs.getString(2) + "\t" + rs.getString(3));
            }
            System.out.println("visible_count=" + n);
        }
    }
}