com.serotonin.mango.db.dao

Class DataPointDao

java.lang.Object

com.serotonin.db.DaoUtils

com.serotonin.mango.db.dao.BaseDao

com.serotonin.mango.db.dao.DataPointDao

public class DataPointDao
extends BaseDao

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
(package private) class	DataPointDao.DataPointRowMapper
(package private) class	DataPointDao.EventDetectorRowMapper

Field Summary

Fields

Modifier and Type	Field and Description
(package private) static PointHierarchy	cachedPointHierarchy
private static java.lang.String	DATA_POINT_SELECT
private static java.lang.String	POINT_COMMENT_SELECT

Fields inherited from class com.serotonin.db.DaoUtils

dataSource, ejt, tm

Constructor Summary

Constructors

Constructor and Description
DataPointDao()
DataPointDao(javax.sql.DataSource dataSource)

Method Summary

Modifier and Type	Method and Description
private void	addFoldersToHeirarchy(PointHierarchy ph, int parentId, java.util.Map<java.lang.Integer,java.util.List<PointFolder>> folders)
private void	beforePointDelete(int dataPointId)
void	copyPermissions(int fromDataPointId, int toDataPointId)
void	deleteDataPoint(int dataPointId)
(package private) void	deleteDataPointImpl(java.lang.String dataPointIdList)
void	deleteDataPoints(int dataSourceId)
(package private) void	deletePointHistory(int dataPointId)
(package private) void	deletePointHistory(int dataPointId, long min, long max)
java.lang.String	generateEventDetectorUniqueXid(int dataPointId)
java.lang.String	generateUniqueXid()
DataPointVO	getDataPoint(int id)
DataPointVO	getDataPoint(java.lang.String xid)
int	getDataPointIdFromDetectorId(int pedId)
java.util.List<DataPointVO>	getDataPoints(java.util.Comparator<DataPointVO> comparator, boolean includeRelationalData)
java.util.List<DataPointVO>	getDataPoints(int dataSourceId, java.util.Comparator<DataPointVO> comparator)
int	getDetectorId(java.lang.String pedXid, int dataPointId)
java.lang.String	getDetectorXid(int pedId)
private java.util.List<PointEventDetectorVO>	getEventDetectors(DataPointVO dp)
java.lang.String	getExtendedPointName(int dataPointId)
PointHierarchy	getPointHierarchy()
java.util.List<PointHistoryCount>	getTopPointHistoryCounts()
(package private) void	insertDataPoint(DataPointVO dp)
boolean	isEventDetectorXidUnique(int dataPointId, java.lang.String xid, int excludeId)
boolean	isXidUnique(java.lang.String xid, int excludeId)
private PointEventDetectorVO	removeFromList(java.util.List<PointEventDetectorVO> list, int id)
void	saveDataPoint(DataPointVO dp)
private void	saveEventDetectors(DataPointVO dp)
(package private) void	savePointFolder(PointFolder folder, int parentId)
void	savePointHierarchy(PointFolder root)
(package private) void	savePointsInFolder(PointFolder folder)
private void	setEventDetectors(DataPointVO dp)
private void	setPointComments(DataPointVO dp)
private void	setRelationalData(DataPointVO dp)
private void	setRelationalData(java.util.List<DataPointVO> dps)
(package private) void	updateDataPoint(DataPointVO dp)
void	updateDataPointShallow(DataPointVO dp)

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

DATA_POINT_SELECT

private static final java.lang.String DATA_POINT_SELECT

See Also:

Constant Field Values

POINT_COMMENT_SELECT

private static final java.lang.String POINT_COMMENT_SELECT

See Also:

Constant Field Values

cachedPointHierarchy

static PointHierarchy cachedPointHierarchy

Constructor Detail

DataPointDao

public DataPointDao()

DataPointDao

public DataPointDao(javax.sql.DataSource dataSource)

Method Detail

generateUniqueXid

public java.lang.String generateUniqueXid()

isXidUnique

public boolean isXidUnique(java.lang.String xid,
                           int excludeId)

getExtendedPointName

public java.lang.String getExtendedPointName(int dataPointId)

getDataPoints

public java.util.List<DataPointVO> getDataPoints(java.util.Comparator<DataPointVO> comparator,
                                                 boolean includeRelationalData)

getDataPoints

public java.util.List<DataPointVO> getDataPoints(int dataSourceId,
                                                 java.util.Comparator<DataPointVO> comparator)

getDataPoint

public DataPointVO getDataPoint(int id)

getDataPoint

public DataPointVO getDataPoint(java.lang.String xid)

setRelationalData

private void setRelationalData(java.util.List<DataPointVO> dps)

setRelationalData

private void setRelationalData(DataPointVO dp)

saveDataPoint

public void saveDataPoint(DataPointVO dp)

insertDataPoint

void insertDataPoint(DataPointVO dp)

updateDataPoint

void updateDataPoint(DataPointVO dp)

updateDataPointShallow

public void updateDataPointShallow(DataPointVO dp)

deleteDataPoints

public void deleteDataPoints(int dataSourceId)

deleteDataPoint

public void deleteDataPoint(int dataPointId)

beforePointDelete

private void beforePointDelete(int dataPointId)

deletePointHistory

void deletePointHistory(int dataPointId)

deletePointHistory

void deletePointHistory(int dataPointId,
                        long min,
                        long max)

deleteDataPointImpl

void deleteDataPointImpl(java.lang.String dataPointIdList)

getDataPointIdFromDetectorId

public int getDataPointIdFromDetectorId(int pedId)

getDetectorXid

public java.lang.String getDetectorXid(int pedId)

getDetectorId

public int getDetectorId(java.lang.String pedXid,
                         int dataPointId)

generateEventDetectorUniqueXid

public java.lang.String generateEventDetectorUniqueXid(int dataPointId)

isEventDetectorXidUnique

public boolean isEventDetectorXidUnique(int dataPointId,
                                        java.lang.String xid,
                                        int excludeId)

setEventDetectors

private void setEventDetectors(DataPointVO dp)

getEventDetectors

private java.util.List<PointEventDetectorVO> getEventDetectors(DataPointVO dp)

saveEventDetectors

private void saveEventDetectors(DataPointVO dp)

removeFromList

private PointEventDetectorVO removeFromList(java.util.List<PointEventDetectorVO> list,
                                            int id)

copyPermissions

public void copyPermissions(int fromDataPointId,
                            int toDataPointId)

setPointComments

private void setPointComments(DataPointVO dp)

getPointHierarchy

public PointHierarchy getPointHierarchy()

addFoldersToHeirarchy

private void addFoldersToHeirarchy(PointHierarchy ph,
                                   int parentId,
                                   java.util.Map<java.lang.Integer,java.util.List<PointFolder>> folders)

savePointHierarchy

public void savePointHierarchy(PointFolder root)

savePointFolder

void savePointFolder(PointFolder folder,
                     int parentId)

savePointsInFolder

void savePointsInFolder(PointFolder folder)

getTopPointHistoryCounts

public java.util.List<PointHistoryCount> getTopPointHistoryCounts()