Package org.objectquery.generic.domain

Examples of org.objectquery.generic.domain.Person

10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
  @Test
  public void testOrders() {
    MockQueryBuilder builder = new MockQueryBuilder();
    SelectQuery<Person> query = new GenericSelectQuery<Person, Object>(builder, Person.class);
    Person toSearch = query.target();

    query.order(toSearch.getDog().getName());
    query.order(toSearch.getDog().getName(), OrderType.ASC);
    query.order(toSearch.getDog().getName(), OrderType.DESC);
    builder.build();

    assertEquals(3, builder.getOrdersString().size());
    assertEquals("dog.name", builder.getOrdersString().get(0));
    assertEquals("dog.name ASC", builder.getOrdersString().get(1));
View Full Code Here
28
29
30
31
32
33
34
35
36
37
38
39
40
41
  @Test
  public void testOrdersProjection() {
    MockQueryBuilder builder = new MockQueryBuilder();
    SelectQuery<Person> query = new GenericSelectQuery<Person, Object>(builder, Person.class);
    Person toSearch = query.target();

    query.order(toSearch.getDog().getName(), ProjectionType.COUNT, OrderType.ASC);
    query.order(toSearch.getDog().getName(), ProjectionType.MAX, OrderType.DESC);
    builder.build();

    assertEquals(2, builder.getOrdersString().size());
    assertEquals("dog.name COUNT ASC", builder.getOrdersString().get(0));
    assertEquals("dog.name MAX DESC", builder.getOrdersString().get(1));
View Full Code Here
26
27
28
29
30
31
32
33
34
35
36
37
38
  @Test
  public void testBackReferenceSubquery() {
    MockQueryBuilder builder = new MockQueryBuilder();
    GenericSelectQuery<Person, Object> query = new GenericSelectQuery<Person, Object>(builder, Person.class);
    Person target = query.target();
    BaseSelectQuery<Person> subQuery = query.subQuery(Person.class);
    subQuery.eq(subQuery.target().getName(), target.getDog().getName());
    query.eq(query.target().getDad(), subQuery);

    builder.build();

    assertEquals(1, builder.getConditions().size());
View Full Code Here
42
43
44
45
46
47
48
49
50
51
52
53
54
55
  @Test
  public void testDoubleSubQuery() {

    MockQueryBuilder builder = new MockQueryBuilder();
    GenericSelectQuery<Person, Object> query = new GenericSelectQuery<Person, Object>(builder, Person.class);
    Person target = query.target();
    BaseSelectQuery<Person> subQuery = query.subQuery(Person.class);
    query.eq(target.getDad(), subQuery);
    subQuery.eq(subQuery.target().getName(), target.getDog().getName());
    BaseSelectQuery<Person> doubSubQuery = subQuery.subQuery(Person.class);
    subQuery.eq(subQuery.target().getMom(), doubSubQuery);

    doubSubQuery.eq(doubSubQuery.target().getMom().getName(), subQuery.target().getMom().getName());
    doubSubQuery.eq(doubSubQuery.target().getMom().getName(), query.target().getMom().getName());
View Full Code Here
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
  @Test
  public void testMultipleReferenceSubquery() {
    MockQueryBuilder builder = new MockQueryBuilder();
    GenericSelectQuery<Person, Object> query = new GenericSelectQuery<Person, Object>(builder, Person.class);
    Person target = query.target();
    BaseSelectQuery<Person> subQuery = query.subQuery(Person.class);
    BaseSelectQuery<Person> subQuery1 = query.subQuery(Person.class);
    query.eq(target.getDad(), subQuery);
    query.eq(target.getMom(), subQuery1);
    builder.build();

    assertEquals(2, builder.getConditions().size());
    assertEquals("A.dad EQUALS select  from Person AA0", builder.getConditionsString().get(0));
    assertEquals("A.mom EQUALS select  from Person AA1", builder.getConditionsString().get(1));
View Full Code Here
11
12
13
14
15
16
17
18
19
20
21
22
  @Test
  public void testSimpleHanving() {
    MockQueryBuilder builder = new MockQueryBuilder();
    SelectQuery<Person> query = new GenericSelectQuery<Person, Object>(builder, Person.class);

    Person target = query.target();
    query.having(target.getName(), ProjectionType.COUNT).eq(2D);
    builder.build();
    assertEquals(1, builder.getHavingString().size());
    assertEquals("name COUNT EQUALS 2.0", builder.getHavingString().get(0));

  }
View Full Code Here
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
  @Test
  public void testAllType() {
    MockQueryBuilder builder = new MockQueryBuilder();
    SelectQuery<Person> query = new GenericSelectQuery<Person, Object>(builder, Person.class);

    Person target = query.target();
    query.having(target.getName(), ProjectionType.COUNT).eq(2D);
    query.having(target.getName(), ProjectionType.MIN).eq(2D);
    query.having(target.getName(), ProjectionType.MAX).eq(2D);
    query.having(target.getName(), ProjectionType.AVG).eq(2D);
    query.having(target.getName(), ProjectionType.SUM).eq(2D);
    builder.build();
    assertEquals(5, builder.getHavingString().size());
    assertEquals("name COUNT EQUALS 2.0", builder.getHavingString().get(0));
    assertEquals("name MIN EQUALS 2.0", builder.getHavingString().get(1));
    assertEquals("name MAX EQUALS 2.0", builder.getHavingString().get(2));
View Full Code Here
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
  @Test
  public void testAllCondition() {
    MockQueryBuilder builder = new MockQueryBuilder();
    SelectQuery<Person> query = new GenericSelectQuery<Person, Object>(builder, Person.class);

    Person target = query.target();
    query.having(target.getName(), ProjectionType.COUNT).eq(2D);
    query.having(target.getName(), ProjectionType.COUNT).notEq(2D);
    query.having(target.getName(), ProjectionType.COUNT).gt(2D);
    query.having(target.getName(), ProjectionType.COUNT).gtEq(2D);
    query.having(target.getName(), ProjectionType.COUNT).lt(2D);
    query.having(target.getName(), ProjectionType.COUNT).ltEq(2D);
    builder.build();
    assertEquals(6, builder.getHavingString().size());
    assertEquals("name COUNT EQUALS 2.0", builder.getHavingString().get(0));
    assertEquals("name COUNT NOT_EQUALS 2.0", builder.getHavingString().get(1));
    assertEquals("name COUNT GREATER 2.0", builder.getHavingString().get(2));
View Full Code Here
15
16
17
18
19
20
21
22
23
24
25
  @Test
  public void testSetSimpleInsert() {
    MockQueryBuilder builder = new MockQueryBuilder();
    GenericInsertQuery<Person> insert = new GenericInsertQuery<Person>(builder, Person.class);
    Person toUp = insert.target();
    insert.set(toUp.getName(), "value");
    builder.build();
    assertEquals(1, builder.getSetsString().size());
    assertEquals("name value", builder.getSetsString().get(0));
  }
View Full Code Here
26
27
28
29
30
31
32
33
34
35
36
  @Test
  public void testSetNestedInsert() {
    MockQueryBuilder builder = new MockQueryBuilder();
    GenericInsertQuery<Person> insert = new GenericInsertQuery<Person>(builder, Person.class);
    Person toUp = insert.target();
    insert.set(toUp.getDad().getName(), "value");
    builder.build();
    assertEquals(1, builder.getSetsString().size());
    assertEquals("dad.name value", builder.getSetsString().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.