Package org.objectquery.generic.domain

Examples of org.objectquery.generic.domain.Person

10
11
12
13
14
15
16
17
18
19
20
21
  @Test
  public void testSimpleCreateJoin() {
    MockQueryBuilder qb = new MockQueryBuilder();
    GenericSelectQuery<Person, Object> objectQuery = new GenericSelectQuery<Person, Object>(qb, Person.class);
    Person join = objectQuery.join(Person.class);
    objectQuery.eq(objectQuery.target().getName(), join.getName());
    qb.build();

    assertEquals(1, qb.getConditionsString().size());

    assertEquals("A.name EQUALS AB0.name", qb.getConditionsString().get(0));
View Full Code Here
29
30
31
32
33
34
35
36
37
38
39
40
  @Test
  public void testLinkedCreateJoin() {
    MockQueryBuilder qb = new MockQueryBuilder();
    GenericSelectQuery<Person, Object> objectQuery = new GenericSelectQuery<Person, Object>(qb, Person.class);
    Person join = objectQuery.join(objectQuery.target().getMom(), Person.class, JoinType.OUTER);
    objectQuery.eq(objectQuery.target().getName(), join.getName());
    qb.build();

    assertEquals(1, qb.getConditionsString().size());

    assertEquals("A.name EQUALS AB0.name", qb.getConditionsString().get(0));
View Full Code Here
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
  public void buildQuery() {
    MockQueryBuilder builder = new MockQueryBuilder();
    GenericSelectQuery<Person, Object> query = new GenericSelectQuery<Person, Object>(builder, Person.class);

    Person toSearch = query.target();
    query.eq(toSearch.getHome().getAddress(), toSearch.getDog().getHome().getAddress());
    query.eq(toSearch.getDad().getHome(), toSearch.getDog().getHome());
    query.eq(toSearch.getMom().getName(), toSearch.getDog().getOwner().getName());
    query.order(toSearch.getName());
    builder.build();
    assertEquals("size of result conditions", 3, builder.getConditionsString().size());
    assertEquals("first condition", "home.address EQUALS dog.home.address", builder.getConditionsString().get(0));
    assertEquals("second condition", "dud.home EQUALS dog.home", builder.getConditionsString().get(1));
    assertEquals("thirdth condition", "mum.name EQUALS dog.owner.name", builder.getConditionsString().get(2));
View Full Code Here
170
171
172
173
174
175
176
177
178
179
180
181
182
183
  @Test
  public void testSimpleQueryBuild() {
    MockQueryBuilder builder = new MockQueryBuilder();
    SelectQuery<Person> query = new GenericSelectQuery<Person, Object>(builder, Person.class);
    Person toSearch = query.target();
    query.eq(toSearch.getHome().getAddress(), "rue d'anton");
    query.eq(toSearch.getMom().getName(), "elisabeth");
    query.order(toSearch.getName());

    builder.build();
    assertEquals("There is more conditions than expected", builder.getConditionsString().size(), 2);
    assertEquals("There is more orders than expected", builder.getOrdersString().size(), 1);
View Full Code Here
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
  @Test
  public void testClean() {
    MockQueryBuilder builder = new MockQueryBuilder();
    GenericSelectQuery<Person, Object> query = new GenericSelectQuery<Person, Object>(builder, Person.class);
    Person toSearch = query.target();
    query.prj(toSearch.getHome().getAddress());
    query.prj(query.subQuery(Person.class));
    query.eq(toSearch.getHome().getAddress(), "rue d'anton");
    query.eq(toSearch.getMom().getName(), "elisabeth");
    query.eq(toSearch.getMom().getName(), toSearch.getDad().getName());
    query.eq(toSearch.getMom(), query.subQuery(Person.class));
    query.having(toSearch.getMom().getName(), ProjectionType.COUNT).eq(query.box(toSearch.getHome().getPrice()));
    query.order(toSearch.getName());
    query.order(query.subQuery(Person.class));

    builder.build();
    query.clear();
  }
View Full Code Here
11
12
13
14
15
16
17
18
19
20
21
22
23
24
  @Test
  public void conditionPlainAnd() {
    MockQueryBuilder tqb = new MockQueryBuilder();
    SelectQuery<Person> oq = new GenericSelectQuery<Person, Object>(tqb, Person.class);
    Person pers = oq.target();
    QueryCondition cond = oq.and();
    cond.eq(pers.getName(), "mary");
    cond.eq(pers.getDog().getName(), "mary");
    tqb.build();

    assertEquals(1, tqb.getConditionsString().size());
    assertEquals(" ( name EQUALS mary AND dog.name EQUALS mary ) ", tqb.getConditionsString().get(0));
View Full Code Here
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
  @Test
  public void conditionNestedAnd() {
    MockQueryBuilder tqb = new MockQueryBuilder();
    SelectQuery<Person> oq = new GenericSelectQuery<Person, Object>(tqb, Person.class);
    Person pers = oq.target();
    QueryCondition cond = oq.and();
    QueryCondition and1 = cond.and();
    and1.eq(pers.getName(), "mary");
    and1.eq(pers.getDog().getName(), "mary");
    QueryCondition and2 = cond.and();
    and2.eq(pers.getName(), "miry");
    and2.eq(pers.getDog().getName(), "miry");

    tqb.build();

    assertEquals(1, tqb.getConditionsString().size());
    assertEquals(" (  ( name EQUALS mary AND dog.name EQUALS mary )  AND  ( name EQUALS miry AND dog.name EQUALS miry )  ) ", tqb.getConditionsString()
View Full Code Here
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
  @Test
  public void conditionNestedOr() {
    MockQueryBuilder tqb = new MockQueryBuilder();
    SelectQuery<Person> oq = new GenericSelectQuery<Person, Object>(tqb, Person.class);
    Person pers = oq.target();
    QueryCondition cond = oq.or();
    QueryCondition and1 = cond.or();
    and1.eq(pers.getName(), "mary");
    and1.eq(pers.getDog().getName(), "mary");
    QueryCondition and2 = cond.or();
    and2.eq(pers.getName(), "miry");
    and2.eq(pers.getDog().getName(), "miry");

    tqb.build();

    assertEquals(1, tqb.getConditionsString().size());
    assertEquals(" (  ( name EQUALS mary OR dog.name EQUALS mary )  OR  ( name EQUALS miry OR dog.name EQUALS miry )  ) ", tqb.getConditionsString().get(0));
View Full Code Here
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
  @Test
  public void conditionNestedMixed() {
    MockQueryBuilder tqb = new MockQueryBuilder();
    SelectQuery<Person> oq = new GenericSelectQuery<Person, Object>(tqb, Person.class);
    Person pers = oq.target();
    QueryCondition cond = oq.or();
    QueryCondition and1 = cond.and();
    and1.eq(pers.getName(), "mary");
    and1.eq(pers.getDog().getName(), "mary");
    QueryCondition and2 = cond.and();
    and2.eq(pers.getName(), "miry");
    and2.eq(pers.getDog().getName(), "miry");

    tqb.build();

    assertEquals(1, tqb.getConditionsString().size());
    assertEquals(" (  ( name EQUALS mary AND dog.name EQUALS mary )  OR  ( name EQUALS miry AND dog.name EQUALS miry )  ) ",
View Full Code Here
88
89
90
91
92
93
94
95
96
97
98
99
100
101
  @Test
  public void conditionPlainOr() {
    MockQueryBuilder tqb = new MockQueryBuilder();
    SelectQuery<Person> oq = new GenericSelectQuery<Person, Object>(tqb, Person.class);
    Person pers = oq.target();
    QueryCondition cond = oq.or();
    cond.eq(pers.getName(), "mary");
    cond.eq(pers.getDog().getName(), "mary");
    tqb.build();

    assertEquals(1, tqb.getConditionsString().size());
    assertEquals(" ( name EQUALS mary OR dog.name EQUALS mary ) ", tqb.getConditionsString().get(0));
View Full Code Here
TOP

Related Classes of org.objectquery.generic.domain.Person

  • org.objectquery.generic.TestGenericQuery
  • org.objectquery.generic.TestGroupCondition
  • org.objectquery.generic.TestInsertQuery
  • org.objectquery.generic.TestJoin
  • org.objectquery.generic.TestQueryCondition
  • org.objectquery.generic.TestQueryHaving
  • org.objectquery.generic.TestQueryOrder
  • org.objectquery.generic.TestQueryProjection
  • org.objectquery.generic.TestRequiredSpeed
  • org.objectquery.generic.TestSubQuery
    • 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.