update method

  1. @override
Future<DbResult> update(
  1. String table,
  2. Map<String, dynamic> data, {
  3. required Map<String, dynamic> where,
})
override

Implementation

@override
Future<DbResult> update(
  String table,
  Map<String, dynamic> data, {
  required Map<String, dynamic> where,
}) async {
  final sets = data.keys.map((k) => '$k = ${ph(k)}').join(', ');
  final conditions = where.keys
      .map((k) => '$k = ${ph('w_$k')}')
      .join(' AND ');
  final values = {
    ...data,
    ...{for (final k in where.keys) 'w_$k': where[k]},
  };
  return rawQuery(
    'UPDATE $table SET $sets WHERE $conditions;',
    values: values,
  );
}