Codota Logo
SQLiteDatabase.beginTransaction
Code IndexAdd Codota to your IDE (free)

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

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

Refine searchRefine arrow

  • SQLiteDatabase.endTransaction
  • Common ways to obtain SQLiteDatabase
private void myMethod () {
SQLiteDatabase s =
  • Codota IconSQLiteOpenHelper dbHelper;dbHelper.getWritableDatabase()
  • Codota IconWeatherDbHelper dbHelper;dbHelper.getWritableDatabase()
  • Codota IconSQLiteOpenHelper dbHelper;dbHelper.getReadableDatabase()
  • Smart code suggestions by Codota
}
origin: yanzhenjie/NoHttp

@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();
  }
}
origin: yanzhenjie/NoHttp

@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();
  }
}
origin: yanzhenjie/NoHttp

@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();
    }
  }
}
origin: yanzhenjie/NoHttp

@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();
    }
  }
}
origin: aa112901/remusic

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();
  }
}
origin: aa112901/remusic

public void delete(String fileName) {
  SQLiteDatabase sqLiteDatabase = getWritableDatabase();
  sqLiteDatabase.beginTransaction();
  try {
    sqLiteDatabase.delete(TABLE_NAME, "FileName=?", new String[]{fileName});
    sqLiteDatabase.setTransactionSuccessful();
  } finally {
    sqLiteDatabase.endTransaction();
  }
}
origin: aa112901/remusic

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();
  }
}
origin: aa112901/remusic

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();
  }
}
origin: aa112901/remusic

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();
  }
}
origin: aa112901/remusic

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();
  }
}
origin: aa112901/remusic

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();
  }
}
origin: jeasonlzy/okhttp-OkGo

/** 用于给外界提供事物开启的模板 */
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();
  }
}
origin: aa112901/remusic

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();
  }
}
origin: aa112901/remusic

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();
  }
}
origin: aa112901/remusic

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();
  }
}
origin: yigit/android-priority-jobqueue

@Override
public void substitute(@NonNull JobHolder newJob, @NonNull JobHolder oldJob) {
  db.beginTransaction();
  try {
    remove(oldJob);
    insert(newJob);
    db.setTransactionSuccessful();
  } finally {
    db.endTransaction();
  }
}
origin: jeasonlzy/okhttp-OkGo

/** 更新一条记录 */
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;
}
origin: jeasonlzy/okhttp-OkGo

/** 根据条件删除数据库中的数据 */
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;
}
origin: jeasonlzy/okhttp-OkGo

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;
}
origin: lingochamp/okdownload

@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();
  }
}
android.database.sqliteSQLiteDatabasebeginTransaction

Popular methods of SQLiteDatabase

  • execSQL
  • insert
  • delete
  • query
  • rawQuery
  • close
  • update
  • endTransaction
  • setTransactionSuccessful
  • isOpen
  • compileStatement
  • getVersion
  • compileStatement,
  • getVersion,
  • insertWithOnConflict,
  • openDatabase,
  • insertOrThrow,
  • replace,
  • getPath,
  • openOrCreateDatabase,
  • setVersion

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
Codota Logo
  • Products

    Search for Java codeSearch for JavaScript codeEnterprise
  • IDE Plugins

    IntelliJ IDEAWebStormAndroid StudioEclipseVisual Studio CodePyCharmSublime TextPhpStormVimAtomGoLandRubyMineEmacsJupyter
  • Company

    About UsContact UsCareers
  • Resources

    FAQBlogCodota Academy Plugin user guide Terms of usePrivacy policyJava Code IndexJavascript Code Index
Get Codota for your IDE now