Android Open Source - Mamytas Tasks D B Access






From Project

Back to project page Mamytas.

License

The source code is released under:

GNU General Public License

If you think the Android project Mamytas listed in this page is inappropriate, such as containing malicious code/tools or violating the copyright, please email info at java2s dot com, thanks.

Java Source Code

package mn.aug.restfulandroid.provider;
// www . j a v a  2  s  . c  o  m
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

import java.util.ArrayList;
import java.util.List;

import mn.aug.restfulandroid.rest.resource.Task;

/**
 * Created by Paul on 09/11/2014.
 */
public class TasksDBAccess {


    private SQLiteDatabase bdd;

    private ProviderDbHelper myHelper;

    public TasksDBAccess(Context context) {
        //On crer la BDD et sa table
        myHelper = new ProviderDbHelper(context);
    }

    public void open() {
        //on ouvre la BDD en criture
        bdd = myHelper.openBDD();
    }

    public void close() {
        //on ferme l'accs  la BDD
        myHelper.closeBDD();
    }

    public SQLiteDatabase getBDD() {
        return bdd;
    }


    /**
     * Store a new task into the database
     *
     * @param todo The task to be stored
     * @return The task stored with its ID
     */
    public boolean storeTodo(Task todo) {

        if (!TodoIsInDB(todo)) try {
            ContentValues values = new ContentValues();
            values.put(ProviderDbHelper.TODOS_ID, todo.getId());
            values.put(ProviderDbHelper.TODOS_TITLE, todo.getTitle());
            values.put(ProviderDbHelper.TODOS_DUE_DATE, todo.getDue_date());
            values.put(ProviderDbHelper.TODOS_LIST_ID, todo.getList_id());
            bdd.insert(ProviderDbHelper.TABLE_TODOS, null, values);
            return true;
        } catch (Exception e) {
            e.printStackTrace();
            return false;
        }
        return false;

    }


    /**
     * Update a task
     *
     * @param todo The task to be updated
     * @return Whether the update was successful
     */
    public boolean updateTodo(Task todo) {

        if (TodoIsInDB(todo)) try {
            ContentValues values = new ContentValues();
            values.put(ProviderDbHelper.TODOS_TITLE, todo.getTitle());
            values.put(ProviderDbHelper.TODOS_DUE_DATE, todo.getDue_date());
            values.put(ProviderDbHelper.TODOS_LIST_ID, todo.getList_id());
            bdd.update(ProviderDbHelper.TABLE_TODOS, values, ProviderDbHelper.TODOS_ID + " = '" + todo.getId() + "'", null);
            return true;
        } catch (Exception e) {
            e.printStackTrace();
            return false;
        }
        return false;

    }

    /**
     * Retrieve a task from its id
     *
     * @param todoID The Id of the task to retrieve
     * @return The task corresponding to the ID
     */
    public Task retrieveTodo(long todoID) {


        Cursor c = null;
        try {
            c = bdd.query(ProviderDbHelper.TABLE_TODOS, new String[]{ProviderDbHelper.TODOS_TITLE, ProviderDbHelper.TODOS_DUE_DATE, ProviderDbHelper.TODOS_LIST_ID},
                    ProviderDbHelper.TODOS_ID + " ='" + todoID + "'", null, null, null, null);
        } catch (Exception e) {
            e.printStackTrace();
            return null;
        }
        if (c.getCount() == 0)
            return null;
        else {
            c.moveToFirst();
            String title = c.getString(0);
            String due_date = c.getString(1);
            Long list_id = c.getLong(2);
            return new Task(todoID, title, due_date, list_id);
        }
    }

    /**
     * Delete a task from its ID
     *
     * @param todoID The ID of the task to be deleted
     * @return Whether it was successful or not
     */
    public boolean deleteTodo(long todoID) {

        if (TodoIsInDB(retrieveTodo(todoID))) {
            try {
                bdd.delete(ProviderDbHelper.TABLE_TODOS, ProviderDbHelper.TODOS_ID + " = '" + todoID + "'", null);
            } catch (Exception e) {
                e.printStackTrace();
                return false;
            }
            return true;
        }
        return false;

    }

    /**
     * Delete all the tasks of a list
     *
     * @param list_ID The ID of the list to be deleted
     * @return Whether it was successful or not
     */
    public boolean deleteTodosFromList(long list_ID) {

        try {
            bdd.delete(ProviderDbHelper.TABLE_TODOS, ProviderDbHelper.TODOS_LIST_ID + " = '" + list_ID + "'", null);
        } catch (Exception e) {
            e.printStackTrace();
            return false;
        }
        return true;


    }

