Tweet
Tweet

Slide 1

Slide 1 text

UNBREAKABLE REST APIs Desenhando e implementando APIs robustas e previsíveis com fail fast e idempotency Rafael Ponte | @rponte

Slide 2

Slide 2 text

No content

Slide 3

Slide 3 text

No content

Slide 4

Slide 4 text

No content

Slide 5

Slide 5 text

No content

Slide 6

Slide 6 text

CACHE

Slide 7

Slide 7 text

CACHE

Slide 8

Slide 8 text

PROCESSAMENTO ASSINCRONO CACHE

Slide 9

Slide 9 text

PROCESSAMENTO ASSINCRONO CACHE

Slide 10

Slide 10 text

BALANCEAMENTO DE CARGA CACHE PROCESSAMENTO ASSINCRONO

Slide 11

Slide 11 text

BALANCEAMENTO DE CARGA CACHE PROCESSAMENTO ASSINCRONO

Slide 12

Slide 12 text

BALANCEAMENTO DE CARGA CACHE PROCESSAMENTO ASSINCRONO

Slide 13

Slide 13 text

No content

Slide 14

Slide 14 text

No content

Slide 15

Slide 15 text

No content

Slide 16

Slide 16 text

Se você não tem requisitos de desempenho ou throughput então você não tem problema de escala.

Slide 17

Slide 17 text

No content

Slide 18

Slide 18 text

Microservices não existem para escalar aplicações, mas sim para escalar times.

Slide 19

Slide 19 text

https://www.youtube.com/watch?v=GBTdnfD6s5Q

Slide 20

Slide 20 text

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

Slide 21

Slide 21 text

@duffleit Simple System

Slide 22

Slide 22 text

@duffleit Complicated System

Slide 23

Slide 23 text

@duffleit Complicated System

Slide 24

Slide 24 text

@duffleit Complicated System

Slide 25

Slide 25 text

@duffleit Complicated System

Slide 26

Slide 26 text

@duffleit Complicated System

Slide 27

Slide 27 text

@duffleit Complicated System 🔴

Slide 28

Slide 28 text

@duffleit Complicated System 🔴

Slide 29

Slide 29 text

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 “

Slide 30

Slide 30 text

Un·cer·tain·ty

Slide 31

Slide 31 text

O que é um Sistema Tolerante a Falhas?

Slide 32

Slide 32 text

https://deniseyu.io/art/

Slide 33

Slide 33 text

https://deniseyu.io/art/

Slide 34

Slide 34 text

https://deniseyu.io/art/

Slide 35

Slide 35 text

Desenhando sistemas distribuídos…

Slide 36

Slide 36 text

No content

Slide 37

Slide 37 text

No content

Slide 38

Slide 38 text

No content

Slide 39

Slide 39 text

No content

Slide 40

Slide 40 text

Spring Boot App

Slide 41

Slide 41 text

Spring Boot App

Slide 42

Slide 42 text

Spring Boot App Client Service

Slide 43

Slide 43 text

Spring Boot App Client Service

Slide 44

Slide 44 text

Spring Boot App Client Service Local Calls

Slide 45

Slide 45 text

Spring Boot App Client Service Local Calls

Slide 46

Slide 46 text

Spring Boot App Client Service Local Calls

Slide 47

Slide 47 text

Spring Boot App Client Service Local Calls Mas não aqui!

Slide 48

Slide 48 text

Spring Boot App Client Service Local Calls Mas não aqui!

Slide 49

Slide 49 text

Spring Boot App Client Service Local Calls

Slide 50

Slide 50 text

Em contrapartida…

Slide 51

Slide 51 text

Spring Boot App Spring Boot App

Slide 52

Slide 52 text

Spring Boot App Spring Boot App Client

Slide 53

Slide 53 text

Spring Boot App Spring Boot App Client Service

Slide 54

Slide 54 text

Spring Boot App Spring Boot App Client Service Internet

Slide 55

Slide 55 text

Spring Boot App Spring Boot App Client Service Internet

Slide 56

Slide 56 text

