public void update(int id, String title, String location) {
SQLiteDatabase db = this.getWritableDatabase();
String where = FIELD_ID + "=?";
String[] whereValue = {Integer.toString(id)};
db.update(TABLE_NAME, createValues(title, location), where, whereValue);
mListener.onFavoriteDatabaseChanged();
}
public void delete(String location) {
SQLiteDatabase db = this.getWritableDatabase();
String where = FIELD_LOCATION + "=?";
String[] whereValue = {location};
db.delete(TABLE_NAME, where, whereValue);
mListener.onFavoriteDatabaseChanged();
}
public void delete(long id, boolean notify) {
SQLiteDatabase db = this.getWritableDatabase();
String where = FIELD_ID + "=?";
String[] whereValue = {Long.toString(id)};
db.delete(TABLE_NAME, where, whereValue);
if (notify) mListener.onFavoriteDatabaseChanged();
}
public long insert(String title, String location) {
if (isFavorite(location)) return -1;
SQLiteDatabase db = this.getWritableDatabase();
long ret = db.insert(TABLE_NAME, null, createValues(title, location));
mListener.onFavoriteDatabaseChanged();
return ret;
}
