update method

Future<QueryResult> update(
  1. Map<String, dynamic> data
)

Executes an UPDATE statement with the provided data.

Implementation

Future<QueryResult> update(Map<String, dynamic> data) async {
  final params = _snapshotParams();
  final sets = data.keys.map((k) {
    final paramName = 'u${++_paramIndex}';
    params[paramName] = data[k];
    return '${_quoteIdentifier(k)} = @$paramName';
  }).join(', ');

  var sql = 'UPDATE ${_quoteIdentifier(_table)} SET $sets';
  if (_wheres.isNotEmpty) {
    sql += ' WHERE ${_wheres.join(' ')}';
  }
  return await _executor.query(sql, params);
}