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']));
}
});
});
}