executeBatch method

  1. @override
Future<List<int>> executeBatch(
  1. String sql,
  2. List<List> parametersList
)
override

Executes multiple SQL commands in a batch

Implementation

@override
Future<List<int>> executeBatch(
    String sql, List<List<dynamic>> parametersList) async {
  if (!_isConnected || _db == null) {
    await connect();
  }

  try {
    final results = <int>[];
    for (var params in parametersList) {
      _db!.execute(sql, params);
      results.add(_db!.lastInsertRowId);
    }
    return results;
  } catch (e) {
    throw DatabaseQueryError('SQLite batch execute failed: $e');
  }
}