com.silverpeas.notation.model
Class RatingDAO

java.lang.Object
  com.silverpeas.notation.model.RatingDAO

public class RatingDAO
extends Object

Field Summary

static String	COLUMN_CONTRIBUTION_ID
static String	COLUMN_CONTRIBUTION_TYPE
static String	COLUMN_ID
static String	COLUMN_INSTANCEID
static String	COLUMN_RATER
static String	COLUMN_RATING
static String	COLUMNS
static String	TABLE_NAME

Method Summary

static void	createRaterRating(Connection con, RaterRatingPK pk, int note)
static long	deleteComponentRatings(Connection con, String componentInstanceId)
static long	deleteRaterRating(Connection con, RaterRatingPK pk)
static long	deleteRatings(Connection con, ContributionRatingPK pk)
static boolean	existRaterRating(Connection con, RaterRatingPK pk)
static Map<String,ContributionRating>	getRatings(Connection con, String componentInstanceId, String contributionType, Collection<String> contributionIds)
static long	moveRatings(Connection con, ContributionRatingPK pk, String componentInstanceId)
static void	updateRaterRating(Connection con, RaterRatingPK pk, int note)

Methods inherited from class java.lang.Object

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

Field Detail

TABLE_NAME

public static final String TABLE_NAME

See Also:

Constant Field Values

COLUMN_ID

public static final String COLUMN_ID

See Also:

Constant Field Values

COLUMN_INSTANCEID

public static final String COLUMN_INSTANCEID

See Also:

Constant Field Values

COLUMN_CONTRIBUTION_ID

public static final String COLUMN_CONTRIBUTION_ID

See Also:

Constant Field Values

COLUMN_CONTRIBUTION_TYPE

public static final String COLUMN_CONTRIBUTION_TYPE

See Also:

Constant Field Values

COLUMN_RATER

public static final String COLUMN_RATER

See Also:

Constant Field Values

COLUMN_RATING

public static final String COLUMN_RATING

See Also:

Constant Field Values

COLUMNS

public static final String COLUMNS

See Also:

Constant Field Values

Method Detail

createRaterRating

public static void createRaterRating(Connection con,
                                     RaterRatingPK pk,
                                     int note)
                              throws SQLException

Throws:

SQLException

updateRaterRating

public static void updateRaterRating(Connection con,
                                     RaterRatingPK pk,
                                     int note)
                              throws SQLException

Throws:

SQLException

moveRatings

public static long moveRatings(Connection con,
                               ContributionRatingPK pk,
                               String componentInstanceId)
                        throws SQLException

Throws:

SQLException

deleteRatings

public static long deleteRatings(Connection con,
                                 ContributionRatingPK pk)
                          throws SQLException

Throws:

SQLException

deleteRaterRating

public static long deleteRaterRating(Connection con,
                                     RaterRatingPK pk)
                              throws SQLException

Throws:

SQLException

deleteComponentRatings

public static long deleteComponentRatings(Connection con,
                                          String componentInstanceId)
                                   throws SQLException

Throws:

SQLException

existRaterRating

public static boolean existRaterRating(Connection con,
                                       RaterRatingPK pk)
                                throws SQLException

Throws:

SQLException

getRatings

public static Map<String,ContributionRating> getRatings(Connection con,
                                                        String componentInstanceId,
                                                        String contributionType,
                                                        Collection<String> contributionIds)
                                                 throws SQLException

Throws:

SQLException