Package org.odbms

Examples of org.odbms.Query.constrain()

30
31
32
33
34
35
36
37
38
39
40
  public void testPersonJoeckel()
  {
    int cnt = 0;

    Query query = db.query(Person.class);
    query.constrain("lastName", OP.EQUALS, FUNCTION.TO_UPPER, "joeckel");
    ObjectSet<Person> joeckels = query.execute();
    for (Person p : joeckels) {
      if (!"Lothar".equals(p.getFirstName()) || !"Joeckel".equals(p.getLastName()))
        fail("Invalid data in firstName || lastName");
      cnt++;
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
   */
  public void testCustomerWithName()
  {
    int cnt = 0;
    Query query = db.query(Customer.class);
    query.constrain("companyName", OP.EQUALS, FUNCTION.TO_UPPER, "MI6");
    ObjectSet<Customer> customers = query.execute();
    for (Customer p : customers) {
      if (!"GOLD4712".equals(p.getCustNr()) || !"MI6".equals(p.getCompanyName()))
        fail("Invalid data in custNr || companyName");
      cnt++;
View Full Code Here
85
86
87
88
89
90
91
92
93
94
95
        } else {
          return false;
        }
      }
    }, compByAge);
    query.constrain("DTITLE", OP.CONTAINS, "Band");

    ObjectSet<Disc> discs = query.execute();

    if (cnt.intValue() == 0)
      fail("No rows found");
View Full Code Here
119
120
121
122
123
124
125
126
127
128
129
        } else {
          return false;
        }
      }
    });
    query.constrain("DTITLE", OP.STARTS_WITH, "John");

    ObjectSet<Disc> discs = query.execute();
    int processed = 0;
    for (Disc disc : discs) {
      int age = disc.getAge();
View Full Code Here
147
148
149
150
151
152
153
154
155
156
157
      public boolean match(Disc disc)
      {
        return disc.getAge() > 10;
      }
    });
    query.constrain("DTITLE", OP.STARTS_WITH, "The");

    Query query2 = db.query(new Predicate<Disc>() {
      public boolean match(Disc disc)
      {
        return disc.getAge() > 10;
View Full Code Here
155
156
157
158
159
160
161
162
163
164
165
      public boolean match(Disc disc)
      {
        return disc.getAge() > 10;
      }
    });
    query2.constrain("DGENRE", OP.EQUALS, FUNCTION.TO_UPPER, "JAZZ");

    ObjectSet<Disc> discs = query.AND(query2);

    int processed = 0;
    for (Disc disc : discs) {
View Full Code Here
53
54
55
56
57
58
59
60
61
62
63
  }

  private void query()
  {
    Query q1 = db.query(LogEntry.class);
    q1.constrain("date", OP.GREATER, currentTime);

    ObjectSet<LogEntry> entries = q1.execute();

    for (LogEntry entry : entries) {
      System.out.println(entry + " exists=" + entry.getFile().exists());
View Full Code Here
37
38
39
40
41
42
43
44
45
46
47
  private void query()
  {
    Query q1 = db.query(LogEntry.class);
    // q1.constrain("date", OP.GREATER, currentTime);
    q1.constrain("date", OP.RANGE, e1.getDate().getTime(), e2.getDate().getTime());

    ObjectSet<LogEntry> entries = q1.execute();

    int cnt = 0;
    for (LogEntry entry : entries) {
View Full Code Here
21
22
23
24
25
26
27
28
29
30
31
  /**
   *
   */
  POQQuery1OR() {
    Query q1 = gtm.query(Disc.class);
    q1.constrain("DTITLE", OP.STARTS_WITH, FUNCTION.TO_UPPER, "TINA");
    q1.constrain("DTITLE", OP.CONTAINS, FUNCTION.TO_UPPER, "TURNER");

    Query q2 = gtm.query(Disc.class);
    q2.constrain("DTITLE", OP.STARTS_WITH, FUNCTION.TO_UPPER, "IKE");
    q2.constrain("DTITLE", OP.CONTAINS, FUNCTION.TO_UPPER, "TURNER");
View Full Code Here
22
23
24
25
26
27
28
29
30
31
32
   *
   */
  POQQuery1OR() {
    Query q1 = gtm.query(Disc.class);
    q1.constrain("DTITLE", OP.STARTS_WITH, FUNCTION.TO_UPPER, "TINA");
    q1.constrain("DTITLE", OP.CONTAINS, FUNCTION.TO_UPPER, "TURNER");

    Query q2 = gtm.query(Disc.class);
    q2.constrain("DTITLE", OP.STARTS_WITH, FUNCTION.TO_UPPER, "IKE");
    q2.constrain("DTITLE", OP.CONTAINS, FUNCTION.TO_UPPER, "TURNER");

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.