SQLiteDatabase db = this.getWritableDatabase(); ContentValues contentValues = new ContentValues(); contentValues.put(COLUMN_ID, id); contentValues.put(COLUMN_VALUE, value); // this will insert if record is new, update otherwise db.insertWithOnConflict(TABLE, null, contentValues, SQLiteDatabase.CONFLICT_REPLACE);
public void insertHasRead(String table, String key, int value) { Cursor cursor = mSQLiteDatabase.query(table, null, null, null, null, null, "id asc"); if (cursor.getCount() > 200 && cursor.moveToNext()) { mSQLiteDatabase.delete(table, "id=?", new String[]{String.valueOf(cursor.getInt(cursor.getColumnIndex("id")))}); } cursor.close(); ContentValues contentValues = new ContentValues(); contentValues.put("key", key); contentValues.put("is_read", value); mSQLiteDatabase.insertWithOnConflict(table, null, contentValues, SQLiteDatabase.CONFLICT_REPLACE); }
@NonNull @Override public Result<Long> merge(@NonNull final SQLiteDatabase database, @NonNull final SqlInsertRequest input) { try { return success(database.insertWithOnConflict(input.table, null, input.contentValues, input.conflictAlgorithm)); } catch (final SQLException e) { return failure(e); } } }
public Uri insert(Uri uri, ContentValues values) { final SQLiteDatabase db = mOpenHelper.getWritableDatabase(); String selection = "latitude=? AND longitude=?"; String[] selectionArgs = new String[] {values.getAsString("latitude"), values.getAsString("longitude")}; //Do an update if the constraints match db.update(DatabaseProperties.TABLE_NAME, values, selection, null); //This will return the id of the newly inserted row if no conflict //It will also return the offending row without modifying it if in conflict long id = db.insertWithOnConflict(DatabaseProperties.TABLE_NAME, null, values, CONFLICT_IGNORE); return ContentUris.withAppendedId(uri, id); }
values.put(PlaylistsColumns.PATH, info.data); values.put(PlaylistsColumns.IS_LOCAL, info.islocal); database.insertWithOnConflict(PlaylistsColumns.NAME, null, values, SQLiteDatabase.CONFLICT_REPLACE);
@Test public void testInsertKeyGeneration() throws Exception { ContentValues values = new ContentValues(); values.put("name", "Chuck"); long key = database.insertWithOnConflict("table_name", null, values, SQLiteDatabase.CONFLICT_IGNORE); assertThat(key).isNotEqualTo(0L); }
values.put(PlaylistsColumns.PATH, info.data); values.put(PlaylistsColumns.IS_LOCAL, info.islocal); database.insertWithOnConflict(PlaylistsColumns.NAME, null, values, SQLiteDatabase.CONFLICT_REPLACE); database.setTransactionSuccessful(); } finally {
private void store(JobRequest request) { ContentValues contentValues = request.toContentValues(); SQLiteDatabase database = null; try { database = getDatabase(); /* * It could happen that a conflict with the job ID occurs, when a job was cancelled (cancelAndEdit()) * the builder object scheduled twice. In this case the last call wins and the value in the database * will be overwritten. */ if (database.insertWithOnConflict(JOB_TABLE_NAME, null, contentValues, SQLiteDatabase.CONFLICT_REPLACE) < 0) { throw new SQLException("Couldn't insert job request into database"); } } finally { closeDatabase(database); } }
@Test public void testInsertEmptyBlobArgument() throws Exception { ContentValues emptyBlobValues = new ContentValues(); emptyBlobValues.put("id", 1); emptyBlobValues.put("blob_col", new byte[]{}); ContentValues nullBlobValues = new ContentValues(); nullBlobValues.put("id", 2); nullBlobValues.put("blob_col", (byte[])null); long key = database.insertWithOnConflict("blob_table", null, emptyBlobValues, SQLiteDatabase.CONFLICT_FAIL); assertThat(key).isNotEqualTo(0L); key = database.insertWithOnConflict("blob_table", null, nullBlobValues, SQLiteDatabase.CONFLICT_FAIL); assertThat(key).isNotEqualTo(0L); Cursor cursor = database.query("blob_table", new String[]{"blob_col"}, "id=1", null, null, null, null); try { assertThat(cursor.moveToFirst()).isTrue(); assertThat(cursor.getBlob(cursor.getColumnIndexOrThrow("blob_col"))).isNotNull(); } finally { cursor.close(); } cursor = database.query("blob_table", new String[]{"blob_col"}, "id=2", null, null, null, null); try { assertThat(cursor.moveToFirst()).isTrue(); assertThat(cursor.getBlob(cursor.getColumnIndexOrThrow("blob_col"))).isNull(); } finally { cursor.close(); } }
@Test(expected = SQLException.class) public void testInsertFails() { SQLiteDatabase database = mock(SQLiteDatabase.class); when(database.insert(anyString(), nullable(String.class), any(ContentValues.class))).thenReturn(-1L); when(database.insertWithOnConflict(anyString(), nullable(String.class), any(ContentValues.class), anyInt())).thenThrow(SQLException.class); manager().getJobStorage().injectDatabase(database); DummyJobs.createOneOff().schedule(); }
@Override public Long then(Task<Void> task) { return db.insertWithOnConflict(table, null, values, conflictAlgorithm); } }, dbExecutor);
public void addOne(String questType) { SQLiteDatabase db = dbHelper.getWritableDatabase(); // first ensure the row exists ContentValues values = new ContentValues(); values.put(QuestStatisticsTable.Columns.QUEST_TYPE, questType); values.put(QuestStatisticsTable.Columns.SUCCEEDED, 0); db.insertWithOnConflict(QuestStatisticsTable.NAME, null, values, SQLiteDatabase.CONFLICT_IGNORE); // then increase by one String[] args = {questType}; db.execSQL("UPDATE " + QuestStatisticsTable.NAME + " SET " + QuestStatisticsTable.Columns.SUCCEEDED + " = " + QuestStatisticsTable.Columns.SUCCEEDED + " + 1 WHERE " + QuestStatisticsTable.Columns.QUEST_TYPE + " = ?", args); }
ContentValues values = new ContentValues(); values.put("YOURCOLUMNNAME", "1-Preludi \"Obrint Pas 2011\""); // ... other stuff you want to insert ... SQLiteDatabase db = ... ; // Usually obtained using a SQLiteOpenHelper long id = db.insertWithOnConflict("EXAMPLETABLE", BaseColumns._ID, values, SQLiteDatabase.CONFLICT_IGNORE);
SQLiteDatabase db; long rows = 0; db = this.getWritableDatabase(); ContentValues Val = new ContentValues(); Val.put("IDD", idd); Val.put("Category", cat); rows = db.insertWithOnConflict(tableName, null, contentValues,SQLiteDatabase.CONFLICT_REPLACE);
public void putResVer(String filename, long version) { SQLiteDatabase db = this.getWritableDatabase(); ContentValues values = new ContentValues(); values.put("file", filename); values.put("version", version); int u = db.update(resver_table_name, values, "file=?", new String[]{filename}); if (u == 0) { db.insertWithOnConflict(resver_table_name, null, values, SQLiteDatabase.CONFLICT_REPLACE); } }
public void putValue(String key, String value) { SQLiteDatabase db = this.getWritableDatabase(); ContentValues values = new ContentValues(); values.put("KEY", key); values.put("VALUE", value); int u = db.update(table_name, values, "KEY=?", new String[]{key}); if (u == 0) { db.insertWithOnConflict(table_name, null, values, SQLiteDatabase.CONFLICT_REPLACE); } }
@Override public void onClick(DialogInterface dialogInterface, int i) { String task = inputField.getText().toString(); helper = new TaskDBHelper(MainActivity.this); SQLiteDatabase db = helper.getWritableDatabase(); ContentValues values = new ContentValues(); values.clear(); values.put(TaskContract.Columns.TASK, task); db.insertWithOnConflict(TaskContract.TABLE, null, values, SQLiteDatabase.CONFLICT_IGNORE); updateUI(); } });
public void addChannelUserMapper(ChannelUserMapper channelUserMapper) { try { ContentValues contentValues = prepareChannelUserMapperValues(channelUserMapper); dbHelper.getWritableDatabase().insertWithOnConflict(CHANNEL_USER_X, null, contentValues, SQLiteDatabase.CONFLICT_REPLACE); } catch (Exception e) { e.printStackTrace(); } finally { dbHelper.close(); } }
public void addChannel(Channel channel) { try { ContentValues contentValues = prepareChannelValues(channel); dbHelper.getWritableDatabase().insertWithOnConflict(CHANNEL, null, contentValues, SQLiteDatabase.CONFLICT_REPLACE); } catch (Exception e) { e.printStackTrace(); } finally { dbHelper.close(); } }
public int insert(String table, Map<String, Object> attrs) { try { SQLiteDatabase db = dbHelper.getWritableDatabase(); ContentValues values = transferMap(attrs); return (int)db.insertWithOnConflict(table, null, values, SQLiteDatabase.CONFLICT_IGNORE); } catch (Exception ex) { LOGGER.w("failed to execute insert instrument. cause: " + ex.getMessage()); return -1; } } public int queryCount(String table, String[] columns, String selection,