NotesDataSource.java

package com.arte.quicknotes.db;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;

public class NotesDataSource implements NotesStorage{

    private SQLiteDatabase db;
    private NotesDbHelper dbHelper;
    private boolean dbEmpty = true;

    public NotesDataSource(Context context) {
        dbHelper = new NotesDbHelper(context);
    }

    public void open() throws SQLException {
        db = dbHelper.getWritableDatabase();
    }

    public void close() {
        dbHelper.close();
    }

    public void createNote(String title, String content) {
        ContentValues values = getContentValues(title, content);
        db.insert(NotesDbHelper.NoteEntry.TABLE_NAME, null, values);
    }

    public void updateNote(long id, String title, String content) {
        ContentValues values = getContentValues(title, content);
        String whereClause = NotesDbHelper.NoteEntry._ID + " = ?";
        String[] args = { String.valueOf(id) };
        db.update(NotesDbHelper.NoteEntry.TABLE_NAME, values, whereClause, args);
    }

    public void deleteNote(Note note) {
        long deleteId = note.getId();
        String[] args = { String.valueOf(deleteId) };
        db.delete(NotesDbHelper.NoteEntry.TABLE_NAME,
                NotesDbHelper.NoteEntry._ID + " = ?",
                args);
    }

    public void deleteAllNotes() {
        db.delete(NotesDbHelper.NoteEntry.TABLE_NAME, null, null);
    }

    public Cursor getAllNotes() {
        String[] projection = {
                NotesDbHelper.NoteEntry._ID,
                NotesDbHelper.NoteEntry.COLUMN_NAME_TITLE,
                NotesDbHelper.NoteEntry.COLUMN_NAME_CONTENT
        };
        String sortOrder =
                NotesDbHelper.NoteEntry._ID + " DESC";

        return db.query(
                NotesDbHelper.NoteEntry.TABLE_NAME,     // The table to query
                projection,                             // The columns to return
                null,                                   // The columns for the WHERE clause
                null,                                   // The values for the WHERE clause
                null,                                   // don't group the rows
                null,                                   // don't filter by row groups
                sortOrder                               // The sort order
        );
    }
    
    private ContentValues getContentValues(String title, String content) {
        ContentValues values = new ContentValues();
        values.put(NotesDbHelper.NoteEntry.COLUMN_NAME_TITLE, title);
        values.put(NotesDbHelper.NoteEntry.COLUMN_NAME_CONTENT, content);
        return values;
    }

}