Examples of QEmployee

Examples of com.mysema.query.jdo.models.company.QEmployee

8
9
10
11
12
13
14
15
16
17
18
public class GroupByTest extends AbstractTest {
   
    @Test
    public void GroupBy() {
        QEmployee employee = QEmployee.employee;
        assertEquals(
                "SELECT FROM com.mysema.query.jdo.models.company.Employee "+
                "PARAMETERS java.lang.String a1 "+
                "GROUP BY this.emailAddress "+
                "HAVING this.emailAddress != a1",
View Full Code Here

Examples of com.mysema.query.jpa.domain.QEmployee

103
104
105
106
107
108
109
110
111
112
113
        }
    }

    @Test
    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);
View Full Code Here

Examples of com.mysema.query.jpa.domain.QEmployee

48
49
50
51
52
53
54
55
56
57
58
                "where cat_kittens.*\\.name = \\?1\\)", serialize(predicate));
    }

    @Test
    public void Simple_BooleanOperation_ElementCollection() {
        QEmployee employee = QEmployee.employee;
        Predicate predicate = employee.jobFunctions.any().eq(JobFunction.CODER);
        assertMatches("exists \\(select 1\n" +
          "from Employee employee.*\n" +
          "  inner join employee.*.jobFunctions as employee_jobFunctions.*\n" +
          "where employee.* = employee and employee_jobFunctions.* = \\?1\\)", serialize(predicate));
View Full Code Here

Examples of com.mysema.query.jpa.domain.QEmployee

36
37
38
39
40
41
42
43
44
45
    }

    @Test
    public void InnerJoin() {
        HibernateQuery hqlQuery = new HibernateQuery();
        QEmployee employee = QEmployee.employee;
        hqlQuery.from(employee);
        hqlQuery.innerJoin(employee.user, QUser.user);
        assertEquals("select employee\nfrom Employee employee\n  inner join employee.user as user", hqlQuery.toString());
    }
View Full Code Here

Examples of com.mysema.query.jpa.domain.QEmployee

55
56
57
58
59
60
61
62
63
64
                sub().from(cat).innerJoin(cat.mate).toString());
    }
   
    @Test
    public void InnerJoin2() {
        QEmployee employee = QEmployee.employee;
        QUser user = QUser.user;
        assertEquals("select employee\nfrom Employee employee\n  inner join employee.user as user",
                sub().from(employee).innerJoin(employee.user, user).toString());
    }
View Full Code Here

Examples of com.mysema.query.sql.KeyAccessorsTest.QEmployee

9
10
11
12
13
14
15
16
17
18
public class SQLDeleteClauseTest {

    @Test(expected=IllegalArgumentException.class)
    public void Error() {
        QEmployee emp1 = new QEmployee("emp1");
        QEmployee emp2 = new QEmployee("emp2");
        SQLDeleteClause delete = new SQLDeleteClause(null, SQLTemplates.DEFAULT, emp1);
        delete.where(emp2.id.eq(1));
    }
View Full Code Here

Examples of com.mysema.query.sql.KeyAccessorsTest.QEmployee

17
18
19
20
21
22
23
24
25
26
27
        delete.where(emp2.id.eq(1));
    }

    @Test
    public void GetSQL() {
        QEmployee emp1 = new QEmployee("emp1");
        SQLDeleteClause delete = new SQLDeleteClause(null, SQLTemplates.DEFAULT, emp1);
        delete.where(emp1.id.eq(1));

        SQLBindings sql = delete.getSQL().get(0);
        assertEquals("delete from EMPLOYEE\nwhere EMPLOYEE.ID = ?", sql.getSQL());
View Full Code Here

Examples of com.mysema.query.sql.KeyAccessorsTest.QEmployee

10
11
12
13
14
15
16
17
18
19
20
public class SQLUpdateClauseTest {

    @Test
    public void GetSQL() {
        QEmployee emp1 = new QEmployee("emp1");
        SQLUpdateClause update = new SQLUpdateClause(null, SQLTemplates.DEFAULT, emp1);
        update.set(emp1.id, 1);

        SQLBindings sql = update.getSQL().get(0);
        assertEquals("update EMPLOYEE\nset ID = ?", sql.getSQL());
View Full Code Here

Examples of com.mysema.query.sql.KeyAccessorsTest.QEmployee

21
22
23
24
25
26
27
28
29
30
31
32
        assertEquals(ImmutableList.of(1), sql.getBindings());
    }

    @Test
    public void Intertable() {
        QEmployee emp1 = new QEmployee("emp1");
        QEmployee emp2 = new QEmployee("emp2");
        SQLUpdateClause update = new SQLUpdateClause(null, SQLTemplates.DEFAULT, emp1);
        update.set(emp1.id, 1)
              .where(emp1.id.eq(new SQLSubQuery().from(emp2)
                      .where(emp2.superiorId.isNotNull())
                      .unique(emp2.id)));
View Full Code Here

Examples of com.mysema.query.sql.KeyAccessorsTest.QEmployee

39
40
41
42
43
44
45
46
47
48
49
50
                "where emp2.SUPERIOR_ID is not null)", sql.getSQL());
    }

    @Test
    public void Intertable2() {
        QEmployee emp1 = new QEmployee("emp1");
        QEmployee emp2 = new QEmployee("emp2");
        SQLUpdateClause update = new SQLUpdateClause(null, SQLTemplates.DEFAULT, emp1);
        update.set(emp1.id, new SQLSubQuery().from(emp2)
              .where(emp2.superiorId.isNotNull())
              .unique(emp2.id));
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.