Android Open Source - checkin Check In Open Helper

• Back to Location/Application  ↑

From Project

Back to project page checkin.

License

The source code is released under:

# License Copyright ? 2014 Sam Whited Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the ?Software??), to deal ...

Java Source Code

package com.samwhited.checkin.database;
//from   ww w.ja va2 s  .  c  om
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;

public class CheckInOpenHelper extends SQLiteOpenHelper {

  private static final int    DATABASE_VERSION   = 2;
  private static final String DATABASE_NAME      = "checkindb";

  public static final String CHECKIN_TABLE_NAME = "checkins";

  // Some DB column names
  public static final String ID_NAME        = "_id";      // INTEGER PRIMARY KEY
  public static final String PROVIDER_NAME  = "provider"; // STRING NOT NULL
  public static final String LATITUDE_NAME  = "lat";      // REAL NOT NULL
  public static final String LONGITUDE_NAME = "long";     // REAL NOT NULL
  public static final String TIME_NAME      = "time";     // INTEGER NOT NULL
  public static final String REALTIME_NAME  = "realtime"; // INTEGER NOT NULL
  public static final String ALTITUDE_NAME  = "altitude"; // REAL
  public static final String ACCURACY_NAME  = "accuracy"; // REAL
  public static final String BEARING_NAME   = "bearing";  // REAL
  public static final String SPEED_NAME     = "speed";    // REAL
  public static final String ICON_NAME      = "icon";     // STRING


  /**
   * Format the data as a geojson blob and store just the blob in the DB. Individual
   * datum will not be stored.
   */
  private static final String CHECKIN_TABLE_CREATE =
      "CREATE TABLE " + CHECKIN_TABLE_NAME + " ("
          + ID_NAME         + " INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "
          + PROVIDER_NAME   + " TEXT NOT NULL,"
          + LATITUDE_NAME   + " REAL NOT NULL,"
          + LONGITUDE_NAME  + " REAL NOT NULL,"
          + TIME_NAME       + " INTEGER NOT NULL,"
          + REALTIME_NAME   + " INTEGER NOT NULL,"
          + ALTITUDE_NAME   + " REAL,"
          + ACCURACY_NAME   + " REAL,"
          + BEARING_NAME    + " REAL,"
          + SPEED_NAME      + " REAL,"
          + ICON_NAME       + " STRING"
          + ");";

  CheckInOpenHelper(final Context context) {
    super(context, DATABASE_NAME, null, DATABASE_VERSION);
  }

  @Override
  public void onCreate(final SQLiteDatabase db) {
    db.execSQL(CHECKIN_TABLE_CREATE);
  }

  /**
   * Called when the database needs to be upgraded. The implementation
   * should use this method to drop tables, add tables, or do anything else it
   * needs to upgrade to the new schema version.
   * <p/>
   * <p>
   * The SQLite ALTER TABLE documentation can be found
   * <a href="http://sqlite.org/lang_altertable.html">here</a>. If you add new columns
   * you can use ALTER TABLE to insert them into a live table. If you rename or remove columns
   * you can use ALTER TABLE to rename the old table, then create the new table and then
   * populate the new table with the contents of the old table.
   * </p><p>
   * This method executes within a transaction.  If an exception is thrown, all changes
   * will automatically be rolled back.
   * </p>
   *
   * @param db         The database.
   * @param oldVersion The old database version.
   * @param newVersion The new database version.
   */
  @Override
  public void onUpgrade(final SQLiteDatabase db, final int oldVersion, final int newVersion) {
    Log.w(CheckInOpenHelper.class.getName(),
        "Upgrading database from version " + oldVersion + " to "
            + newVersion + ", which will destroy all old data"
    );
    db.execSQL("DROP TABLE IF EXISTS " + CHECKIN_TABLE_NAME);
    onCreate(db);
  }
}

Java Source Code List

• Back to Location/Application  ↑