mobi.liason.mvvm.task.TaskStateTable Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of task Show documentation
Task library
The newest version!
package mobi.liason.mvvm.task;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.net.Uri;

import com.google.common.collect.Lists;

import java.util.Arrays;
import java.util.List;

import mobi.liason.loaders.Path;
import mobi.liason.mvvm.database.Column;
import mobi.liason.mvvm.database.Model;
import mobi.liason.mvvm.database.ModelColumn;
import mobi.liason.loaders.UriUtilities;
import mobi.liason.mvvm.database.annotations.ColumnDefinition;
import mobi.liason.mvvm.database.annotations.ColumnDefinitions;
import mobi.liason.mvvm.database.annotations.PathDefinition;
import mobi.liason.mvvm.database.annotations.PathDefinitions;

/**
 * Created by Emir Hasanbegovic on 12/05/14.
 */
public class TaskStateTable extends Model {

    public static final String TABLE_NAME = "TasksStateTable";

    public static ContentValues getContentValues(final TaskState taskState) {
        final ContentValues contentValues = new ContentValues();
        contentValues.put(Columns.URI.getName(), taskState.getUri());
        contentValues.put(Columns.STATE.getName(), taskState.getState());
        contentValues.put(Columns.TIME.getName(), taskState.getTime());
        final byte[] jsonObjectByteArray = taskState.getJsonByteArray();
        if (jsonObjectByteArray != null){
            contentValues.put(Columns.JSON.getName(), jsonObjectByteArray);
        }
        return contentValues;
    }

    @Override
    public String getName(final Context context) {
        return TABLE_NAME;
    }

    @Override
    public Cursor query(Context context, SQLiteDatabase sqLiteDatabase, Path path, Uri uri, String[] projection, String selection, String[] selectionArgs, String sortOrder) {
        final String uriString = uri.getLastPathSegment();

        final String[] overridenProjection = {Columns.TIME.getName()};
        final String overridenSelection = Columns.URI.getName() + "=?";
        final String[] overridenSelectionArguments = {uriString};

        return super.query(context, sqLiteDatabase, path, uri, overridenProjection, overridenSelection, overridenSelectionArguments, null);
    }

    @Override
    public Uri insert(Context context, SQLiteDatabase sqLiteDatabase, Path path, Uri uri, ContentValues contentValues) {
        final String uriString = uri.getLastPathSegment();
        sqLiteDatabase.beginTransaction();
        try {
            final String selection = Columns.URI.getName() + "=? AND " + Columns.STATE.getName() + "<>?";
            final String[] selectionArguments = { uriString , State.RUNNING};

            final int rows = sqLiteDatabase.update(TaskStateTable.TABLE_NAME, contentValues, selection, selectionArguments);
            if (rows == 0) {
                final String queryWhereClause = Columns.URI.getName() + "=? AND " + Columns.STATE.getName() + "=?";
                final String[] queryWhereArguments = new String[]{uriString, State.RUNNING};
                final Cursor cursor = sqLiteDatabase.query(TaskStateTable.TABLE_NAME, null, queryWhereClause, queryWhereArguments, null, null, null);
                try {
                    if (cursor.getCount() != 0) {
                        return null;
                    }
                } finally {
                    cursor.close();
                }
                sqLiteDatabase.insert(TaskStateTable.TABLE_NAME, null, contentValues);
            }
            sqLiteDatabase.setTransactionSuccessful();
        } finally {
            sqLiteDatabase.endTransaction();
        }
        final String scheme = uri.getScheme();
        final String authority = uri.getAuthority();
        return UriUtilities.getUri(scheme, authority, Paths.TASK_STATE, uriString);
    }

    public static final class State {
        public static final String RUNNING = "running";
        public static final String SUCCESS = "success";
        public static final String FAIL = "fail";
    }

    @ColumnDefinitions
    public static class Columns {
        @ColumnDefinition
        public static final ModelColumn URI = new ModelColumn(TABLE_NAME, TaskState.Fields.URI, ModelColumn.Type.text);
        @ColumnDefinition
        public static final ModelColumn STATE = new ModelColumn(TABLE_NAME, TaskState.Fields.STATE, ModelColumn.Type.text);
        @ColumnDefinition
        public static final ModelColumn TIME = new ModelColumn(TABLE_NAME, TaskState.Fields.TIME, ModelColumn.Type.integer);
        @ColumnDefinition
        public static final ModelColumn JSON = new ModelColumn(TABLE_NAME, TaskState.Fields.JSON, ModelColumn.Type.blob);
    }

    @PathDefinitions
    public static class Paths {
        @PathDefinition
        public static final Path TASK_STATE = new Path(TABLE_NAME, "*");
    }

}