All Downloads are FREE. Search and download functionalities are using the official Maven repository.
  • Log In
  • Register

    • com.centurylink.mdw.dataaccess.reports.ProcessHotspots Maven / Gradle / Ivy

    There is a newer version: 6.1.39
    Show newest version
    package com.centurylink.mdw.dataaccess.reports;

import com.centurylink.mdw.common.service.Query;
import com.centurylink.mdw.common.service.ServiceException;
import com.centurylink.mdw.dataaccess.PreparedWhere;
import com.centurylink.mdw.model.report.Hotspot;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class ProcessHotspots extends ProcessInsights {

    public List getHotspots(Query query) throws SQLException, ServiceException {

        PreparedWhere where = getWhere(query);
        String sql = "select avg(it.elapsed_ms) as avg_time, ai.activity_id\n" +
                "from ACTIVITY_INSTANCE ai, PROCESS_INSTANCE pi, INSTANCE_TIMING it\n" +
                where.getWhere() + "\ngroup by ai.activity_id\norder by avg_time desc";

        try {
            db.openConnection();
            List hotspots = new ArrayList<>();
            ResultSet rs = db.runSelect("Process hotspots ", sql, where.getParams());
            while (rs.next()) {
                hotspots.add(new Hotspot(rs.getString("activity_id"), rs.getLong("avg_time")));
            }
            return hotspots;
        }
        finally {
            db.closeConnection();
        }
    }

    private PreparedWhere getWhere(Query query) throws ServiceException {
        StringBuilder where = new StringBuilder("where ");
        List params = new ArrayList<>();

        where.append("((ai.process_instance_id = pi.process_instance_id and process_id = ?)\n");
        where.append("  or (ai.process_instance_id in (select process_instance_id from PROCESS_INSTANCE where " +
                "owner = 'MAIN_PROCESS_INSTANCE' and owner_id in " +
                "(select process_instance_id from PROCESS_INSTANCE where process_id = ?))))\n");
        Long processId = getProcessId(query);
        params.add(processId);
        params.add(processId);

        where.append("and owner_type = ?\n");
        params.add("ACTIVITY_INSTANCE");

        where.append("and ai.activity_instance_id = it.instance_id\n");

        where.append("and ai.start_dt >= ?");
        params.add(getDt(getStartDate(query)));

        return new PreparedWhere(where.toString(), params.toArray());
    }

}
    
    
    
    

    




    
    
    © 2015 - 2025 Weber Informatics LLC | Privacy Policy