com.serotonin.mango.db.dao

Class ReportDao

java.lang.Object

com.serotonin.db.DaoUtils

com.serotonin.mango.db.dao.BaseDao

com.serotonin.mango.db.dao.ReportDao

public class ReportDao
extends BaseDao

Author:

Matthew Lohbihler

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	ReportDao.PointInfo
(package private) class	ReportDao.ReportCommentRowMapper
(package private) class	ReportDao.ReportInstanceRowMapper
(package private) class	ReportDao.ReportRowMapper

Field Summary

Fields

Modifier and Type	Field and Description
private static java.lang.String	EVENT_COMMENT_SELECT
private static java.lang.String	EVENT_SELECT
private static java.lang.String	REPORT_INSERT
private static java.lang.String	REPORT_INSTANCE_DATA_SELECT
private static java.lang.String	REPORT_INSTANCE_INSERT This method should only be called by the ReportWorkItem.
private static java.lang.String	REPORT_INSTANCE_POINT_SELECT This method guarantees that the data is provided to the setData handler method grouped by point (points are not ordered), and sorted by time ascending.
private static java.lang.String	REPORT_INSTANCE_POINTS_INSERT This method should only be called by the ReportWorkItem.
private static java.lang.String	REPORT_INSTANCE_SELECT
private static java.lang.String	REPORT_INSTANCE_UPDATE
private static java.lang.String	REPORT_SELECT
private static java.lang.String	REPORT_UPDATE
private static java.lang.String	USER_COMMENT_SELECT

Fields inherited from class com.serotonin.db.DaoUtils

dataSource, ejt, tm

Constructor Summary

Constructors

Constructor and Description
ReportDao()

Method Summary

Modifier and Type	Method and Description
private java.lang.Object[]	appendParameters(java.lang.Object[] toAppend, java.lang.Object... params)
void	deleteReport(int reportId)
void	deleteReportInstance(int id, int userId)
ReportVO	getReport(int id)
ReportInstance	getReportInstance(int id)
java.util.List<EventInstance>	getReportInstanceEvents(int instanceId)
java.util.List<ReportInstance>	getReportInstances(int userId)
java.util.List<ReportUserComment>	getReportInstanceUserComments(int instanceId)
java.util.List<ReportVO>	getReports()
java.util.List<ReportVO>	getReports(int userId)
private void	insertReport(ReportVO report)
int	purgeReportsBefore(long time)
void	reportInstanceData(int instanceId, ReportDataStreamHandler handler)
int	runReport(ReportInstance instance, java.util.List<ReportDao.PointInfo> points, java.util.ResourceBundle bundle)
void	saveReport(ReportVO report)
void	saveReportInstance(ReportInstance instance)
void	setReportInstancePreventPurge(int id, boolean preventPurge, int userId)
private void	updateReport(ReportVO report)

Methods inherited from class com.serotonin.mango.db.dao.BaseDao

boolToChar, charToBool, deleteInChunks, doInsert, doInsert, doInsert, doInsertLong, doInsertLong, doInsertLong, generateUniqueXid, getGeneratedKeyName, getPreparedStatementCreator, isXidUnique

Methods inherited from class com.serotonin.db.DaoUtils

batchUpdate, createDelimitedList, createDelimitedList, createDelimitedList, createIntValuePairs, createKeyValuePairs, dbEncodeSearchString, getInt, getTransactionManager, getTransactionTemplate, now, query, query, query, query, query, query, queryForList, queryForList, queryForObject, queryForObject, queryForObject, setInt

Methods inherited from class java.lang.Object

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

Field Detail

REPORT_SELECT

private static final java.lang.String REPORT_SELECT

See Also:

Constant Field Values

REPORT_INSERT

private static final java.lang.String REPORT_INSERT

See Also:

Constant Field Values

REPORT_UPDATE

private static final java.lang.String REPORT_UPDATE

See Also:

Constant Field Values

REPORT_INSTANCE_SELECT

private static final java.lang.String REPORT_INSTANCE_SELECT

See Also:

Constant Field Values

REPORT_INSTANCE_INSERT

private static final java.lang.String REPORT_INSTANCE_INSERT

This method should only be called by the ReportWorkItem.

See Also:

Constant Field Values

REPORT_INSTANCE_UPDATE

private static final java.lang.String REPORT_INSTANCE_UPDATE

See Also:

Constant Field Values

REPORT_INSTANCE_POINTS_INSERT

private static final java.lang.String REPORT_INSTANCE_POINTS_INSERT

This method should only be called by the ReportWorkItem.

See Also:

Constant Field Values

REPORT_INSTANCE_POINT_SELECT

private static final java.lang.String REPORT_INSTANCE_POINT_SELECT

This method guarantees that the data is provided to the setData handler method grouped by point (points are not ordered), and sorted by time ascending.

See Also:

Constant Field Values

REPORT_INSTANCE_DATA_SELECT

private static final java.lang.String REPORT_INSTANCE_DATA_SELECT

See Also:

Constant Field Values

EVENT_SELECT

private static final java.lang.String EVENT_SELECT

See Also:

Constant Field Values

EVENT_COMMENT_SELECT

private static final java.lang.String EVENT_COMMENT_SELECT

See Also:

Constant Field Values

USER_COMMENT_SELECT

private static final java.lang.String USER_COMMENT_SELECT

See Also:

Constant Field Values

Constructor Detail

ReportDao

public ReportDao()

Method Detail

getReports

public java.util.List<ReportVO> getReports()

getReports

public java.util.List<ReportVO> getReports(int userId)

getReport

public ReportVO getReport(int id)

saveReport

public void saveReport(ReportVO report)

insertReport

private void insertReport(ReportVO report)

updateReport

private void updateReport(ReportVO report)

deleteReport

public void deleteReport(int reportId)

getReportInstances

public java.util.List<ReportInstance> getReportInstances(int userId)

getReportInstance

public ReportInstance getReportInstance(int id)

deleteReportInstance

public void deleteReportInstance(int id,
                                 int userId)

purgeReportsBefore

public int purgeReportsBefore(long time)

setReportInstancePreventPurge

public void setReportInstancePreventPurge(int id,
                                          boolean preventPurge,
                                          int userId)

saveReportInstance

public void saveReportInstance(ReportInstance instance)

runReport

public int runReport(ReportInstance instance,
                     java.util.List<ReportDao.PointInfo> points,
                     java.util.ResourceBundle bundle)

appendParameters

private java.lang.Object[] appendParameters(java.lang.Object[] toAppend,
                                            java.lang.Object... params)

reportInstanceData

public void reportInstanceData(int instanceId,
                               ReportDataStreamHandler handler)

getReportInstanceEvents

public java.util.List<EventInstance> getReportInstanceEvents(int instanceId)

getReportInstanceUserComments

public java.util.List<ReportUserComment> getReportInstanceUserComments(int instanceId)