update method

Implementation

Future<Either<ErrorSqlResult, ExecuteSuccesSqlResult>> update() async {
  return (_prepareUpdateSQL()).fold((l) => left(l..methodName = 'update'),
      (sql) async {
    return (await _sqlConnection.executeCommand('update', sql))
        .fold((l) => left(l), (r) {
      if (r.rowsAffected == 1) {
        _currentRecord.finalize();
        return right(r);
      } else {
        return left(
            ErrorSqlResult(_className, 'update', sql, ['record not found']));
      }
    });
  });
}