Java Code Examples for android.database.sqlite.SQLiteDatabase#update()
The following examples show how to use
android.database.sqlite.SQLiteDatabase#update() .
These examples are extracted from open source projects.
You can vote up the ones you like or vote down the ones you don't like,
and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example 1
Source Project: IdeaTrackerPlus File: DatabaseHelper.java License: MIT License | 6 votes |
public void moveAllToTab(int tabNumber, ArrayList<Pair<Integer, String>> ideas) { SQLiteDatabase db = this.getWritableDatabase(); ContentValues values = new ContentValues(); switch (tabNumber) { case 1: //NOW values.put(DataEntry.COLUMN_NAME_DONE, false); values.put(DataEntry.COLUMN_NAME_LATER, false); break; case 2: //LATER values.put(DataEntry.COLUMN_NAME_DONE, false); values.put(DataEntry.COLUMN_NAME_LATER, true); break; case 3: //DONE values.put(DataEntry.COLUMN_NAME_LATER, false); values.put(DataEntry.COLUMN_NAME_DONE, true); break; } for (Pair<Integer, String> idea : ideas) { db.update(DataEntry.TABLE_NAME, values, "_id=" + idea.first, null); } notifyAllLists(); }
Example 2
Source Project: XMouse File: DatabaseHandler.java License: MIT License | 6 votes |
public int updateRow(String TABLE_NAME,String[] columnKeys, String[] columnValues,String id) { SQLiteDatabase db = this.getWritableDatabase(); ContentValues values = new ContentValues(); for(int i=0;i<columnKeys.length;i++){ values.put(columnKeys[i], columnValues[i]); } // updating row return db.update( TABLE_NAME, values, KEY_ID + " = ?", new String[] { id } ); }
Example 3
Source Project: loaned-android File: DatabaseManager.java License: Apache License 2.0 | 6 votes |
public void updateLoan(Loan loan){ SQLiteDatabase db = getWritableDatabase(); ContentValues values = new ContentValues(); if(loan.isNotifying()){ values.put(LOAN_NOTIFY, 1); } else { values.put(LOAN_NOTIFY, 0); } values.put(LOAN_STARTDATE, loan.getStartDate().toString()); if(loan.getReturnDate()==null){ values.putNull(LOAN_RETURNDATE); } else { values.put(LOAN_RETURNDATE, loan.getReturnDate().toString()); } values.put(LOAN_ITEMID, loan.getItemID()); values.put(LOAN_PERSONID, loan.getPersonID()); db.update(LOAN_TABLENAME, values, LOAN_ID+"=?", new String[]{Integer.toString(loan.getLoanID())}); db.close(); }
Example 4
Source Project: BigApp_Discuz_Android File: CalendarProvider.java License: Apache License 2.0 | 6 votes |
@Override //更新数据 public int update(Uri uri, ContentValues values, String where, String[] whereArgs) { SQLiteDatabase db = mOpenHelper.getWritableDatabase(); int count; switch (sUriMatcher.match(uri)) { case CALENDAR: count = db.update(CalendarColumn_TABLE_NAME, values, where, whereArgs); break; case CALENDAR_ID: String noteId = uri.getPathSegments().get(1); count = db.update(CalendarColumn_TABLE_NAME, values, CalendarColumn._ID + "=" + noteId + (!TextUtils.isEmpty(where) ? " AND (" + where + ')' : ""), whereArgs); break; default: throw new IllegalArgumentException("Unknown URI " + uri); } getContext().getContentResolver().notifyChange(uri, null); return count; }
Example 5
Source Project: SkyTube File: SubscriptionsDb.java License: GNU General Public License v3.0 | 6 votes |
/** * Updates the given channel's last visit time. * * @param channelId Channel ID * * @return last visit time, if the update was successful; -1 otherwise. */ public long updateLastVisitTime(String channelId) { SQLiteDatabase db = getWritableDatabase(); long currentTime = System.currentTimeMillis(); ContentValues values = new ContentValues(); values.put(SubscriptionsTable.COL_LAST_VISIT_TIME, currentTime); int count = db.update( SubscriptionsTable.TABLE_NAME, values, SubscriptionsTable.COL_CHANNEL_ID + " = ?", new String[]{channelId}); return (count > 0 ? currentTime : -1); }
Example 6
Source Project: android_tv_metro File: iDataProvider.java License: Apache License 2.0 | 6 votes |
@Override public int update(Uri uri, ContentValues values, String selection, String[] selectionArgs) { int count = 0; SqlArguments args = new SqlArguments(uri, selection, selectionArgs); //always update local database SQLiteDatabase db = mOpenHelper.getWritableDatabase(); count = db.update(args.table, values, args.where, args.args); if (count > 0) { getContext().getContentResolver().notifyChange(uri, null); } return count; }
Example 7
Source Project: 4pdaClient-plus File: DownloadsTable.java License: Apache License 2.0 | 6 votes |
public static void endRow(DownloadTask downloadTask) { SQLiteDatabase db = null; try { DbHelper dbHelper = new DbHelper(App.getInstance()); db = dbHelper.getWritableDatabase(); // db.beginTransaction(); ContentValues cv = new ContentValues(); cv.put(COLUMN_ENDDATETIME, DbHelper.DateTimeFormat.format(downloadTask.getStateChangedDate())); cv.put(COLUMN_STATE, downloadTask.getState()); cv.put(COLUMN_DOWNLOADEDCONTENTLENGTH, downloadTask.getDownloadedSize()); db.update(TABLE_NAME, cv, COLUMN_ID + "=" + downloadTask.getId(), null); } catch (Exception ex) { AppLog.e(App.getInstance(), ex); } finally { if (db != null) { // db.endTransaction(); db.close(); } } }
Example 8
Source Project: MediaSDK File: DefaultDownloadIndex.java License: Apache License 2.0 | 5 votes |
@Override public void setDownloadingStatesToQueued() throws DatabaseIOException { ensureInitialized(); try { ContentValues values = new ContentValues(); values.put(COLUMN_STATE, Download.STATE_QUEUED); SQLiteDatabase writableDatabase = databaseProvider.getWritableDatabase(); writableDatabase.update(tableName, values, WHERE_STATE_IS_DOWNLOADING, /* whereArgs= */ null); } catch (SQLException e) { throw new DatabaseIOException(e); } }
Example 9
Source Project: Demo_Public File: SettingsProvider.java License: MIT License | 5 votes |
@Override public int update(Uri uri, ContentValues values, String selection, String[] selectionArgs) { SQLiteDatabase db = mOPenHelper.getWritableDatabase(); int count; String finalWhere; switch (sUriMatcher.match(uri)){ case SETTINGS: count = db.update( Settings.TABLE_NAME, values, selection, selectionArgs ); break; case SETTINGS_ID: String id = uri.getPathSegments().get(1); finalWhere = Settings._ID +" = "+id; if(selection != null){ finalWhere += " AND " +selection; } count = db.update(Settings.TABLE_NAME, values, finalWhere, selectionArgs); break; default: throw new IllegalArgumentException("Unknown uri: "+uri); } getContext().getContentResolver().notifyChange(uri,null); return count; }
Example 10
Source Project: nextcloud-notes File: NotesDatabase.java License: GNU General Public License v3.0 | 5 votes |
public void updateCapabilitiesETag(long accountId, String capabilitiesETag) { validateAccountId(accountId); SQLiteDatabase db = this.getWritableDatabase(); ContentValues values = new ContentValues(1); values.put(key_capabilities_etag, capabilitiesETag); final int updatedRows = db.update(table_accounts, values, key_id + " = ?", new String[]{String.valueOf(accountId)}); if (updatedRows == 1) { Log.v(TAG, "Updated etag to " + capabilitiesETag + " for accountId = " + accountId); } else { Log.e(TAG, "Updated " + updatedRows + " but expected only 1 for accountId = " + accountId + " and capabilitiesETag = " + capabilitiesETag); } }
Example 11
Source Project: indigenous-android File: DatabaseHelper.java License: GNU General Public License v3.0 | 5 votes |
/** * Saves a draft. * * @param draft * The draft to save. */ public void saveDraft(Draft draft) { SQLiteDatabase db = this.getWritableDatabase(); ContentValues values = new ContentValues(); values.put(Draft.COLUMN_SEND_WHEN_ONLINE, draft.getSendWhenOnline()); values.put(Draft.COLUMN_TYPE, draft.getType()); values.put(Draft.COLUMN_ACCOUNT, draft.getAccount()); values.put(Draft.COLUMN_NAME, draft.getName()); values.put(Draft.COLUMN_BODY, draft.getBody()); values.put(Draft.COLUMN_IMAGE, draft.getImage()); values.put(Draft.COLUMN_CAPTION, draft.getCaption()); values.put(Draft.COLUMN_VIDEO, draft.getVideo()); values.put(Draft.COLUMN_AUDIO, draft.getAudio()); values.put(Draft.COLUMN_TAGS, draft.getTags()); values.put(Draft.COLUMN_URL, draft.getUrl()); values.put(Draft.COLUMN_START_DATE, draft.getStartDate()); values.put(Draft.COLUMN_END_DATE, draft.getEndDate()); values.put(Draft.COLUMN_SYNDICATION_TARGETS, draft.getSyndicationTargets()); values.put(Draft.COLUMN_PUBLISH_DATE, draft.getPublishDate()); values.put(Draft.COLUMN_LOCATION_NAME, draft.getLocationName()); values.put(Draft.COLUMN_LOCATION_URL, draft.getLocationUrl()); values.put(Draft.COLUMN_LOCATION_VISIBILITY, draft.getLocationVisibility()); values.put(Draft.COLUMN_SPINNER, draft.getSpinner()); values.put(Draft.COLUMN_COORDINATES, draft.getCoordinates()); if (draft.getId() > 0) { db.update(Draft.TABLE_NAME, values, Draft.COLUMN_ID + "=" + draft.getId(), null); } else { db.insert(Draft.TABLE_NAME, null, values); } db.close(); }
Example 12
Source Project: QuranAndroid File: DatabaseHandler.java License: GNU General Public License v3.0 | 5 votes |
public int updateContact(Contact contact) { SQLiteDatabase db = this.getWritableDatabase(); ContentValues values = new ContentValues(); //values.put(KEY_NAME, contact.getName()); values.put(KEY_PH_NO, contact.getPhoneNumber()); // updating row return db.update(TABLE_CONTACTS, values, KEY_ID + " = ?", new String[] { String.valueOf(contact.getID()) }); }
Example 13
Source Project: weMessage File: MessageDatabase.java License: GNU Affero General Public License v3.0 | 5 votes |
protected void updateChat(String uuid, Chat newData){ SQLiteDatabase db = getWritableDatabase(); ContentValues values = chatToContentValues(newData); String selection = ChatTable.UUID + " = ?"; db.update(ChatTable.TABLE_NAME, values, selection, new String[]{ uuid }); }
Example 14
Source Project: UltimateAndroid File: TeamDAO.java License: Apache License 2.0 | 5 votes |
private Team updateExistingTeam(SQLiteDatabase db, Team team) { Logger.d("Updating team with the name of '" + team.getName() + "'"); ContentValues values = new ContentValues(); values.put(TEAMS_NAME, team.getName()); long id = db.update(TEAMS_TABLE_NAME, values, _ID + " = ?", new String[]{team.getId().toString()}); return new Team(id, team.getName()); }
Example 15
Source Project: Silence File: SmsDatabase.java License: GNU General Public License v3.0 | 5 votes |
public void markAsNotified(long id) { SQLiteDatabase database = databaseHelper.getWritableDatabase(); ContentValues contentValues = new ContentValues(); contentValues.put(NOTIFIED, 1); database.update(TABLE_NAME, contentValues, ID_WHERE, new String[] {String.valueOf(id)}); }
Example 16
Source Project: java-unified-sdk File: AndroidDatabaseDelegate.java License: Apache License 2.0 | 5 votes |
public int update(String table, Map<String, Object> attrs, String whereClause, String[] whereArgs) { try { SQLiteDatabase db = dbHelper.getWritableDatabase(); ContentValues values = transferMap(attrs); return db.update(table, values, whereClause, whereArgs); } catch (Exception ex) { LOGGER.w("failed to execute update instrument. cause: " + ex.getMessage()); return 0; } }
Example 17
Source Project: Hify File: UserHelper.java License: MIT License | 4 votes |
public void updateContactPassword(Integer id, String password) { SQLiteDatabase db = this.getWritableDatabase(); ContentValues contentValues = new ContentValues(); contentValues.put("password", password); db.update("user", contentValues, "id = ? ", new String[] { Integer.toString(id) } ); }
Example 18
Source Project: tindroid File: TopicDb.java License: Apache License 2.0 | 4 votes |
/** * Update topic description * * @return true if the record was updated, false otherwise */ public static boolean update(SQLiteDatabase db, Topic topic) { StoredTopic st = (StoredTopic) topic.getLocal(); if (st == null) { return false; } BaseDb.Status status = st.status; // Convert topic description to a map of values ContentValues values = new ContentValues(); if (st.status == BaseDb.Status.QUEUED && !topic.isNew()) { status = BaseDb.Status.SYNCED; values.put(COLUMN_NAME_STATUS, status.value); values.put(COLUMN_NAME_TOPIC, topic.getName()); } if (topic.getUpdated() != null) { values.put(COLUMN_NAME_UPDATED, topic.getUpdated().getTime()); } values.put(COLUMN_NAME_READ, topic.getRead()); values.put(COLUMN_NAME_RECV, topic.getRecv()); values.put(COLUMN_NAME_SEQ, topic.getSeq()); values.put(COLUMN_NAME_CLEAR, topic.getClear()); values.put(COLUMN_NAME_ACCESSMODE, BaseDb.serializeMode(topic.getAccessMode())); values.put(COLUMN_NAME_DEFACS, BaseDb.serializeDefacs(topic.getDefacs())); values.put(COLUMN_NAME_TAGS, BaseDb.serializeStringArray(topic.getTags())); if (topic.getLastSeen() != null) { values.put(COLUMN_NAME_LAST_SEEN, topic.getLastSeen().getTime()); } if (topic.getLastSeenUA() != null) { values.put(COLUMN_NAME_LAST_SEEN_UA, topic.getLastSeenUA()); } if (topic instanceof MeTopic) { values.put(COLUMN_NAME_CREDS, BaseDb.serialize(((MeTopic) topic).getCreds())); } values.put(COLUMN_NAME_PUBLIC, BaseDb.serialize(topic.getPub())); values.put(COLUMN_NAME_PRIVATE, BaseDb.serialize(topic.getPriv())); Date lastUsed = topic.getTouched(); if (lastUsed != null) { values.put(COLUMN_NAME_LASTUSED, lastUsed.getTime()); } int updated = db.update(TABLE_NAME, values, _ID + "=" + st.id, null); if (updated > 0) { if (lastUsed != null) { st.lastUsed = lastUsed; } st.status = status; } return updated > 0; }
Example 19
Source Project: fanfouapp-opensource File: FanFouProvider.java License: Apache License 2.0 | 4 votes |
@Override public int update(final Uri uri, final ContentValues values, final String where, final String[] whereArgs) { // log("update() uri = " + uri + " where= (" + where + ") whereArgs = " // + StringHelper.toString(whereArgs)); final SQLiteDatabase db = this.dbHelper.getWritableDatabase(); int count; String id; String _id; switch (FanFouProvider.sUriMatcher.match(uri)) { case USER_ID: id = uri.getPathSegments().get(2); count = db.update(UserInfo.TABLE_NAME, values, BasicColumns.ID + "=?", new String[] { id }); break; case STATUS_ID: id = uri.getPathSegments().get(2); count = db.update(StatusInfo.TABLE_NAME, values, BasicColumns.ID + "=?", new String[] { id }); // count = db.update(StatusInfo.TABLE_NAME, values, // StatusInfo.ID // + "=" // + statusId // + (!TextUtils.isEmpty(where) ? " AND (" + where // + ')' : ""), whereArgs); break; case MESSAGE_ITEM: id = uri.getPathSegments().get(2); count = db.update(DirectMessageInfo.TABLE_NAME, values, BasicColumns.ID + "=?", new String[] { id }); // count = db.update( // DirectMessageInfo.TABLE_NAME, // values, // DirectMessageInfo.ID // + "=" // + messageId // + (!TextUtils.isEmpty(where) ? " AND (" + where // + ')' : ""), whereArgs); break; case MESSAGE_ID: _id = uri.getPathSegments().get(2); id = _id; count = db.update(DirectMessageInfo.TABLE_NAME, values, BaseColumns._ID + "=?", new String[] { _id }); break; case USERS_ALL: id = ""; count = db.update(UserInfo.TABLE_NAME, values, where, whereArgs); break; case USER_TYPE: id = ""; count = db.update(UserInfo.TABLE_NAME, values, BasicColumns.TYPE + "=?", new String[] { uri.getPathSegments().get(2) }); break; case STATUSES_ALL: id = ""; count = db.update(StatusInfo.TABLE_NAME, values, where, whereArgs); break; // case PUBLIC: // id = ""; // count = db.update(StatusInfo.PUBLIC_TABLE_NAME, values, where, // whereArgs); // break; case MESSAGES_ALL: id = ""; count = db.update(DirectMessageInfo.TABLE_NAME, values, where, whereArgs); break; case DRAFT_ALL: case DRAFT_ID: throw new UnsupportedOperationException( "unsupported update action: " + uri); default: throw new IllegalArgumentException("update() Unknown URI " + uri); } if (AppContext.DEBUG) { if (count > 0) { log("update() result uri=" + uri + " id=" + id + " count=" + count); } } getContext().getContentResolver().notifyChange(uri, null); return count; }
Example 20
Source Project: Study_Android_Demo File: HistoryManager.java License: Apache License 2.0 | 4 votes |
public void addHistoryItemDetails(String itemID, String itemDetails) { // As we're going to do an update only we don't need need to worry // about the preferences; if the item wasn't saved it won't be udpated SQLiteOpenHelper helper = new DBHelper(activity); SQLiteDatabase db = null; Cursor cursor = null; try { db = helper.getWritableDatabase(); cursor = db.query(DBHelper.TABLE_NAME, ID_DETAIL_COL_PROJECTION, DBHelper.TEXT_COL + "=?", new String[] { itemID }, null, null, DBHelper.TIMESTAMP_COL + " DESC", "1"); String oldID = null; String oldDetails = null; if (cursor.moveToNext()) { oldID = cursor.getString(0); oldDetails = cursor.getString(1); } if (oldID != null) { String newDetails; if (oldDetails == null) { newDetails = itemDetails; } else if (oldDetails.contains(itemDetails)) { newDetails = null; } else { newDetails = oldDetails + " : " + itemDetails; } if (newDetails != null) { ContentValues values = new ContentValues(); values.put(DBHelper.DETAILS_COL, newDetails); db.update(DBHelper.TABLE_NAME, values, DBHelper.ID_COL + "=?", new String[] { oldID }); } } } finally { close(cursor, db); } }