com.serotonin.mango.db.dao

Class ViewDao

java.lang.Object

com.serotonin.db.DaoUtils

com.serotonin.mango.db.dao.BaseDao

com.serotonin.mango.db.dao.ViewDao

public class ViewDao
extends BaseDao

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
(package private) class	ViewDao.ViewNameRowMapper
(package private) class	ViewDao.ViewRowMapper
(package private) class	ViewDao.ViewUserRowMapper

Field Summary

Fields

Modifier and Type	Field and Description
private org.apache.commons.logging.Log	LOG
private static java.lang.String	PROFILE_USER_ID_COND
private static java.lang.String	USER_ID_COND
private static java.util.Map<java.lang.Integer,java.util.List<com.serotonin.db.IntValuePair>>	usersPermissions
private static java.lang.String	VIEW_SELECT

Fields inherited from class com.serotonin.db.DaoUtils

dataSource, ejt, tm

Constructor Summary

Constructors

Constructor and Description
ViewDao()

Method Summary

Modifier and Type	Method and Description
private void	deleteViewUsers(int viewId)
java.lang.String	generateUniqueXid()
java.util.List<com.serotonin.db.IntValuePair>	getAllViewNames()
private View	getSingleView(java.lang.String sql, java.lang.Object[] params)
View	getView(int id)
View	getView(java.lang.String name)
View	getViewByXid(java.lang.String xid)
java.util.List<com.serotonin.db.IntValuePair>	getViewNames(int userId)
java.util.List<com.serotonin.db.IntValuePair>	getViewNames(int userId, int userProfileId)
java.util.List<com.serotonin.db.IntValuePair>	getViewNamesWithReadOrWritePermissions(int userId, int userProfileId)
java.util.List<View>	getViews()
java.util.List<View>	getViews(int userId, int userProfileId)
(package private) void	insertView(View view)
boolean	isXidUnique(java.lang.String xid, int excludeId)
void	removeUserFromView(int viewId, int userId)
void	removeView(int viewId)
void	saveView(View view)
(package private) void	saveViewUsers(View view)
private void	setViewUsers(java.util.List<View> views)
private void	setViewUsers(View view)
(package private) void	updateView(View view)
java.util.List<com.serotonin.db.IntValuePair>	updateViewUsersPermissions(int userId, int userProfileId)

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

LOG

private org.apache.commons.logging.Log LOG

usersPermissions

private static java.util.Map<java.lang.Integer,java.util.List<com.serotonin.db.IntValuePair>> usersPermissions

VIEW_SELECT

private static final java.lang.String VIEW_SELECT

See Also:

Constant Field Values

PROFILE_USER_ID_COND

private static final java.lang.String PROFILE_USER_ID_COND

See Also:

Constant Field Values

USER_ID_COND

private static final java.lang.String USER_ID_COND

See Also:

Constant Field Values

Constructor Detail

ViewDao

public ViewDao()

Method Detail

getViews

public java.util.List<View> getViews()

getViews

public java.util.List<View> getViews(int userId,
                                     int userProfileId)

getViewNames

public java.util.List<com.serotonin.db.IntValuePair> getViewNames(int userId,
                                                                  int userProfileId)

getViewNames

public java.util.List<com.serotonin.db.IntValuePair> getViewNames(int userId)

getAllViewNames

public java.util.List<com.serotonin.db.IntValuePair> getAllViewNames()

getViewNamesWithReadOrWritePermissions

public java.util.List<com.serotonin.db.IntValuePair> getViewNamesWithReadOrWritePermissions(int userId,
                                                                                            int userProfileId)

updateViewUsersPermissions

public java.util.List<com.serotonin.db.IntValuePair> updateViewUsersPermissions(int userId,
                                                                                int userProfileId)

setViewUsers

private void setViewUsers(java.util.List<View> views)

getView

public View getView(int id)

getViewByXid

public View getViewByXid(java.lang.String xid)

getView

public View getView(java.lang.String name)

getSingleView

private View getSingleView(java.lang.String sql,
                           java.lang.Object[] params)

generateUniqueXid

public java.lang.String generateUniqueXid()

isXidUnique

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

saveView

public void saveView(View view)

insertView

void insertView(View view)

updateView

void updateView(View view)

removeView

public void removeView(int viewId)

setViewUsers

private void setViewUsers(View view)

deleteViewUsers

private void deleteViewUsers(int viewId)

saveViewUsers

void saveViewUsers(View view)

removeUserFromView

public void removeUserFromView(int viewId,
                               int userId)