Share
Unbreakable REST APIs: desenhando e implementando APIs robustas e previsíveis com fail fast e idempotency
(🎥 RECORDING: https://youtu.be/_MYy68tKsbA?list=PLHMMERsvy9EyWQPru4SrJAYHEGKfkjRgP&t=8954)
Existe uma grande diferença ao desenhar sistemas distribuídos e sistemas centralizados. Estar ciente delas é o que te permite construir sistemas escaláveis e resilientes.
Nesta talk você vai entender alguns desafios comuns e escorregadios ao construir sistemas distribuídos nesse mundo de microsserviços. Mas não se engane, até mesmo aquele seu CRUD simples com poucas chamadas a um banco de dados relacional pode ser uma fonte de incertezas e problemas de concorrência e consistência de dados.
Para lidar com estes percalços, você aprenderá como construir APIs REST robustas e previsíveis através de técnicas de resiliência como fail fast e idempotência. Apesar de ambas serem fáceis de entender, elas não necessariamente são simples de implementar. Para isso, tiraremos proveito do poder das transações e propriedades ACID dos bancos relacionais que nos ajudarão a minimizar vários desafios de concorrência e de cenários de indisponibilidade e inconsistência de dados.
Se você acha que uma API REST de CRUD é algo simples, então essa talk é para você!
Rafael Ponte
Transcript
401 slides
-
UNBREAKABLE REST APIs Desenhando e implementando APIs robustas e previsíveis
com fail fast e idempotency Rafael Ponte | @rponte -
Se você não tem requisitos de desempenho ou throughput então
você não tem problema de escala. -
https://www.youtube.com/watch?v=GBTdnfD6s5Q “ Eu não escrevi um livro sobre microservices, mas
sim sobre como você arquiteta para Entrega Contínua. ” — Sam Newman -
A distributed system is one in which the failure of
a computer you didn't even know existed can render your own computer unusable. — Leslie Lamport “ -
Spring Boot App Spring Boot App Spring Boot App Local
Calls Remote Calls -
Spring Boot App Spring Boot App Spring Boot App Centralized
System Distributed System -
Spring Boot App Spring Boot App Spring Boot App Centralized
System Distributed System -
— Martin Fowler First Law of Distributed Object Design: "don’t
distribute your objects" -
@RestController public class FindUserController { @Autowired private UserRepository repository; @GetMapping("/api/users/{id}")
public ResponseEntity<?> findById(@PathVariable Long id) { User user = repository.findById(id).orElseThrow(() -> { return new ResponseStatusException(NOT_FOUND, "User not found"); }); return ResponseEntity .ok(new UserResponse(user)); } } -
@RestController public class FindUserController { @Autowired private UserRepository repository; @GetMapping("/api/users/{id}")
public ResponseEntity<?> findById(@PathVariable Long id) { User user = repository.findById(id).orElseThrow(() -> { return new ResponseStatusException(NOT_FOUND, "User not found"); }); return ResponseEntity .ok(new UserResponse(user)); } } -
@RestController public class FindUserController { @Autowired private UserRepository repository; @GetMapping("/api/users/{id}")
public ResponseEntity<?> findById(@PathVariable Long id) { User user = repository.findById(id).orElseThrow(() -> { return new ResponseStatusException(NOT_FOUND, "User not found"); }); return ResponseEntity .ok(new UserResponse(user)); } } -
@RestController public class FindUserController { @Autowired private UserRepository repository; @GetMapping("/api/users/{id}")
public ResponseEntity<?> findById(@PathVariable Long id) { User user = repository.findById(id).orElseThrow(() -> { return new ResponseStatusException(NOT_FOUND, "User not found"); }); return ResponseEntity .ok(new UserResponse(user)); } } -
@RestController public class FindUserController { @Autowired private UserRepository repository; @GetMapping("/api/users/{id}")
public ResponseEntity<?> findById(@PathVariable Long id) { User user = repository.findById(id).orElseThrow(() -> { return new ResponseStatusException(NOT_FOUND, "User not found"); }); return ResponseEntity .ok(new UserResponse(user)); } } -
@RestController public class FindUserController { @Autowired private UserRepository repository; @GetMapping("/api/users/{id}")
public ResponseEntity<?> findById(@PathVariable Long id) { User user = repository.findById(id).orElseThrow(() -> { return new ResponseStatusException(NOT_FOUND, "User not found"); }); return ResponseEntity .ok(new UserResponse(user)); } } -
@RestController public class FindUserController { @Autowired private UserRepository repository; @GetMapping("/api/users/{id}")
public ResponseEntity<?> findById(@PathVariable Long id) { User user = repository.findById(id).orElseThrow(() -> { return new ResponseStatusException(NOT_FOUND, "User not found"); }); return ResponseEntity .ok(new UserResponse(user)); } } -
@RestController public class FindUserController { @Autowired private UserRepository repository; @GetMapping("/api/users/{id}")
public ResponseEntity<?> findById(@PathVariable Long id) { User user = repository.findById(id).orElseThrow(() -> { return new ResponseStatusException(NOT_FOUND, "User not found"); }); return ResponseEntity .ok(new UserResponse(user)); } } -
@RestController public class FindUserController { @Autowired private UserRepository repository; @GetMapping("/api/users/{id}")
public ResponseEntity<?> findById(@PathVariable Long id) { User user = repository.findById(id).orElseThrow(() -> { return new ResponseStatusException(NOT_FOUND, "User not found"); }); return ResponseEntity .ok(new UserResponse(user)); } } -
@RestController public class FindUserController { @Autowired private UserRepository repository; @GetMapping("/api/users/{id}")
public ResponseEntity<?> findById(@PathVariable Long id) { User user = repository.findById(id).orElseThrow(() -> { return new ResponseStatusException(NOT_FOUND, "User not found"); }); return ResponseEntity .ok(new UserResponse(user)); } } Injetado pelo Spring! -
@RestController public class FindUserController { @Autowired private UserRepository repository; @GetMapping("/api/users/{id}")
public ResponseEntity<?> findById(@PathVariable Long id) { User user = repository.findById(id).orElseThrow(() -> { return new ResponseStatusException(NOT_FOUND, "User not found"); }); return ResponseEntity .ok(new UserResponse(user)); } } -
@RestController public class FindUserController { @Autowired private UserRepository repository; @GetMapping("/api/users/{id}")
public ResponseEntity<?> findById(@PathVariable Long id) { User user = repository.findById(id).orElseThrow(() -> { return new ResponseStatusException(NOT_FOUND, "User not found"); }); return ResponseEntity .ok(new UserResponse(user)); } } -
@RestController public class FindUserController { @Autowired private UserRepository repository; @GetMapping("/api/users/{id}")
public ResponseEntity<?> findById(@PathVariable Long id) { User user = repository.findById(id).orElseThrow(() -> { return new ResponseStatusException(NOT_FOUND, "User not found"); }); return ResponseEntity .ok(new UserResponse(user)); } } -
@RestController public class FindUserController { @Autowired private UserRepository repository; @GetMapping("/api/users/{id}")
public ResponseEntity<?> findById(@PathVariable Long id) { User user = repository.findById(id).orElseThrow(() -> { return new ResponseStatusException(NOT_FOUND, "User not found"); }); return ResponseEntity .ok(new UserResponse(user)); } } -
@RestController public class FindUserController { @Autowired private UserRepository repository; @GetMapping("/api/users/{id}")
public ResponseEntity<?> findById(@PathVariable Long id) { User user = repository.findById(id).orElseThrow(() -> { return new ResponseStatusException(NOT_FOUND, "User not found"); }); return ResponseEntity .ok(new UserResponse(user)); } } -
@rponte Rafael Ponte Brazilian Software Engineer at aka Prince of
the Ocean aka Maharaja of the Legacies 20+ years of experience working with Java and distributed systems Loves working with "boring techs" -
UNBREAKABLE REST APIs Desenhando e implementando APIs robustas e previsíveis
com fail fast e idempotency Rafael Ponte | @rponte -
@RestController public class FindUserController { @Autowired private UserRepository repository; @GetMapping("/api/users/{id}")
public ResponseEntity<?> findById(@PathVariable Long id) { User user = repository.findById(id).orElseThrow(() -> { return new ResponseStatusException(NOT_FOUND, "User not found"); }); return ResponseEntity .ok(new UserResponse(user)); } } -
@RestController public class FindUserController { @Autowired private UserRepository repository; @GetMapping("/api/users/{id}")
public ResponseEntity<?> findById(@PathVariable Long id) { User user = repository.findById(id).orElseThrow(() -> { return new ResponseStatusException(NOT_FOUND, "User not found"); }); return ResponseEntity .ok(new UserResponse(user)); } } -
@RestController public class FindUserController { @Autowired private UserRepository repository; @GetMapping("/api/users/{id}")
public ResponseEntity<?> findById(@PathVariable Long id) { User user = repository.findById(id).orElseThrow(() -> { return new ResponseStatusException(NOT_FOUND, "User not found"); }); return ResponseEntity .ok(new UserResponse(user)); } } -
@RestController public class FindUserController { @Autowired private UserRepository repository; @GetMapping("/api/users/{id}")
public ResponseEntity<?> findById(@PathVariable Long id) { User user = repository.findById(id).orElseThrow(() -> { return new ResponseStatusException(NOT_FOUND, "User not found"); }); return ResponseEntity .ok(new UserResponse(user)); } } -
@Repository public interface UserRepository extends JpaRepository<User, Long> { @QueryHints({ @QueryHint(name
= "javax.persistence.query.timeout", value = "2000") }) @Override public Optional<User> findById(Long id); } -
@Repository public interface UserRepository extends JpaRepository<User, Long> { @QueryHints({ @QueryHint(name
= "javax.persistence.query.timeout", value = "2000") }) @Override public Optional<User> findById(Long id); } -
@Repository public interface UserRepository extends JpaRepository<User, Long> { @QueryHints({ @QueryHint(name
= "javax.persistence.query.timeout", value = "2000") }) @Override public Optional<User> findById(Long id); } -
@Repository public interface UserRepository extends JpaRepository<User, Long> { @QueryHints({ @QueryHint(name
= "javax.persistence.query.timeout", value = "2000") }) @Override public Optional<User> findById(Long id); } -
@Repository public interface UserRepository extends JpaRepository<User, Long> { @QueryHints({ @QueryHint(name
= "javax.persistence.query.timeout", value = "2000") }) @Override public Optional<User> findById(Long id); } -
@Repository public interface UserRepository extends JpaRepository<User, Long> { @QueryHints({ @QueryHint(name
= "javax.persistence.query.timeout", value = "2000") }) @Override public Optional<User> findById(Long id); } -
@Repository public interface UserRepository extends JpaRepository<User, Long> { @QueryHints({ @QueryHint(name
= "javax.persistence.query.timeout", value = "2000") }) @Override public Optional<User> findById(Long id); } -
SELECT u.* FROM user u WHERE u.id = 42 --
SQL Error: 0, SQLState: 57014 -- ERROR: canceling statement due to user request -
@RestController public class FindUserController { @Autowired private UserRepository repository; @GetMapping("/api/users/{id}")
public ResponseEntity<?> findById(@PathVariable Long id) { User user = repository.findById(id).orElseThrow(() -> { return new ResponseStatusException(NOT_FOUND, "User not found"); }); return ResponseEntity .ok(new UserResponse(user)); } } -
Aplicação Usuário Banco de dados GET /api/users/42 SELECT 1 FROM
user u WHERE ud.id = 42 -
Aplicação Usuário Banco de dados GET /api/users/42 SELECT 1 FROM
user u WHERE ud.id = 42 -
Aplicação Usuário Banco de dados GET /api/users/42 SELECT u.* FROM
user u WHERE ud.id = 42 -
Aplicação Usuário Banco de dados GET /api/users/42 HTTP 503 (SERVICE
UNAVAILABLE) SELECT u.* FROM user u WHERE ud.id = 42 -
Aplicação Usuário Banco de dados GET /api/users/42 HTTP 503 (SERVICE
UNAVAILABLE) SELECT u.* FROM user u WHERE ud.id = 42 -
Aplicação Usuário Banco de dados GET /api/users/42 HTTP 503 (SERVICE
UNAVAILABLE) GET /api/users/42 SELECT u.* FROM user u WHERE ud.id = 42 -
Aplicação Usuário Banco de dados GET /api/users/42 HTTP 503 (SERVICE
UNAVAILABLE) GET /api/users/42 SELECT 1 FROM user u WHERE ud.id = 42 SELECT u.* FROM user u WHERE ud.id = 42 -
Aplicação Usuário Banco de dados GET /api/users/42 HTTP 503 (SERVICE
UNAVAILABLE) GET /api/users/42 SELECT 1 FROM user u WHERE ud.id = 42 SELECT u.* FROM user u WHERE ud.id = 42 -
Aplicação Usuário Banco de dados GET /api/users/42 HTTP 503 (SERVICE
UNAVAILABLE) GET /api/users/42 SELECT 1 FROM user u WHERE ud.id = 42 HTTP 200 (OK) SELECT u.* FROM user u WHERE ud.id = 42 -
Aplicação Usuário Banco de dados GET /api/users/42 SELECT u.* FROM
user u WHERE ud.id = 42 5xx -
Aplicação Usuário Banco de dados GET /api/users/42 SELECT 1 FROM
user u WHERE ud.id = 42 SELECT u.* FROM user u WHERE ud.id = 42 GET /api/users/42 GET /api/users/42 5xx -
Aplicação Usuário Banco de dados GET /api/users/42 GET /api/users/42 SELECT
1 FROM user u WHERE ud.id = 42 SELECT u.* FROM user u WHERE ud.id = 42 GET /api/users/42 GET /api/users/42 GET /api/users/42 5xx -
Aplicação Usuário Banco de dados GET /api/users/42 GET /api/users/42 SELECT
1 FROM user u WHERE ud.id = 42 SELECT u.* FROM user u WHERE ud.id = 42 GET /api/users/42 GET /api/users/42 GET /api/users/42 GET /api/users/42 . . . 5xx -
Aplicação Usuário Banco de dados GET /api/users/42 5xx GET /api/users/42
SELECT 1 FROM user u WHERE ud.id = 42 2xx SELECT u.* FROM user u WHERE ud.id = 42 GET /api/users/42 GET /api/users/42 GET /api/users/42 GET /api/users/42 . . . -
Aplicação Usuário Banco de dados GET /api/users/42 5xx GET /api/users/42
SELECT 1 FROM user u WHERE ud.id = 42 2xx SELECT u.* FROM user u WHERE ud.id = 42 GET /api/users/42 GET /api/users/42 GET /api/users/42 GET /api/users/42 . . . Aplicação Usuário Banco de dados -
Aplicação Usuário Banco de dados GET /api/users/42 5xx GET /api/users/42
SELECT 1 FROM user u WHERE ud.id = 42 2xx SELECT u.* FROM user u WHERE ud.id = 42 GET /api/users/42 GET /api/users/42 GET /api/users/42 GET /api/users/42 . . . 2xx GET /api/users/42 Aplicação Usuário Banco de dados -
Aplicação Usuário Banco de dados GET /api/users/42 5xx GET /api/users/42
SELECT 1 FROM user u WHERE ud.id = 42 2xx SELECT u.* FROM user u WHERE ud.id = 42 GET /api/users/42 GET /api/users/42 GET /api/users/42 GET /api/users/42 . . . ID NAME EMAIL ... ... ... 42 Gleice Elen [email protected] ... ... ... user Aplicação Usuário Banco de dados -
FUNCIONA MUITO BEM PARA ENDPOINTS DE LEITURA …mas não tão
bem para endpoints de escrita -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } -
Aplicação Usuário Banco de dados INSERT INTO user (name ,
email) VALUES (:name, :email); POST /api/users { name: “Gleice Elen”, email: “[email protected]” } -
Aplicação Usuário Banco de dados INSERT INTO user (name ,
email) VALUES (:name, :email); POST /api/users { name: “Gleice Elen”, email: “[email protected]” } -
Aplicação Usuário Banco de dados INSERT INTO user (name ,
email) VALUES (:name, :email); POST /api/users { name: “Gleice Elen”, email: “[email protected]” } INSERT INTO user_audit (used_id, action) VALUES (:user_id, :action); -
Aplicação Usuário Banco de dados INSERT INTO user (name ,
email) VALUES (:name, :email); POST /api/users { name: “Gleice Elen”, email: “[email protected]” } INSERT INTO user_audit (used_id, action) VALUES (:user_id, :action); -
Aplicação Usuário Banco de dados INSERT INTO user (name ,
email) VALUES (:name, :email); POST /api/users { name: “Gleice Elen”, email: “[email protected]” } Network INSERT INTO user_audit (used_id, action) VALUES (:user_id, :action); -
Aplicação Usuário Banco de dados INSERT INTO user (name ,
email) VALUES (:name, :email); POST /api/users { name: “Gleice Elen”, email: “[email protected]” } Network INSERT INTO user_audit (used_id, action) VALUES (:user_id, :action); -
Aplicação Usuário Banco de dados INSERT INTO user (name ,
email) VALUES (:name, :email); POST /api/users { name: “Gleice Elen”, email: “[email protected]” } POST /api/users { name: “Gleice Elen”, email: “[email protected]” } Network INSERT INTO user_audit (used_id, action) VALUES (:user_id, :action); -
Aplicação Usuário Banco de dados INSERT INTO user (name ,
email) VALUES (:name, :email); POST /api/users { name: “Gleice Elen”, email: “[email protected]” } POST /api/users { name: “Gleice Elen”, email: “[email protected]” } INSERT INTO user (name , email) VALUES (:name, :email); Network INSERT INTO user_audit (used_id, action) VALUES (:user_id, :action); -
Aplicação Usuário Banco de dados INSERT INTO user (name ,
email) VALUES (:name, :email); POST /api/users { name: “Gleice Elen”, email: “[email protected]” } POST /api/users { name: “Gleice Elen”, email: “[email protected]” } INSERT INTO user (name , email) VALUES (:name, :email); Network INSERT INTO user_audit (used_id, action) VALUES (:user_id, :action); -
Aplicação Usuário Banco de dados INSERT INTO user (name ,
email) VALUES (:name, :email); POST /api/users { name: “Gleice Elen”, email: “[email protected]” } POST /api/users { name: “Gleice Elen”, email: “[email protected]” } INSERT INTO user (name , email) VALUES (:name, :email); INSERT INTO user_audit (used_id, action) VALUES (:user_id, :action); Network INSERT INTO user_audit (used_id, action) VALUES (:user_id, :action); -
Aplicação Usuário Banco de dados INSERT INTO user (name ,
email) VALUES (:name, :email); POST /api/users { name: “Gleice Elen”, email: “[email protected]” } POST /api/users { name: “Gleice Elen”, email: “[email protected]” } INSERT INTO user (name , email) VALUES (:name, :email); INSERT INTO user_audit (used_id, action) VALUES (:user_id, :action); Network INSERT INTO user_audit (used_id, action) VALUES (:user_id, :action); -
Aplicação Usuário Banco de dados INSERT INTO user (name ,
email) VALUES (:name, :email); POST /api/users { name: “Gleice Elen”, email: “[email protected]” } 2xx POST /api/users { name: “Gleice Elen”, email: “[email protected]” } INSERT INTO user (name , email) VALUES (:name, :email); INSERT INTO user_audit (used_id, action) VALUES (:user_id, :action); Network INSERT INTO user_audit (used_id, action) VALUES (:user_id, :action); -
Aplicação Usuário Banco de dados INSERT INTO user (name ,
email) VALUES (:name, :email); POST /api/users { name: “Gleice Elen”, email: “[email protected]” } 2xx POST /api/users { name: “Gleice Elen”, email: “[email protected]” } INSERT INTO user (name , email) VALUES (:name, :email); INSERT INTO user_audit (used_id, action) VALUES (:user_id, :action); Network INSERT INTO user_audit (used_id, action) VALUES (:user_id, :action); Aplicação Usuário Banco de dados -
Aplicação Usuário Banco de dados INSERT INTO user (name ,
email) VALUES (:name, :email); POST /api/users { name: “Gleice Elen”, email: “[email protected]” } 2xx POST /api/users { name: “Gleice Elen”, email: “[email protected]” } INSERT INTO user (name , email) VALUES (:name, :email); INSERT INTO user_audit (used_id, action) VALUES (:user_id, :action); Network INSERT INTO user_audit (used_id, action) VALUES (:user_id, :action); Aplicação Usuário Banco de dados POST /api/users { name: “Gleice Elen”, email: “[email protected]” } 2xx -
Aplicação Usuário Banco de dados INSERT INTO user (name ,
email) VALUES (:name, :email); POST /api/users { name: “Gleice Elen”, email: “[email protected]” } 2xx POST /api/users { name: “Gleice Elen”, email: “[email protected]” } INSERT INTO user (name , email) VALUES (:name, :email); INSERT INTO user_audit (used_id, action) VALUES (:user_id, :action); Network INSERT INTO user_audit (used_id, action) VALUES (:user_id, :action); Aplicação Usuário Banco de dados Banco de dados INSERT INTO user (name , email) VALUES (:name, :email); INSERT INTO user_audit (used_id, action) VALUES (:user_id, :action); Banco de dados -
Aplicação Usuário Banco de dados INSERT INTO user (name ,
email) VALUES (:name, :email); POST /api/users { name: “Gleice Elen”, email: “[email protected]” } 2xx POST /api/users { name: “Gleice Elen”, email: “[email protected]” } INSERT INTO user (name , email) VALUES (:name, :email); INSERT INTO user_audit (used_id, action) VALUES (:user_id, :action); Network INSERT INTO user_audit (used_id, action) VALUES (:user_id, :action); Aplicação Usuário Banco de dados Banco de dados INSERT INTO user (name , email) VALUES (:name, :email); INSERT INTO user (name , email) VALUES (:name, :email); INSERT INTO user_audit (used_id, action) VALUES (:user_id, :action); INSERT INTO user_audit (used_id, action) VALUES (:user_id, :action); Banco de dados 👀 -
Aplicação Usuário Banco de dados INSERT INTO user (name ,
email) VALUES (:name, :email); POST /api/users { name: “Gleice Elen”, email: “[email protected]” } 2xx POST /api/users { name: “Gleice Elen”, email: “[email protected]” } INSERT INTO user (name , email) VALUES (:name, :email); INSERT INTO user_audit (used_id, action) VALUES (:user_id, :action); Network INSERT INTO user_audit (used_id, action) VALUES (:user_id, :action); Aplicação Usuário ID NAME EMAIL ... ... ... 42 Gleice Elen [email protected] 43 Gleice Elen [email protected] ... ... ... user 😱 Banco de dados -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } Nosso endpoint NÃO é idempotente! 😰 -
@Entity public class User { @Id @GeneratedValue private Long id;
private String name; private String email; private LocalDateTime createdAt; // construtor, getters etc } -
@Entity public class User { @Id @GeneratedValue private Long id;
private String name; private String email; private LocalDateTime createdAt; // construtor, getters etc } -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { if (repository.existsByEmail(request.email())) { throw new ResponseStatusException(BAD_REQUEST, "User exists”); // http 400 }; User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { if (repository.existsByEmail(request.email())) { throw new ResponseStatusException(BAD_REQUEST, "User exists”); // http 400 }; User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { if (repository.existsByEmail(request.email())) { throw new ResponseStatusException(BAD_REQUEST, "User exists”); // http 400 }; User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } 🥳 Email como chave natural de idempotência! -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { if (repository.existsByEmail(request.email())) { throw new ResponseStatusException(BAD_REQUEST, "User exists”); // http 400 }; User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { if (repository.existsByEmail(request.email())) { throw new ResponseStatusException(BAD_REQUEST, "User exists”); // http 400 }; User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } 😵💫 Not cool! -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { if (repository.existsByEmail(request.email())) { throw new ResponseStatusException(BAD_REQUEST, "User exists”); // http 400 }; User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { if (repository.existsByEmail(request.email())) { return ResponseEntity.ok("User exists”); // http 200 }; User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { if (repository.existsByEmail(request.email())) { return ResponseEntity.ok("User exists”); // http 200 }; User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } 😍 Oh yeah! -
Aplicação Usuário Banco de dados POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } SELECT exists… -
Aplicação Usuário Banco de dados POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } SELECT exists… INSERT user… -
Aplicação Usuário Banco de dados POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… -
Aplicação Usuário Banco de dados POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… -
Aplicação Usuário Banco de dados POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… Network -
Aplicação Usuário Banco de dados POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… Network -
Aplicação Usuário Banco de dados POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… Network POST /api/users { name: “Gleice Elen”, email: “[email protected]” } -
Aplicação Usuário Banco de dados POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… Network POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists ( SELECT 1 FROM user u WHERE u.email = :email ); -
Aplicação Usuário Banco de dados POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… Network POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists ( SELECT 1 FROM user u WHERE u.email = :email ); -
Aplicação Usuário Banco de dados INSERT user… POST /api/users {
name: “Gleice Elen”, email: “[email protected]” } 2xx POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists ( SELECT 1 FROM user u WHERE u.email = :email ); Network INSERT user_audit_… SELECT exists… -
Aplicação Usuário Banco de dados INSERT user… POST /api/users {
name: “Gleice Elen”, email: “[email protected]” } 2xx POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists ( SELECT 1 FROM user u WHERE u.email = :email ); Network INSERT user_audit_… SELECT exists… Aplicação Usuário Banco de dados -
Aplicação Usuário Banco de dados INSERT user… POST /api/users {
name: “Gleice Elen”, email: “[email protected]” } 2xx POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists ( SELECT 1 FROM user u WHERE u.email = :email ); Network INSERT user_audit_… SELECT exists… Aplicação Usuário Banco de dados POST /api/users { name: “Gleice Elen”, email: “[email protected]” } 2xx -
Aplicação Usuário Banco de dados INSERT user… POST /api/users {
name: “Gleice Elen”, email: “[email protected]” } 2xx POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists ( SELECT 1 FROM user u WHERE u.email = :email ); Network INSERT user_audit_… SELECT exists… Aplicação Usuário Banco de dados INSERT user… INSERT user_audit_… SELECT exists… -
Aplicação Usuário Banco de dados INSERT user… POST /api/users {
name: “Gleice Elen”, email: “[email protected]” } 2xx POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists ( SELECT 1 FROM user u WHERE u.email = :email ); Network INSERT user_audit_… SELECT exists… Aplicação Usuário Banco de dados INSERT user… INSERT user_audit_… SELECT exists… SELECT exists ( SELECT 1 FROM user u WHERE u.email = :email ); 💪 -
Aplicação Usuário Banco de dados INSERT user… POST /api/users {
name: “Gleice Elen”, email: “[email protected]” } 2xx POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists ( SELECT 1 FROM user u WHERE u.email = :email ); Network INSERT user_audit_… SELECT exists… Aplicação Usuário Banco de dados ID NAME EMAIL ... ... ... 42 Gleice Elen [email protected] ... ... ... user 🥳 -
Aplicação Usuário Banco de dados POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } SELECT exists… -
Aplicação Usuário Banco de dados POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } SELECT exists… INSERT user… -
Aplicação Usuário Banco de dados POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… -
Aplicação Usuário Banco de dados POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… -
Aplicação Usuário Banco de dados POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… -
Aplicação Usuário Banco de dados POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… 5xx -
Aplicação Usuário Banco de dados POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… 5xx POST /api/users { name: “Gleice Elen”, email: “[email protected]” } -
Aplicação Usuário Banco de dados POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… 5xx POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists ( SELECT 1 FROM user u WHERE u.email = :email ); -
Aplicação Usuário Banco de dados POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… 5xx POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists ( SELECT 1 FROM user u WHERE u.email = :email ); -
Aplicação Usuário Banco de dados INSERT user… POST /api/users {
name: “Gleice Elen”, email: “[email protected]” } 2xx POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists ( SELECT 1 FROM user u WHERE u.email = :email ); INSERT user_audit_… SELECT exists… 5xx -
Aplicação Usuário Banco de dados INSERT user… POST /api/users {
name: “Gleice Elen”, email: “[email protected]” } 2xx POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists ( SELECT 1 FROM user u WHERE u.email = :email ); INSERT user_audit_… SELECT exists… 5xx Aplicação Usuário Banco de dados -
Aplicação Usuário Banco de dados INSERT user… POST /api/users {
name: “Gleice Elen”, email: “[email protected]” } 2xx POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists ( SELECT 1 FROM user u WHERE u.email = :email ); INSERT user_audit_… SELECT exists… 5xx Aplicação Usuário Banco de dados POST /api/users { name: “Gleice Elen”, email: “[email protected]” } 2xx -
Aplicação Usuário Banco de dados INSERT user… POST /api/users {
name: “Gleice Elen”, email: “[email protected]” } 2xx POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists ( SELECT 1 FROM user u WHERE u.email = :email ); INSERT user_audit_… SELECT exists… 5xx Aplicação Usuário Banco de dados SELECT exists… INSERT user… INSERT user_audit_… -
Aplicação Usuário Banco de dados INSERT user… POST /api/users {
name: “Gleice Elen”, email: “[email protected]” } 2xx POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists ( SELECT 1 FROM user u WHERE u.email = :email ); INSERT user_audit_… SELECT exists… 5xx Aplicação Usuário Banco de dados SELECT exists… INSERT user… INSERT user_audit_… SELECT exists ( SELECT 1 FROM user u WHERE u.email = :email ); -
Aplicação Usuário Banco de dados INSERT user… POST /api/users {
name: “Gleice Elen”, email: “[email protected]” } 2xx POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists ( SELECT 1 FROM user u WHERE u.email = :email ); INSERT user_audit_… SELECT exists… 5xx Aplicação Usuário Banco de dados ID NAME EMAIL ... ... ... 42 Gleice Elen [email protected] ... ... ... user -
Aplicação Usuário Banco de dados INSERT user… POST /api/users {
name: “Gleice Elen”, email: “[email protected]” } 2xx POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists ( SELECT 1 FROM user u WHERE u.email = :email ); INSERT user_audit_… SELECT exists… 5xx Aplicação Usuário Banco de dados ID NAME EMAIL ... ... ... 42 Gleice Elen [email protected] ... ... ... user ID ACTION USER_ID ... ... ... ?? ?? ?? ... ... ... user_audit -
Aplicação Usuário Banco de dados INSERT user… POST /api/users {
name: “Gleice Elen”, email: “[email protected]” } 2xx POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists ( SELECT 1 FROM user u WHERE u.email = :email ); INSERT user_audit_… SELECT exists… 5xx Aplicação Usuário Banco de dados ID NAME EMAIL ... ... ... 42 Gleice Elen [email protected] ... ... ... user ID ACTION USER_ID ... ... ... ?? ?? ?? ... ... ... user_audit 😱 -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { if (repository.existsByEmail(request.email())) { return ResponseEntity.ok("User exists”); // http 200 }; User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { if (repository.existsByEmail(request.email())) { return ResponseEntity.ok("User exists”); // http 200 }; User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { if (repository.existsByEmail(request.email())) { return ResponseEntity.ok("User exists”); // http 200 }; User user = request.toModel(); repository.save(user); // inicia e comita uma transação UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); // inicia e comita uma transação return ResponseEntity .status(CREATED).build(); // http 201 } } -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { if (repository.existsByEmail(request.email())) { return ResponseEntity.ok("User exists”); // http 200 }; User user = request.toModel(); repository.save(user); // inicia e comita uma transação UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); // inicia e comita uma transação return ResponseEntity .status(CREATED).build(); // http 201 } } Semelhante a auto_commit = true 😱 -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { if (repository.existsByEmail(request.email())) { return ResponseEntity.ok("User exists”); // http 200 }; User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { if (repository.existsByEmail(request.email())) { return ResponseEntity.ok("User exists”); // http 200 }; User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { if (repository.existsByEmail(request.email())) { return ResponseEntity.ok("User exists”); // http 200 }; User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { if (repository.existsByEmail(request.email())) { return ResponseEntity.ok("User exists”); // http 200 }; User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { if (repository.existsByEmail(request.email())) { return ResponseEntity.ok("User exists”); // http 200 }; User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @Transactional @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { if (repository.existsByEmail(request.email())) { return ResponseEntity.ok("User exists”); // http 200 }; User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @Transactional @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { if (repository.existsByEmail(request.email())) { return ResponseEntity.ok("User exists”); // http 200 }; User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @Transactional @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { if (repository.existsByEmail(request.email())) { return ResponseEntity.ok("User exists”); // http 200 }; User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } -
Aplicação Usuário Banco de dados POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } SELECT exists… -
Aplicação Usuário Banco de dados POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } SELECT exists… INSERT user… -
Aplicação Usuário Banco de dados POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… -
Aplicação Usuário Banco de dados POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… -
Aplicação Usuário Banco de dados POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… -
Aplicação Usuário Banco de dados POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… -
Aplicação Usuário Banco de dados POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… 5xx -
Aplicação Usuário Banco de dados POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… 5xx POST /api/users { name: “Gleice Elen”, email: “[email protected]” } -
Aplicação Usuário Banco de dados POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… 5xx POST /api/users { name: “Gleice Elen”, email: “[email protected]” } -
Aplicação Usuário Banco de dados POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… 5xx POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… -
Aplicação Usuário Banco de dados POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… 5xx POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… -
Aplicação Usuário Banco de dados POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… 5xx POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… -
Aplicação Usuário Banco de dados POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… 5xx POST /api/users { name: “Gleice Elen”, email: “[email protected]” } 2xx SELECT exists… INSERT user… INSERT user_audit_… -
Aplicação Usuário Banco de dados POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… 5xx POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… 2xx Aplicação Usuário Banco de dados -
Aplicação Usuário Banco de dados POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… 5xx POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… 2xx Aplicação Usuário Banco de dados POST /api/users { name: “Gleice Elen”, email: “[email protected]” } 2xx -
Aplicação Usuário Banco de dados POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… 5xx POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… 2xx Aplicação Usuário Banco de dados SELECT exists… INSERT user… INSERT user_audit_… -
Aplicação Usuário Banco de dados POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… 5xx POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… 2xx Aplicação Usuário Banco de dados ID NAME EMAIL ... ... ... 42 Gleice Elen [email protected] ... ... ... user ID ACTION USER_ID ... ... ... 1024 created 42 ... ... ... user_audit 💪 -
Aplicação Usuário 1 Usuário 2 POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } POST /api/users { name: “Gleice Elen”, email: “[email protected]” } -
Aplicação Usuário 1 Usuário 2 POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } POST /api/users { name: “Gleice Elen”, email: “[email protected]” } HTTP 201 (CREATED) -
Aplicação Usuário 1 Usuário 2 HTTP 201 (CREATED) POST /api/users
{ name: “Gleice Elen”, email: “[email protected]” } POST /api/users { name: “Gleice Elen”, email: “[email protected]” } HTTP 201 (CREATED) -
ID NAME EMAIL ... ... ... 42 Gleice Elen [email protected]
43 Gleice Elen [email protected] ... ... ... user 😱 -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @Transactional @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { if (repository.existsByEmail(request.email())) { return ResponseEntity.ok("User exists”); // http 200 }; User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @Transactional @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { if (repository.existsByEmail(request.email())) { return ResponseEntity.ok("User exists”); // http 200 }; User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } -
@RestController public class CreateNewUserController { private UserRepository repository; private UserAuditRepository
auditRepository; @Transactional @PostMapping(“/api/users") public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { if (repository.existsByEmail(request.email())) { return ResponseEntity.ok("User exists”); // http 200 }; User user = request.toModel(); repository.save(user); UserAudit audit = new UserAudit(user, "created"); auditRepository.save(audit); return ResponseEntity .status(CREATED).build(); // http 201 } } -
if (repository.existsByEmail(request.email())) { return ResponseEntity.ok("User exists”); // http 200 };
User user = request.toModel(); repository.save(user); -
boolean exists = repository.existsByEmail(request.email()); if (exists) { return ResponseEntity.ok("User exists”);
// http 200 }; User user = request.toModel(); repository.save(user); -
boolean exists = repository.existsByEmail(request.email()); if (exists) { return ResponseEntity.ok("User exists”);
// http 200 }; User user = request.toModel(); repository.save(user); -
boolean exists = repository.existsByEmail(request.email()); if (exists) { return ResponseEntity.ok("User exists”);
// http 200 }; User user = request.toModel(); repository.save(user); -
boolean exists = repository.existsByEmail(request.email()); if (exists) { return ResponseEntity.ok("User exists”);
// http 200 }; User user = request.toModel(); repository.save(user); -
boolean exists = repository.existsByEmail(request.email()); if (exists) { return ResponseEntity.ok("User exists”);
// http 200 }; User user = request.toModel(); repository.save(user); -
@Entity public class User { @Id @GeneratedValue private Long id;
private String name; private String email; private LocalDateTime createdAt; // construtor, getters etc } -
@Entity public class User { @Id @GeneratedValue private Long id;
private String name; private String email; private LocalDateTime createdAt; // construtor, getters etc } -
@Entity public class User { @Id @GeneratedValue private Long id;
private String name; @Column(unique = true) private String email; private LocalDateTime createdAt; // construtor, getters etc } -
Aplicação Usuário 1 Usuário 2 POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } POST /api/users { name: “Gleice Elen”, email: “[email protected]” } -
Aplicação Usuário 1 Usuário 2 POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } POST /api/users { name: “Gleice Elen”, email: “[email protected]” } HTTP 201 (CREATED) -
Aplicação Usuário 1 Usuário 2 POST /api/users { name: “Gleice
Elen”, email: “[email protected]” } POST /api/users { name: “Gleice Elen”, email: “[email protected]” } HTTP 201 (CREATED) HTTP 409 (CONFLICT) -
Aplicação Usuário Banco de dados POST /api/users SELECT exists… INSERT
user… INSERT user_audit_… -
Aplicação Usuário Banco de dados POST /api/users SELECT exists… INSERT
user… INSERT user_audit_… -
Aplicação Usuário Banco de dados POST /api/users SELECT exists… INSERT
user… INSERT user_audit_… OK -
Aplicação Usuário Banco de dados POST /api/users 2xx OK SELECT
exists… INSERT user… INSERT user_audit_… -
Aplicação Usuário Banco de dados POST /api/users SELECT exists… INSERT
user… INSERT user_audit_… -
Aplicação Usuário Banco de dados POST /api/users SELECT exists… INSERT
user… INSERT user_audit_… -
Aplicação Usuário Banco de dados POST /api/users SELECT exists… INSERT
user… INSERT user_audit_… ERROR -
Aplicação Usuário Banco de dados POST /api/users SELECT exists… INSERT
user… INSERT user_audit_… 5xx ERROR -
Aplicação Usuário Banco de dados POST /api/users SELECT exists… INSERT
user… INSERT user_audit_… OK 2xx Aplicação Usuário Banco de dados -
Aplicação Usuário Banco de dados POST /api/users SELECT exists… INSERT
user… INSERT user_audit_… OK 2xx Aplicação Usuário Banco de dados OK SELECT exists… INSERT user… INSERT user_audit_… -
Aplicação Usuário Banco de dados POST /api/users SELECT exists… INSERT
user… INSERT user_audit_… OK 2xx Aplicação Usuário Banco de dados OK SELECT exists… INSERT user… INSERT user_audit_… Unit of Work -
Aplicação Usuário Banco de dados POST /api/users SELECT exists… INSERT
user… INSERT user_audit_… OK 2xx Aplicação Usuário Banco de dados POST /api/users 2xx -
Aplicação Usuário Banco de dados POST /api/users SELECT exists… INSERT
user… INSERT user_audit_… OK 2xx Aplicação Usuário Banco de dados 2xx POST /api/users Unit of Work -
Aplicação Usuário Banco de dados POST /api/users SELECT exists… INSERT
user… INSERT user_audit_… OK 2xx Aplicação Usuário Banco de dados OK SELECT exists… INSERT user… INSERT user_audit_… 2xx POST /api/users Unit of Work Unit of Work -
Aplicação Usuário Banco de dados POST /api/users SELECT exists… INSERT
user… INSERT user_audit_… OK 2xx Aplicação Usuário Banco de dados OK SELECT exists… INSERT user… INSERT user_audit_… 2xx POST /api/users Unit of Work Unit of Work -
Aplicação Usuário Banco de dados POST /api/users SELECT exists… INSERT
user… INSERT user_audit_… OK 2xx Usuário Banco de dados OK SELECT exists… INSERT user… INSERT user_audit_… POST /api/users 2xx Unit of Work -
THE 1:1 MODEL Brandur | @brandur Mapear uma transação para
um HTTP request -
@RestController public class CreateNewUserController { private UserRepository repository; @Transactional @PostMapping(“/api/users")
public ResponseEntity<?> create(@Valid @RequestBody NewUserRequest request) { // lógica de negócio return ResponseEntity .status(OK).build(); // http 200 } } -
…abraça o tudo ou nada …permite re-tentativas do cliente …falha
rapidamente …previne falhas de races conditions