org.ametys.plugins.core.impl.user.directory

Class JdbcUserDirectory

java.lang.Object

org.ametys.runtime.plugin.component.AbstractLogEnabled

org.ametys.core.util.CachingComponent<User>

org.ametys.plugins.core.impl.user.directory.JdbcUserDirectory

All Implemented Interfaces:

ModifiableUserDirectory, UserDirectory, LogEnabled, PluginAware, Disposable, Initializable, Component, Contextualizable, Serviceable

public class JdbcUserDirectory
extends CachingComponent<User>
implements ModifiableUserDirectory, Component, Serviceable, Contextualizable, PluginAware

Use a jdbc driver for getting the list of users, modifying them and also authenticate them.
Passwords need to be encrypted with MD5 and encoded in base64.

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
protected class	JdbcUserDirectory.AbstractJdbcQueryExecutor<T> An internal query executor.
protected static class	JdbcUserDirectory.JdbcParameterParser AbstractParameterParser for parsing JdbcParameter.
class	JdbcUserDirectory.JdbcPredicate Class representing a SQL predicate (to use in a WHERE or HAVING clause), with optional string parameters.
protected class	JdbcUserDirectory.SelectUserJdbcQueryExecutor<T> Query executor in order to select an user
protected class	JdbcUserDirectory.SelectUsersJdbcQueryExecutor<T> Query executor in order to select users

Field Summary

Fields

Modifier and Type	Field and Description
private static String	__COLUMN_EMAIL
private static String	__COLUMN_FIRSTNAME
private static String	__COLUMN_LASTNAME
private static String	__COLUMN_LOGIN
private static String	__COLUMN_PASSWORD
private static String	__COLUMN_SALT
(package private) static String[]	__COLUMNS
private static String	__DATASOURCE_PARAM_NAME Name of the parameter holding the datasource id
private static String	__USERS_TABLE_PARAM_NAME Name of the parameter holding the table users' name
protected Context	_context The avalon context
private CurrentUserProvider	_currentUserProvider
protected String	_dataSourceId The identifier of data source
private ThreadSafeComponentManager<Enumerator>	_enumeratorManager
private String	_id
private String	_label
private boolean	_lazyInitialized
protected ServiceManager	_manager The avalon service manager
protected Map<String,JdbcParameter>	_model Model
private ObservationManager	_observationManager
private Map<String,Object>	_paramValues
protected String	_pluginName Plugin name
private String	_populationId
protected SourceResolver	_sourceResolver The cocoon source resolver
private String	_udModelId
protected String	_userTableName The name of users' SQL table
private ThreadSafeComponentManager<Validator>	_validatorManager
protected static String	BASE_PLUGIN_NAME The base plugin (for i18n key)

Constructor Summary

Constructors

Constructor and Description
JdbcUserDirectory()

Method Summary

Modifier and Type	Method and Description
protected JdbcParameter	_configureParameter(JdbcUserDirectory.JdbcParameterParser jdbcParameterParser, String id, String column) Configure the parameter (for special handling)
protected User	_createUserFromResultSet(ResultSet rs) Create the user implementation from the result set of the request
protected void	_fillModifyStatement(PreparedStatement stmt, Map<String,String> userInformation) Fill the statement with the user informations
protected JdbcUserDirectory.JdbcPredicate	_getMandatoryPredicate(String pattern) Get the mandatory predicate to use when querying users by pattern.
protected String	_getPatternToMatch(String pattern) Get the pattern to match user login
protected User	_getUserProcessResultSet(ResultSet rs, String login) Retrieve an user from a result set
protected List<User>	_getUsersProcessResultSet(ResultSet rs) Populate the user list with the result set
protected boolean	_isMD5Encrypted(String password) Determines if the password is encrypted with MD5 algorithm
protected void	_updateToSSHAPassword(String login, String password) Generate a salt key and encrypt the password with the sha2 algorithm
void	add(Map<String,String> userInformation) Add a new user to the list.
boolean	checkCredentials(String login, String password) Authenticate a user with its credentials
protected void	configureModelParameters() Configure the edition model parameters
void	contextualize(Context context)
protected PreparedStatement	createAddStatement(Connection con, Map<String,String> userInformation) Create Add statement
protected PreparedStatement	createModifyStatement(Connection con, Map<String,String> userInformation) Create statement to update database
void	dispose()
protected CurrentUserProvider	getCurrentUserProvider() Lazy lookup the CurrentUserProvider
String	getId() A unique identifier
String	getLabel() Get the label of the CredentialProvider
Collection<? extends Parameter<ParameterHelper.ParameterType>>	getModel() Get the user's edition model as a Collection of parameters.
protected ObservationManager	getObservationManager() Lazy lookup the ObservationManager
Map<String,Object>	getParameterValues() Get the values of parameters (from user directory model)
String	getPopulationId() Get the id of the population this user directory belongs to.
protected Connection	getSQLConnection() Get the connection to the database
User	getUser(String login) Get a particular user by his login.
String	getUserDirectoryModelId() Get the id of the UserDirectoryModel extension point
Collection<User>	getUsers() Get the list of all users of one directory.
List<User>	getUsers(int count, int offset, Map<String,Object> parameters) Get a list of users from a directory given the parameters
void	init(String id, String udModelId, Map<String,Object> paramValues, String label) Initialize the user's directory with given parameters' values.
void	remove(String login) Remove an user from the list.
void	service(ServiceManager manager)
void	setPluginInfo(String pluginName, String featureName, String id) Sets the plugin info relative to the current component. Note : The feature name may be null if the targeted component in declared at plugin level.
void	setPopulationId(String populationId) Set the value of the id of the population this user directory belong to.
void	update(Map<String,String> userInformation) Modify informations about an user of the list.
Map<String,Errors>	validate(Map<String,String> userInformation) Validate user information.

