- Common ways to obtain SQLiteDatabase
private void myMethod () {SQLiteDatabase s =
SQLiteOpenHelper dbHelper;dbHelper.getWritableDatabase()
WeatherDbHelper dbHelper;dbHelper.getWritableDatabase()
SQLiteOpenHelper dbHelper;dbHelper.getReadableDatabase()
- Smart code suggestions by Codota
}
@Override public void setTransactionSuccessful() { delegate.setTransactionSuccessful(); }
@Override public void onCreate(SQLiteDatabase db) { db.beginTransaction(); try { db.execSQL(SQL_CREATE_TABLE); db.execSQL(SQL_CREATE_UNIQUE_INDEX); db.setTransactionSuccessful(); } finally { db.endTransaction(); } }
@Override public void onCreate(SQLiteDatabase db) { db.beginTransaction(); try { db.execSQL(SQL_CREATE_TABLE); db.execSQL(SQL_CREATE_UNIQUE_INDEX); db.setTransactionSuccessful(); } finally { db.endTransaction(); } }
public synchronized void Delete(long id) { final SQLiteDatabase database = mMusicDatabase.getWritableDatabase(); database.beginTransaction(); try { database.delete(PlaybackQueueColumns.NAME, PlaybackQueueColumns.TRACK_ID + " = " + id, null); database.setTransactionSuccessful(); } finally { database.endTransaction(); } }
public synchronized void clearQueue() { final SQLiteDatabase database = mMusicDatabase.getWritableDatabase(); try { database.delete(PlaybackQueueColumns.NAME, null, null); database.setTransactionSuccessful(); } catch (Exception e) { } }
public void delete(String fileName) { SQLiteDatabase sqLiteDatabase = getWritableDatabase(); sqLiteDatabase.beginTransaction(); try { sqLiteDatabase.delete(TABLE_NAME, "FileName=?", new String[]{fileName}); sqLiteDatabase.setTransactionSuccessful(); } finally { sqLiteDatabase.endTransaction(); } }
public synchronized void update(long playlistid, long id, int order) { final SQLiteDatabase database = mMusicDatabase.getWritableDatabase(); database.beginTransaction(); try { ContentValues values = new ContentValues(1); values.put(PlaylistsColumns.TRACK_ORDER, order); database.update(PlaylistsColumns.NAME, values, PlaylistsColumns.PLAYLIST_ID + " = ?" + " AND " + PlaylistsColumns.TRACK_ID + " = ?", new String[]{playlistid + "", id + ""}); database.setTransactionSuccessful(); } finally { database.endTransaction(); } }
public synchronized void Insert(MusicTrack track) { final SQLiteDatabase database = mMusicDatabase.getWritableDatabase(); database.beginTransaction(); try { ContentValues values = new ContentValues(2); values.put(PlaybackQueueColumns.TRACK_ID, track.mId); values.put(PlaybackQueueColumns.SOURCE_POSITION, track.mSourcePosition); database.insert(PlaybackQueueColumns.NAME, null, values); database.setTransactionSuccessful(); } finally { database.endTransaction(); } }
public synchronized void update(long playlistid, int count) { final SQLiteDatabase database = mMusicDatabase.getWritableDatabase(); database.beginTransaction(); try { ContentValues values = new ContentValues(2); values.put(PlaylistInfoColumns.PLAYLIST_ID, playlistid); //values.put(PlaylistInfoColumns.PLAYLIST_NAME, name); values.put(PlaylistInfoColumns.SONG_COUNT, count); database.update(PlaylistInfoColumns.NAME, values, PlaylistInfoColumns.PLAYLIST_ID + " = " + playlistid, null); database.setTransactionSuccessful(); } finally { database.endTransaction(); } }
/** 用于给外界提供事物开启的模板 */ public void startTransaction(Action action) { lock.lock(); try { database.beginTransaction(); action.call(database); database.setTransactionSuccessful(); } catch (Exception e) { OkLogger.printStackTrace(e); } finally { database.endTransaction(); lock.unlock(); } }
private void insert(CacheFileInfo cacheFileInfo) { SQLiteDatabase sqLiteDatabase = getWritableDatabase(); sqLiteDatabase.beginTransaction(); try { ContentValues cv = packData(cacheFileInfo); sqLiteDatabase.insert(TABLE_NAME, null, cv); sqLiteDatabase.setTransactionSuccessful(); } finally { sqLiteDatabase.endTransaction(); } }
@Override public void substitute(@NonNull JobHolder newJob, @NonNull JobHolder oldJob) { db.beginTransaction(); try { remove(oldJob); insert(newJob); db.setTransactionSuccessful(); } finally { db.endTransaction(); } }
private void update(CacheFileInfo cacheFileSize) { SQLiteDatabase sqLiteDatabase = getWritableDatabase(); sqLiteDatabase.beginTransaction(); try { ContentValues cv = packData(cacheFileSize); sqLiteDatabase.update(TABLE_NAME, cv, "FileName=?", new String[]{cacheFileSize.getFileName()}); sqLiteDatabase.setTransactionSuccessful(); } finally { sqLiteDatabase.endTransaction(); } }
@Override public ContentProviderResult[] applyBatch(ArrayList<ContentProviderOperation> operations) throws OperationApplicationException { SQLiteDatabase db = mOpenHelper.getWritableDatabase(); db.beginTransaction(); try { ContentProviderResult[] results = super.applyBatch(operations); db.setTransactionSuccessful(); return results; } finally { db.endTransaction(); notifyChange(); } }
public boolean replace(ContentValues contentValues) { long start = System.currentTimeMillis(); lock.lock(); try { database.beginTransaction(); database.replace(getTableName(), null, contentValues); database.setTransactionSuccessful(); return true; } catch (Exception e) { OkLogger.printStackTrace(e); } finally { database.endTransaction(); lock.unlock(); OkLogger.v(TAG, System.currentTimeMillis() - start + " replaceContentValues"); } return false; }
private <E> List<E> requestAndStore(final SQLiteOpenHelper helper, final PersistableResource<E> persistableResource) throws IOException { final List<E> items = persistableResource.request(); final SQLiteDatabase db = getWritable(helper); if (db == null) { return items; } db.beginTransaction(); try { persistableResource.store(db, items); db.setTransactionSuccessful(); } finally { db.endTransaction(); } return items; }
@Test public void testSuccessNestedTransaction() throws Exception { database.beginTransaction(); database.execSQL("INSERT INTO table_name (id, name) VALUES(1234, 'Chuck');"); database.beginTransaction(); database.execSQL("INSERT INTO table_name (id, name) VALUES(12345, 'Julie');"); database.setTransactionSuccessful(); database.endTransaction(); database.setTransactionSuccessful(); database.endTransaction(); Cursor cursor = database.rawQuery("SELECT COUNT(*) FROM table_name", null); assertThat(cursor.moveToNext()).isTrue(); assertThat(cursor.getInt(0)).isEqualTo(2); }
@Test public void testSuccessTransaction() throws Exception { database.beginTransaction(); database.execSQL("INSERT INTO table_name (id, name) VALUES(1234, 'Chuck');"); database.setTransactionSuccessful(); database.endTransaction(); Cursor cursor = database.rawQuery("SELECT COUNT(*) FROM table_name", null); assertThat(cursor.moveToNext()).isTrue(); assertThat(cursor.getInt(0)).isEqualTo(1); }
@Test public void testFailureNestedTransaction() throws Exception { database.beginTransaction(); database.execSQL("INSERT INTO table_name (id, name) VALUES(1234, 'Chuck');"); database.beginTransaction(); database.execSQL("INSERT INTO table_name (id, name) VALUES(12345, 'Julie');"); database.endTransaction(); database.setTransactionSuccessful(); database.endTransaction(); Cursor cursor = database.rawQuery("SELECT COUNT(*) FROM table_name", null); assertThat(cursor.moveToNext()).isTrue(); assertThat(cursor.getInt(0)).isEqualTo(0); }
@Test public void testTransactionAlreadySuccessful() { database.beginTransaction(); database.setTransactionSuccessful(); try { database.setTransactionSuccessful(); fail("didn't receive the expected IllegalStateException"); } catch (IllegalStateException e) { assertThat(e.getMessage()).contains("transaction"); assertThat(e.getMessage()).contains("successful"); } }