Package com.mysema.query.jpa.impl

Examples of com.mysema.query.jpa.impl.JPAQuery.from()

42
43
44
45
46
47
48
49
50
51
52
   
    @Test
    public void test() throws IOException, ClassNotFoundException{
        // create query
        JPAQuery query = new JPAQuery(entityManager);
        query.from(cat).where(cat.name.eq("Kate")).list(cat);
       
        // get metadata
        QueryMetadata metadata = query.getMetadata();
        assertFalse(metadata.getJoins().isEmpty());
        assertTrue(metadata.getWhere() != null);
View Full Code Here
42
43
44
45
46
47
48
49
50
51
    }

    @Test
    public void Query() throws ClassNotFoundException, IOException {
        JPAQuery query = new JPAQuery();
        query.from(QCat.cat);
        query.where(serialize(QCat.cat.name.eq("test")));
    }

}
View Full Code Here
16
17
18
19
20
21
22
23
24
25
26
 
  @Override
  public ProjectVersion getByProjectAndVersion(Project project, String version) {
    JPAQuery query = new JPAQuery(getEntityManager());
   
    query.from(qProjectVersion)
      .where(qProjectVersion.project.eq(project))
      .where(qProjectVersion.version.eq(version));
   
    return query.uniqueResult(qProjectVersion);
  }
View Full Code Here
85
86
87
88
89
90
91
92
93
94
95
 
  @Override
  public List<ArtifactVersionNotification> listLastNotifications(User user, long limit) {
    JPAQuery query = new JPAQuery(getEntityManager());
   
    query.from(qArtifactVersionNotification)
      .where(qArtifactVersionNotification.user.eq(user))
      .orderBy(qArtifactVersionNotification.creationDate.desc())
      .limit(limit);
   
    return query.list(qArtifactVersionNotification);
View Full Code Here
97
98
99
100
101
102
103
104
105
106
107
 
  @Override
  public List<ArtifactVersionNotification> listNotificationsAfterDate(User user, Date date) {
    JPAQuery query = new JPAQuery(getEntityManager());
   
    query.from(qArtifactVersionNotification)
      .where(qArtifactVersionNotification.user.eq(user))
      .where(qArtifactVersionNotification.creationDate.after(date))
      .orderBy(qArtifactVersionNotification.creationDate.desc());
   
    return query.list(qArtifactVersionNotification);
View Full Code Here
109
110
111
112
113
114
115
116
117
118
119
 
  @Override
  public FollowedArtifact getFollowedArtifact(User user, Artifact artifact) {
    JPAQuery query = new JPAQuery(getEntityManager());
   
    query.from(qFollowedArtifact)
      .where(qFollowedArtifact.user.eq(user))
      .where(qFollowedArtifact.artifact.eq(artifact));
   
    return query.singleResult(qFollowedArtifact);
  }
View Full Code Here
122
123
124
125
126
127
128
129
130
131
132
  public List<User> listByUserGroup(UserGroup userGroup) {
    JPAQuery query = new JPAQuery(getEntityManager());
    QUser qUser = QUser.user;
    QUserGroup qUserGroup = QUserGroup.userGroup;
   
    query.from(qUser)
        .join(qUser.groups, qUserGroup)
        .where(qUserGroup.eq(userGroup))
        .orderBy(qUser.lastName.lower().asc(), qUser.firstName.lower().asc());
   
    return query.list(qUser);
View Full Code Here
49
50
51
52
53
54
55
56
57
58
59
 
  @Override
  public List<ArtifactVersion> listArtifactVersionsAfterDate(Artifact artifact, Date date) {
    JPAQuery query = new JPAQuery(getEntityManager());
   
    query.from(qArtifactVersion)
      .where(qArtifactVersion.artifact.eq(artifact))
      .where(qArtifactVersion.lastUpdateDate.gt(date))
      .orderBy(qArtifactVersion.lastUpdateDate.desc());
   
    return query.list(qArtifactVersion);
View Full Code Here
61
62
63
64
65
66
67
68
69
70
71
 
  @Override
  public Artifact getByGroupIdArtifactId(String groupId, String artifactId) {
    JPAQuery query = new JPAQuery(getEntityManager());
   
    query.from(qArtifact)
      .where(qArtifact.group.groupId.eq(groupId))
      .where(qArtifact.artifactId.eq(artifactId));
   
    return query.uniqueResult(qArtifact);
  }
View Full Code Here
72
73
74
75
76
77
78
79
80
81
82
 
  @Override
  public List<Artifact> listMostFollowedArtifacts(int limit) {
    JPAQuery query = new JPAQuery(getEntityManager());
   
    query.from(qArtifact)
      .where(qArtifact.deprecationStatus.eq(ArtifactDeprecationStatus.NORMAL))
      .orderBy(qArtifact.followersCount.desc())
      .limit(limit);
   
    return query.list(qArtifact);
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.