@Override public void add(Thread thread, User user) { SQLiteDatabase db = null; ContentValues values = null; values = new ContentValues(3); values.put(Thread.Columns.SECTION_ID, thread.getSection().getSectionId()); values.put(Thread.Columns.THREAD_ID, thread.getThreadId()); values.put(Thread.Columns.FLOOR, thread.getFloor()); values.put(Thread.Columns.USER_ID, user.getUserId()); db = DatabaseHelper.getWriteDatabase(); db.insert(Constants.APOLLO_DATA_TABLE_BOOKMARK, null, values); db.close(); }
@Override public void delete(Thread thread, User user) { SQLiteDatabase db = null; String whereClause = null; String[] whereArgs = null; whereClause = Thread.Columns.USER_ID + "=? AND " + Thread.Columns.SECTION_ID + "=? AND " + Thread.Columns.THREAD_ID + "=?"; whereArgs = new String[] { Integer.toString(user.getUserId()), thread.getSection().getSectionId(), Integer.toString(thread.getThreadId()) }; db = DatabaseHelper.getWriteDatabase(); db.delete(Constants.APOLLO_DATA_TABLE_BOOKMARK, whereClause, whereArgs); db.close(); }