Examples of com.googlecode.gql4j.GqlQuery.From

com.googlecode.gql4j.GqlQuery.From

  }
  
  @Test
  public void testParseFrom_1() {
    ParseResult actual = GqlQuery.parse("SELECT * from a");
    ParseResult expected = new ParseResult().setSelect(new Select(false)).setFrom(new From("a"));
    assertEquals(expected, actual);
  }

View Full Code Here

  }
  
  @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

  }
  
  @Test
  public void testOrderBy_1() {
    ParseResult actual = GqlQuery.parse("SELECT * from a order by a desc");
    ParseResult expected = new ParseResult().setSelect(new Select(false)).setFrom(new From("a")).setOrderBy(
        new OrderBy().withItem(new OrderByItem("a").setDirection(false)));
    assertEquals(expected, actual);
  }

View Full Code Here

  }
  
  @Test
  public void testOrderBy_2() {
    ParseResult actual = GqlQuery.parse("SELECT * from a order by a desc, b, c asc");
    ParseResult expected = new ParseResult().setSelect(new Select(false)).setFrom(new From("a")).setOrderBy(
        new OrderBy().withItem(new OrderByItem("a").setDirection(false))
        .withItem(new OrderByItem("b").setDirection(true))
        .withItem(new OrderByItem("c").setDirection(true)));
    assertEquals(expected, actual);
  }

View Full Code Here

  }
  
  @Test
  public void testLimit_1() {
    ParseResult actual = GqlQuery.parse("SELECT * from a limit 5");
    ParseResult expected = new ParseResult().setSelect(new Select(false)).setFrom(new From("a"
        )).setLimit(new Limit(5));
    assertEquals(expected, actual);
  }

View Full Code Here

0 1

TOP

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

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.