Package org.hibernate.criterion

Examples of org.hibernate.criterion.ProjectionList


    @SuppressWarnings("unchecked")
    @Override
    public Set<TutorialVideoDTO> execute(final Long inRequest)
    {
        Criteria criteria = getHibernateSession().createCriteria(TutorialVideo.class);
        ProjectionList fields = Projections.projectionList();
        fields.add(getColumn("id"));
        fields.add(getColumn("page"));
        fields.add(getColumn("dialogTitle"));
        fields.add(getColumn("innerContentTitle"));
        fields.add(getColumn("innerContent"));
        fields.add(getColumn("videoUrl"));
        fields.add(getColumn("videoWidth"));
        fields.add(getColumn("videoHeight"));
        criteria.setProjection(fields);

        ModelViewResultTransformer<TutorialVideoDTO> resultTransformer = //
        new ModelViewResultTransformer<TutorialVideoDTO>(new TutorialVideoDTOFactory());
View Full Code Here


        {
            return new ArrayList<Long>();
        }

        Criteria criteria = getHibernateSession().createCriteria(entityClass);
        ProjectionList fields = Projections.projectionList();
        fields.add(Projections.property(pointerFieldName).as("key"));
        fields.add(Projections.property("id").as("itemId"));
        criteria.setProjection(fields);

        // Creates the necessary "OR" clauses to get all uncached item pointers
        Criterion restriction = null;
        for (PointerType pointer : inPointerValues)
View Full Code Here

        {
            return new ArrayList<CommentDTO>(0);
        }

        Criteria criteria = getHibernateSession().createCriteria(Comment.class);
        ProjectionList fields = Projections.projectionList();
        fields.add(getColumn("id"));
        fields.add(getColumn("body"));
        fields.add(getColumn("timeSent"));
        fields.add(Projections.property("author.id").as("authorId"));
        fields.add(Projections.property("target.id").as("activityId"));
        criteria.setProjection(fields);

        criteria.setResultTransformer(resultTransformer);

        criteria.add(Restrictions.in("this.id", inRequest));
View Full Code Here

    @Override
    @SuppressWarnings("unchecked")
    public List<ActivityDTO> execute(final List<Long> activityIds)
    {
        Criteria criteria = getHibernateSession().createCriteria(Activity.class);
        ProjectionList fields = Projections.projectionList();
        fields.add(getColumn("id"));
        fields.add(getColumn("verb"));
        fields.add(getColumn("baseObjectType"));
        fields.add(Projections.property("baseObject").as("baseObjectProperties"));
        fields.add(Projections.property("recipStreamScope.destinationEntityId").as("destinationStreamEntityId"));
        fields.add(Projections.property("recipStreamScope.id").as("destinationStreamScopeId"));
        fields.add(Projections.property("recipStreamScope.scopeType").as("destinationStreamScopeType"));
        fields.add(Projections.property("recipStreamScope.uniqueKey").as("destinationStreamUniqueKey"));
        fields.add(getColumn("isDestinationStreamPublic"));
        fields.add(getColumn("actorType"));
        fields.add(getColumn("originalActorType"));
        fields.add(Projections.property("actorId").as("actorUniqueIdentifier"));
        fields.add(Projections.property("originalActorId").as("originalActorUniqueIdentifier"));
        fields.add(getColumn("postedTime"));
        fields.add(getColumn("mood"));
        fields.add(getColumn("location"));
        fields.add(getColumn("annotation"));
        fields.add(getColumn("appId"));
        fields.add(getColumn("appSource"));
        fields.add(getColumn("appName"));
        fields.add(getColumn("showInStream"));
        criteria.createAlias("recipientStreamScope", "recipStreamScope");
        criteria.setProjection(fields);
        criteria.add(Restrictions.in("this.id", activityIds));

        final Map<Long, ActivityDTO> activityMap = new HashMap<Long, ActivityDTO>();
View Full Code Here

     * @return the base criteria object.
     */
    public Criteria getCriteria(final Session hibernateSession)
    {
        Criteria criteria = hibernateSession.createCriteria(Person.class);
        ProjectionList fields = Projections.projectionList();
        fields.add(getColumn("id"));
        fields.add(getColumn("dateAdded"));
        fields.add(getColumn("accountId"));
        fields.add(getColumn("openSocialId"));
        fields.add(getColumn("avatarId"));
        fields.add(getColumn("avatarCropX"));
        fields.add(getColumn("avatarCropY"));
        fields.add(getColumn("avatarCropSize"));
        fields.add(getColumn("lastName"));
        fields.add(getColumn("displayNameSuffix"));
        fields.add(getColumn("displayName"));
        fields.add(getColumn("preferredName"));
        fields.add(getColumn("jobDescription"));
        fields.add(getColumn("title"));
        fields.add(getColumn("overview"));
        fields.add(getColumn("followersCount"));
        fields.add(getColumn("followingCount"));
        fields.add(getColumn("groupsCount"));
        fields.add(getColumn("optOutVideoIds"));
        fields.add(getColumn("updatesCount"));
        fields.add(getColumn("email"));
        fields.add(getColumn("commentable"));
        fields.add(getColumn("companyName"));
        fields.add(getColumn("streamPostable"));
        fields.add(getColumn("additionalProperties"));
        fields.add(getColumn("groupStreamHiddenLineIndex"));
        fields.add(getColumn("lastAcceptedTermsOfService"));
        fields.add(getColumn("accountLocked"));
        fields.add(getColumn("accountDeactivated"));
        fields.add(getColumn("workPhone"));
        fields.add(getColumn("cellPhone"));
        fields.add(getColumn("fax"));
        fields.add(Projections.property("streamViewHiddenLineIndex").as("compositeStreamHiddenLineIndex"));
        fields.add(Projections.property("stream.id").as("streamId"));
        criteria.setProjection(fields);
        criteria.createAlias("streamScope", "stream");

        ModelViewResultTransformer<PersonModelView> resultTransformer = new ModelViewResultTransformer<PersonModelView>(
                new PersonModelViewFactory());
View Full Code Here

     * @return the base criteria object.
     */
    public Criteria getCriteria(final Session hibernateSession)
    {
        Criteria criteria = hibernateSession.createCriteria(DomainGroup.class);
        ProjectionList fields = Projections.projectionList();
        fields.add(getColumn("id"));
        fields.add(getColumn("description"));
        fields.add(getColumn("name"));
        fields.add(getColumn("shortName"));
        fields.add(Projections.property("publicGroup").as("isPublic"));
        fields.add(getColumn("updatesCount"));
        fields.add(getColumn("followersCount"));
        fields.add(getColumn("dateAdded"));
        fields.add(getColumn("avatarId"));
        fields.add(getColumn("avatarCropSize"));
        fields.add(getColumn("avatarCropX"));
        fields.add(getColumn("avatarCropY"));
        fields.add(getColumn("bannerId"));
        fields.add(getColumn("overview"));
        fields.add(getColumn("commentable"));
        fields.add(getColumn("streamPostable"));
        fields.add(getColumn("url"));
        fields.add(getColumn("stickyActivityId"));
        fields.add(Projections.property("cb.accountId").as("personCreatedByAccountId"));
        fields.add(Projections.property("cb.displayName").as("personCreatedByDisplayName"));
        fields.add(Projections.property("cb.companyName").as("personCreatedByCompanyName"));
        fields.add(Projections.property("stream.id").as("streamId"));
        criteria.setProjection(fields);
        criteria.createAlias("createdBy", "cb");
        criteria.createAlias("streamScope", "stream");

        // We don't currently cache pending groups
View Full Code Here

TOP

Related Classes of org.hibernate.criterion.ProjectionList

Copyright © 2018 www.massapicom. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.