executeBatch method

Implementation

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

  try {
    final results = <int>[];
    for (var _ in parametersList) {
      final result = await _connection!.execute(sql);
      results.add(result.affectedRows.toInt());
    }
    return results;
  } catch (e) {
    throw DatabaseQueryError('MySQL batch execute failed: $e');
  }
}