NoteRepository.java

package pl.llp.aircasting.storage.repository;

import pl.llp.aircasting.model.Note;
import pl.llp.aircasting.model.Session;
import pl.llp.aircasting.storage.db.AirCastingDB;
import pl.llp.aircasting.storage.db.ReadOnlyDatabaseTask;

import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import com.google.inject.Inject;

import java.util.List;

import static com.google.common.collect.Lists.newArrayList;
import static pl.llp.aircasting.storage.DBHelper.getDate;
import static pl.llp.aircasting.storage.DBHelper.getDouble;
import static pl.llp.aircasting.storage.DBHelper.getInt;
import static pl.llp.aircasting.storage.DBHelper.getString;
import static pl.llp.aircasting.storage.db.DBConstants.*;

public class NoteRepository
{
  @Inject AirCastingDB dbAccessor;

  @Internal
  void save(Iterable<Note> notes, long sessionId, SQLiteDatabase writableDb)
  {
    writableDb.delete(NOTE_TABLE_NAME, NOTE_SESSION_ID + " = " + sessionId, null);

    ContentValues values = new ContentValues();

    for (Note note : notes) {
      values.clear();
      values.put(NOTE_SESSION_ID, sessionId);
      values.put(NOTE_LATITUDE, note.getLatitude());
      values.put(NOTE_LONGITUDE, note.getLongitude());
      values.put(NOTE_TEXT, note.getText());
      values.put(NOTE_DATE, note.getDate().getTime());
      values.put(NOTE_PHOTO, note.getPhotoPath());
      values.put(NOTE_NUMBER, note.getNumber());

      writableDb.insertOrThrow(NOTE_TABLE_NAME, null, values);
    }
  }

  @API
  List<Note> load(final Session session)
  {
    return dbAccessor.executeReadOnlyTask(new ReadOnlyDatabaseTask<List<Note>>()
    {
      @Override
      public List<Note> execute(SQLiteDatabase readOnlyDatabase)
      {
        List<Note> result = newArrayList();

        Cursor cursor = readOnlyDatabase.query(NOTE_TABLE_NAME, null, NOTE_SESSION_ID + " = " + session.getId(),
                                               null, null, null, null);
        cursor.moveToFirst();

        while (!cursor.isAfterLast())
        {
          Note note = new Note();

          note.setLatitude(getDouble(cursor, NOTE_LATITUDE));
          note.setLongitude(getDouble(cursor, NOTE_LONGITUDE));
          note.setDate(getDate(cursor, NOTE_DATE));
          note.setText(getString(cursor, NOTE_TEXT));
          note.setPhotoPath(getString(cursor, NOTE_PHOTO));
          note.setNumber(getInt(cursor, NOTE_NUMBER));

          result.add(note);
          cursor.moveToNext();
        }

        cursor.close();
        return result;
      }
    });
  }

  @Internal
  void delete(long sessionId, long noteNumber, SQLiteDatabase writableDb)
  {
    writableDb.delete(NOTE_TABLE_NAME, NOTE_SESSION_ID + " = " + sessionId + " " +
        "AND " + NOTE_NUMBER + " = " + noteNumber, null);
  }
}