executeBatch method

@override Future<void> executeBatch(String sql, List<List<Object?>> parameterSets)

Execute a write query (INSERT, UPDATE, DELETE) multiple times with each parameter set. This is faster than executing separately with each parameter set.

Implementation

@override
Future<void> executeBatch(
    String sql, List<List<Object?>> parameterSets) async {
  task.timeSync('executeBatch', () {
    final statement = db.prepare(sql, checkNoTail: true);
    try {
      for (var parameters in parameterSets) {
        task.timeSync('iteration', () => statement.execute(parameters),
            parameters: parameters);
      }
    } finally {
      statement.dispose();
    }
  }, sql: sql);
}