Search in sources :

Example 1 with IntegerColumn

use of com.dailystudio.dataobject.IntegerColumn 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);
}
Also used : IntegerColumn(com.dailystudio.dataobject.IntegerColumn) IntegerColumn(com.dailystudio.dataobject.IntegerColumn) DoubleColumn(com.dailystudio.dataobject.DoubleColumn) TextColumn(com.dailystudio.dataobject.TextColumn) Column(com.dailystudio.dataobject.Column) QueryToken(com.dailystudio.dataobject.query.QueryToken)

Example 2 with IntegerColumn

use of com.dailystudio.dataobject.IntegerColumn 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()));
}
Also used : IntegerColumn(com.dailystudio.dataobject.IntegerColumn) LongColumn(com.dailystudio.dataobject.LongColumn) DoubleColumn(com.dailystudio.dataobject.DoubleColumn) LongColumn(com.dailystudio.dataobject.LongColumn) IntegerColumn(com.dailystudio.dataobject.IntegerColumn) DoubleColumn(com.dailystudio.dataobject.DoubleColumn) TextColumn(com.dailystudio.dataobject.TextColumn) Column(com.dailystudio.dataobject.Column) TextColumn(com.dailystudio.dataobject.TextColumn) QueryToken(com.dailystudio.dataobject.query.QueryToken)

Example 3 with IntegerColumn

use of com.dailystudio.dataobject.IntegerColumn in project devbricks by dailystudio.

the class QueryTokenTest method testCreateQueryToken.

public void testCreateQueryToken() {
    QueryToken token = null;
    token = new QueryToken("1234");
    assertEquals("1234", token.toString());
    token = new QueryToken(new IntegerColumn("intVal"));
    assertEquals("intVal", token.toString());
}
Also used : IntegerColumn(com.dailystudio.dataobject.IntegerColumn) QueryToken(com.dailystudio.dataobject.query.QueryToken)

Example 4 with IntegerColumn

use of com.dailystudio.dataobject.IntegerColumn in project devbricks by dailystudio.

the class ExpressionTokenTest method testOrOperation.

public void testOrOperation() {
    Column column = null;
    column = new IntegerColumn("intVal");
    assertNotNull(column);
    ExpressionToken token = null;
    token = column.lt(1000);
    assertEquals(new QueryToken("intVal < 1000"), token);
    token.or(column.gt(2000));
    assertEquals(new QueryToken("( intVal < 1000 ) OR ( intVal > 2000 )"), token);
}
Also used : IntegerColumn(com.dailystudio.dataobject.IntegerColumn) IntegerColumn(com.dailystudio.dataobject.IntegerColumn) DoubleColumn(com.dailystudio.dataobject.DoubleColumn) TextColumn(com.dailystudio.dataobject.TextColumn) Column(com.dailystudio.dataobject.Column) QueryToken(com.dailystudio.dataobject.query.QueryToken)

Example 5 with IntegerColumn

use of com.dailystudio.dataobject.IntegerColumn in project devbricks by dailystudio.

the class ExpressionTokenTest method testSamples.

public void testSamples() {
    Template templ = new Template();
    assertNotNull(templ);
    templ.addColumn(new IntegerColumn("_id", false, true));
    templ.addColumn(new IntegerColumn("intValue"));
    templ.addColumn(new DoubleColumn("doubleValue"));
    templ.addColumn(new TextColumn("textValue"));
    assertEquals(new QueryToken("( intValue > 1000 ) AND ( intValue < 2000 )"), templ.getColumn("intValue").gt(1000).and(templ.getColumn("intValue").lt(2000)));
}
Also used : IntegerColumn(com.dailystudio.dataobject.IntegerColumn) DoubleColumn(com.dailystudio.dataobject.DoubleColumn) Template(com.dailystudio.dataobject.Template) TextColumn(com.dailystudio.dataobject.TextColumn) QueryToken(com.dailystudio.dataobject.query.QueryToken)

Aggregations

IntegerColumn (com.dailystudio.dataobject.IntegerColumn)9 Column (com.dailystudio.dataobject.Column)6 DoubleColumn (com.dailystudio.dataobject.DoubleColumn)5 TextColumn (com.dailystudio.dataobject.TextColumn)5 QueryToken (com.dailystudio.dataobject.query.QueryToken)5 TestDatabaseObject (com.dailystudio.dataobject.samples.TestDatabaseObject)3 Template (com.dailystudio.dataobject.Template)2 LongColumn (com.dailystudio.dataobject.LongColumn)1