Spring Boot App Spring Boot App Client Service Internet Remote Calls

Slide 57

Slide 57 text

Spring Boot App Spring Boot App Client Service Internet Remote Calls

Slide 58

Slide 58 text

Spring Boot App Client Spring Boot App Service Internet Remote Calls

Slide 59

Slide 59 text

Spring Boot App Client Spring Boot App Service Internet Remote Calls

Slide 60

Slide 60 text

Spring Boot App Client Spring Boot App Service Internet Remote Calls

Slide 61

Slide 61 text

Spring Boot App Client Spring Boot App Service Internet Remote Calls

Slide 62

Slide 62 text

Spring Boot App Client Spring Boot App Service Internet Remote Calls

Slide 63

Slide 63 text

Spring Boot App Spring Boot App Internet Client Service Remote Calls

Slide 64

Slide 64 text

https://deniseyu.io/art/

Slide 65

Slide 65 text

https://deniseyu.io/art/

Slide 66

Slide 66 text

https://deniseyu.io/art/

Slide 67

Slide 67 text

https://deniseyu.io/art/

Slide 68

Slide 68 text

No content

Slide 69

Slide 69 text

No content

Slide 70

Slide 70 text

https://deniseyu.io/art/

Slide 71

Slide 71 text

No content

Slide 72

Slide 72 text

Por que isso importa?

Slide 73

Slide 73 text

Spring Boot App Spring Boot App Spring Boot App Local Calls Remote Calls

Slide 74

Slide 74 text

Spring Boot App Spring Boot App Spring Boot App Centralized System Distributed System

Slide 75

Slide 75 text

Spring Boot App Spring Boot App Spring Boot App Centralized System Distributed System

Slide 76

Slide 76 text

— Martin Fowler First Law of Distributed Object Design: "don’t distribute your objects"

Slide 77

Slide 77 text

Mas se não tiver jeito…

Slide 78

Slide 78 text

Spring Boot App Client Spring Boot App Service Internet Distributed System

Slide 79

Slide 79 text

Spring Boot App Client Spring Boot App Service Internet Distributed System

Slide 80

Slide 80 text

No content

Slide 81

Slide 81 text

No content

Slide 82

Slide 82 text

No content

Slide 83

Slide 83 text

No content

Slide 84

Slide 84 text

No content

Slide 85

Slide 85 text

Distributed System Spring Boot App Client Service Internet Database

Slide 86

Slide 86 text

Distributed System Spring Boot App Client Service Internet Database

Slide 87

Slide 87 text

Distributed System Spring Boot App Client Service Internet Database

Slide 88

Slide 88 text

@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)); } }

Slide 89

Slide 89 text

@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)); } }

Slide 90

Slide 90 text

@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)); } }

Slide 91

Slide 91 text

@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)); } }

Slide 92

Slide 92 text

@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)); } }

Slide 93

Slide 93 text

@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)); } }

Slide 94

Slide 94 text

@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)); } }

Slide 95

Slide 95 text

@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)); } }

Slide 96

Slide 96 text

@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)); } }

Slide 97

Slide 97 text

@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!

Slide 98

Slide 98 text

@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)); } }

Slide 99

Slide 99 text

@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)); } }

Slide 100

Slide 100 text

@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)); } }

Slide 101

Slide 101 text

@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)); } }

Slide 102

Slide 102 text

@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)); } }

Slide 103

Slide 103 text

Design for Failures

Slide 104

Slide 104 text

@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"

Slide 105

Slide 105 text

Fortaleza - Terra do Sol

Slide 106

Slide 106 text

No content

Slide 107

Slide 107 text

?

Slide 108

Slide 108 text

?

Slide 109

Slide 109 text

No content

Slide 110

Slide 110 text

UNBREAKABLE REST APIs Desenhando e implementando APIs robustas e previsíveis com fail fast e idempotency Rafael Ponte | @rponte

Slide 111

Slide 111 text

@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)); } }

Slide 112

Slide 112 text

@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)); } }

Slide 113

Slide 113 text

