org.ametys.plugins.survey.data

Class SurveyAnswerDao

java.lang.Object

org.ametys.runtime.plugins.core.sqlmap.dao.AbstractDAO

org.ametys.plugins.survey.data.SurveyAnswerDao

All Implemented Interfaces:

org.ametys.runtime.plugins.core.sqlmap.SqlMapClientsAware, Component, ThreadSafe

public class SurveyAnswerDao
extends org.ametys.runtime.plugins.core.sqlmap.dao.AbstractDAO
implements ThreadSafe, Component

Survey answer DAO.

Nested Class Summary

Nested classes/interfaces inherited from class org.ametys.runtime.plugins.core.sqlmap.dao.AbstractDAO

org.ametys.runtime.plugins.core.sqlmap.dao.AbstractDAO.SQLExceptionWrapper<T>

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	ROLE The Avalon role name.

Constructor Summary

Constructors

Constructor and Description
SurveyAnswerDao()

Method Summary

Modifier and Type	Method and Description
void	addSession(SurveySession session) Insert a session with its answers.
void	deleteSession(java.lang.String sessionId) Delete a session with its answers.
void	deleteSessions(java.lang.String surveyId) Delete sessions related to a given survey.
java.util.List<java.util.Map<java.lang.String,java.lang.Object>>	getAllSessionCount() Get the session count list.
java.util.List<SurveyAnswer>	getAnswers(int sessionId) Get the answers of a session.
SurveySession	getSession(int sessionId) Get a session from its ID.
SurveySession	getSession(java.lang.String surveyId, java.lang.String login) Get a user session from the survey ID and the user login.
int	getSessionCount(java.lang.String surveyId) Get the count of sessions for a given survey.
java.util.List<SurveySession>	getSessions() Get the exhaustive list of sessions.
java.util.List<SurveySession>	getSessions(java.lang.String surveyId) Get all the sessions of a given survey.
java.util.List<SurveySession>	getSessionsWithAnswers(java.lang.String surveyId) Get all the sessions of a given survey, with their answers.
SurveySession	getSessionWithAnswers(int sessionId) Get a session from its ID.
protected java.lang.String	getStatementSuffix(java.sql.Connection connection) Get the statement name suffix, depending of the DBMS family.

Methods inherited from class org.ametys.runtime.plugins.core.sqlmap.dao.AbstractDAO

_getSqlMapClient, _getSqlMapClient, setSqlMapClients

Methods inherited from class java.lang.Object

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

Field Detail

ROLE

public static final java.lang.String ROLE

The Avalon role name.

Constructor Detail

SurveyAnswerDao

public SurveyAnswerDao()

Method Detail

getSession

public SurveySession getSession(int sessionId)
                         throws org.ametys.runtime.plugins.core.sqlmap.dao.DataAccessException

Get a session from its ID.

Parameters:

sessionId - the session ID.

Returns:

the session.

Throws:

org.ametys.runtime.plugins.core.sqlmap.dao.DataAccessException - if an error occurs.

getSession

public SurveySession getSession(java.lang.String surveyId,
                                java.lang.String login)
                         throws org.ametys.runtime.plugins.core.sqlmap.dao.DataAccessException

Get a user session from the survey ID and the user login.

Parameters:

surveyId - the survey ID.

login - the user login.

Returns:

the session.

Throws:

org.ametys.runtime.plugins.core.sqlmap.dao.DataAccessException - if an error occurs.

getSessionWithAnswers

public SurveySession getSessionWithAnswers(int sessionId)
                                    throws org.ametys.runtime.plugins.core.sqlmap.dao.DataAccessException

Get a session from its ID.

Parameters:

sessionId - the session ID.

Returns:

the session.

Throws:

org.ametys.runtime.plugins.core.sqlmap.dao.DataAccessException - if an error occurs.

getSessionCount

public int getSessionCount(java.lang.String surveyId)
                    throws org.ametys.runtime.plugins.core.sqlmap.dao.DataAccessException

Get the count of sessions for a given survey.

Parameters:

surveyId - the survey ID.

Returns:

the session count for this survey.

Throws:

org.ametys.runtime.plugins.core.sqlmap.dao.DataAccessException - if an error occurs.

getAllSessionCount

public java.util.List<java.util.Map<java.lang.String,java.lang.Object>> getAllSessionCount()
                                                                                    throws org.ametys.runtime.plugins.core.sqlmap.dao.DataAccessException

Get the session count list.

Returns:

the session count list.

Throws:

org.ametys.runtime.plugins.core.sqlmap.dao.DataAccessException - if an error occurs.

getSessions

public java.util.List<SurveySession> getSessions()
                                          throws org.ametys.runtime.plugins.core.sqlmap.dao.DataAccessException

Get the exhaustive list of sessions.

Returns:

the sessions.

Throws:

org.ametys.runtime.plugins.core.sqlmap.dao.DataAccessException - if an error occurs.

getSessions

public java.util.List<SurveySession> getSessions(java.lang.String surveyId)
                                          throws org.ametys.runtime.plugins.core.sqlmap.dao.DataAccessException

Get all the sessions of a given survey.

Parameters:

surveyId - the survey ID.

Returns:

the sessions.

Throws:

org.ametys.runtime.plugins.core.sqlmap.dao.DataAccessException - if an error occurs.

getSessionsWithAnswers

public java.util.List<SurveySession> getSessionsWithAnswers(java.lang.String surveyId)
                                                     throws org.ametys.runtime.plugins.core.sqlmap.dao.DataAccessException

Get all the sessions of a given survey, with their answers.

Parameters:

surveyId - the survey ID.

Returns:

the sessions with their answers.

Throws:

org.ametys.runtime.plugins.core.sqlmap.dao.DataAccessException - if an error occurs.

getAnswers

public java.util.List<SurveyAnswer> getAnswers(int sessionId)
                                        throws org.ametys.runtime.plugins.core.sqlmap.dao.DataAccessException

Get the answers of a session.

Parameters:

sessionId - the session ID.

Returns:

the session answers.

Throws:

org.ametys.runtime.plugins.core.sqlmap.dao.DataAccessException - if an error occurs.

addSession

public void addSession(SurveySession session)
                throws org.ametys.runtime.plugins.core.sqlmap.dao.DataAccessException

Insert a session with its answers.

Parameters:

session - the session.

Throws:

org.ametys.runtime.plugins.core.sqlmap.dao.DataAccessException - if an error occurs.

deleteSession

public void deleteSession(java.lang.String sessionId)
                   throws org.ametys.runtime.plugins.core.sqlmap.dao.DataAccessException

Delete a session with its answers.

Parameters:

sessionId - the session ID.

Throws:

org.ametys.runtime.plugins.core.sqlmap.dao.DataAccessException - if an error occurs.

deleteSessions

public void deleteSessions(java.lang.String surveyId)
                    throws org.ametys.runtime.plugins.core.sqlmap.dao.DataAccessException

Delete sessions related to a given survey.

Parameters:

surveyId - the survey ID.

Throws:

org.ametys.runtime.plugins.core.sqlmap.dao.DataAccessException - if an error occurs.

getStatementSuffix

protected java.lang.String getStatementSuffix(java.sql.Connection connection)

Get the statement name suffix, depending of the DBMS family.

Parameters:

connection - the connection.

Returns:

the statement suffix.