    /**
     * Retrieve tasks related to a list
     *
     * @param listID The Id of the list
     * @return The tasks ids corresponding to the list
     */
    public List<Integer> retrieveTodosFromList(long listID) {

        List<Integer> list = new ArrayList<Integer>();

        Cursor c = null;
        try {
            c = bdd.query(ProviderDbHelper.TABLE_TODOS, new String[]{ProviderDbHelper.TODOS_ID},
                    ProviderDbHelper.TODOS_LIST_ID + " ='" + listID + "'", null, null, null, null);
        } catch (Exception e) {
            e.printStackTrace();
            return null;
        }
        if (c.getCount() == 0)
            return list;
        else {
            c.moveToFirst();
            do {
                int list_id = c.getInt(0);
                list.add(list_id);
            } while (c.moveToNext());
            return list;

        }

    }

    /**
     * Retrieve tasks related to a list
     *
     * @param listID The Id of the list
     * @return The tasks ids corresponding to the list
     */
    public List<Task> retrieveTodosInstancesFromList(long listID) {

        List<Task> list = new ArrayList<Task>();

        Cursor c = null;
        try {
            c = bdd.query(ProviderDbHelper.TABLE_TODOS, new String[]{ProviderDbHelper.TODOS_ID},
                    ProviderDbHelper.TODOS_LIST_ID + " ='" + listID + "'", null, null, null, null);
        } catch (Exception e) {
            e.printStackTrace();
            return null;
        }
        if (c.getCount() == 0)
            return list;
        else {
            c.moveToFirst();
            do {
                int task_id = c.getInt(0);
                list.add(retrieveTodo(task_id));
            } while (c.moveToNext());
            return list;

        }

    }


    public boolean TodoIsInDB(Task task) {

        Cursor c = null;
        try {
            c = bdd.query(ProviderDbHelper.TABLE_TODOS, new String[]{ProviderDbHelper.TODOS_TITLE}, ProviderDbHelper.TODOS_ID + " ='" + task.getId() + "'", null, null, null, null);
        } catch (Exception e) {
            e.printStackTrace();
            return false;
        }
        return c.getCount() != 0;
    }

    public boolean TodoIsInDB(long id) {

        Cursor c = null;
        try {
            c = bdd.query(ProviderDbHelper.TABLE_TODOS, new String[]{ProviderDbHelper.TODOS_TITLE}, ProviderDbHelper.TODOS_ID + " ='" + id + "'", null, null, null, null);
        } catch (Exception e) {
            e.printStackTrace();
            return false;
        }
        return c.getCount() != 0;
    }


    public boolean setStatus(long id, String state) {

        if (TodoIsInDB(id)) {
            try {
                ContentValues values = new ContentValues();
                values.put(ProviderDbHelper.TODOS_STATE, state);
                bdd.update(ProviderDbHelper.TABLE_TODOS, values, ProviderDbHelper.TODOS_ID + " = '" + id + "'", null);
                return true;
            } catch (Exception e) {
                e.printStackTrace();
                return false;
            }
        }
        return false;
    }


    public String getStatus(long id) {

        if (TodoIsInDB(id)) {
            Cursor c = null;
            try {
                c = bdd.query(ProviderDbHelper.TABLE_TODOS, new String[]{ProviderDbHelper.TODOS_STATE},
                        ProviderDbHelper.TODOS_ID + " ='" + id + "'", null, null, null, null);
            } catch (Exception e) {
                e.printStackTrace();
                return null;
            }
            if (c.getCount() == 0)
                return null;
            else {
                c.moveToFirst();
                return c.getString(0);


            }

        }
        return "not_existing";
    }

    public List<Integer> retrieveAllTasks(){

        List<Integer> list = new ArrayList<Integer>();

        Cursor c = null;
        try {
            c = bdd.query(ProviderDbHelper.TABLE_TODOS, new String[]{ProviderDbHelper.TODOS_ID},null, null, null, null, null);
        } catch (Exception e) {
            e.printStackTrace();
            return null;
        }
        if (c.getCount() == 0)
            return list;
        else {
            c.moveToFirst();
            do {
                int list_id = c.getInt(0);
                list.add(list_id);
            } while (c.moveToNext());
            return list;

        }

    }

    public List<Integer> retrieveTasksWithState(String state){

        List<Integer> list = new ArrayList<Integer>();

        Cursor c = null;
        try {
            c = bdd.query(ProviderDbHelper.TABLE_TODOS, new String[]{ProviderDbHelper.TODOS_ID},
                    ProviderDbHelper.TODOS_STATE + " ='" + state+ "'", null, null, null, null);
        } catch (Exception e) {
            e.printStackTrace();
            return null;
        }
        if (c.getCount() == 0)
            return null;
        else {
            c.moveToFirst();
            do {
                int list_id = c.getInt(0);
                list.add(list_id);
            } while (c.moveToNext());
            return list;

        }
    }
}