O que acontece quando esperamos demais?

Slide 114

Slide 114 text

Client Service Network Database Spring Boot App

Slide 115

Slide 115 text

Client Service Network Database Spring Boot App

Slide 116

Slide 116 text

Client Service Network Database Spring Boot App

Slide 117

Slide 117 text

Client Service Network Database Spring Boot App

Slide 118

Slide 118 text

Client Service Network Database Spring Boot App

Slide 119

Slide 119 text

Client Service Network Database Spring Boot App

Slide 120

Slide 120 text

Client Service Network Database Spring Boot App

Slide 121

Slide 121 text

Client Service Network Database Spring Boot App

Slide 122

Slide 122 text

Client Service Network Database Spring Boot App

Slide 123

Slide 123 text

Client Service Network Database Spring Boot App

Slide 124

Slide 124 text

Client Service Network Database Spring Boot App

Slide 125

Slide 125 text

Client Service Network Database Spring Boot App

Slide 126

Slide 126 text

Client Service Network Database Spring Boot App

Slide 127

Slide 127 text

Client Service Network Database Spring Boot App

Slide 128

Slide 128 text

Client Service Network Database Spring Boot App

Slide 129

Slide 129 text

Client Service Network Database Spring Boot App

Slide 130

Slide 130 text

Client Service Network Database Spring Boot App

Slide 131

Slide 131 text

No content

Slide 132

Slide 132 text

No content

Slide 133

Slide 133 text

Tudo isso porque esperamos demais…

Slide 134

Slide 134 text

Fail Fast

Slide 135

Slide 135 text

Fail Fast with timeouts

Slide 136

Slide 136 text

Não con fi e no timeout default dos frameworks

Slide 137

Slide 137 text

@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)); } }

Slide 138

Slide 138 text

@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)); } }

Slide 139

Slide 139 text

@Repository public interface UserRepository extends JpaRepository { @QueryHints({ @QueryHint(name = "javax.persistence.query.timeout", value = "2000") }) @Override public Optional findById(Long id); }

Slide 140

Slide 140 text

@Repository public interface UserRepository extends JpaRepository { @QueryHints({ @QueryHint(name = "javax.persistence.query.timeout", value = "2000") }) @Override public Optional findById(Long id); }

Slide 141

Slide 141 text

@Repository public interface UserRepository extends JpaRepository { @QueryHints({ @QueryHint(name = "javax.persistence.query.timeout", value = "2000") }) @Override public Optional findById(Long id); }

Slide 142

Slide 142 text

@Repository public interface UserRepository extends JpaRepository { @QueryHints({ @QueryHint(name = "javax.persistence.query.timeout", value = "2000") }) @Override public Optional findById(Long id); }

Slide 143

Slide 143 text

@Repository public interface UserRepository extends JpaRepository { @QueryHints({ @QueryHint(name = "javax.persistence.query.timeout", value = "2000") }) @Override public Optional findById(Long id); }

Slide 144

Slide 144 text

@Repository public interface UserRepository extends JpaRepository { @QueryHints({ @QueryHint(name = "javax.persistence.query.timeout", value = "2000") }) @Override public Optional findById(Long id); }

Slide 145

Slide 145 text

@Repository public interface UserRepository extends JpaRepository { @QueryHints({ @QueryHint(name = "javax.persistence.query.timeout", value = "2000") }) @Override public Optional findById(Long id); }

Slide 146

Slide 146 text

Quando a query demorar mais do que 2 seg…

Slide 147

Slide 147 text

SELECT u.* FROM user u WHERE u.id = 42 -- SQL Error: 0, SQLState: 57014 -- ERROR: canceling statement due to user request

Slide 148

Slide 148 text

Client Service Network Database Spring Boot App

Slide 149

Slide 149 text

Client Service Network Database Spring Boot App

Slide 150

Slide 150 text

Client Service Network Database Spring Boot App

Slide 151

Slide 151 text

Client Service Network Database Spring Boot App

Slide 152

Slide 152 text

Client Service Network Database Spring Boot App

Slide 153

