com.centurylink.mdw.service.data.process.ProcessInsights Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of mdw-services Show documentation
MDW is a workflow framework specializing in microservice orchestration
There is a newer version: 6.1.39
package com.centurylink.mdw.service.data.process;

import com.centurylink.mdw.common.service.Query;
import com.centurylink.mdw.common.service.ServiceException;
import com.centurylink.mdw.dataaccess.DatabaseAccess;
import com.centurylink.mdw.dataaccess.PreparedWhere;
import com.centurylink.mdw.dataaccess.db.CommonDataAccess;
import com.centurylink.mdw.model.report.Insight;
import com.centurylink.mdw.model.report.Timepoint;
import com.centurylink.mdw.model.workflow.WorkStatuses;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.ParseException;
import java.util.ArrayList;
import java.util.Date;
import java.util.LinkedHashMap;
import java.util.List;

public class ProcessInsights extends CommonDataAccess {

    public List getInsights(Query query) throws SQLException, ParseException, ServiceException {
        PreparedWhere where = getWhere(query, false);
        String sql = "select count(pi.status_cd) as ct, pi.st, pi.status_cd\n" +
                "from (" + getSelectDate("start_dt") + " as st, status_cd\n" +
                "  from PROCESS_INSTANCE\n" + where.getWhere() + ") pi\n" +
                "group by st, status_cd\n" +
                "order by st";

        try {
            db.openConnection();
            List insights = new ArrayList<>();
            TimeIncrement increment = TimeIncrement.day;
            Date prevStart = getStartDate(query);
            ResultSet rs = db.runSelect("Process insights ", sql, where.getParams());
            while (rs.next()) {
                String startStr = rs.getString("st");
                Date start = getDateFormat().parse(startStr);

                // fill in gaps
                while (start.getTime() - prevStart.getTime() > Query.Timespan.Day.millis()) {
                    prevStart = new Date(prevStart.getTime() + Query.Timespan.Day.millis());
                    insights.add(new Insight(getRoundDate(prevStart, increment).toInstant(), new LinkedHashMap<>()));
                }

                Insight insight = insights.stream().filter(in -> in.getTime().equals(start.toInstant())).findAny().orElse(null);
                if (insight == null) {
                    LinkedHashMap map = new LinkedHashMap<>();
                    insight = new Insight(getRoundDate(start, increment).toInstant(), map);
                    insights.add(insight);
                }

                String status = WorkStatuses.getName(rs.getInt("status_cd"));
                insight.getElements().put(status, rs.getInt("ct"));

                prevStart = start;
            }
            // gaps at end
            Date endDate = new Date(System.currentTimeMillis() + DatabaseAccess.getDbTimeDiff());
            while ((endDate.getTime() - prevStart.getTime()) > Query.Timespan.Day.millis()) {
                prevStart = new Date(prevStart.getTime() + Query.Timespan.Day.millis());
                insights.add(new Insight(getRoundDate(prevStart, increment).toInstant(), new LinkedHashMap<>()));
            }

            return insights;
        }
        finally {
            db.closeConnection();
        }
    }

    public List getTrend(Query query) throws SQLException, ParseException, ServiceException {
        PreparedWhere where = getWhere(query, true);
        String sql = "select avg(pi.elapsed_ms) as ms, pi.st\n" +
                "from (" + getSelectDate("start_dt") +
                " as st, elapsed_ms\n" +
                "  from PROCESS_INSTANCE, INSTANCE_TIMING\n" + where.getWhere() + ") pi\n" +
                "group by st\n" +
                "order by st";

        try {
            db.openConnection();
            List timepoints = new ArrayList<>();
            ResultSet rs = db.runSelect("Process trend ", sql, where.getParams());
            while (rs.next()) {
                String startStr = rs.getString("st");
                Date start = getDateFormat().parse(startStr);
                timepoints.add(new Timepoint(getRoundDate(start, TimeIncrement.day).toInstant(),
                        Math.round(rs.getDouble("ms"))));
            }
            return timepoints;
        }
        finally {
            db.closeConnection();
        }
    }

    private PreparedWhere getWhere(Query query, boolean isTrend) throws ServiceException {
        StringBuilder where = new StringBuilder();
        List