insert method

@override Future<DbResult> insert(String table, Map<String, dynamic> data)

Inserts a new row into the specified table.

• data: A map of column names and values. Returns the inserted row(s) if supported.

Implementation

@override
Future<DbResult> insert(String table, Map<String, dynamic> data) async {
  final columns = data.keys.join(', ');
  final placeholders = List.filled(data.length, '?').join(', ');
  return _run(
    _db,
    'INSERT INTO $table ($columns) VALUES ($placeholders);',
    data,
  );
}