zlyh.dmitry.recaller.services.SqlService.java Source code

Introduction

Here is the source code for zlyh.dmitry.recaller.services.SqlService.java

Source

/*
 * Copyright 2016 Dmitriy Zlykh
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 * http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

package zlyh.dmitry.recaller.services;

import android.app.IntentService;
import android.content.ContentValues;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.support.v4.content.LocalBroadcastManager;
import android.util.Log;

import java.util.ArrayList;

import zlyh.dmitry.recaller.Const;
import zlyh.dmitry.recaller.model.RecordModel;
import zlyh.dmitry.recaller.utils.SQLHelper;

public class SqlService extends IntentService {

    public SqlService() {
        super("SqlService");
    }

    @Override
    protected void onHandleIntent(Intent intent) {
        int command = intent.getIntExtra(Const.COMMAND, -1);

        switch (command) {
        case Const.SqlService.LOAD:
            load(intent.getIntExtra(Const.SqlService.LOAD_CHUNK, -1));
            break;
        case Const.SqlService.SAVE:
            save((RecordModel) intent.getParcelableExtra(Const.MODEL));
            break;
        case Const.SqlService.DELETE:
            delete(intent.getIntExtra(Const.MODEL, -1));

        }
    }

    private synchronized void delete(int id) {
        if (id != -1) {
            SQLHelper.getInstance().getWritableDatabase().delete(SQLHelper.TABLE_NAME, SQLHelper.C_ID + " = ?",
                    new String[] { String.valueOf(id) });

            Intent delete_broadcast = new Intent(Const.SqlService.BROADCAST).putExtra(Const.COMMAND,
                    Const.SqlService.DELETE);
            LocalBroadcastManager.getInstance(this).sendBroadcast(delete_broadcast);
        }
    }

    private synchronized void load(int from) {
        if (from == -1) {
            return;
        }

        String args[] = { String.valueOf(from), String.valueOf(SQLHelper.SELECTION_LIMIT) };
        Cursor cursor = SQLHelper.getInstance().getReadableDatabase().rawQuery(SQLHelper.SQL_READ_LIMIT, args);

        ArrayList<RecordModel> records = new ArrayList<>();

        while (cursor.moveToNext()) {
            RecordModel recordModel = new RecordModel();
            recordModel.setId(cursor.getInt(0));
            recordModel.setFile_name(cursor.getString(1));
            recordModel.setPath(cursor.getString(2));
            recordModel.setDuration(cursor.getString(3));
            recordModel.setReadable_time(cursor.getString(4));
            recordModel.setTime_start(cursor.getInt(5));
            recordModel.setTime_end(cursor.getInt(6));
            recordModel.setFavorite(cursor.getInt(7));
            recordModel.setCustom_name(cursor.getString(8));
            recordModel.setPhone(cursor.getString(9));
            recordModel.setIncoming(cursor.getInt(10));

            records.add(recordModel);
        }

        cursor.close();
        Log.e("1", "records " + records.size());
        Intent model_broadcast = new Intent(Const.SqlService.BROADCAST)
                .putExtra(Const.COMMAND, Const.SqlService.LOAD).putParcelableArrayListExtra(Const.MODEL, records);
        Log.e("1", "newlist " + model_broadcast.getExtras().toString());
        LocalBroadcastManager.getInstance(this).sendBroadcast(model_broadcast);

    }

    private synchronized void save(RecordModel model) {
        // -1 means no id yet, new record
        if (model.getId() == -1) {
            ContentValues values = new ContentValues();
            values.put(SQLHelper.C_FILENAME, model.getFile_name());
            values.put(SQLHelper.C_PATH, model.getPath());
            values.put(SQLHelper.C_DURATION, model.getDuration());
            values.put(SQLHelper.C_DATE, model.getReadable_time());
            values.put(SQLHelper.C_START, model.getTime_start());
            values.put(SQLHelper.C_END, model.getTime_end());
            values.put(SQLHelper.C_FAVORITE, model.isFavorite());
            values.put(SQLHelper.C_CUSTOM_NAME, model.getCustom_name());
            values.put(SQLHelper.C_PHONE, model.getPhone());
            values.put(SQLHelper.C_INCOMING, model.isIncoming());

            long id = SQLHelper.getInstance().getWritableDatabase().insert(SQLHelper.TABLE_NAME, null, values);
            if (id != -1) {
                model.setId((int) id);
            }

            Intent model_broadcast = new Intent(Const.SqlService.BROADCAST)
                    .putExtra(Const.COMMAND, Const.SqlService.SAVE).putExtra(Const.MODEL, model);
            LocalBroadcastManager.getInstance(this).sendBroadcast(model_broadcast);
        } else {
            //existing record
            ContentValues values = new ContentValues();
            values.put(SQLHelper.C_FAVORITE, model.isFavorite());
            values.put(SQLHelper.C_CUSTOM_NAME, model.getCustom_name());

            SQLHelper.getInstance().getWritableDatabase().updateWithOnConflict(SQLHelper.TABLE_NAME, values,
                    SQLHelper.C_ID + " = ?", new String[] { String.valueOf(model.getId()) },
                    SQLiteDatabase.CONFLICT_REPLACE);

        }

    }
}