ylrz_saas_pharmacy/java/scripts/ScanServerAllSchemas.java

import java.sql.*;
public class ScanServerAllSchemas {
  public static void main(String[] a) throws Exception {
    Class.forName("com.mysql.cj.jdbc.Driver");
    Connection m = DriverManager.getConnection("jdbc:mysql://cq-cdb-8fjmemkb.sql.tencentcdb.com:27220/mysql?allowMultiQueries=true","root","Ylrz_1q2w3e4r5t6y");
    Statement st = m.createStatement();
    ResultSet rs = st.executeQuery("SELECT TABLE_SCHEMA FROM information_schema.TABLES WHERE TABLE_NAME='company_workflow_lobster' ORDER BY 1");
    int missing=0;
    while (rs.next()) {
      String db=rs.getString(1);
      Connection c=DriverManager.getConnection("jdbc:mysql://cq-cdb-8fjmemkb.sql.tencentcdb.com:27220/"+db+"?allowMultiQueries=true","root","Ylrz_1q2w3e4r5t6y");
      ResultSet r2=c.createStatement().executeQuery("SELECT COUNT(*) FROM information_schema.COLUMNS WHERE TABLE_SCHEMA=DATABASE() AND TABLE_NAME='company_workflow_lobster' AND COLUMN_NAME='visible_company_ids'");
      r2.next(); boolean has=r2.getInt(1)>0; if(!has){ missing++; System.out.println("MISSING: "+db);} c.close();
    }
    System.out.println("total missing="+missing);
    m.close();
  }
}