com.silverpeas.comment.dao.jdbc
Class JDBCCommentDAO

java.lang.Object
  com.silverpeas.comment.dao.jdbc.JDBCCommentDAO

All Implemented Interfaces:

CommentDAO

@Named(value="commentDAO")
public class JDBCCommentDAO
extends Object
implements CommentDAO

Field Summary

protected static long

serialVersionUID

Constructor Summary

JDBCCommentDAO()

Method Summary

List<Comment>	getAllCommentsByForeignKey(String resourceType, ForeignPK foreign_pk) Gets all the comments of the publication identified by the resource type and the specified foreign key.
List<CommentedPublicationInfo>	getAllMostCommentedPublications() Among all available commented publications, gets the most commented ones.
Comment	getComment(CommentPK pk) Gets the comment identified by the specified primary key.
int	getCommentsCountByForeignKey(String resourceType, ForeignPK foreign_pk) Gets the number of comments on the publication identified by the resource type and the specified foreign key.
List<Comment>	getLastComments(String instanceId, int count) Gets the last comments posted to the publications in the specified component instance.
List<CommentedPublicationInfo>	getMostCommentedPublications(String resourceType) Among all available commented publications of the specified type, gets the moste commented ones.
List<CommentedPublicationInfo>	getMostCommentedPublications(String resourceType, List<? extends WAPrimaryKey> pks) Among all the publications identified by the resource type and the specified primary keys, gets the most commented ones.
List<SocialInformationComment>	getSocialInformationCommentsListByUserId(List<String> resourceTypes, String userId, Period period) Get the list of SocialInformationComment added by userId in a period
List<SocialInformationComment>	getSocialInformationCommentsListOfMyContacts(List<String> resourceTypes, List<String> myContactsIds, List<String> instanceIds, Period period) Gets the list of SocialInformationComment added by myContactsIds in a period
void	moveComments(String resourceType, ForeignPK fromPK, ForeignPK toPK) Moves all the comments from the publication identified by the resource type and the specified foreign key to the publication identified by the second specified foreign key.
void	moveComments(String fromResourceType, ForeignPK fromPK, String toResourceType, ForeignPK toPK) Moves all the comments from the publication identified by the resource type and the specified foreign key to the publication identified by the second resource type and specified foreign key.
void	removeAllCommentsByForeignPk(String resourceType, ForeignPK foreign_pk) Deletes all the comments on the publication identified by the resource type and the specified foreign key.
void	removeComment(CommentPK pk) Deletes the comment identified by the specified primary key
CommentPK	saveComment(Comment cmt) Saves the specified comment into the underlying data source.
void	updateComment(Comment cmt) Updates the comment in the data source identified by the specified one with the values carried by the specified comment.

Methods inherited from class java.lang.Object

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

Field Detail

serialVersionUID

protected static final long serialVersionUID

See Also:

Constant Field Values

Constructor Detail

JDBCCommentDAO

public JDBCCommentDAO()

Method Detail

saveComment

public CommentPK saveComment(Comment cmt)

Description copied from interface: CommentDAO

Saves the specified comment into the underlying data source.

Specified by:

saveComment in interface CommentDAO

Parameters:

cmt - the comment to save.

Returns:

the primary key of the comment in the data source.

removeComment

public void removeComment(CommentPK pk)

Description copied from interface: CommentDAO

Deletes the comment identified by the specified primary key

Specified by:

removeComment in interface CommentDAO

updateComment

public void updateComment(Comment cmt)

Description copied from interface: CommentDAO

Updates the comment in the data source identified by the specified one with the values carried by the specified comment.

Specified by:

updateComment in interface CommentDAO

Parameters:

cmt - the comment to update in the data source.

getComment

public Comment getComment(CommentPK pk)

Description copied from interface: CommentDAO

Gets the comment identified by the specified primary key. If no comment exist with a such primary key, then a CommentRuntimeException is thrown.

Specified by:

getComment in interface CommentDAO

Parameters:

pk - the primary key of the comment to get.

Returns:

the comment.

getAllMostCommentedPublications

public List<CommentedPublicationInfo> getAllMostCommentedPublications()

Description copied from interface: CommentDAO

Among all available commented publications, gets the most commented ones.

Specified by:

getAllMostCommentedPublications in interface CommentDAO

Returns:

a list of information about the most commented publication (publication primary key, number of comments, and so on).

getMostCommentedPublications

public List<CommentedPublicationInfo> getMostCommentedPublications(String resourceType,
                                                                   List<? extends WAPrimaryKey> pks)

Description copied from interface: CommentDAO

Among all the publications identified by the resource type and the specified primary keys, gets the most commented ones.

Specified by:

