Package org.odbms

Examples of org.odbms.Query

56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
   */
  public void testDdiscLast3YearsWithSingleInTitle()
  {
    final AtomicInteger cnt = new AtomicInteger();

    Query query = db.query(new Predicate<Disc>() {
      public boolean match(Disc disc)
      {
        if (disc.getAge() <= 3 && disc.getAge() != -1) {
          cnt.incrementAndGet();
          return true;
        } else {
          return false;
        }
      }
    });
    query.constrain("DTITLE", OP.STARTS_WITH, "John");

    ObjectSet<Disc> discs = query.execute();
    for (Disc disc : discs) {
      if (disc.getAge() > 3)
        fail("Disc age >3");
      if (!disc.getDTITLE().startsWith("John"))
        fail("DTITLE does not start with 'John'");
View Full Code Here
90
91
92
93
94
95
96
97
98
99
100
101
102
103
  public void albumYear1969()
  {
    Util.enter("QBE: Album.year=1969");

    Query query = gtm.query(Album.class);
    query.constrain("year", OP.EQUALS, null, "1969");

    ObjectSet<Album> albums = query.execute();
    Util.snapshot();
    for (Album album : albums) {
      System.out.println("Album " + album.getOID() + " " + album.getName() + " " + album.getYear());
    }
    Util.leave(albums.size());
View Full Code Here
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
   */
  public void testDiscLast3YearsStartsWithTHEandAgeLastTenYearsAndEndsWithSingle()
  {
    final AtomicInteger cnt = new AtomicInteger();

    Query query = db.query(new Predicate<Disc>() {
      public boolean match(Disc disc)
      {
        if (disc.getAge() < 10 && disc.getAge() != -1) {
          cnt.incrementAndGet();
          return true;
        } else {
          return false;
        }
      }
    });
    query.constrain("DTITLE", OP.STARTS_WITH, "The");

    ObjectSet<Disc> discs = query.execute();
    for (Disc disc : discs) {
      if (disc.getAge() < 10) {
        cnt.decrementAndGet();
      } else {
        fail("Disc age is greater 10 years");
View Full Code Here
29
30
31
32
33
34
35
36
37
38
39
40
41
   */
  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
61
62
63
64
65
66
67
68
69
70
71
72
73
   * Find all customers with company=CUSTOMER (Customer extends Person)
   */
  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
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
      {
        return o1.getAge().compareTo(o2.getAge());
      }
    };

    Query query = db.query(new Predicate<Disc>() {
      public boolean match(Disc disc)
      {
        int age = disc.getAge();
        boolean valid = (age >= 0 && age <= 3);
        if (valid) {
          cnt.incrementAndGet();
          return true;
        } else {
          return false;
        }
      }
    }, compByAge);

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

    if (cnt.intValue() == 0)
      fail("No rows found");

    int lastAge = -1;
View Full Code Here
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
      {
        return o1.getAge().compareTo(o2.getAge());
      }
    };

    Query query = db.query(new Predicate<Disc>() {
      public boolean match(Disc disc)
      {
        int age = disc.getAge();
        boolean valid = (age >= 0 && age <= 3) && disc.getDTITLE().contains("Band");
        if (valid) {
          cnt.incrementAndGet();
          return true;
        } else {
          return false;
        }
      }
    }, compByAge);
    query.constrain("DTITLE", OP.CONTAINS, "Band");

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

    if (cnt.intValue() == 0)
      fail("No rows found");

    for (Disc disc : discs) {
View Full Code Here
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
   *
   */
  public void testLast3YearsWithJohnInTitle()
  {
    final AtomicInteger cnt = new AtomicInteger();
    Query query = db.query(new Predicate<Disc>() {
      public boolean match(Disc disc)
      {
        int age = disc.getAge();
        boolean valid = (age <= 3 && age != -1);
        if (valid) {
          cnt.incrementAndGet();
          return true;
        } 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();
      boolean valid = (age <= 3 && age != -1) && disc.getDTITLE().startsWith("John");
      if (valid)
View Full Code Here
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
  /**
   *
   */
  public void testAgeOver10StartsWithTHEGenreJazz()
  {
    Query query = db.query(new Predicate<Disc>() {
      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;
      }
    });
    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
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
    });
  }

  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());
    }

    q1.printConstraintInfo();
    db.printCacheStatistics();

  }
View Full Code Here
TOP

Related Classes of org.odbms.Query

  • de.linwave.gtm.query.FileTree
  • de.linwave.gtm.query.NumericTest
  • de.linwave.gtm.query.SimplePOQ
  • de.linwave.gtm.spring.info.QueryInfo
  • de.linwave.junit.constrained.ConstrainedQuerySorted
  • de.linwave.junit.inheritance.InheritanceQuery
  • de.linwave.junit.nativequery.NativeQueryFreeDB
  • de.linwave.junit.nativequery.NativeQueryFreeDBWithIndex
  • de.linwave.junit.nativequery.NativeQueryMusic
  • de.linwave.junit.nativequery.NativeQueryWithComparator
    • 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.