org.processmining.stagedprocessflows.database

Class ConnectionManager

java.lang.Object

org.processmining.stagedprocessflows.database.ConnectionManager

public class ConnectionManager
extends java.lang.Object

Author:

Administrator

Field Summary

Fields

Modifier and Type	Field and Description
static int	CUM_TYPE_ARRIVAL
static int	CUM_TYPE_DEPARTURE
static int	CUM_TYPE_EXIT
static java.util.Map<java.lang.String,java.util.List<org.joda.time.Interval>>	stageActivityIntervalMap
static java.util.Map<java.lang.String,java.util.List<org.joda.time.Interval>>	stageServiceIntervalMap
static java.util.Map<java.lang.String,java.util.List<org.joda.time.Interval>>	stageTotalIntervalMap

Constructor Summary

Constructors

Constructor and Description
ConnectionManager()

Method Summary

Modifier and Type	Method and Description
static void	close()
static java.sql.ResultSet	executeSQL(java.lang.String sql)
static void	executeStatement(java.lang.String sql)
static java.sql.Connection	getConnection()
static ConnectionManager	getInstance()
static void	initConnectionProperties(java.util.Map<java.lang.String,java.lang.String> conParams)
static void	initParametersFromFile()
static void	insertActivity(java.lang.String caseID, java.lang.String stage, java.lang.String res, java.lang.Long start, java.lang.Long complete)
static void	insertStage(java.lang.String caseID, java.lang.String stage, java.lang.Long queuestart, java.lang.Long servicestart, java.lang.Long servicecomplete, java.lang.String status, java.lang.String lastStage)
static void	main(java.lang.String[] args)
static int	selectCumulativeArrivalCount(java.lang.String stageName, org.joda.time.DateTime timePoint)
static long	selectCumulativeCaseTime2(java.lang.String stageName, org.joda.time.DateTime timePoint)
static int	selectCumulativeCount(java.lang.String stageName, org.joda.time.DateTime timePoint, int cumulativeType, java.lang.String exitType, boolean isLastStage)
static int	selectCumulativeDepartureCount(java.lang.String stageName, org.joda.time.DateTime timePoint)
static long	selectCumulativeResTime2(java.lang.String stageName, org.joda.time.DateTime timePoint)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

CUM_TYPE_ARRIVAL

public static int CUM_TYPE_ARRIVAL

CUM_TYPE_DEPARTURE

public static int CUM_TYPE_DEPARTURE

CUM_TYPE_EXIT

public static int CUM_TYPE_EXIT

stageActivityIntervalMap

public static java.util.Map<java.lang.String,java.util.List<org.joda.time.Interval>> stageActivityIntervalMap

stageServiceIntervalMap

public static java.util.Map<java.lang.String,java.util.List<org.joda.time.Interval>> stageServiceIntervalMap

stageTotalIntervalMap

public static java.util.Map<java.lang.String,java.util.List<org.joda.time.Interval>> stageTotalIntervalMap

Constructor Detail

ConnectionManager

public ConnectionManager()

Method Detail

main

public static void main(java.lang.String[] args)

getInstance

public static ConnectionManager getInstance()

close

public static void close()

initConnectionProperties

public static void initConnectionProperties(java.util.Map<java.lang.String,java.lang.String> conParams)

getConnection

public static java.sql.Connection getConnection()
                                         throws java.lang.ClassNotFoundException,
                                                java.sql.SQLException

Throws:

java.lang.ClassNotFoundException

java.sql.SQLException

initParametersFromFile

public static void initParametersFromFile()

executeSQL

public static java.sql.ResultSet executeSQL(java.lang.String sql)
                                     throws java.lang.ClassNotFoundException,
                                            java.sql.SQLException

Throws:

java.lang.ClassNotFoundException

java.sql.SQLException

executeStatement

public static void executeStatement(java.lang.String sql)
                             throws java.lang.ClassNotFoundException,
                                    java.sql.SQLException

Throws:

java.lang.ClassNotFoundException

java.sql.SQLException

insertStage

public static void insertStage(java.lang.String caseID,
                               java.lang.String stage,
                               java.lang.Long queuestart,
                               java.lang.Long servicestart,
                               java.lang.Long servicecomplete,
                               java.lang.String status,
                               java.lang.String lastStage)
                        throws java.lang.ClassNotFoundException,
                               java.sql.SQLException

Throws:

java.lang.ClassNotFoundException

java.sql.SQLException

insertActivity

public static void insertActivity(java.lang.String caseID,
                                  java.lang.String stage,
                                  java.lang.String res,
                                  java.lang.Long start,
                                  java.lang.Long complete)
                           throws java.lang.ClassNotFoundException,
                                  java.sql.SQLException

Throws:

java.lang.ClassNotFoundException

java.sql.SQLException

selectCumulativeCount

public static int selectCumulativeCount(java.lang.String stageName,
                                        org.joda.time.DateTime timePoint,
                                        int cumulativeType,
                                        java.lang.String exitType,
                                        boolean isLastStage)
                                 throws java.lang.ClassNotFoundException,
                                        java.sql.SQLException

Throws:

java.lang.ClassNotFoundException

java.sql.SQLException

selectCumulativeArrivalCount

public static int selectCumulativeArrivalCount(java.lang.String stageName,
                                               org.joda.time.DateTime timePoint)

Parameters:

stageName -

timePoint -

Returns:

number of cumulative seconds for all res within this stage

Throws:

java.lang.ClassNotFoundException

java.sql.SQLException

selectCumulativeDepartureCount

public static int selectCumulativeDepartureCount(java.lang.String stageName,
                                                 org.joda.time.DateTime timePoint)

selectCumulativeCaseTime2

public static long selectCumulativeCaseTime2(java.lang.String stageName,
                                             org.joda.time.DateTime timePoint)

selectCumulativeResTime2

public static long selectCumulativeResTime2(java.lang.String stageName,
                                            org.joda.time.DateTime timePoint)