Package com.mysema.query.sql.domain

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

99
100
101
102
103
104
105
106
107
108
109
    }

    @Test
    public void Delete_with_SubQuery_exists_Params() {
        QSurvey survey1 = new QSurvey("s1");
        QEmployee employee = new QEmployee("e");

        Param<Integer> param = new Param<Integer>(Integer.class, "param");
        SQLSubQuery sq = sq().from(employee).where(employee.id.eq(param));
        sq.set(param, -12478923);
View Full Code Here
113
114
115
116
117
118
119
120
121
122
123
    }

    @Test
    public void Delete_with_SubQuery_exists2() {
        QSurvey survey1 = new QSurvey("s1");
        QEmployee employee = new QEmployee("e");
        SQLDeleteClause delete = delete(survey1);
        delete.where(survey1.name.eq("XXX"),
                sq().from(employee).where(survey1.name.eq(employee.lastname)).exists());
        delete.execute();
    }
View Full Code Here
29
30
31
32
33
34
35
36
37
38
39
    }
   
    @Test
    public void HashCode2() {
        QSurvey survey = new QSurvey("entity");
        QEmployee employee = new QEmployee("entity");
        ListSubQuery<Integer> query1 = new SQLSubQuery().from(survey).list(survey.id);
        ListSubQuery<Integer> query2 = new SQLSubQuery().from(employee).list(employee.id);

        Set<ListSubQuery<Integer>> queries = new HashSet<ListSubQuery<Integer>>();
        queries.add(query1);
View Full Code Here
60
61
62
63
64
65
66
67
68
69
70
        assertEquals(employee.firstname, exprs.get(2));
    }

    @Test
    public void List_Entity() {
        QEmployee employee2 = new QEmployee("employee2");
        SQLSubQuery query = new SQLSubQuery();
        Expression<?> expr = query.from(employee)
             .innerJoin(employee.superiorIdKey, employee2)
             .list(employee, employee2.id);
View Full Code Here
110
111
112
113
114
115
116
117
118
119
120
121
    @Test
    public void Complex() {
        // related to #584795
        QSurvey survey = new QSurvey("survey");
        QEmployee emp1 = new QEmployee("emp1");
        QEmployee emp2 = new QEmployee("emp2");
        SubQueryExpression<?> subQuery = new SQLSubQuery().from(survey)
          .innerJoin(emp1)
           .on(survey.id.eq(emp1.id))
          .innerJoin(emp2)
           .on(emp1.superiorId.eq(emp2.superiorId), emp1.firstname.eq(emp2.firstname))
View Full Code Here
TOP

Related Classes of com.mysema.query.sql.domain.QEmployee

  • com.mysema.query.DeleteBase
  • com.mysema.query.ListSubQueryTest
  • com.mysema.query.SelectOracleBase
  • com.mysema.query.sql.ForeignKeyTest
  • com.mysema.query.sql.PaginationTest
  • com.mysema.query.sql.RelationalPathExtractorTest
  • com.mysema.query.sql.SerializationTest
  • com.mysema.query.sql.SQLSerializerTest
  • com.mysema.query.sql.SQLSubQueryTest
  • com.mysema.query.SubqueriesBase
    • 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.