// Update check-in data
public synchronized DBError updateCheckInData(CheckInData data) {
Assert.assertTrue(data != null);
DBError result = DBError.DB_ERROR_NONE;
try {
// Append new shortcut item to mDatabase
ContentValues values = new ContentValues();
values.put("lat", data.lat);
values.put("lng", data.lng);
values.put("time", data.time);
values.put("date", Utility.getDateString(data.time, DATE_FORMAT));
values.put("place", data.place);
long ret =
mDatabase.update(
"tbl_checkin", values, "time=?", new String[] {String.valueOf(data.time)});
if (ret == -1) result = DBError.DB_ERROR_FAILED;
else if (ret == 0) result = DBError.DB_ERROR_NOT_EXIST;
} catch (SQLiteException e) {
result = DBError.DB_ERROR_FAILED;
}
return result;
}
/** Add check-in data */
public synchronized DBError addCheckInData(CheckInData data) {
ContentValues values = new ContentValues();
long result;
Assert.assertTrue(data != null);
values.put("lat", data.lat);
values.put("lng", data.lng);
values.put("time", data.time);
String dateStr = Utility.getDateString(data.time, DATE_FORMAT);
values.put("date", dateStr);
values.put("place", data.place);
result = mDatabase.insert("tbl_checkin", null, values);
if (result == -1) return DBError.DB_ERROR_FAILED;
return DBError.DB_ERROR_NONE;
}