Slide 153 text

Service Network Database Client Spring Boot App

Slide 154

Slide 154 text

O que acontece quando o cliente recebe um erro de timeout?

Slide 155

Slide 155 text

Un·cer·tain·ty

Slide 156

Slide 156 text

Client Service Network Database Spring Boot App

Slide 157

Slide 157 text

Client Service Network Database Spring Boot App

Slide 158

Slide 158 text

Client Service Network Database Spring Boot App

Slide 159

Slide 159 text

Client Service Network Database Spring Boot App

Slide 160

Slide 160 text

Client Service Network Database Spring Boot App

Slide 161

Slide 161 text

Client Service Network Database Spring Boot App

Slide 162

Slide 162 text

Client Service Network Database Spring Boot App

Slide 163

Slide 163 text

Client Service Network Database Spring Boot App

Slide 164

Slide 164 text

Como seu sistema se comporta quando o cliente re-tenta uma chamada?

Slide 165

Slide 165 text

@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)); } }

Slide 166

Slide 166 text

Aplicação Usuário Banco de dados

Slide 167

Slide 167 text

Aplicação Usuário Banco de dados GET /api/users/42

Slide 168

Slide 168 text

Aplicação Usuário Banco de dados GET /api/users/42 SELECT 1 FROM user u WHERE ud.id = 42

Slide 169

Slide 169 text

Aplicação Usuário Banco de dados GET /api/users/42 SELECT 1 FROM user u WHERE ud.id = 42

Slide 170

Slide 170 text

Aplicação Usuário Banco de dados GET /api/users/42 SELECT u.* FROM user u WHERE ud.id = 42

Slide 171

Slide 171 text

Aplicação Usuário Banco de dados GET /api/users/42 HTTP 503 (SERVICE UNAVAILABLE) SELECT u.* FROM user u WHERE ud.id = 42

Slide 172

Slide 172 text

Aplicação Usuário Banco de dados GET /api/users/42 HTTP 503 (SERVICE UNAVAILABLE) SELECT u.* FROM user u WHERE ud.id = 42

Slide 173

Slide 173 text

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

Slide 174

Slide 174 text

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

Slide 175

Slide 175 text

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

Slide 176

Slide 176 text

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

Slide 177

Slide 177 text

Mais do que isso…

Slide 178

Slide 178 text

Aplicação Usuário Banco de dados

Slide 179

Slide 179 text

Aplicação Usuário Banco de dados GET /api/users/42

Slide 180

Slide 180 text

Aplicação Usuário Banco de dados GET /api/users/42 SELECT u.* FROM user u WHERE ud.id = 42 5xx

Slide 181

Slide 181 text

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

Slide 182

Slide 182 text

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

Slide 183

Slide 183 text

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

Slide 184

Slide 184 text

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 . . .

Slide 185

Slide 185 text

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

Slide 186

Slide 186 text

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

Slide 187

Slide 187 text

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

Slide 188

Slide 188 text

IDEMPOTENCY

Slide 189

Slide 189 text

FUNCIONA MUITO BEM PARA ENDPOINTS DE LEITURA

Slide 190

Slide 190 text

FUNCIONA MUITO BEM PARA ENDPOINTS DE LEITURA …mas não tão bem para endpoints de escrita

Slide 191

Slide 191 text

IDEMPOTENCY O que acontece quando o cliente re-tenta uma requisição?

Slide 192

Slide 192 text

IDEMPOTENCY O que acontece quando o cliente re-tenta uma requisição? …de ESCRITA

Slide 193

Slide 193 text

@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 } }

Slide 194

Slide 194 text

@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 } }

Slide 195

Slide 195 text

@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 } }

Slide 196

Slide 196 text

@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 } }

Slide 197

Slide 197 text

@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 } }

Slide 198

Slide 198 text

@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 } }

Slide 199

Slide 199 text

@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 } }

Slide 200

Slide 200 text

@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 } }

Slide 201

Slide 201 text

@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 } }

Slide 202

Slide 202 text

@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 } }

Slide 203

Slide 203 text

