StatusProvider.java :  » Calendar » kolab-android » at » dasz » KolabDroid » Provider » Android Open Source

/*
 * Copyright 2010 Arthur Zaczek <arthur@dasz.at>, dasz.at OG; All rights reserved.
 * Copyright 2010 David Schmitt <david@dasz.at>, dasz.at OG; All rights reserved.
 *
 *  This file is part of Kolab Sync for Android.

 *  Kolab Sync for Android is free software: you can redistribute it
 *  and/or modify it under the terms of the GNU General Public License
 *  as published by the Free Software Foundation, either version 3 of
 *  the License, or (at your option) any later version.

 *  Kolab Sync for Android is distributed in the hope that it will be
 *  useful, but WITHOUT ANY WARRANTY; without even the implied warranty
 *  of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 *  General Public License for more details.

 *  You should have received a copy of the GNU General Public License
 *  along with Kolab Sync for Android.
 *  If not, see <http://www.gnu.org/licenses/>.
 */

package at.dasz.KolabDroid.Provider;

import java.util.ArrayList;

import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteQueryBuilder;
import at.dasz.KolabDroid.Sync.StatusEntry;

public class StatusProvider
{
  public final static String    STATUS_TABLE_NAME    = "Status";

  public final static String    COL_time        = "time";
  public final static String    COL_task        = "task";

  public final static String    COL_items        = "items";

  public final static String    COL_localChanged    = "localChanged";
  public final static String    COL_remoteChanged    = "remoteChanged";

  public final static String    COL_localNew      = "localNew";
  public final static String    COL_remoteNew      = "remoteNew";

  public final static String    COL_localDeleted    = "localDeleted";
  public final static String    COL_remoteDeleted    = "remoteDeleted";

  public final static String    COL_conflicted      = "conflicted";
  public final static String    COL_errors        = "errors";
  public final static String    COL_fatalErrorMsg    = "fatalErrorMsg";

  public final static int      COL_IDX_time      = 1;
  public final static int      COL_IDX_task      = 2;

  public final static int      COL_IDX_items      = 3;

  public final static int      COL_IDX_localChanged  = 4;
  public final static int      COL_IDX_remoteChanged  = 5;

  public final static int      COL_IDX_localNew    = 6;
  public final static int      COL_IDX_remoteNew    = 7;

  public final static int      COL_IDX_localDeleted  = 8;
  public final static int      COL_IDX_remoteDeleted  = 9;

  public final static int      COL_IDX_conflicted    = 10;
  public final static int      COL_IDX_errors      = 11;
  public final static int      COL_IDX_fatalErrorMsg  = 12;

  public static final String[]  DEFAULT_PROJECTION    = new String[] {
      DatabaseHelper.COL_ID, // 0
      COL_time, // 1
      COL_task, // 2
      COL_items, // 3
      COL_localChanged, // 4
      COL_remoteChanged, // 5
      COL_localNew, // 6
      COL_remoteNew, // 7
      COL_localDeleted, // 8
      COL_remoteDeleted, // 9
      COL_conflicted, // 10
      COL_errors, // 11
      COL_fatalErrorMsg, // 12
                              };

  private DatabaseHelper      dbHelper;

  public StatusProvider(Context ctx)
  {
    dbHelper = new DatabaseHelper(ctx);
  }

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

  private Cursor getCursor(SQLiteDatabase db, String[] projectionIn,
      String selection, String[] selectionArgs, String groupBy,
      String having, String sortOrder)
  {
    SQLiteQueryBuilder qb = new SQLiteQueryBuilder();
    qb.setTables(STATUS_TABLE_NAME);
    return qb.query(db, projectionIn, selection, selectionArgs, groupBy,
        having, sortOrder);
  }

  public StatusEntry getStatusEntry(int id)
  {
    SQLiteDatabase db = dbHelper.getReadableDatabase();
    Cursor c = null;
    try
    {
      c = getCursor(db, DEFAULT_PROJECTION, DatabaseHelper.COL_ID
          + " = ?", new String[] { Integer.toString(id) }, null,
          null, null);
      if (c.moveToFirst()) return new StatusEntry(c);
      return null;
    }
    finally
    {
      if (c != null) c.close();
      if (db != null) db.close();
    }
  }

  public StatusEntry getLastStatusEntry(String task)
  {
    SQLiteDatabase db = dbHelper.getReadableDatabase();
    Cursor c = null;
    try
    {
      c = getCursor(db, DatabaseHelper.ID_PROJECTION, "MAX(" + COL_time
          + ") AND " + COL_task + "= ?", new String[] { task }, null,
          null, null);
      if (c.moveToFirst()) return getStatusEntry(c
          .getInt(DatabaseHelper.COL_IDX_ID));
      return null;
    }
    finally
    {
      if (c != null) c.close();
      if (db != null) db.close();
    }
  }

  public ArrayList<StatusEntry> getLastStatusEntries()
  {
    ArrayList<StatusEntry> result = new ArrayList<StatusEntry>();

    SQLiteDatabase db = dbHelper.getReadableDatabase();
    Cursor c = null;
    try
    {
      c = getCursor(db, DEFAULT_PROJECTION, null, null, null, null,
          COL_time + " DESC");
      while (c.moveToNext())
      {
        result.add(new StatusEntry(c));
      }
    }
    finally
    {
      if (c != null) c.close();
      if (db != null) db.close();
    }

    return result;
  }

  public void saveStatusEntry(StatusEntry entry)
  {
    SQLiteDatabase db = dbHelper.getWritableDatabase();
    try
    {
      if (entry.getId() != 0)
      {
        db.update(STATUS_TABLE_NAME, entry.toContentValues(),
            DatabaseHelper.COL_ID + " = " + entry.getId(), null);
      }
      else
      {
        long rowId = db.insertOrThrow(STATUS_TABLE_NAME, null, entry
            .toContentValues());
        entry.setId(rowId);
      }
    }
    finally
    {
      if (db != null) db.close();
    }
  }

  public void deleteStatusEntry(StatusEntry entry)
  {
    SQLiteDatabase db = dbHelper.getWritableDatabase();
    try
    {
      db.delete(STATUS_TABLE_NAME, DatabaseHelper.COL_ID + " = "
          + entry.getId(), null);
    }
    finally
    {
      if (db != null) db.close();
    }
  }

  public void clearAllEntries()
  {
    SQLiteDatabase db = dbHelper.getWritableDatabase();
    try
    {
      db.execSQL("DELETE FROM " + StatusProvider.STATUS_TABLE_NAME);
    }
    finally
    {
      if (db != null) db.close();
    }
  }
}