import java.io.*;
import java.sql.*;

public class VerifyLobsterMasterMenuSync {
    public static void main(String[] a) throws Exception {
        Class.forName("com.mysql.cj.jdbc.Driver");
        String url = "jdbc:mysql://cq-cdb-8fjmemkb.sql.tencentcdb.com:27220/ylrz_saas"
                + "?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8";
        new File("output").mkdirs();
        try (Connection c = DriverManager.getConnection(url, "root", "Ylrz_1q2w3e4r5t6y");
             PrintWriter out = new PrintWriter(new OutputStreamWriter(
                     new FileOutputStream("output/verify-lobster-master-menu-sync.txt"), "UTF-8"))) {
            dump(c, out, "tenant_sys_menu");
            dump(c, out, "tenant_company_menu");
            try (Statement st = c.createStatement();
                 ResultSet rs = st.executeQuery(
                         "SELECT COUNT(*) FROM tenant_sys_menu WHERE menu_id=2951 OR parent_id=2951")) {
                rs.next();
                out.println("legacy 2951 rows in tenant_sys_menu: " + rs.getInt(1));
            }
        }
        System.out.println("Wrote output/verify-lobster-master-menu-sync.txt");
    }

    static void dump(Connection c, PrintWriter out, String table) throws Exception {
        out.println("=== " + table + " ===");
        try (Statement st = c.createStatement();
             ResultSet rs = st.executeQuery(
                     "SELECT menu_id, menu_name, parent_id, order_num, path, visible FROM " + table
                             + " WHERE menu_id=29900 OR parent_id=29900 ORDER BY order_num, menu_id")) {
            while (rs.next()) {
                out.printf("[%d] %s | parent=%d order=%d path=%s visible=%s%n",
                        rs.getLong(1), rs.getString(2), rs.getLong(3), rs.getInt(4),
                        rs.getString(5), rs.getString(6));
            }
        }
        out.println();
    }
}