Android Open Source - beeline Location Entry Db Helper

• Back to Location/distance  ↑

From Project

Back to project page beeline.

License

The source code is released under:

GNU General Public License

Java Source Code

package net.datag.beeline;
//  w ww.j  a  v  a 2 s.c o m
import net.datag.beeline.LocationEntryContract.LocationEntry;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class LocationEntryDbHelper extends SQLiteOpenHelper {
  public static final int DATABASE_VERSION = 4;
  public static final String DATABASE_NAME = "LocationEntries.db";

  private static final String SQL_CREATE_ENTRIES =
      "CREATE TABLE " + LocationEntry.TABLE_NAME + " (" +
          LocationEntry._ID + " INTEGER PRIMARY KEY," +
          LocationEntry.COLUMN_NAME_NAME + " TEXT," +
          LocationEntry.COLUMN_NAME_LATITUDE + " REAL," +
          LocationEntry.COLUMN_NAME_LONGITUDE + " REAL" +
          " )";

//  private static final String SQL_DELETE_ENTRIES =
//      "DROP TABLE IF EXISTS " + LocationEntry.TABLE_NAME;

  public LocationEntryDbHelper(Context context) {
    super(context, DATABASE_NAME, null, DATABASE_VERSION);
  }

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

  @Override
  public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
//    // FIXME
//    db.execSQL(SQL_DELETE_ENTRIES);
//        onCreate(db);
  }

  public Entry find(int id) throws Exception {
    SQLiteDatabase db = this.getReadableDatabase();
    Entry entry = null;

    try {
      String[] columns = new String[] {
          LocationEntry._ID,
          LocationEntry.COLUMN_NAME_NAME,
          LocationEntry.COLUMN_NAME_LATITUDE,
          LocationEntry.COLUMN_NAME_LONGITUDE
      };

      String selection = LocationEntry._ID + " = ?";
      String[] selectionArgs = { String.valueOf(id) };
      String limit = "1";

      Cursor c = db.query(LocationEntry.TABLE_NAME, columns, selection, selectionArgs, null, null, null, limit);
      if (c.moveToFirst() == false) {
        throw new Exception("Entry not found");
      }

      entry = new Entry(c.getInt(c.getColumnIndex(LocationEntry._ID)),
          c.getString(c.getColumnIndex(LocationEntry.COLUMN_NAME_NAME)),
          c.getDouble(c.getColumnIndex(LocationEntry.COLUMN_NAME_LATITUDE)),
          c.getDouble(c.getColumnIndex(LocationEntry.COLUMN_NAME_LONGITUDE)));
    } catch (Exception e) {
      throw e;
    } finally {
      db.close();
    }

    return entry;
  }

  public void save(Entry entry) throws Exception {
    SQLiteDatabase db = this.getWritableDatabase();

    try {
      ContentValues values = new ContentValues();
      values.put(LocationEntry.COLUMN_NAME_NAME, entry.name);
      values.put(LocationEntry.COLUMN_NAME_LATITUDE, entry.latitude);
      values.put(LocationEntry.COLUMN_NAME_LONGITUDE, entry.longitude);

      if (entry.id != null) {
        String whereClause = LocationEntry._ID + " = ?";
        String[] whereArgs = { String.valueOf(entry.id) };
        db.update(LocationEntry.TABLE_NAME, values, whereClause, whereArgs);
      } else {
        if (db.insert(LocationEntry.TABLE_NAME, null, values) == -1) {
          throw new Exception("No rows were inserted.");
        }
      }
    } catch (Exception e) {
      throw e;
    } finally {
      db.close();
    }
  }

  public void delete(int id) throws Exception {
    SQLiteDatabase db = this.getWritableDatabase();

    try {
      String whereClause = LocationEntry._ID + " = ?";
      String[] whereArgs = { String.valueOf(id) };

      if (db.delete(LocationEntry.TABLE_NAME, whereClause, whereArgs) == 0) {
        throw new Exception("No rows were deleted.");
      }
    } catch (Exception e) {
      throw e;
    } finally {
      db.close();
    }
  }

  final public class Entry {
    public Integer id;
    public String name;
    public Double latitude;
    public Double longitude;

    public Entry(Integer id, String name, Double latitude, Double longitude) {
      this.id = id;
      this.name = name;
      this.latitude = latitude;
      this.longitude = longitude;
    }
  }
}

Java Source Code List

• Back to Location/distance  ↑