Search in sources :

Example 46 with Query

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

the class TimeCapsuleQueryBuilder method getQuery.

public Query getQuery(long start, long end, boolean orderByAscending) {
    Logger.debug("peroid: start(%s), end(%s), orderByAscending(%s)", CalendarUtils.timeToReadableString(start), CalendarUtils.timeToReadableString(end), orderByAscending);
    Query query = getQuery();
    if (query != null) {
        if (start < end) {
            ExpressionToken selection = TimeCapsule.COLUMN_TIME.gte(start).and(TimeCapsule.COLUMN_TIME.lte(end));
            if (selection != null) {
                query.setSelection(selection);
            }
        }
        OrderingToken orderBy = (orderByAscending ? TimeCapsule.COLUMN_TIME.orderByAscending() : TimeCapsule.COLUMN_TIME.orderByDescending());
        if (orderBy != null) {
            query.setOrderBy(orderBy);
        }
    }
    return query;
}
Also used : Query(com.dailystudio.dataobject.query.Query) OrderingToken(com.dailystudio.dataobject.query.OrderingToken) ExpressionToken(com.dailystudio.dataobject.query.ExpressionToken)

Aggregations

Query (com.dailystudio.dataobject.query.Query)46 DatabaseObject (com.dailystudio.dataobject.DatabaseObject)38 ExpressionToken (com.dailystudio.dataobject.query.ExpressionToken)28 QueryObject (com.dailystudio.dataobject.samples.QueryObject)18 Cursor (android.database.Cursor)17 SQLiteDatabase (android.database.sqlite.SQLiteDatabase)17 Column (com.dailystudio.dataobject.Column)15 Template (com.dailystudio.dataobject.Template)15 SampleObject1 (com.dailystudio.dataobject.samples.SampleObject1)12 SampleObject2 (com.dailystudio.dataobject.samples.SampleObject2)12 OrderingToken (com.dailystudio.dataobject.query.OrderingToken)9 DatabaseConnectivity (com.dailystudio.dataobject.database.DatabaseConnectivity)5 SQLException (android.database.SQLException)3 DynamicColumnsObject (com.dailystudio.dataobject.samples.DynamicColumnsObject)2 ProjectionObject (com.dailystudio.dataobject.samples.ProjectionObject)2 ContentResolver (android.content.ContentResolver)1 Uri (android.net.Uri)1 List (java.util.List)1