Java BriteDatabase.Transaction方法代码示例

import com.squareup.sqlbrite.BriteDatabase; //导入方法依赖的package包/类
/**
 * 更新TaskBundle
 */
public void updateTaskBundle(TaskBundle taskBundle) {

  //更新 有可能是
  if (taskBundle.getTaskList() == null || taskBundle.getTaskList().size() == 0) {
    db.update(TaskBundle.TASK_BUNDLE_TABLE_NAME, getTaskBundleValues(taskBundle),
        TaskBundle.COLUMN_KEY + "=?", taskBundle.getKey());
  } else {
    if (!isExistTaskEntity(taskBundle.getBundleId())) {
      BriteDatabase.Transaction transaction = db.newTransaction();
      db.update(TaskBundle.TASK_BUNDLE_TABLE_NAME, getTaskBundleValues(taskBundle),
          TaskBundle.COLUMN_KEY + "=?", taskBundle.getKey());
      int nextTaskId = getNextID(db, TaskEntity.TASK_TABLE_NAME, TaskEntity.COLUMN_TASK_ID);
      for (TaskEntity taskEntity : taskBundle.getTaskList()) {
        taskEntity.setTaskBundleId(taskBundle.getBundleId());
        taskEntity.setTaskId(nextTaskId);
        db.insert(TaskEntity.TASK_TABLE_NAME, getTaskEntity(taskEntity));
        nextTaskId++;
      }
      transaction.markSuccessful();
      transaction.end();
    }
    db.update(TaskBundle.TASK_BUNDLE_TABLE_NAME, getTaskBundleValues(taskBundle),
        TaskBundle.COLUMN_KEY + "=?", taskBundle.getKey());
  }
}
 

import com.squareup.sqlbrite.BriteDatabase; //导入方法依赖的package包/类
public void addPackages(List<PackageInfo> packageInfos) {
  BriteDatabase db = databaseManager.get();
  try (BriteDatabase.Transaction transaction = db.newTransaction()) {

    for (PackageInfo packageInfo : packageInfos) {
      App app = toAppMapper.map(packageInfo.applicationInfo);
      long appId = appRepository.insertOrUpdate(db, app);

      Version version = new ToVersionMapper(clock, appId).map(packageInfo);
      versionRepository.insert(db, version);

      String thread = Thread.currentThread().getName();
      Timber.d("%s : inserted app %s, %s", thread, app.packageName(), version.versionName());
    }

    transaction.markSuccessful();
  }
}
 

import com.squareup.sqlbrite.BriteDatabase; //导入方法依赖的package包/类
public void insertOrUpdate(List<Permission> permissions) {
  BriteDatabase db = databaseManager.get();
  try (BriteDatabase.Transaction transaction = db.newTransaction()) {
    for (Permission permission : permissions) {
      PermissionGroup group = getGroup(permission.permissionGroup());

      if (group != null) {
        insertOrUpdate(group);
      }

      int updatedRows = permissionRepository.update(db, permission);

      if (updatedRows == 0) {
        permissionRepository.insert(db, permission);
      }
    }
    transaction.markSuccessful();
  }
}
 

import com.squareup.sqlbrite.BriteDatabase; //导入方法依赖的package包/类
public int insertOrUpdateInTransaction(final String table, final List<ContentValues> batch) {
    final BriteDatabase.Transaction transaction = briteDatabase.newTransaction();
    int updatedRows = 0;
    try {
        for (final ContentValues cv : batch) {
            updatedRows += (insertOrUpdate(table, cv) >= 0 ? 1 : 0);
        }
        transaction.markSuccessful();
    } finally {
        transaction.end();
    }
    return updatedRows;
}
 

import com.squareup.sqlbrite.BriteDatabase; //导入方法依赖的package包/类
/**
 * 插入TaskBundle
 */
public void insertTaskBundle(TaskBundle taskBundle) {
  if (!isExistTaskBundle(taskBundle.getKey())) {
    BriteDatabase.Transaction transaction = db.newTransaction();
    try {
      int nextBundleId =
          getNextID(db, TaskBundle.TASK_BUNDLE_TABLE_NAME, TaskBundle.COLUMN_BUNDLE_ID);
      db.insert(TaskBundle.TASK_BUNDLE_TABLE_NAME, getTaskBundleValues(taskBundle));
      List<TaskEntity> taskList = taskBundle.getTaskList();

      taskBundle.setBundleId(nextBundleId);

      if (taskList != null && taskList.size() > 0) {
        int nextTaskId = getNextID(db, TaskEntity.TASK_TABLE_NAME, TaskEntity.COLUMN_TASK_ID);
        for (TaskEntity taskEntity : taskList) {
          taskEntity.setTaskBundleId(nextBundleId);
          taskEntity.setTaskId(nextTaskId);
          db.insert(TaskEntity.TASK_TABLE_NAME, getTaskEntity(taskEntity));
          nextTaskId++;
        }
      }
      transaction.markSuccessful();
    } finally {
      transaction.end();
    }
  } else {
    TaskBundle bundleByKey = getBundleByKey(taskBundle.getKey());
    taskBundle.init(bundleByKey);
  }
}
 

