/* * Copyright (c) 2013 Lockheed Martin Corporation * * Licensed under the Apache License, Version 2.0 (the "License"); * you may not use this file except in compliance with the License. * You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ package org.eurekastreams.server.persistence.mappers.db.metrics; import java.io.Serializable; import java.util.ArrayList; import java.util.List; import javax.persistence.Query; import org.eurekastreams.server.domain.dto.StreamDTO; import org.eurekastreams.server.persistence.comparators.StreamDTOFollowerCountDescendingComparator; import org.eurekastreams.server.persistence.mappers.BaseArgDomainMapper; import edu.emory.mathcs.backport.java.util.Collections; /** * DB mapper to get the top N streams sorted by follower count. */ public class GetStreamsByFollowersCountDbMapper extends BaseArgDomainMapper<Serializable, List<StreamDTO>> { /** * Number of streams to get. */ private final Integer streamCount; /** * Constructor. * * @param inStreamCount * the number of streams to fetch */ public GetStreamsByFollowersCountDbMapper(final Integer inStreamCount) { streamCount = inStreamCount; } /** * Get the top N streams sorted by follower count. * * @param inIgnored * I don't personally care what you pass in here * @return a list of StreamDTOs of the most followed streams */ @Override public List<StreamDTO> execute(final Serializable inIgnored) { Query q; List<StreamDTO> results = new ArrayList<StreamDTO>(); q = getEntityManager().createQuery( "SELECT new org.eurekastreams.server.search.modelview.PersonModelView(id, accountId, " + "preferredName, lastName, displayName, displayNameSuffix, followersCount, dateAdded, " + "streamScope.id) " + "FROM Person WHERE followersCount > 0 ORDER BY followersCount DESC"); if (streamCount > 0) { q.setMaxResults(streamCount).getResultList(); } results.addAll(q.getResultList()); q = getEntityManager().createQuery( "SELECT new org.eurekastreams.server.search.modelview.DomainGroupModelView(id, " + "shortName, name, followersCount, dateAdded, streamScope.id, publicGroup) " + "FROM DomainGroup WHERE isPending = false AND followersCount > 0 " + "ORDER BY followersCount DESC"); if (streamCount > 0) { q.setMaxResults(streamCount).getResultList(); } results.addAll(q.getResultList()); // sort the list Collections.sort(results, new StreamDTOFollowerCountDescendingComparator()); if (results.size() > streamCount) { results = results.subList(0, streamCount); } return results; } }