insertMany method

@override Future<List<int>> insertMany(List<Map<String, dynamic>> values)

Insert multiple rows at once

Implementation

@override
Future<List<int>> insertMany(List<Map<String, dynamic>> values) async {
  if (values.isEmpty) return [];
  final sql = grammar.compileInsertMany(_getQueryComponents(), values);
  final bindings = values.expand((e) => e.values).toList();
  final response = await connection.execute(sql, bindings);
  final startId = response.insertId ?? 0;
  return List.generate(values.length, (i) => startId + i);
}