Methods inherited from class org.ametys.core.util.CachingComponent

addObjectInCache, clearCache, getObjectFromCache, initialize, isCacheEnabled, removeObjectFromCache

Methods inherited from class org.ametys.runtime.plugin.component.AbstractLogEnabled

getLogger, setLogger

Methods inherited from class java.lang.Object

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

Field Detail

BASE_PLUGIN_NAME

protected static final String BASE_PLUGIN_NAME

The base plugin (for i18n key)

See Also:

Constant Field Values

__COLUMNS

static final String[] __COLUMNS

__DATASOURCE_PARAM_NAME

private static final String __DATASOURCE_PARAM_NAME

Name of the parameter holding the datasource id

See Also:

Constant Field Values

__USERS_TABLE_PARAM_NAME

private static final String __USERS_TABLE_PARAM_NAME

Name of the parameter holding the table users' name

See Also:

Constant Field Values

__COLUMN_LOGIN

private static final String __COLUMN_LOGIN

See Also:

Constant Field Values

__COLUMN_PASSWORD

private static final String __COLUMN_PASSWORD

See Also:

Constant Field Values

__COLUMN_FIRSTNAME

private static final String __COLUMN_FIRSTNAME

See Also:

Constant Field Values

__COLUMN_LASTNAME

private static final String __COLUMN_LASTNAME

See Also:

Constant Field Values

__COLUMN_EMAIL

private static final String __COLUMN_EMAIL

See Also:

Constant Field Values

__COLUMN_SALT

private static final String __COLUMN_SALT

See Also:

Constant Field Values

_dataSourceId

protected String _dataSourceId

The identifier of data source

_userTableName

protected String _userTableName

The name of users' SQL table

_model

protected Map<String,JdbcParameter> _model

Model

_pluginName

protected String _pluginName

Plugin name

_manager

protected ServiceManager _manager

The avalon service manager

_context

protected Context _context

The avalon context

_sourceResolver

protected SourceResolver _sourceResolver

The cocoon source resolver

_validatorManager

private ThreadSafeComponentManager<Validator> _validatorManager

_enumeratorManager

private ThreadSafeComponentManager<Enumerator> _enumeratorManager

_observationManager

private ObservationManager _observationManager

_currentUserProvider

private CurrentUserProvider _currentUserProvider

_udModelId

private String _udModelId

_paramValues

private Map<String,Object> _paramValues

_populationId

private String _populationId

_label

private String _label

_id

private String _id

_lazyInitialized

private boolean _lazyInitialized

Constructor Detail

JdbcUserDirectory

public JdbcUserDirectory()

Method Detail

setPluginInfo

public void setPluginInfo(String pluginName,
                          String featureName,
                          String id)

Description copied from interface: PluginAware

Sets the plugin info relative to the current component.
Note : The feature name may be null if the targeted component in declared at plugin level.

Specified by:

setPluginInfo in interface PluginAware

Parameters:

pluginName - Unique identifier for the plugin hosting the extension

featureName - Unique feature identifier (unique for a given pluginName)

id - Unique identifier of this component

contextualize

public void contextualize(Context context)
                   throws ContextException

Specified by:

contextualize in interface Contextualizable

Throws:

ContextException

service

public void service(ServiceManager manager)
             throws ServiceException

Specified by:

service in interface Serviceable

Throws:

ServiceException

dispose

public void dispose()

Specified by:

dispose in interface Disposable

Overrides:

dispose in class CachingComponent<User>

getId

public String getId()

Description copied from interface: UserDirectory

A unique identifier

Specified by:

getId in interface UserDirectory

Returns:

The non-null and non-empty identifier

getLabel

public String getLabel()

Description copied from interface: UserDirectory

Get the label of the CredentialProvider

Specified by:

getLabel in interface UserDirectory

Returns:

The optionnal label

init

public void init(String id,
                 String udModelId,
                 Map<String,Object> paramValues,
                 String label)

Description copied from interface: UserDirectory

Initialize the user's directory with given parameters' values.

Specified by:

init in interface UserDirectory

Parameters:

id - The non-null and non-empty unique identifier

udModelId - The id of user directory extension point

paramValues - The parameters' values

label - The optional label

getObservationManager

protected ObservationManager getObservationManager()

Lazy lookup the ObservationManager

Returns:

the observation manager

getCurrentUserProvider

protected CurrentUserProvider getCurrentUserProvider()

Lazy lookup the CurrentUserProvider

Returns:

the current user provider

getSQLConnection

protected Connection getSQLConnection()

Get the connection to the database

Returns:

the SQL connection

setPopulationId

public void setPopulationId(String populationId)

Description copied from interface: UserDirectory

Set the value of the id of the population this user directory belong to.

Specified by:

setPopulationId in interface UserDirectory

Parameters:

populationId - The id of the population the user directory belongs to.

getPopulationId

public String getPopulationId()

Description copied from interface: UserDirectory

Get the id of the population this user directory belongs to.

Specified by:

getPopulationId in interface UserDirectory

Returns:

The id of the population

getParameterValues

public Map<String,Object> getParameterValues()

Description copied from interface: UserDirectory

Get the values of parameters (from user directory model)

Specified by:

getParameterValues in interface UserDirectory

Returns:

the parameters' values

getUserDirectoryModelId

public String getUserDirectoryModelId()

Description copied from interface: UserDirectory

Get the id of the UserDirectoryModel extension point

Specified by:

getUserDirectoryModelId in interface UserDirectory

Returns:

the id of extension point

getUsers

public Collection<User> getUsers()

Description copied from interface: UserDirectory

Get the list of all users of one directory.

Specified by:

getUsers in interface UserDirectory

Returns:

list of users as Collection of Users, empty if a problem occurs.

getUsers

public List<User> getUsers(int count,
                           int offset,
                           Map<String,Object> parameters)

Description copied from interface: UserDirectory

Get a list of users from a directory given the parameters

Specified by:

getUsers in interface UserDirectory

Parameters:

count - The limit of users to retrieve

offset - The number of result to ignore before starting to collect users.

parameters - A map of additional parameters, see implementation.

Returns:

The list of retrieved User

getUser

public User getUser(String login)

Description copied from interface: UserDirectory

Get a particular user by his login.

Specified by:

getUser in interface UserDirectory

Parameters:

login - Login of the user to get. Cannot be null.

Returns:

User's information as a User instance or null if the user login does not exist.

checkCredentials

public boolean checkCredentials(String login,
                                String password)

Description copied from interface: UserDirectory

Authenticate a user with its credentials

Specified by:

checkCredentials in interface UserDirectory

Parameters:

login - The login to check. Cannot be null.

password - The password to check.

Returns:

true if the user is authenticated, false otherwise.

add

public void add(Map<String,String> userInformation)
         throws InvalidModificationException

Description copied from interface: ModifiableUserDirectory

Add a new user to the list.

Specified by:

add in interface ModifiableUserDirectory

Parameters:

userInformation - Informations about the user, see implementation. Cannot be null.

Throws:

InvalidModificationException - if the login exists yet or if at least one of the parameter is invalid.

validate

public Map<String,Errors> validate(Map<String,String> userInformation)

