Examples of com.googlecode.gql4j.GqlQuery.Where

com.googlecode.gql4j.GqlQuery.Where

  
  @Test
  public void testParseWhere_1() {
    ParseResult actual = GqlQuery.parse("SELECT * from a where a = 1");
    ParseResult expected = new ParseResult().setSelect(new Select(false)).setFrom(new From("a")).setWhere(
        new Where().withCondition(new Condition("a", FilterOperator.EQUAL, new DecimalEvaluator("1"))));
    assertEquals(expected, actual);
  }

View Full Code Here

  
  @Test
  public void testParseWhere_2() {
    ParseResult actual = GqlQuery.parse("SELECT * from a where a = 1 and b <= '3'");
    ParseResult expected = new ParseResult().setSelect(new Select(false)).setFrom(new From("a")).setWhere(
        new Where().withCondition(new Condition("a", FilterOperator.EQUAL, new DecimalEvaluator("1")))
        .withCondition(new Condition("b", FilterOperator.LESS_THAN_OR_EQUAL, new StringEvaluator("'3'")))
        );
    assertEquals(expected, actual);
  }

View Full Code Here

  
  @Test
  public void testParseWhere_3() {
    ParseResult actual = GqlQuery.parse("SELECT * from a where a = :1");
    ParseResult expected = new ParseResult().setSelect(new Select(false)).setFrom(new From("a")).setWhere(
        new Where().withCondition(new Condition("a", FilterOperator.EQUAL, new ParamEvaluator("1"))));
    assertEquals(expected, actual);
  }

View Full Code Here

  
  @Test
  public void testParseWhere_4() {
    ParseResult actual = GqlQuery.parse("SELECT * from a where a = :abc");
    ParseResult expected = new ParseResult().setSelect(new Select(false)).setFrom(new From("a")).setWhere(
        new Where().withCondition(new Condition("a", FilterOperator.EQUAL, new ParamEvaluator("abc"))));
    assertEquals(expected, actual);
  }

View Full Code Here

  
  @Test
  public void testParseWhere_5() {
    ParseResult actual = GqlQuery.parse("SELECT * from a where a in (:abc, 'b', 'c')");
    ParseResult expected = new ParseResult().setSelect(new Select(false)).setFrom(new From("a")).setWhere(
        new Where().withCondition(new Condition("a", FilterOperator.IN, 
            new ListEvaluator(new ParamEvaluator("abc"), new StringEvaluator("'b'"), new StringEvaluator("'c'")))));
    assertEquals(expected, actual);
  }

View Full Code Here

  
  @Test
  public void testParseWhere_6() {
    ParseResult actual = GqlQuery.parse("SELECT * from a WHERE ANCESTOR IS KEY('Person', 'Amy')");
    ParseResult expected = new ParseResult().setSelect(new Select(false)).setFrom(new From("a")).setWhere(
        new Where().withAncestor(
            new FunctionEvaluator("key", new StringEvaluator("'Person'"), new StringEvaluator("'Amy'"))));
    assertEquals(expected, actual);
  }

View Full Code Here

TOP

Related Classes of com.googlecode.gql4j.GqlQuery.Where

com.googlecode.gql4j.GqlQueryTest

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.