Search in sources :

Example 71 with Column

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

the class TextColumnTest method testParseValueFrom.

public void testParseValueFrom() {
    Column columnA = new TextColumn("columnA");
    assertNotNull(columnA);
    Column columnB = new TextColumn("columnB");
    assertNotNull(columnB);
    SimpleStringCursor c = new SimpleStringCursor();
    c.putColumnValue(columnA.getName(), "Sample Text 1");
    c.putColumnValue(columnB.getName(), "Hello world!");
    ContentValues values = new ContentValues();
    assertNotNull(values);
    columnA.parseValueFrom(c, values);
    columnB.parseValueFrom(c, values);
    String actual = null;
    actual = values.getAsString(columnA.getName());
    assertEquals("Sample Text 1", actual);
    actual = values.getAsString(columnB.getName());
    assertEquals("Hello world!", actual);
}
Also used : ContentValues(android.content.ContentValues) Column(com.dailystudio.dataobject.Column)

Example 72 with Column

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

the class TimeColumnTest method testTimeColumns.

public void testTimeColumns() {
    TimeColumn source = new TimeColumn("time");
    assertNotNull(source);
    Column column = null;
    String expected = null;
    column = source.HOUR();
    expected = "CAST ( strftime('%H', (time / 1000), 'unixepoch', 'localtime') AS INTEGER )";
    assertNotNull(column);
    assertTrue((column instanceof IntegerColumn));
    assertEquals(expected, column.getName());
    column = source.MINUTE();
    expected = "CAST ( strftime('%M', (time / 1000), 'unixepoch', 'localtime') AS INTEGER )";
    assertNotNull(column);
    assertTrue((column instanceof IntegerColumn));
    assertEquals(expected, column.getName());
    column = source.SECOND();
    expected = "CAST ( strftime('%S', (time / 1000), 'unixepoch', 'localtime') AS INTEGER )";
    assertNotNull(column);
    assertTrue((column instanceof IntegerColumn));
    assertEquals(expected, column.getName());
    column = source.DAY();
    expected = "CAST ( strftime('%d', (time / 1000), 'unixepoch', 'localtime') AS INTEGER )";
    assertNotNull(column);
    assertTrue((column instanceof IntegerColumn));
    assertEquals(expected, column.getName());
    column = source.WEEKDAY();
    expected = "CAST ( strftime('%w', (time / 1000), 'unixepoch', 'localtime') AS INTEGER )";
    assertNotNull(column);
    assertTrue((column instanceof IntegerColumn));
    assertEquals(expected, column.getName());
    column = source.MONTH();
    expected = "CAST ( strftime('%m', (time / 1000), 'unixepoch', 'localtime') AS INTEGER )";
    assertNotNull(column);
    assertTrue((column instanceof IntegerColumn));
    assertEquals(expected, column.getName());
    column = source.YEAR();
    expected = "CAST ( strftime('%Y', (time / 1000), 'unixepoch', 'localtime') AS INTEGER )";
    assertNotNull(column);
    assertTrue((column instanceof IntegerColumn));
    assertEquals(expected, column.getName());
}
Also used : Column(com.dailystudio.dataobject.Column)

Example 73 with Column

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

the class TimeColumnTest method testConvertValueToString.

public void testConvertValueToString() {
    Column column = new TimeColumn("column");
    assertNotNull(column);
    String expected = null;
    String actual = null;
    expected = "987654321012345678";
    actual = column.convertValueToString(987654321012345678l);
    assertEquals(expected, actual);
    expected = "-1234567654321";
    actual = column.convertValueToString(-1234567654321l);
    assertEquals(expected, actual);
}
Also used : Column(com.dailystudio.dataobject.Column)

Example 74 with Column

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

the class TimeColumnTest method testSetValue.

public void testSetValue() {
    Column column = null;
    column = new TimeColumn("columnA");
    assertNotNull(column);
    ContentValues values = new ContentValues();
    column.setValue(values, 987654321012345678l);
    assertEquals(Long.valueOf(987654321012345678l), values.getAsLong("columnA"));
    column.setValue(values, -12345678l);
    assertEquals(Long.valueOf(-12345678l), values.getAsLong("columnA"));
    boolean exceptionCacthed = false;
    try {
        column.setValue(values, 123);
        exceptionCacthed = false;
    } catch (ClassCastException e) {
        exceptionCacthed = true;
    }
    assertEquals(true, exceptionCacthed);
    try {
        column.setValue(values, 3.1415);
        exceptionCacthed = false;
    } catch (ClassCastException e) {
        exceptionCacthed = true;
    }
    assertEquals(true, exceptionCacthed);
}
Also used : ContentValues(android.content.ContentValues) Column(com.dailystudio.dataobject.Column)

Example 75 with Column

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

the class TimeColumnTest method testMatchValueType.

public void testMatchValueType() {
    Column column = null;
    column = new TimeColumn("columnA");
    assertNotNull(column);
    assertEquals(true, column.matchColumnType(987654321012345678l));
    assertEquals(true, column.matchColumnType(-12345678l));
    assertEquals(false, column.matchColumnType(-2012));
    assertEquals(false, column.matchColumnType(3.1415));
    assertEquals(false, column.matchColumnType("String"));
}
Also used : Column(com.dailystudio.dataobject.Column)

Aggregations

Column (com.dailystudio.dataobject.Column)81 ContentValues (android.content.ContentValues)28 Template (com.dailystudio.dataobject.Template)26 DatabaseObject (com.dailystudio.dataobject.DatabaseObject)19 QueryObject (com.dailystudio.dataobject.samples.QueryObject)19 ExpressionToken (com.dailystudio.dataobject.query.ExpressionToken)15 Query (com.dailystudio.dataobject.query.Query)15 OrderingToken (com.dailystudio.dataobject.query.OrderingToken)8 Intent (android.content.Intent)6 Cursor (android.database.Cursor)6 IntegerColumn (com.dailystudio.dataobject.IntegerColumn)6 ContentResolver (android.content.ContentResolver)4 Uri (android.net.Uri)4 DoubleColumn (com.dailystudio.dataobject.DoubleColumn)3 TextColumn (com.dailystudio.dataobject.TextColumn)3 QueryToken (com.dailystudio.dataobject.query.QueryToken)3 ProjectionObject (com.dailystudio.dataobject.samples.ProjectionObject)3 TestDatabaseObject (com.dailystudio.dataobject.samples.TestDatabaseObject)3 ArrayList (java.util.ArrayList)2 LongColumn (com.dailystudio.dataobject.LongColumn)1