br.org.scadabr.db.dao

Class UsersProfileDao

java.lang.Object

com.serotonin.db.DaoUtils

com.serotonin.mango.db.dao.BaseDao

br.org.scadabr.db.dao.UsersProfileDao

public class UsersProfileDao
extends BaseDao

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
private class	UsersProfileDao.UsersProfilesRowMapper

Field Summary

Fields

Modifier and Type	Field and Description
private static java.util.List<UsersProfileVO>	currentProfileList
org.apache.commons.logging.Log	LOG
private static java.lang.String	PROFILES_DELETE
private static java.lang.String	PROFILES_INSERT
private static java.lang.String	PROFILES_SELECT
private static java.lang.String	PROFILES_UPDATE
private static java.lang.String	SELECT_DATA_POINT_PERMISSIONS
private static java.lang.String	SELECT_DATA_SOURCE_PERMISSIONS
private static java.lang.String	SELECT_VIEW_PERMISSIONS
private static java.lang.String	SELECT_WATCHLIST_PERMISSIONS
private UserDao	userDao
private static java.lang.String	USERS_PROFILES_SELECT
private static java.lang.String	USERS_PROFILES_USERS_SELECT
private ViewDao	viewDao
private WatchListDao	watchlistDao

Fields inherited from class com.serotonin.db.DaoUtils

dataSource, ejt, tm

Constructor Summary

Constructors

Constructor and Description
UsersProfileDao()

Method Summary

Modifier and Type	Method and Description
void	deleteUserProfile(int usersProfileId)
java.util.List<java.lang.Integer>	getUserIdsFromProfile(int profileId)
UsersProfileVO	getUserProfileById(int id)
UsersProfileVO	getUserProfileByName(java.lang.String name)
UsersProfileVO	getUserProfileByUserId(int userid)
UsersProfileVO	getUserProfileByXid(java.lang.String xid)
java.util.List<UsersProfileVO>	getUsersProfiles()
void	grantUserAdminProfile(User user)
private void	insertProfile(UsersProfileVO profile)
private void	populateDatapoints(UsersProfileVO profile)
private void	populateDataSources(UsersProfileVO profile)
private void	populateUserProfilePermissions(java.util.List<UsersProfileVO> profiles)
private void	populateUserProfilePermissions(UsersProfileVO profile)
private void	populateUsers(UsersProfileVO profile)
private void	populateViews(UsersProfileVO profile)
private void	populateWatchlists(UsersProfileVO profile)
private boolean	profileExistsWithThatName(UsersProfileVO profile)
void	resetUserProfile(User user)
private void	saveRelationalData(UsersProfileVO usersProfile)
void	saveUsersProfile(UsersProfileVO profile)
void	saveUsersProfileWithoutNameConstraint(UsersProfileVO profile)
void	setViewDao(ViewDao dao)
void	setWatchlistDao(WatchListDao dao)
private void	updateProfile(UsersProfileVO profile)
void	updateUsersProfile(UsersProfileVO profile)
boolean	userProfileExists(java.lang.String xid)

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

public org.apache.commons.logging.Log LOG

currentProfileList

private static java.util.List<UsersProfileVO> currentProfileList

PROFILES_SELECT

private static final java.lang.String PROFILES_SELECT

See Also:

Constant Field Values

PROFILES_INSERT

private static final java.lang.String PROFILES_INSERT

See Also:

Constant Field Values

PROFILES_UPDATE

private static final java.lang.String PROFILES_UPDATE

See Also:

Constant Field Values

PROFILES_DELETE

private static final java.lang.String PROFILES_DELETE

See Also:

Constant Field Values

watchlistDao

private WatchListDao watchlistDao

viewDao

private ViewDao viewDao

userDao

private UserDao userDao

SELECT_DATA_SOURCE_PERMISSIONS

private static final java.lang.String SELECT_DATA_SOURCE_PERMISSIONS

See Also:

Constant Field Values

SELECT_DATA_POINT_PERMISSIONS

private static final java.lang.String SELECT_DATA_POINT_PERMISSIONS

See Also:

Constant Field Values

SELECT_WATCHLIST_PERMISSIONS

private static final java.lang.String SELECT_WATCHLIST_PERMISSIONS

See Also:

Constant Field Values

SELECT_VIEW_PERMISSIONS

private static final java.lang.String SELECT_VIEW_PERMISSIONS

See Also:

Constant Field Values

USERS_PROFILES_SELECT

private static final java.lang.String USERS_PROFILES_SELECT

See Also:

Constant Field Values

USERS_PROFILES_USERS_SELECT

private static final java.lang.String USERS_PROFILES_USERS_SELECT

See Also:

Constant Field Values

Constructor Detail

UsersProfileDao

public UsersProfileDao()

Method Detail

getUsersProfiles

public java.util.List<UsersProfileVO> getUsersProfiles()

getUserProfileByName

public UsersProfileVO getUserProfileByName(java.lang.String name)

getUserProfileById

public UsersProfileVO getUserProfileById(int id)

getUserProfileByXid

public UsersProfileVO getUserProfileByXid(java.lang.String xid)

saveUsersProfile

public void saveUsersProfile(UsersProfileVO profile)
                      throws DAOException

Throws:

DAOException

profileExistsWithThatName

private boolean profileExistsWithThatName(UsersProfileVO profile)

saveUsersProfileWithoutNameConstraint

public void saveUsersProfileWithoutNameConstraint(UsersProfileVO profile)
                                           throws DAOException

Throws:

DAOException

updateProfile

private void updateProfile(UsersProfileVO profile)

getUserIdsFromProfile

public java.util.List<java.lang.Integer> getUserIdsFromProfile(int profileId)

updateUsersProfile

public void updateUsersProfile(UsersProfileVO profile)

insertProfile

private void insertProfile(UsersProfileVO profile)

populateUserProfilePermissions

private void populateUserProfilePermissions(UsersProfileVO profile)

populateUsers

private void populateUsers(UsersProfileVO profile)

populateWatchlists

private void populateWatchlists(UsersProfileVO profile)

populateDatapoints

private void populateDatapoints(UsersProfileVO profile)

populateDataSources

private void populateDataSources(UsersProfileVO profile)

populateViews

private void populateViews(UsersProfileVO profile)

populateUserProfilePermissions

private void populateUserProfilePermissions(java.util.List<UsersProfileVO> profiles)

saveRelationalData

private void saveRelationalData(UsersProfileVO usersProfile)

getUserProfileByUserId

public UsersProfileVO getUserProfileByUserId(int userid)

grantUserAdminProfile

public void grantUserAdminProfile(User user)

resetUserProfile

public void resetUserProfile(User user)

setWatchlistDao

public void setWatchlistDao(WatchListDao dao)

setViewDao

public void setViewDao(ViewDao dao)

userProfileExists

public boolean userProfileExists(java.lang.String xid)

deleteUserProfile

public void deleteUserProfile(int usersProfileId)