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

Example 1 with QueryToken

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

the class TextColumnTest method testLikeOperator.

public void testLikeOperator() {
    TextColumn column = null;
    column = new TextColumn("textVal");
    assertNotNull(column);
    assertEquals(new QueryToken("textVal LIKE \'%abc%\'"), column.like("%abc%"));
    column = new TextColumn("textVal");
    assertNotNull(column);
    assertEquals(new QueryToken(), column.eq(1000));
}

Example 2 with QueryToken

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

the class ColumnTest method testOUTOFOperator.

public void testOUTOFOperator() {
    Column column = null;
    column = new IntegerColumn("intVal");
    assertNotNull(column);
    assertEquals(new QueryToken("( intVal < 1000 ) OR ( intVal > 2000 )"), column.outOf(1000, 2000));
    column = new LongColumn("longVal");
    assertNotNull(column);
    assertEquals(new QueryToken("( longVal < 12345678987654321 ) OR ( longVal > 987654321012345678 )"), column.outOf(12345678987654321l, 987654321012345678l));
    column = new DoubleColumn("doubleVal");
    assertNotNull(column);
    assertEquals(new QueryToken("( doubleVal < 1.4142135 ) OR ( doubleVal > 3.141592653 )"), column.outOf(1.4142135, 3.141592653));
    column = new TextColumn("textVal");
    assertNotNull(column);
    assertEquals(new QueryToken("( textVal < \'ABC\' ) OR ( textVal > \'DEF\' )"), column.outOf("ABC", "DEF"));
    column = new TextColumn("textVal");
    assertNotNull(column);
    assertEquals(new QueryToken(), column.outOf(1000, 2000));
}

Example 3 with QueryToken

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

the class ColumnTest method testINValuesOperator.

public void testINValuesOperator() {
    Column column = null;
    column = new IntegerColumn("intVal");
    assertNotNull(column);
    assertEquals(new QueryToken("intVal IN ( 1000, 2000, 3000 )"), column.inValues(new Integer[] { 1000, 2000, 3000 }));
    column = new LongColumn("longVal");
    assertNotNull(column);
    assertEquals(new QueryToken("longVal IN ( 12345678987654321, 987654321012345678, 1111111111 )"), column.inValues(new Long[] { 12345678987654321l, 987654321012345678l, 1111111111l }));
    column = new DoubleColumn("doubleVal");
    assertNotNull(column);
    assertEquals(new QueryToken("doubleVal IN ( 1.4142135, 3.141592653, 1.732 )"), column.inValues(new Double[] { 1.4142135, 3.141592653, 1.732 }));
    column = new TextColumn("textVal");
    assertNotNull(column);
    assertEquals(new QueryToken("textVal IN ( \'ABC\', \'DEF\', \'GHI\', \'JKL\', \'MNO\', \'PQR\', \'STU\', \'VWX\', \'YZ\' )"), column.inValues(new String[] { "ABC", "DEF", "GHI", "JKL", "MNO", "PQR", "STU", "VWX", "YZ" }));
    column = new TextColumn("textVal");
    assertNotNull(column);
    assertEquals(new QueryToken(), column.inValues(new Integer[] { 1000, 2000, 3000 }));
}

Example 4 with QueryToken

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

the class ColumnTest method testOUTOFValuesOperator.

public void testOUTOFValuesOperator() {
    Column column = null;
    column = new IntegerColumn("intVal");
    assertNotNull(column);
    assertEquals(new QueryToken("intVal NOT IN ( 1000, 2000, 3000 )"), column.outOfValues(new Integer[] { 1000, 2000, 3000 }));
    column = new LongColumn("longVal");
    assertNotNull(column);
    assertEquals(new QueryToken("longVal NOT IN ( 12345678987654321, 987654321012345678, 1111111111 )"), column.outOfValues(new Long[] { 12345678987654321l, 987654321012345678l, 1111111111l }));
    column = new DoubleColumn("doubleVal");
    assertNotNull(column);
    assertEquals(new QueryToken("doubleVal NOT IN ( 1.4142135, 3.141592653, 1.732 )"), column.outOfValues(new Double[] { 1.4142135, 3.141592653, 1.732 }));
    column = new TextColumn("textVal");
    assertNotNull(column);
    assertEquals(new QueryToken("textVal NOT IN ( \'ABC\', \'DEF\', \'GHI\', \'JKL\', \'MNO\', \'PQR\', \'STU\', \'VWX\', \'YZ\' )"), column.outOfValues(new String[] { "ABC", "DEF", "GHI", "JKL", "MNO", "PQR", "STU", "VWX", "YZ" }));
    column = new TextColumn("textVal");
    assertNotNull(column);
    assertEquals(new QueryToken(), column.outOfValues(new Integer[] { 1000, 2000, 3000 }));
}

Example 5 with QueryToken

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

the class ColumnTest method testPLUSOperator.

public void testPLUSOperator() {
    Column column1 = null;
    Column column2 = null;
    column1 = new IntegerColumn("intVal1");
    assertNotNull(column1);
    column2 = new IntegerColumn("intVal2");
    assertNotNull(column2);
    assertEquals(new QueryToken("( ( intVal1 ) + ( intVal2 ) )"), column1.plus(column2));
    assertEquals(new QueryToken("( ( intVal2 ) + ( intVal1 ) )"), column2.plus(column1));
    column1 = new LongColumn("longVal1");
    assertNotNull(column1);
    column2 = new LongColumn("longVal2");
    assertNotNull(column2);
    assertEquals(new QueryToken("( ( longVal1 ) + ( longVal2 ) )"), column1.plus(column2));
    assertEquals(new QueryToken("( ( longVal2 ) + ( longVal1 ) )"), column2.plus(column1));
    column1 = new DoubleColumn("dbVal1");
    assertNotNull(column1);
    column2 = new DoubleColumn("dbVal2");
    assertNotNull(column2);
    assertEquals(new QueryToken("( ( dbVal1 ) + ( dbVal2 ) )"), column1.plus(column2));
    assertEquals(new QueryToken("( ( dbVal2 ) + ( dbVal1 ) )"), column2.plus(column1));
    column1 = new TextColumn("textVal1");
    assertNotNull(column1);
    column2 = new TextColumn("textVal2");
    assertNotNull(column2);
    assertEquals(new QueryToken("( ( textVal1 ) + ( textVal2 ) )"), column1.plus(column2));
    assertEquals(new QueryToken("( ( textVal2 ) + ( textVal1 ) )"), column2.plus(column1));
    column1 = new TimeColumn("timeVal1");
    assertNotNull(column1);
    column2 = new TimeColumn("timeVal2");
    assertNotNull(column2);
    assertEquals(new QueryToken("( ( timeVal1 ) + ( timeVal2 ) )"), column1.plus(column2));
    assertEquals(new QueryToken("( ( timeVal2 ) + ( timeVal1 ) )"), column2.plus(column1));
    column1 = new TextColumn("textVal1");
    assertNotNull(column1);
    column2 = new DoubleColumn("dbVal2");
    assertNotNull(column2);
    assertEquals(new QueryToken("( ( textVal1 ) + ( dbVal2 ) )"), column1.plus(column2));
    assertEquals(new QueryToken("( ( dbVal2 ) + ( textVal1 ) )"), column2.plus(column1));
}