@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 } }

Slide 204

Slide 204 text

@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 } }

Slide 205

Slide 205 text

@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 } }

Slide 206

Slide 206 text

@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 } }

Slide 207

Slide 207 text

@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 } }

Slide 208

Slide 208 text

@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 } }

Slide 209

Slide 209 text

Aplicação Usuário Banco de dados

Slide 210

Slide 210 text

Aplicação Usuário Banco de dados POST /api/users { name: “Gleice Elen”, email: “[email protected]” }

Slide 211

Slide 211 text

Aplicação Usuário Banco de dados INSERT INTO user (name , email) VALUES (:name, :email); POST /api/users { name: “Gleice Elen”, email: “[email protected]” }

Slide 212

Slide 212 text

Aplicação Usuário Banco de dados INSERT INTO user (name , email) VALUES (:name, :email); POST /api/users { name: “Gleice Elen”, email: “[email protected]” }

Slide 213

Slide 213 text

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);

Slide 214

Slide 214 text

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);

Slide 215

Slide 215 text

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);

Slide 216

Slide 216 text

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);

Slide 217

Slide 217 text

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);

Slide 218

Slide 218 text

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);

Slide 219

Slide 219 text

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);

Slide 220

Slide 220 text

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);

Slide 221

Slide 221 text

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);

Slide 222

Slide 222 text

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);

Slide 223

Slide 223 text

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

Slide 224

Slide 224 text

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

Slide 225

Slide 225 text

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

Slide 226

Slide 226 text

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 👀

Slide 227

Slide 227 text

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

Slide 228

Slide 228 text

TEMOS UM DUPLICIDADE BUG

Slide 229

Slide 229 text

@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 } }

Slide 230

Slide 230 text

@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 } }

Slide 231

Slide 231 text

@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! 😰

Slide 232

Slide 232 text

https://opensource.zalando.com/restful-api-guidelines/#229 Zalando API Guidelines

Slide 233

Slide 233 text

https://opensource.zalando.com/restful-api-guidelines/#229 Idempotency Key Zalando API Guidelines

Slide 234

Slide 234 text

https://opensource.zalando.com/restful-api-guidelines/#229 Conditional Key Zalando API Guidelines

Slide 235

Slide 235 text

https://opensource.zalando.com/restful-api-guidelines/#229 Secondary Key Zalando API Guidelines

Slide 236

Slide 236 text

https://opensource.zalando.com/restful-api-guidelines/#229 Secondary Key Zalando API Guidelines

Slide 237

Slide 237 text

@Entity public class User { @Id @GeneratedValue private Long id; private String name; private String email; private LocalDateTime createdAt; // construtor, getters etc }

Slide 238

Slide 238 text

@Entity public class User { @Id @GeneratedValue private Long id; private String name; private String email; private LocalDateTime createdAt; // construtor, getters etc }

Slide 239

Slide 239 text

@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 } }

Slide 240

Slide 240 text

@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 } }

Slide 241

Slide 241 text

@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!

Slide 242

Slide 242 text

SELECT exists ( SELECT 1 FROM user u WHERE u.email = :email );

Slide 243

Slide 243 text

@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 } }

Slide 244

Slide 244 text

@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!

Slide 245

Slide 245 text

@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 } }

Slide 246

Slide 246 text

@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 } }

Slide 247

Slide 247 text

@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!

Slide 248

Slide 248 text

Aplicação Usuário Banco de dados

Slide 249

Slide 249 text

Aplicação Usuário Banco de dados POST /api/users { name: “Gleice Elen”, email: “[email protected]” }

Slide 250

Slide 250 text

Aplicação Usuário Banco de dados POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists…

Slide 251

Slide 251 text

Aplicação Usuário Banco de dados POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists… INSERT user…

Slide 252

Slide 252 text

Aplicação Usuário Banco de dados POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_…

Slide 253

Slide 253 text

Aplicação Usuário Banco de dados POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_…

Slide 254

Slide 254 text

Aplicação Usuário Banco de dados POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… Network

