compileInsertMany method

@override String compileInsertMany(Map<String, dynamic> query, List<Map<String, dynamic>> values)

Compile an insert statement with multiple rows.

Implementation

@override
String compileInsertMany(
  Map<String, dynamic> query,
  List<Map<String, dynamic>> values,
) {
  final table = wrapTable(query['table']);
  final columns = values.first.keys.map(wrap).join(', ');
  final rowPlaceholders =
      '(${List.filled(values.first.length, '?').join(', ')})';
  final placeholders = List.filled(values.length, rowPlaceholders).join(', ');

  return 'INSERT INTO $table ($columns) VALUES $placeholders';
}