Java Source Code List

mn.aug.restfulandroid.activity.AboutActivity.java
mn.aug.restfulandroid.activity.LoginActivity.java
mn.aug.restfulandroid.activity.ProjectEditor.java
mn.aug.restfulandroid.activity.ProjectsActivity.java
mn.aug.restfulandroid.activity.ProjectsArrayAdapter.java
mn.aug.restfulandroid.activity.TaskActivity.java
mn.aug.restfulandroid.activity.TaskEditor.java
mn.aug.restfulandroid.activity.TasksActivity.java
mn.aug.restfulandroid.activity.TasksArrayAdapter.java
mn.aug.restfulandroid.activity.TimerServiceHelper.java
mn.aug.restfulandroid.activity.TimerService.java
mn.aug.restfulandroid.activity.TimersArrayAdapter.java
mn.aug.restfulandroid.activity.base.RESTfulActivity.java
mn.aug.restfulandroid.activity.base.RESTfulListActivity.java
mn.aug.restfulandroid.activity.base.UndoBarController.java
mn.aug.restfulandroid.provider.CommentsDBAccess.java
mn.aug.restfulandroid.provider.ListsDBAccess.java
mn.aug.restfulandroid.provider.OwnershipDBAccess.java
mn.aug.restfulandroid.provider.ProviderDbHelper.java
mn.aug.restfulandroid.provider.RemindersDBAccess.java
mn.aug.restfulandroid.provider.TasksDBAccess.java
mn.aug.restfulandroid.provider.UsersDBAccess.java
mn.aug.restfulandroid.rest.AbstractRestMethod.java
mn.aug.restfulandroid.rest.DeleteListRestMethod.java
mn.aug.restfulandroid.rest.DeleteTaskRestMethod.java
mn.aug.restfulandroid.rest.GetListsRestMethod.java
mn.aug.restfulandroid.rest.GetTasksRestMethod.java
mn.aug.restfulandroid.rest.GetTimersRestMethod.java
mn.aug.restfulandroid.rest.LoginRestMethod.java
mn.aug.restfulandroid.rest.PostListRestMethod.java
mn.aug.restfulandroid.rest.PostTaskRestMethod.java
mn.aug.restfulandroid.rest.PostTimerRestMethod.java
mn.aug.restfulandroid.rest.PutListRestMethod.java
mn.aug.restfulandroid.rest.PutTaskRestMethod.java
mn.aug.restfulandroid.rest.PutTimerRestMethod.java
mn.aug.restfulandroid.rest.Request.java
mn.aug.restfulandroid.rest.Response.java
mn.aug.restfulandroid.rest.RestClient.java
mn.aug.restfulandroid.rest.RestMethodFactory.java
mn.aug.restfulandroid.rest.RestMethodResult.java
mn.aug.restfulandroid.rest.RestMethod.java
mn.aug.restfulandroid.rest.ShareListRestMethod.java
mn.aug.restfulandroid.rest.resource.Comment.java
mn.aug.restfulandroid.rest.resource.Lists.java
mn.aug.restfulandroid.rest.resource.Listw.java
mn.aug.restfulandroid.rest.resource.Login.java
mn.aug.restfulandroid.rest.resource.Reminder.java
mn.aug.restfulandroid.rest.resource.Resource.java
mn.aug.restfulandroid.rest.resource.TaskList.java
mn.aug.restfulandroid.rest.resource.Task.java
mn.aug.restfulandroid.rest.resource.Tasks.java
mn.aug.restfulandroid.rest.resource.Timer.java
mn.aug.restfulandroid.rest.resource.Timers.java
mn.aug.restfulandroid.security.AuthorizationManager.java
mn.aug.restfulandroid.security.RequestSigner.java
mn.aug.restfulandroid.service.ListProcessor.java
mn.aug.restfulandroid.service.ListsProcessor.java
mn.aug.restfulandroid.service.LoginProcessor.java
mn.aug.restfulandroid.service.ProcessorCallback.java
mn.aug.restfulandroid.service.ShareProcessor.java
mn.aug.restfulandroid.service.TaskProcessor.java
mn.aug.restfulandroid.service.TasksProcessor.java
mn.aug.restfulandroid.service.TimersProcessor.java
mn.aug.restfulandroid.service.WunderlistServiceHelper.java
mn.aug.restfulandroid.service.WunderlistService.java
mn.aug.restfulandroid.util.DateHelper.java
mn.aug.restfulandroid.util.DatePickerFragment.java
mn.aug.restfulandroid.util.Logger.java
mn.aug.restfulandroid.util.TimePickerFragment.java