Slide 255

Slide 255 text

Aplicação Usuário Banco de dados POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… Network

Slide 256

Slide 256 text

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]” }

Slide 257

Slide 257 text

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 );

Slide 258

Slide 258 text

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 );

Slide 259

Slide 259 text

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…

Slide 260

Slide 260 text

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

Slide 261

Slide 261 text

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

Slide 262

Slide 262 text

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…

Slide 263

Slide 263 text

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 ); 💪

Slide 264

Slide 264 text

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 🥳

Slide 265

Slide 265 text

E se…

Slide 266

Slide 266 text

Aplicação Usuário Banco de dados

Slide 267

Slide 267 text

Aplicação Usuário Banco de dados POST /api/users { name: “Gleice Elen”, email: “[email protected]” }

Slide 268

Slide 268 text

Aplicação Usuário Banco de dados POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists…

Slide 269

Slide 269 text

Aplicação Usuário Banco de dados POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists… INSERT user…

Slide 270

Slide 270 text

Aplicação Usuário Banco de dados POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_…

Slide 271

Slide 271 text

Aplicação Usuário Banco de dados POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_…

Slide 272

Slide 272 text

Aplicação Usuário Banco de dados POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_…

Slide 273

Slide 273 text

Aplicação Usuário Banco de dados POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… 5xx

Slide 274

Slide 274 text

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]” }

Slide 275

Slide 275 text

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 );

Slide 276

Slide 276 text

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 );

Slide 277

Slide 277 text

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

Slide 278

Slide 278 text

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

Slide 279

Slide 279 text

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

Slide 280

Slide 280 text

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_…

Slide 281

Slide 281 text

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 );

Slide 282

Slide 282 text

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

Slide 283

Slide 283 text

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

Slide 284

Slide 284 text

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 😱

Slide 285

Slide 285 text

TEMOS UM INCONSISTÊNCIA BUG

Slide 286

Slide 286 text

@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 } }

Slide 287

Slide 287 text

@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 } }

Slide 288

Slide 288 text

@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 } }

Slide 289

Slide 289 text

@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 😱

Slide 290

Slide 290 text

@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 } }

Slide 291

Slide 291 text

@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 } }

Slide 292

Slide 292 text

@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 } }

Slide 293

Slide 293 text

Para resolver…

Slide 294

Slide 294 text

@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 } }

Slide 295

Slide 295 text

No content

Slide 296

Slide 296 text

@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 } }

Slide 297

Slide 297 text

@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 } }

Slide 298

Slide 298 text

@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 } }

Slide 299

Slide 299 text

@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 } }

Slide 300

Slide 300 text

Aplicação Usuário Banco de dados

Slide 301

Slide 301 text

Aplicação Usuário Banco de dados POST /api/users { name: “Gleice Elen”, email: “[email protected]” }

Slide 302

Slide 302 text

Aplicação Usuário Banco de dados POST /api/users { name: “Gleice Elen”, email: “[email protected]” }

Slide 303

Slide 303 text

Aplicação Usuário Banco de dados POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists…

Slide 304

Slide 304 text

Aplicação Usuário Banco de dados POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists… INSERT user…

Slide 305

Slide 305 text

Aplicação Usuário Banco de dados POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_…

Slide 306

Slide 306 text

Aplicação Usuário Banco de dados POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_…

Slide 307

Slide 307 text

Aplicação Usuário Banco de dados POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_…

Slide 308

Slide 308 text

Aplicação Usuário Banco de dados POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_…

Slide 309

Slide 309 text

Aplicação Usuário Banco de dados POST /api/users { name: “Gleice Elen”, email: “[email protected]” } SELECT exists… INSERT user… INSERT user_audit_… 5xx

Slide 310

Slide 310 text

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]” }

Slide 311

Slide 311 text

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]” }

Slide 312

Slide 312 text

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_…

Slide 313

Slide 313 text

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_…

Slide 314

Slide 314 text

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_…

Slide 315

Slide 315 text

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_…

Slide 316

