android.database.sqlite.SQLiteDatabase.setTransactionSuccessful java code examples

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");
  }
}

Popular methods of SQLiteDatabase

Popular in Java

Making http post requests using okhttp
getContentResolver (Context)
runOnUiThread (Activity)
scheduleAtFixedRate (Timer)
Schedules the specified task for repeated fixed-rate execution, beginning after the specified delay.
Graphics2D (java.awt)
This Graphics2D class extends the Graphics class to provide more sophisticated control overgraphics
OutputStream (java.io)
A writable sink for bytes.Most clients will use output streams that write data to the file system (
Charset (java.nio.charset)
A charset is a named mapping between Unicode characters and byte sequences. Every Charset can decode
Time (java.sql)
Java representation of an SQL TIME value. Provides utilities to format and parse the time's represen
Timestamp (java.sql)
A Java representation of the SQL TIMESTAMP type. It provides the capability of representing the SQL
Dictionary (java.util)
The Dictionary class is the abstract parent of any class, such as Hashtable, which maps keys to valu

How to use setTransactionSuccessfulmethodin android.database.sqlite.SQLiteDatabase

Best Java code snippets using android.database.sqlite.SQLiteDatabase.setTransactionSuccessful (Showing top 20 results out of 2,007)

How to use
setTransactionSuccessful
method
in
android.database.sqlite.SQLiteDatabase