Android Open Source - observer Observation

From Project

Back to project page observer.
License

The source code is released under:
GNU General Public License
If you think the Android project observer 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 uk.ac.horizon.observer.model;
/*  w ww  . j av a  2s. c o  m*/
import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.nio.channels.FileChannel;
import java.util.Date;

import android.annotation.TargetApi;
import android.content.ContentValues;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.os.Build;
import android.os.Environment;
import android.provider.BaseColumns;
import android.widget.Toast;

/**
 * An observation (such as a Place or Task)
 * 
 * @author Jesse
 * 
 */
public abstract class Observation {
  private String name;
  private String type;
  protected Date observationTime = new Date();
  // The id of the last inserted observation; -2 means the value has not been
  // set
  protected static long lastobs = -2;

  public Observation(String name, String type) {
    this.name = name;
    this.type = type;
  }

  public String toString() {
    return name;
  }

  public String getName() {
    return name;
  }

  public String getType() {
    return type;
  }

  public Date getObservationTime() {
    return observationTime;
  }

  public static void initDB(Context context) {
    ObservationDBHelper.getInstance(context).onCreate(
        ObservationDBHelper.getInstance(context).getDb());
  }

  /**
   * Inserts an observation into the database
   * 
   * @param context
   */
  public long addObservation(Context context) {
    // Create a new map of values, where column names are the keys
    ContentValues values = new ContentValues();

    values.put(ObservationDBHelper.ObservationColumns.COLUMN_NAME_SESSION,
        Places.getSession());
    values.put(ObservationDBHelper.ObservationColumns.COLUMN_NAME_OBS_TIME,
        this.observationTime.getTime());
    values.put(ObservationDBHelper.ObservationColumns.COLUMN_NAME_OBS_NAME,
        this.name);
    values.put(ObservationDBHelper.ObservationColumns.COLUMN_NAME_OBS_TYPE,
        type);

    lastobs = ObservationDBHelper
        .getInstance(context)
        .getDb()
        .insert(ObservationDBHelper.ObservationColumns.TABLE_NAME,
            null, values);
    // Log the insertion of the new row
    //Toast.makeText(context, "lastobs: " + lastobs, Toast.LENGTH_SHORT)
    //    .show();
    return lastobs;
  }

  /**
   * Note a -2 means this value is not set and a -1 means an error occured in
   * the last insertion
   * 
   * @return the id of the last insertion
   */
  public static long getLastObs() {
    return lastobs;
  }
  
  /**
   * Outputs the database to SD card /BackupFolder/DATABASE_NAME
   * @param context
   */
  public static void dumpDB(Context context){
    ObservationDBHelper.exportDB(context);
  }

  /**
   * Helper class to write Observations to the SQLite DB
   * 
   * @author Jesse
   * 
   */
  protected static class ObservationDBHelper extends SQLiteOpenHelper {
    // If the database schema changes increment the database version.
    public static final int DATABASE_VERSION = 1;
    public static final String DATABASE_NAME = "Observer.db";
    public static final String DATABASE_PATH = "uk.ac.horizon.observer";

    private static ObservationDBHelper instance = null;
    private static SQLiteDatabase db = null;

    public static ObservationDBHelper getInstance(Context context) {
      if (null == instance) {
        instance = new ObservationDBHelper(context);
        db = instance.getWritableDatabase();
      }
      return instance;
    }

    public SQLiteDatabase getDb() {
      return db;
    }

    protected ObservationDBHelper(Context context) {
      super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }

    public void onCreate(SQLiteDatabase db) {
      db.execSQL(SQL_CREATE_CONFIG);
    }

    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
      // This database is only a cache for online data, so its upgrade
      // policy is
      // to simply to discard the data and start over
      db.execSQL(SQL_DELETE_CONFIG);
      onCreate(db);
    }

    public void onDowngrade(SQLiteDatabase db, int oldVersion,
        int newVersion) {
      onUpgrade(db, oldVersion, newVersion);
    }

    /**
     * methods that create and maintain the database and tables
     */
    private static final String TEXT_TYPE = " TEXT";
    private static final String SEP = ",";
    private static final String SQL_CREATE_CONFIG = "CREATE TABLE IF NOT EXISTS "
        + ObservationColumns.TABLE_NAME
        + "("
        + ObservationColumns.COLUMN_NAME_SESSION
        + " INTEGER NOT NULL"
        + SEP
        + ObservationColumns.COLUMN_NAME_OBS_TIME
        + " INTEGER NOT NULL"
        + SEP
        + ObservationColumns.COLUMN_NAME_OBS_NAME
        + " TEXT NOT NULL"
        + SEP
        + ObservationColumns.COLUMN_NAME_OBS_TYPE
        + " TEXT"
        + SEP
        + ObservationColumns.COLUMN_NAME_OBS_BIN
        + " INTEGER"
        + SEP
        + ObservationColumns.COLUMN_NAME_RELATED_OBS_TIME
        + " INTEGER"
        + SEP
        + ObservationColumns.COLUMN_NAME_RELATED_OBS_NAME
        + " TEXT"
        + SEP
        + " PRIMARY KEY ("
        + ObservationColumns.COLUMN_NAME_OBS_TIME
        + SEP
        + ObservationColumns.COLUMN_NAME_OBS_NAME + "))";

    private static final String SQL_DELETE_CONFIG = "DROP TABLE IF EXISTS "
        + ObservationColumns.TABLE_NAME;

    /**
     * SQLite Database contract for storing observations
     * 
     * @author Jesse
     * 
     */
    protected static abstract class ObservationColumns implements
        BaseColumns {
      public static final String TABLE_NAME = "Observations";
      public static final String COLUMN_NAME_SESSION = "session";
      public static final String COLUMN_NAME_OBS_TIME = "obs_time";
      public static final String COLUMN_NAME_OBS_NAME = "obs_name";
      public static final String COLUMN_NAME_OBS_TYPE = "obs_type";
      public static final String COLUMN_NAME_OBS_BIN = "obs_bin";
      public static final String COLUMN_NAME_RELATED_OBS_TIME = "related_obs_time";
      public static final String COLUMN_NAME_RELATED_OBS_NAME = "related_obs_name";
    }
    /**
     * Export the DB contents to file
     */
        @TargetApi(19)
    public static void exportDB(Context context) {

            try {
              //Add to manifest: <uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" />
                File sd = Environment.getExternalStorageDirectory();
                File data = Environment.getDataDirectory();

                if (sd.canWrite()) {
                    String  currentDBPath= "//data//" + DATABASE_PATH
                            + "//databases//" + DATABASE_NAME;
                    File currentDB = new File(data, currentDBPath);
                    File backupDB = new File(Environment.getExternalStoragePublicDirectory(
                            Environment.DIRECTORY_DOWNLOADS), DATABASE_NAME );
                    backupDB.createNewFile();

                    FileInputStream fis = new FileInputStream(currentDB);
                    FileChannel src = fis.getChannel();
                    FileOutputStream fos = new FileOutputStream(backupDB);
                    FileChannel dst = fos.getChannel();
                    dst.transferFrom(src, 0, src.size());
                    src.close();
                    dst.close();
                    fos.close();
                    fis.close();
                    Toast.makeText(context, "Database backed up to: " + backupDB.toString(),
                            Toast.LENGTH_LONG).show();

                } else{
                    Toast.makeText(context, "Couldn't write to SD", Toast.LENGTH_LONG)
                            .show();
                }
            } catch (Exception e) {

                Toast.makeText(context, e.toString(), Toast.LENGTH_LONG)
                        .show();

            }
        }
  }
}
Java Source Code List
