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

Refine search

SQLiteDatabase.endTransaction

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

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
  if (newVersion != oldVersion) {
    db.beginTransaction();
    try {
      db.execSQL(SQL_DELETE_TABLE);
      db.execSQL(SQL_CREATE_TABLE);
      db.execSQL(SQL_CREATE_UNIQUE_INDEX);
      db.setTransactionSuccessful();
    } finally {
      db.endTransaction();
    }
  }
}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
  if (newVersion != oldVersion) {
    db.beginTransaction();
    try {
      db.execSQL(SQL_DELETE_TABLE);
      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 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 synchronized void update(long playlistid, int count, String album) {
  final SQLiteDatabase database = mMusicDatabase.getWritableDatabase();
  database.beginTransaction();
  try {
    ContentValues values = new ContentValues(3);
    values.put(PlaylistInfoColumns.PLAYLIST_ID, playlistid);
    values.put(PlaylistInfoColumns.SONG_COUNT, count);
    values.put(PlaylistInfoColumns.ALBUM_ART, album);
    database.update(PlaylistInfoColumns.NAME, values, PlaylistInfoColumns.PLAYLIST_ID + " = " + playlistid, null);
    database.setTransactionSuccessful();
  } finally {
    database.endTransaction();
  }
}

public synchronized void update(long playlistid, long[] ids, int[] order) {
  final SQLiteDatabase database = mMusicDatabase.getWritableDatabase();
  database.beginTransaction();
  try {
    for (int i = 0; i < order.length; i++) {
      ContentValues values = new ContentValues(1);
      values.put(PlaylistsColumns.TRACK_ORDER, order[i]);
      database.update(PlaylistsColumns.NAME, values, PlaylistsColumns.PLAYLIST_ID + " = ?" + " AND " +
          PlaylistsColumns.TRACK_ID + " = ?", new String[]{playlistid + "", ids[i] + ""});
    }
    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();
  }
}

public synchronized void addPlaylist(long playlistid, String name, int count, String albumart, String author) {
  final SQLiteDatabase database = mMusicDatabase.getWritableDatabase();
  database.beginTransaction();
  try {
    ContentValues values = new ContentValues(5);
    values.put(PlaylistInfoColumns.PLAYLIST_ID, playlistid);
    values.put(PlaylistInfoColumns.PLAYLIST_NAME, name);
    values.put(PlaylistInfoColumns.SONG_COUNT, count);
    values.put(PlaylistInfoColumns.ALBUM_ART, albumart);
    values.put(PlaylistInfoColumns.AUTHOR, author);
    database.insert(PlaylistInfoColumns.NAME, null, values);
    database.setTransactionSuccessful();
  } finally {
    database.endTransaction();
  }
}

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

public synchronized void addPlaylist(ArrayList<Playlist> playlists) {
  final SQLiteDatabase database = mMusicDatabase.getWritableDatabase();
  database.beginTransaction();
  try {
    for (int i = 0; i < playlists.size(); i++) {
      ContentValues values = new ContentValues(5);
      values.put(PlaylistInfoColumns.PLAYLIST_ID, playlists.get(i).id);
      values.put(PlaylistInfoColumns.PLAYLIST_NAME, playlists.get(i).name);
      values.put(PlaylistInfoColumns.SONG_COUNT, playlists.get(i).songCount);
      values.put(PlaylistInfoColumns.ALBUM_ART, playlists.get(i).albumArt);
      values.put(PlaylistInfoColumns.AUTHOR, playlists.get(i).author);
      database.insert(PlaylistInfoColumns.NAME, null, values);
    }
    database.setTransactionSuccessful();
  } finally {
    database.endTransaction();
  }
}

@Override
public void substitute(@NonNull JobHolder newJob, @NonNull JobHolder oldJob) {
  db.beginTransaction();
  try {
    remove(oldJob);
    insert(newJob);
    db.setTransactionSuccessful();
  } finally {
    db.endTransaction();
  }
}

/** 更新一条记录 */
public boolean update(ContentValues contentValues, String whereClause, String[] whereArgs) {
  long start = System.currentTimeMillis();
  lock.lock();
  try {
    database.beginTransaction();
    database.update(getTableName(), contentValues, whereClause, whereArgs);
    database.setTransactionSuccessful();
    return true;
  } catch (Exception e) {
    OkLogger.printStackTrace(e);
  } finally {
    database.endTransaction();
    lock.unlock();
    OkLogger.v(TAG, System.currentTimeMillis() - start + " updateContentValues");
  }
  return false;
}

/** 根据条件删除数据库中的数据 */
public boolean delete(String whereClause, String[] whereArgs) {
  long start = System.currentTimeMillis();
  lock.lock();
  try {
    database.beginTransaction();
    database.delete(getTableName(), whereClause, whereArgs);
    database.setTransactionSuccessful();
    return true;
  } catch (Exception e) {
    OkLogger.printStackTrace(e);
  } finally {
    database.endTransaction();
    lock.unlock();
    OkLogger.v(TAG, System.currentTimeMillis() - start + " delete");
  }
  return false;
}

public boolean deleteList(List<Pair<String, String[]>> where) {
  long start = System.currentTimeMillis();
  lock.lock();
  try {
    database.beginTransaction();
    for (Pair<String, String[]> pair : where) {
      database.delete(getTableName(), pair.first, pair.second);
    }
    database.setTransactionSuccessful();
    return true;
  } catch (Exception e) {
    OkLogger.printStackTrace(e);
  } finally {
    database.endTransaction();
    lock.unlock();
    OkLogger.v(TAG, System.currentTimeMillis() - start + " deleteList");
  }
  return false;
}

@Override public void syncCacheToDB(List<Integer> idList) throws IOException {
  final SQLiteDatabase database = sqLiteHelper.getWritableDatabase();
  database.beginTransaction();
  try {
    for (Integer id : idList) {
      syncCacheToDB(id);
    }
    database.setTransactionSuccessful();
  } finally {
    database.endTransaction();
  }
}

Popular methods of SQLiteDatabase

Popular in Java

Making http post requests using okhttp
runOnUiThread (Activity)
scheduleAtFixedRate (Timer)
Schedules the specified task for repeated fixed-rate execution, beginning after the specified delay.
getContentResolver (Context)
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 beginTransactionmethodin android.database.sqlite.SQLiteDatabase

Best Java code snippets using android.database.sqlite.SQLiteDatabase.beginTransaction (Showing top 20 results out of 1,989)

Refine search

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