Description copied from interface: ModifiableUserDirectory

Validate user information.

Specified by:

validate in interface ModifiableUserDirectory

Parameters:

userInformation - Informations about the user, see implementation. Cannot be null.

Returns:

validation errors.

update

public void update(Map<String,String> userInformation)
            throws InvalidModificationException

Description copied from interface: ModifiableUserDirectory

Modify informations about an user of the list.

Specified by:

update in interface ModifiableUserDirectory

Parameters:

userInformation - New informations about the user, see implementation. Cannot be null.

Throws:

InvalidModificationException - if the login does not match in the list or if at least one of the parameter is invalid.

remove

public void remove(String login)
            throws InvalidModificationException

Description copied from interface: ModifiableUserDirectory

Remove an user from the list.

Specified by:

remove in interface ModifiableUserDirectory

Parameters:

login - The user's login. Cannot be null.

Throws:

InvalidModificationException - if the user cannot be removed

getModel

public Collection<? extends Parameter<ParameterHelper.ParameterType>> getModel()

Description copied from interface: ModifiableUserDirectory

Get the user's edition model as a Collection of parameters.

Specified by:

getModel in interface ModifiableUserDirectory

Returns:

the user's edition model as a Collection of parameters.

configureModelParameters

protected void configureModelParameters()

Configure the edition model parameters

_configureParameter

protected JdbcParameter _configureParameter(JdbcUserDirectory.JdbcParameterParser jdbcParameterParser,
                                            String id,
                                            String column)

Configure the parameter (for special handling)

Parameters:

jdbcParameterParser - the JdbcParameter parser.

id - Id the of the parameter

column - Column name of the parameter

Returns:

The parameter created

_getMandatoryPredicate

protected JdbcUserDirectory.JdbcPredicate _getMandatoryPredicate(String pattern)

Get the mandatory predicate to use when querying users by pattern.

Parameters:

pattern - The pattern to match, can be null.

Returns:

a JdbcUserDirectory.JdbcPredicate, can be null.

_getPatternToMatch

protected String _getPatternToMatch(String pattern)

Get the pattern to match user login

Parameters:

pattern - the pattern

Returns:

the pattern to match user login

_isMD5Encrypted

protected boolean _isMD5Encrypted(String password)

Determines if the password is encrypted with MD5 algorithm

Parameters:

password - The encrypted password

Returns:

true if the password is encrypted with MD5 algorithm

_updateToSSHAPassword

protected void _updateToSSHAPassword(String login,
                                     String password)

Generate a salt key and encrypt the password with the sha2 algorithm

Parameters:

login - The user login

password - The user pasword

createAddStatement

protected PreparedStatement createAddStatement(Connection con,
                                               Map<String,String> userInformation)
                                        throws SQLException

Create Add statement

Parameters:

con - The sql connection

userInformation - the user informations

Returns:

The statement

Throws:

SQLException - if an error occurred

createModifyStatement

protected PreparedStatement createModifyStatement(Connection con,
                                                  Map<String,String> userInformation)
                                           throws SQLException

Create statement to update database

Parameters:

con - The sql connection

userInformation - The user information

Returns:

The statement

Throws:

SQLException - if an error occurred

_fillModifyStatement

protected void _fillModifyStatement(PreparedStatement stmt,
                                    Map<String,String> userInformation)
                             throws SQLException

Fill the statement with the user informations

Parameters:

stmt - The statement of the sql request

userInformation - the user informations

Throws:

SQLException - if an error occurred

_getUsersProcessResultSet

protected List<User> _getUsersProcessResultSet(ResultSet rs)
                                        throws SQLException

Populate the user list with the result set

Parameters:

rs - The result set

Returns:

The user list

Throws:

SQLException - If an SQL exception occurs

_createUserFromResultSet

protected User _createUserFromResultSet(ResultSet rs)
                                 throws SQLException

Create the user implementation from the result set of the request

Parameters:

rs - The result set where you can use get methods

Returns:

The user refleting the current cursor position in the result set

Throws:

SQLException - if an error occurred

_getUserProcessResultSet

protected User _getUserProcessResultSet(ResultSet rs,
                                        String login)
                                 throws SQLException

Retrieve an user from a result set

Parameters:

rs - The result set

login - The user login

Returns:

The retrieved user or null if not found

Throws:

SQLException - If an SQL Exception occurs