import com.squareup.sqlbrite.BriteDatabase; //导入方法依赖的package包/类
/**
 * 删除数据
 */
public void deleteBundleByKey(TaskBundle bundle) {
  BriteDatabase.Transaction transaction = db.newTransaction();
  db.delete(TaskBundle.TASK_BUNDLE_TABLE_NAME, TaskBundle.COLUMN_KEY + "=?", bundle.getKey());
  db.delete(TaskEntity.TASK_TABLE_NAME, TaskEntity.COLUMN_TASK_BUNDLE_ID + "=?",
      bundle.getBundleId() + "");
  transaction.markSuccessful();
  transaction.end();
}
 

import com.squareup.sqlbrite.BriteDatabase; //导入方法依赖的package包/类
public void insert(List<Library> libraries) {
  BriteDatabase db = databaseManager.get();
  try (BriteDatabase.Transaction transaction = db.newTransaction()) {
    for (Library library : libraries) {
      libraryRepository.insert(db, library);
    }

    transaction.markSuccessful();
  }
}
 

import com.squareup.sqlbrite.BriteDatabase; //导入方法依赖的package包/类
public void insertOrUpdate(List<Library> libraries) {
  BriteDatabase db = databaseManager.get();
  try (BriteDatabase.Transaction transaction = db.newTransaction()) {
    for (Library library : libraries) {
      int updatedRows = libraryRepository.update(db, library);

      if (updatedRows == 0) {
        libraryRepository.insert(db, library);
      }
    }
    transaction.markSuccessful();
  }
}
 

import com.squareup.sqlbrite.BriteDatabase; //导入方法依赖的package包/类
public void insertForApp(App app, List<Library> libraries) {
  BriteDatabase db = databaseManager.get();
  try (BriteDatabase.Transaction transaction = db.newTransaction()) {
    for (Library library : libraries) {
      libraryAppRepository.insert(db, library.id(), app.id());
    }

    transaction.markSuccessful();
  }
}
 

import com.squareup.sqlbrite.BriteDatabase; //导入方法依赖的package包/类
public void insertOrUpdate(App app) {
  BriteDatabase db = databaseManager.get();
  try (BriteDatabase.Transaction transaction = db.newTransaction()) {
    appRepository.insertOrUpdate(db, app);
    transaction.markSuccessful();
  }
}
 

import com.squareup.sqlbrite.BriteDatabase; //导入方法依赖的package包/类
public void addPackage(PackageInfo packageInfo) {
  BriteDatabase db = databaseManager.get();
  try (BriteDatabase.Transaction transaction = db.newTransaction()) {
    App app = toAppMapper.map(packageInfo.applicationInfo);
    long appId = appRepository.insertOrUpdate(db, app);

    Version version = new ToVersionMapper(clock, appId).map(packageInfo);
    versionRepository.insertOrUpdate(db, version);

    String thread = Thread.currentThread().getName();
    Timber.d("%s : inserted app %s, %s", thread, app.packageName(), version.versionName());

    transaction.markSuccessful();
  }
}
 

import com.squareup.sqlbrite.BriteDatabase; //导入方法依赖的package包/类
public void removeAllByPackageName(List<String> packageNames) {
  BriteDatabase db = databaseManager.get();
  try (BriteDatabase.Transaction transaction = db.newTransaction()) {

    for (String packageName : packageNames) {
      String where = String.format("%s = '%s'", App.PACKAGENAME, packageName);
      appRepository.delete(db, where);

      String thread = Thread.currentThread().getName();
      Timber.d("%s : delete app %s", thread, packageName);
    }

    transaction.markSuccessful();
  }
}
 

import com.squareup.sqlbrite.BriteDatabase; //导入方法依赖的package包/类
public void insertForApp(List<AppPermission> appPermissions) {
  BriteDatabase db = databaseManager.get();
  try (BriteDatabase.Transaction transaction = db.newTransaction()) {

    for (AppPermission appPermission : appPermissions) {
      appPermissionRepository.insert(db, appPermission);
    }

    transaction.markSuccessful();
  }
}
 

import com.squareup.sqlbrite.BriteDatabase; //导入方法依赖的package包/类
public void insertForAppAndLibrary(App app, Library library, List<Permission> permissions) {
  BriteDatabase db = databaseManager.get();
  try (BriteDatabase.Transaction transaction = db.newTransaction()) {

    for (Permission permission : permissions) {
      AppLibraryPermission appLibraryPermission =
          AppLibraryPermission.create(app.id(), library.id(), permission.id());
      appLibraryPermissionRepository.insert(db, appLibraryPermission);
    }

    transaction.markSuccessful();
  }
}
 

import com.squareup.sqlbrite.BriteDatabase; //导入方法依赖的package包/类
public void insert(List<ProtectedMethod> protectedMethods) {
  BriteDatabase db = databaseManager.get();
  try (BriteDatabase.Transaction transaction = db.newTransaction()) {
    for (ProtectedMethod protectedMethod : protectedMethods) {
      methodRepository.insert(db, protectedMethod);
    }

    transaction.markSuccessful();
  }
}