import java.sql.*;

public class QueryAiModels {
    public static void main(String[] a) throws Exception {
        Class.forName("com.mysql.cj.jdbc.Driver");
        String jdbc = "jdbc:mysql://cq-cdb-8fjmemkb.sql.tencentcdb.com:27220/fs_tenant_cs1"
                + "?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8";
        try (Connection c = DriverManager.getConnection(jdbc, "root", "Ylrz_1q2w3e4r5t6y");
             Statement st = c.createStatement()) {
            ResultSet rs = st.executeQuery(
                    "SELECT id, provider_code, model_name, model_identifier, api_endpoint, status FROM admin_ai_model ORDER BY id");
            while (rs.next()) {
                System.out.printf("id=%d %s name=%s id=%s status=%d ep=%s%n",
                        rs.getLong(1), rs.getString(2), rs.getString(3), rs.getString(4),
                        rs.getInt(6), rs.getString(5));
            }
            System.out.println("\n--- scene bindings ---");
            rs = st.executeQuery(
                    "SELECT sm.scene_code, m.provider_code, m.model_name, m.model_identifier "
                            + "FROM admin_ai_scene_model sm JOIN admin_ai_model m ON sm.model_id=m.id "
                            + "WHERE sm.scene_code IN ('workflow_llm','workflow_evolution','semantic_analysis','quality_scoring') "
                            + "ORDER BY sm.scene_code, sm.pipeline_order");
            while (rs.next()) {
                System.out.printf("%s | %s | %s | %s%n",
                        rs.getString(1), rs.getString(2), rs.getString(3), rs.getString(4));
            }
        }
    }
}