Examples of addWhere()

Examples of com.mysema.query.DefaultQueryMetadata.addWhere()

107
108
109
110
111
112
113
114
115
116
117
    public void Delete_Clause_Uses_DELETE_FROM() {
        QEmployee employee = QEmployee.employee;
        JPQLSerializer serializer = new JPQLSerializer(HQLTemplates.DEFAULT);
        QueryMetadata md = new DefaultQueryMetadata();
        md.addJoin(JoinType.DEFAULT, employee);
        md.addWhere(employee.lastName.isNull());
        serializer.serializeForDelete(md);
        assertEquals("delete from Employee employee\nwhere employee.lastName is null", serializer.toString());
    }

    @Test
View Full Code Here

Examples of com.mysema.query.DefaultQueryMetadata.addWhere()

120
121
122
123
124
125
126
127
128
129
130
        QCat child = new QCat("kitten");

        JPQLSerializer serializer = new JPQLSerializer(HQLTemplates.DEFAULT);
        QueryMetadata md = new DefaultQueryMetadata();
        md.addJoin(JoinType.DEFAULT, child);
        md.addWhere(
            child.id.eq(1)
            .and(new JPASubQuery()
                .from(parent)
                .where(parent.id.eq(2), child.in(parent.kittens)).exists()));
        serializer.serializeForDelete(md);
View Full Code Here

Examples of com.mysema.query.DefaultQueryMetadata.addWhere()

30
31
32
33
34
35
36
37
38
39
40
        Configuration conf = new Configuration(new MySQLTemplates());
        NativeSQLSerializer serializer = new NativeSQLSerializer(conf, true);
        DefaultQueryMetadata md = new DefaultQueryMetadata();
        SAnimal cat = SAnimal.animal_;
        md.addJoin(JoinType.DEFAULT, cat);
        md.addWhere(cat.name.in("X", "Y"));
        md.addProjection(cat.id);
        serializer.serialize(md, false);
        assertEquals("select animal_.id\n" +
          "from animal_ animal_\n" +
          "where animal_.name in (?1, ?2)", serializer.toString());
View Full Code Here

Examples of com.mysema.query.DefaultQueryMetadata.addWhere()

27
28
29
30
31
32
33
34
35
36
37
   
    @Test
    public void Reusage() {
        QueryMetadata metadata = new DefaultQueryMetadata();
        metadata.addJoin(JoinType.DEFAULT, cat);
        metadata.addWhere(cat.name.startsWith("A"));
       
        CollQuery query = new CollQuery(metadata);
        query.bind(cat, cats);
        assertEquals(Arrays.asList(c3), query.list(cat));
    }
View Full Code Here

Examples of com.mysema.query.QueryMetadata.addWhere()

107
108
109
110
111
112
113
114
115
116
117
    public void Delete_Clause_Uses_DELETE_FROM() {
        QEmployee employee = QEmployee.employee;
        JPQLSerializer serializer = new JPQLSerializer(HQLTemplates.DEFAULT);
        QueryMetadata md = new DefaultQueryMetadata();
        md.addJoin(JoinType.DEFAULT, employee);
        md.addWhere(employee.lastName.isNull());
        serializer.serializeForDelete(md);
        assertEquals("delete from Employee employee\nwhere employee.lastName is null", serializer.toString());
    }

    @Test
View Full Code Here

Examples of com.mysema.query.QueryMetadata.addWhere()

120
121
122
123
124
125
126
127
128
129
130
        QCat child = new QCat("kitten");

        JPQLSerializer serializer = new JPQLSerializer(HQLTemplates.DEFAULT);
        QueryMetadata md = new DefaultQueryMetadata();
        md.addJoin(JoinType.DEFAULT, child);
        md.addWhere(
            child.id.eq(1)
            .and(new JPASubQuery()
                .from(parent)
                .where(parent.id.eq(2), child.in(parent.kittens)).exists()));
        serializer.serializeForDelete(md);
View Full Code Here

Examples of com.mysema.query.QueryMetadata.addWhere()

27
28
29
30
31
32
33
34
35
36
37
   
    @Test
    public void Reusage() {
        QueryMetadata metadata = new DefaultQueryMetadata();
        metadata.addJoin(JoinType.DEFAULT, cat);
        metadata.addWhere(cat.name.startsWith("A"));
       
        CollQuery query = new CollQuery(metadata);
        query.bind(cat, cats);
        assertEquals(Arrays.asList(c3), query.list(cat));
    }
View Full Code Here

Examples of mondrian.rolap.sql.SqlQuery.addWhere()

257
258
259
260
261
262
263
264
265
266
267
                expr,
                predicate,
                column.getDatatype(),
                innerSqlQuery);
            if (!where.equals("true")) {
                innerSqlQuery.addWhere(where);
            }
            if (countOnly) {
                continue;
            }
            final String alias = "d" + i;
View Full Code Here

Examples of org.hibernate.envers.internal.tools.query.Parameters.addWhere()

362
363
364
365
366
367
368
369
370
371
372
        revisionEndProperty + ".id",
        addAlias,
        inclusive ? ">" : ">=",
        REVISION_PARAMETER
    );
    subParm.addWhere( revisionEndProperty, addAlias, "is", "null", false );
  }

  @SuppressWarnings({"unchecked"})
  private RevisionType getRevisionType(AuditConfiguration auditCfg, Object data) {
    return (RevisionType) ((Map<String, Object>) data).get( auditCfg.getAuditEntCfg().getRevisionTypePropName() );
View Full Code Here

Examples of org.hibernate.envers.internal.tools.query.Parameters.addWhere()

369
370
371
372
373
374
375
376
377
378
379
        revisionEndProperty + ".id",
        addAlias,
        inclusive ? ">" : ">=",
        REVISION_PARAMETER
    );
    subParm.addWhere( revisionEndProperty, addAlias, "is", "null", false );
  }

  @SuppressWarnings({"unchecked"})
  private RevisionType getRevisionType(AuditConfiguration auditCfg, Object data) {
    return (RevisionType) ((Map<String, Object>) data).get( auditCfg.getAuditEntCfg().getRevisionTypePropName() );
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.