Examples of org.odbms.Query.constrain()

org.odbms.Query.constrain()
adds a constraint to this node.
If the object parameter is deeper than the entire query graph, the query graph is extended accordingly. @param example object for comparison @return Constraint

    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");


    ObjectSet<Disc> discs = q1.OR(q2);


    Util.printObjectSet(discs);

View Full Code Here

    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");


    ObjectSet<Disc> discs = q1.OR(q2);


    Util.printObjectSet(discs);

View Full Code Here

  /**
   * 
   */
  public POQQuery1AND() {
    Query q1 = gtm.query(Disc.class);
    q1.constrain("DTITLE", OP.STARTS_WITH, FUNCTION.TO_UPPER, "ERIC CLAPTON");
    q1.constrain("DYEAR", OP.RANGE, 1990, 1999);


    Query q2 = gtm.query(Disc.class);
    q2.constrain("DGENRE", OP.EQUALS, FUNCTION.TO_UPPER, "Blues");
    q2.constrain("DTITLE", OP.CONTAINS, FUNCTION.TO_UPPER, "Live");

View Full Code Here

   * 
   */
  public POQQuery1AND() {
    Query q1 = gtm.query(Disc.class);
    q1.constrain("DTITLE", OP.STARTS_WITH, FUNCTION.TO_UPPER, "ERIC CLAPTON");
    q1.constrain("DYEAR", OP.RANGE, 1990, 1999);


    Query q2 = gtm.query(Disc.class);
    q2.constrain("DGENRE", OP.EQUALS, FUNCTION.TO_UPPER, "Blues");
    q2.constrain("DTITLE", OP.CONTAINS, FUNCTION.TO_UPPER, "Live");

View Full Code Here

    Query q1 = gtm.query(Disc.class);
    q1.constrain("DTITLE", OP.STARTS_WITH, FUNCTION.TO_UPPER, "ERIC CLAPTON");
    q1.constrain("DYEAR", OP.RANGE, 1990, 1999);


    Query q2 = gtm.query(Disc.class);
    q2.constrain("DGENRE", OP.EQUALS, FUNCTION.TO_UPPER, "Blues");
    q2.constrain("DTITLE", OP.CONTAINS, FUNCTION.TO_UPPER, "Live");


    ObjectSet<Disc> discs = q1.AND(q2);


    Util.printObjectSet(discs);

View Full Code Here

    q1.constrain("DTITLE", OP.STARTS_WITH, FUNCTION.TO_UPPER, "ERIC CLAPTON");
    q1.constrain("DYEAR", OP.RANGE, 1990, 1999);


    Query q2 = gtm.query(Disc.class);
    q2.constrain("DGENRE", OP.EQUALS, FUNCTION.TO_UPPER, "Blues");
    q2.constrain("DTITLE", OP.CONTAINS, FUNCTION.TO_UPPER, "Live");


    ObjectSet<Disc> discs = q1.AND(q2);


    Util.printObjectSet(discs);

View Full Code Here

  public POQQuery1(String searchFor) {
    if (searchFor == null)
      throw new IllegalArgumentException("Parameter 'searchFor' must not be null");


    Query q1 = gtm.query(Disc.class);
    q1.constrain("DGENRE", OP.EQUALS, FUNCTION.TO_UPPER, "Jazz");
    q1.constrain("DTITLE", OP.CONTAINS, FUNCTION.TO_UPPER, searchFor);
    q1.constrain("DYEAR", OP.GREATER, 1999);
    q1.sortBy("DYEAR");
    ObjectSet<Disc> discs = q1.execute();

View Full Code Here

    if (searchFor == null)
      throw new IllegalArgumentException("Parameter 'searchFor' must not be null");


    Query q1 = gtm.query(Disc.class);
    q1.constrain("DGENRE", OP.EQUALS, FUNCTION.TO_UPPER, "Jazz");
    q1.constrain("DTITLE", OP.CONTAINS, FUNCTION.TO_UPPER, searchFor);
    q1.constrain("DYEAR", OP.GREATER, 1999);
    q1.sortBy("DYEAR");
    ObjectSet<Disc> discs = q1.execute();


    Util.printObjectSet(discs);

View Full Code Here

      throw new IllegalArgumentException("Parameter 'searchFor' must not be null");


    Query q1 = gtm.query(Disc.class);
    q1.constrain("DGENRE", OP.EQUALS, FUNCTION.TO_UPPER, "Jazz");
    q1.constrain("DTITLE", OP.CONTAINS, FUNCTION.TO_UPPER, searchFor);
    q1.constrain("DYEAR", OP.GREATER, 1999);
    q1.sortBy("DYEAR");
    ObjectSet<Disc> discs = q1.execute();


    Util.printObjectSet(discs);
    q1.printConstraintInfo();

View Full Code Here


    System.out.println("-----------------------------------------");


    // 2. query with Iterator
    Query q2 = gtm.query(Disc.class);
    q2.constrain("DTITLE", OP.STARTS_WITH, FUNCTION.TO_UPPER, searchFor);
    q2.constrain("DTITLE", OP.CONTAINS, FUNCTION.TO_UPPER, "live");
    q2.constrain("DYEAR", OP.RANGE, 2000, 2002);
    q2.constrain("DGENRE", OP.EQUALS, FUNCTION.TO_UPPER, "BLUES");
    discs = q2.execute();

View Full Code Here

0 1 2 3

TOP

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.