getMostCommentedPublications in interface CommentDAO

Parameters:

resourceType - type of the commented publication.

pks - a list of primary keys refering some publications.

Returns:

a list of information about the most commented publication (publication primary key, number of comments, and so on).

getCommentsCountByForeignKey

public int getCommentsCountByForeignKey(String resourceType,
                                        ForeignPK foreign_pk)

Description copied from interface: CommentDAO

Gets the number of comments on the publication identified by the resource type and the specified foreign key.

Specified by:

getCommentsCountByForeignKey in interface CommentDAO

Parameters:

resourceType - type of the commented publication.

foreign_pk - the foreign key refering the publication.

Returns:

the number of the publication comments.

getAllCommentsByForeignKey

public List<Comment> getAllCommentsByForeignKey(String resourceType,
                                                ForeignPK foreign_pk)

Description copied from interface: CommentDAO

Gets all the comments of the publication identified by the resource type and the specified foreign key.

Specified by:

getAllCommentsByForeignKey in interface CommentDAO

Parameters:

resourceType - type of the commented publication.

foreign_pk - the foreign key refering the publication in the data source.

Returns:

a list with all of the publication comments. If the publication isn't commented, then an empty list is returned.

removeAllCommentsByForeignPk

public void removeAllCommentsByForeignPk(String resourceType,
                                         ForeignPK foreign_pk)

Description copied from interface: CommentDAO

Deletes all the comments on the publication identified by the resource type and the specified foreign key.

Specified by:

removeAllCommentsByForeignPk in interface CommentDAO

Parameters:

resourceType - type of the commented publication.

foreign_pk - the foreign key refering the publication in the data source

moveComments

public void moveComments(String resourceType,
                         ForeignPK fromPK,
                         ForeignPK toPK)

Description copied from interface: CommentDAO

Moves all the comments from the publication identified by the resource type and the specified foreign key to the publication identified by the second specified foreign key.

Specified by:

moveComments in interface CommentDAO

Parameters:

resourceType - type of source and destination publication.

fromPK - the foreign key refering the source publication.

toPK - the foreign key refering the destination publication.

moveComments

public void moveComments(String fromResourceType,
                         ForeignPK fromPK,
                         String toResourceType,
                         ForeignPK toPK)

Description copied from interface: CommentDAO

Moves all the comments from the publication identified by the resource type and the specified foreign key to the publication identified by the second resource type and specified foreign key.

Specified by:

moveComments in interface CommentDAO

Parameters:

fromResourceType - source type the source publication.

fromPK - the foreign key refering the source publication.

toResourceType - type of the destination publication.

toPK - the foreign key refering the destination publication.

getMostCommentedPublications

public List<CommentedPublicationInfo> getMostCommentedPublications(String resourceType)

Description copied from interface: CommentDAO

Among all available commented publications of the specified type, gets the moste commented ones.

Specified by:

getMostCommentedPublications in interface CommentDAO

Parameters:

resourceType - the type of the publication.

Returns:

a list of information about the most commented publication sorted in descendent order.

getLastComments

public List<Comment> getLastComments(String instanceId,
                                     int count)

Description copied from interface: CommentDAO

Gets the last comments posted to the publications in the specified component instance.

Specified by:

getLastComments in interface CommentDAO

Parameters:

instanceId - the unique identifier of the component instance.

count - the maximum number of comments to fetch. Lesser or equal to 0 means no limit.

Returns:

a list of the last comments.

getSocialInformationCommentsListByUserId

public List<SocialInformationComment> getSocialInformationCommentsListByUserId(List<String> resourceTypes,
                                                                               String userId,
                                                                               Period period)

Description copied from interface: CommentDAO

Get the list of SocialInformationComment added by userId in a period

Specified by:

getSocialInformationCommentsListByUserId in interface CommentDAO

Parameters:

resourceTypes - the aimed resources types.

userId - the author of comments.

period - the period into which the comment has been created or modified.

Returns:

List of SocialInformation

getSocialInformationCommentsListOfMyContacts

public List<SocialInformationComment> getSocialInformationCommentsListOfMyContacts(List<String> resourceTypes,
                                                                                   List<String> myContactsIds,
                                                                                   List<String> instanceIds,
                                                                                   Period period)

Description copied from interface: CommentDAO

Gets the list of SocialInformationComment added by myContactsIds in a period

Specified by:

getSocialInformationCommentsListOfMyContacts in interface CommentDAO

Parameters:

resourceTypes - the aimed resources types.

myContactsIds - the aimed user identifiers of contacts.

instanceIds - the aimed identifiers of component instances.

period - the period into which the comment has been created or modified.

Returns:

List of SocialInformation