Slide 316 text

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

Slide 317

Slide 317 text

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

Slide 318

Slide 318 text

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_…

Slide 319

Slide 319 text

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 💪

Slide 320

Slide 320 text

E se…

Slide 321

Slide 321 text

Aplicação Usuário 1 Usuário 2

Slide 322

Slide 322 text

Aplicação Usuário 1 Usuário 2 POST /api/users { name: “Gleice Elen”, email: “[email protected]” }

Slide 323

Slide 323 text

Aplicação Usuário 1 Usuário 2 POST /api/users { name: “Gleice Elen”, email: “[email protected]” }

Slide 324

Slide 324 text

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]” }

Slide 325

Slide 325 text

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)

Slide 326

Slide 326 text

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)

Slide 327

Slide 327 text

SELECT u.* FROM user u

Slide 328

Slide 328 text

ID NAME EMAIL ... ... ... 42 Gleice Elen [email protected] 43 Gleice Elen [email protected] ... ... ... user 😱

Slide 329

Slide 329 text

TEMOS UM RACE CONDITION BUG

Slide 330

Slide 330 text

@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 } }

Slide 331

Slide 331 text

@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 } }

Slide 332

Slide 332 text

@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 } }

Slide 333

Slide 333 text

if (repository.existsByEmail(request.email())) { return ResponseEntity.ok("User exists”); // http 200 }; User user = request.toModel(); repository.save(user);

Slide 334

Slide 334 text

boolean exists = repository.existsByEmail(request.email()); if (exists) { return ResponseEntity.ok("User exists”); // http 200 }; User user = request.toModel(); repository.save(user);

Slide 335

Slide 335 text

boolean exists = repository.existsByEmail(request.email()); if (exists) { return ResponseEntity.ok("User exists”); // http 200 }; User user = request.toModel(); repository.save(user);

Slide 336

Slide 336 text

boolean exists = repository.existsByEmail(request.email()); if (exists) { return ResponseEntity.ok("User exists”); // http 200 }; User user = request.toModel(); repository.save(user);

Slide 337

Slide 337 text

boolean exists = repository.existsByEmail(request.email()); if (exists) { return ResponseEntity.ok("User exists”); // http 200 }; User user = request.toModel(); repository.save(user);

Slide 338

Slide 338 text

boolean exists = repository.existsByEmail(request.email()); if (exists) { return ResponseEntity.ok("User exists”); // http 200 }; User user = request.toModel(); repository.save(user);

Slide 339

Slide 339 text

READ-MODIFY-WRITE

Slide 340

Slide 340 text

READ-MODIFY-WRITE

Slide 341

Slide 341 text

READ-MODIFY-WRITE

Slide 342

Slide 342 text

READ-MODIFY-WRITE

Slide 343

Slide 343 text

READ-MODIFY-WRITE ANTI-PATTERN

Slide 344

Slide 344 text

@Entity public class User { @Id @GeneratedValue private Long id; private String name; private String email; private LocalDateTime createdAt; // construtor, getters etc }

Slide 345

Slide 345 text

@Entity public class User { @Id @GeneratedValue private Long id; private String name; private String email; private LocalDateTime createdAt; // construtor, getters etc }

Slide 346

Slide 346 text

@Entity public class User { @Id @GeneratedValue private Long id; private String name; @Column(unique = true) private String email; private LocalDateTime createdAt; // construtor, getters etc }

Slide 347

Slide 347 text

ALTER TABLE user ADD CONSTRAINT uk_email UNIQUE (email);

Slide 348

Slide 348 text

Aplicação Usuário 1 Usuário 2

Slide 349

Slide 349 text

Aplicação Usuário 1 Usuário 2 POST /api/users { name: “Gleice Elen”, email: “[email protected]” }

Slide 350

Slide 350 text

Aplicação Usuário 1 Usuário 2 POST /api/users { name: “Gleice Elen”, email: “[email protected]” }

Slide 351

Slide 351 text

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]” }

Slide 352

Slide 352 text

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)

Slide 353

Slide 353 text

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)

Slide 354

Slide 354 text

No content

Slide 355

Slide 355 text

Você percebeu?

Slide 356

Slide 356 text

Aplicação Usuário Banco de dados

Slide 357

Slide 357 text

Aplicação Usuário Banco de dados POST /api/users

Slide 358

Slide 358 text

Aplicação Usuário Banco de dados POST /api/users SELECT exists… INSERT user… INSERT user_audit_…

Slide 359

Slide 359 text

Aplicação Usuário Banco de dados POST /api/users SELECT exists… INSERT user… INSERT user_audit_…

Slide 360

Slide 360 text

Aplicação Usuário Banco de dados POST /api/users SELECT exists… INSERT user… INSERT user_audit_… OK

Slide 361

Slide 361 text

Aplicação Usuário Banco de dados POST /api/users 2xx OK SELECT exists… INSERT user… INSERT user_audit_…

Slide 362

Slide 362 text

Aplicação Usuário Banco de dados POST /api/users SELECT exists… INSERT user… INSERT user_audit_…

Slide 363

Slide 363 text

Aplicação Usuário Banco de dados POST /api/users SELECT exists… INSERT user… INSERT user_audit_…

Slide 364

Slide 364 text

Aplicação Usuário Banco de dados POST /api/users SELECT exists… INSERT user… INSERT user_audit_… ERROR

Slide 365

Slide 365 text

Aplicação Usuário Banco de dados POST /api/users SELECT exists… INSERT user… INSERT user_audit_… 5xx ERROR

Slide 366

Slide 366 text

TUDO NADA ou

Slide 367

Slide 367 text

TUDO ou NADA

Slide 368

Slide 368 text

TUDO NADA ou

Slide 369

Slide 369 text

Espera… onde já vimos isso? 🤔

Slide 370

Slide 370 text

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

Slide 371

Slide 371 text

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_…

Slide 372

Slide 372 text

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

Slide 373

Slide 373 text

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

Slide 374

Slide 374 text

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

Slide 375

Slide 375 text

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

Slide 376

Slide 376 text

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

Slide 377

Slide 377 text

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

Slide 378

Slide 378 text

THE 1:1 MODEL Mapear uma transação para um HTTP request

Slide 379

Slide 379 text

THE 1:1 MODEL Brandur | @brandur Mapear uma transação para um HTTP request

Slide 380

Slide 380 text

https://brandur.org/http-transactions

Slide 381

Slide 381 text

@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 } }

Slide 382

Slide 382 text

Tenho uma opinião forte sobre esse tema…

Slide 383

Slide 383 text

Todo endpoint de uma API REST deveria ser…

Slide 384

Slide 384 text

IDEMPOTENTE Todo endpoint de uma API REST deveria ser…

Slide 385

Slide 385 text

CONCLUINDO

Slide 386

Slide 386 text

Sistemas distribuídos podem ser difíceis… 😬

Slide 387

Slide 387 text

No content

Slide 388

Slide 388 text

“Use o banco apenas como repositório de dados.”

Slide 389

Slide 389 text

“Use o banco apenas como repositório de dados.” Não!

Slide 390

Slide 390 text

Recapitulando…

Slide 391

Slide 391 text

Agora temos uma API REST robusta que…

Slide 392

Slide 392 text

No content

Slide 393

Slide 393 text

…falha rapidamente

Slide 394

Slide 394 text

…permite re-tentativas do cliente …falha rapidamente

Slide 395

Slide 395 text

…abraça o tudo ou nada …permite re-tentativas do cliente …falha rapidamente

Slide 396

Slide 396 text

…abraça o tudo ou nada …permite re-tentativas do cliente …falha rapidamente …previne falhas de races conditions

Slide 397

Slide 397 text

No content

Slide 398

Slide 398 text

Mas que serve para outras plataformas

Slide 399

Slide 399 text

Por fi m…

Slide 400

Slide 400 text

Minha sub-celebridade ❤ 🌟

Slide 401

Slide 401 text

@rponte Rafael Ponte Obrigado!!