Examples with QueryToken com.dailystudio.dataobject.query.QueryToken used on opensource projects

Example 11 with QueryToken

use of com.dailystudio.dataobject.query.QueryToken in project devbricks by dailystudio.

the class ColumnTest method testIsNull.

public void testIsNull() {
    Column column = null;
    column = new IntegerColumn("intVal");
    assertNotNull(column);
    assertEquals(new QueryToken("intVal ISNULL"), column.isNull());
    column = new LongColumn("longVal");
    assertNotNull(column);
    assertEquals(new QueryToken("longVal ISNULL"), column.isNull());
    column = new DoubleColumn("doubleVal");
    assertNotNull(column);
    assertEquals(new QueryToken("doubleVal ISNULL"), column.isNull());
    column = new TextColumn("textVal");
    assertNotNull(column);
    assertEquals(new QueryToken("textVal ISNULL"), column.isNull());
}

Example 12 with QueryToken

use of com.dailystudio.dataobject.query.QueryToken in project devbricks by dailystudio.

the class ExpressionTokenTest method testMinusOperation.

public void testMinusOperation() {
    ExpressionToken token1 = null;
    ExpressionToken token2 = null;
    ExpressionToken token = null;
    token1 = new ExpressionToken("abc");
    assertNotNull(token1);
    token2 = new ExpressionToken("def");
    assertNotNull(token2);
    token = token1.minus(token2);
    assertEquals(new QueryToken("( ( abc ) - ( def ) )"), token);
}

Example 13 with QueryToken

use of com.dailystudio.dataobject.query.QueryToken in project devbricks by dailystudio.

the class ExpressionTokenTest method testCreateExpressionToken.

public void testCreateExpressionToken() {
    ExpressionToken token = null;
    token = new ExpressionToken(1234);
    assertEquals(new QueryToken("1234"), token);
    token = new ExpressionToken(3.1415);
    assertEquals(new QueryToken("3.1415"), token);
    token = new ExpressionToken("a < 10");
    assertEquals(new QueryToken("a < 10"), token);
}

Example 14 with QueryToken

use of com.dailystudio.dataobject.query.QueryToken in project devbricks by dailystudio.

the class ExpressionTokenTest method testAndOperation.

public void testAndOperation() {
    Column column = null;
    column = new IntegerColumn("intVal");
    assertNotNull(column);
    ExpressionToken token = null;
    token = column.gt(1000);
    assertEquals(new QueryToken("intVal > 1000"), token);
    token.and(column.lt(2000));
    assertEquals(new QueryToken("( intVal > 1000 ) AND ( intVal < 2000 )"), token);
}

Example 15 with QueryToken

use of com.dailystudio.dataobject.query.QueryToken in project devbricks by dailystudio.

the class OrderingTokenTest method testWithOperation.

public void testWithOperation() {
    Column column1 = null;
    column1 = new IntegerColumn("intVal");
    assertNotNull(column1);
    Column column2 = null;
    column2 = new DoubleColumn("doubleVal");
    assertNotNull(column2);
    Column column3 = null;
    column3 = new LongColumn("longVal");
    assertNotNull(column3);
    Column column4 = null;
    column4 = new TextColumn("textVal");
    assertNotNull(column4);
    assertEquals(new QueryToken("intVal, doubleVal, longVal, textVal"), column1.groupBy().with(column2.groupBy()).with(column3.groupBy()).with(column4.groupBy()));
}