Examples of org.odbms.Query

org.odbms.Query
handle to a query graph and reference to a specific node.

The query graph consists of multiple nodes, each representing a class or a member of a class. The structure can be linked in any way that the class model used allows. A Query object references a single node of this graph.

The graph can be traversed with the functions descendant() and parent() which return references to other nodes of the graph. These two functions will automatically extend the graph, if necessary.

execute() evaluates the entire graph against the objects stored in the data container. execute() can be called from any node of the graph and will create an ObjectSet filled with objects of the object type that the node, it was called from, represents. Objects for all descendant nodes of the caller Query object will be instantiated. Objects of parent nodes will not be visible in the ObjectSet if they are not referenced from the caller Query object.

   */
  public void testDdiscLast3YearsTitleStartWithJohn()
  {
    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

  private static ObjectContainer gtm = GTM.getInstance();


  private void showAlbum()
  {
    try {
      Query query = gtm.query(Album.class);
      query.sortBy("year");


      ObjectSet<Album> items = query.execute();


      int cnt = 0;
      for (Album album : items) {
        System.out.println("  [ALBUM " + album.OID + "] " + album.name + " (" + album.year + ")");
        String albumArtist = "          Artist=";

View Full Code Here

{
  static final ObjectContainer db = GTM.getInstance();


  void query()
  {
    Query q1 = db.query(Info.class);
    ObjectSet<Info> entries = q1.execute();


    int cnt = 0;
    for (Info info : entries) {
      cnt++;
      System.out.println(cnt + " " + info);
    }


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

View Full Code Here


  public void testDiscStartsWithTHEandAgeLastTenYears()
  {
    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");
    query.constrain("DYEAR", OP.GREATER, 1998);


    ObjectSet<Disc> discs = query.execute();
    for (Disc disc : discs) {
      if (disc.getAge() > 10) {
        fail("Disc age is greater 10 years");
      } else {
        cnt.decrementAndGet();

View Full Code Here


  public void allAritsts()
  {
    Util.enter("QBE: ALL Artists");


    Query query = gtm.query(Artist.class);


    ObjectSet<Artist> artists = query.execute();
    Util.snapshot();


    for (Artist artist : artists) {
      System.out.println("Artist = " + artist.getOID() + " " + artist.getName() + " played=" + artist.getPlayed());
    }

View Full Code Here


  public void artistJohnLennon()
  {
    Util.enter("QBE: Artist.name='John Lennon'");


    Query query = gtm.query(Artist.class);
    query.constrain("name", OP.EQUALS, null, "John Lennon");


    ObjectSet<Artist> artists = query.execute();
    Util.snapshot();


    for (Artist artist : artists) {
      System.out.println("Artist = " + artist.getOID() + " " + artist.getName() + " played=" + artist.getPlayed());
    }


    query.printConstraintInfo();
    Util.leave(artists.size());
  }

View Full Code Here

  }


  public void albumYelloSubmarine()
  {
    Util.enter("QBE: Album.name='YELLOW SUBMARINE");
    Query query = gtm.query(Album.class);
    query.constrain("name", OP.EQUALS, FUNCTION.TO_UPPER, "YELLOW SUBMARINE");


    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

  }


  public void albumYelloSubmarine1970()
  {
    Util.enter("QBE: Album.name='YELLOW SUBMARINE AND yeear=1970");
    Query query = gtm.query(Album.class);
    query.constrain("name", OP.EQUALS, FUNCTION.TO_UPPER, "YELLOW SUBMARINE");
    query.constrain("year", OP.EQUALS, null, "1970");


    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


  public void testRows()
  {
    int cnt = 0;


    Query query = db.query(Disc.class);
    ObjectSet<Disc> discs = query.execute();
    for (Disc disc : discs) {
      cnt++;
      if (disc.getDYEAR() == 2008)
        rows_from_2008++;
    }

View Full Code Here

   */
  public void testDiscsFrom2008()
  {
    int cnt = 0;


    Query query = db.query(new Predicate<Disc>() {
      public boolean match(Disc disc)
      {
        return disc.getDYEAR() == 2008;
      }
    });
    ObjectSet<Disc> discs = query.execute();
    for (Disc disc : discs) {
      cnt++;
      if (disc.getDYEAR() != 2008)
        fail("Disc DYEAR != 2008");
    }

View Full Code Here

0 1 2 3

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

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.