/**
* 쿼리 실행 히스토리 디테일 창을 얻습니다.
*
* @param strType
* @param dbSeq
* @param executeTime
* @param durationLimit
* @return
* @throws Exception
*/
public static List<SQLHistoryDAO> getExecuteQueryHistoryDetail(
String strType,
String dbSeq,
long startTime,
long endTime,
int duringExecute,
String strSearch)
throws Exception {
List<SQLHistoryDAO> returnSQLHistory = new ArrayList<SQLHistoryDAO>();
Map<String, Object> queryMap = new HashMap<String, Object>();
queryMap.put("db_seq", dbSeq);
queryMap.put("type", strType);
if (ApplicationArgumentUtils.isDBServer()) {
Date date = new Date(startTime);
DateFormat formatter = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss:SSS");
queryMap.put("startTime", formatter.format(date));
Date dateendTime = new Date(endTime);
queryMap.put("endTime", formatter.format(dateendTime));
} else {
queryMap.put("startTime", startTime);
queryMap.put("endTime", endTime);
}
queryMap.put("duration", duringExecute);
queryMap.put("count", 1000);
queryMap.put("strSearch", strSearch);
SqlMapClient sqlClient = TadpoleSQLManager.getInstance(TadpoleSystemInitializer.getUserDB());
List<java.util.Map> listResourceData = new ArrayList<Map>();
if (PublicTadpoleDefine.EXECUTE_SQL_TYPE.API.name().endsWith(strType)) {
listResourceData = sqlClient.queryForList("getExecuteQueryHistoryAPIDetail", queryMap);
} else {
listResourceData = sqlClient.queryForList("getExecuteQueryHistoryDetail", queryMap);
}
for (Map resultMap : listResourceData) {
int seq = (Integer) resultMap.get("executed_sql_resource_seq");
Long startdateexecute = 0l;
String strSQLText = (String) resultMap.get("datas");
Long enddateexecute = 0l;
if (ApplicationArgumentUtils.isDBServer()) {
startdateexecute = ((Timestamp) resultMap.get("startdateexecute")).getTime();
enddateexecute = ((Timestamp) resultMap.get("enddateexecute")).getTime();
} else {
startdateexecute = (Long) resultMap.get("startdateexecute");
enddateexecute = (Long) resultMap.get("enddateexecute");
}
int row = (Integer) resultMap.get("row");
String result = (String) resultMap.get("result");
String userName = resultMap.get("name") == null ? "" : (String) resultMap.get("name");
String dbName = (String) resultMap.get("display_name");
String ipAddress = (String) resultMap.get("ipaddress");
int dbSeq2 = (Integer) resultMap.get("dbseq");
String strMessage = (String) resultMap.get("message");
SQLHistoryDAO dao =
new SQLHistoryDAO(
userName,
dbName,
new Timestamp(startdateexecute),
strSQLText,
new Timestamp(enddateexecute),
row,
result,
strMessage,
ipAddress,
dbSeq2);
dao.setSeq(seq);
if (PublicTadpoleDefine.EXECUTE_SQL_TYPE.API.name().endsWith(strType)) {
dao.setEXECUSTE_SQL_TYPE(PublicTadpoleDefine.EXECUTE_SQL_TYPE.API);
} else {
dao.setEXECUSTE_SQL_TYPE(PublicTadpoleDefine.EXECUTE_SQL_TYPE.EDITOR);
}
returnSQLHistory.add(dao);
}
return returnSQLHistory;
}
