kubawieczorek

INSERT INTO employees(employeeid, lastname, firstname, payment)
	VALUES (1, 'McDonald', 'Carl', 1000)
	
SELECT xmin, xmax, employeeid, lastname, firstname, payment
	FROM employees WHERE firstname = 'Carl';

kubawieczorek

BEGIN;

SELECT txid_current();

kubawieczorek

UPDATE employees
	SET  payment=5000
	WHERE employeeid = 1

kubawieczorek

SELECT xmin, xmax, employeeid, lastname, firstname, payment
	FROM public.employees;

kubawieczorek

SELECT employeeid, lastname, firstname, payment
	FROM public.employees;

kubawieczorek

INSERT INTO employees(
	employeeid, lastname, firstname, payment)
	VALUES (1, 'John', 'Smith', 3000);

kubawieczorek

{
  "_embedded": {
    "accounts": [
      {
        "number": "100",
        "money": 1500,
        "clientName": "Thomas Johnson",
        "_links": {
          "self": {
            "href": "http://localhost:8080/accounts/1"

kubawieczorek

@Projection(name = "accountProjection", types = {Account.class})
public interface AccountProjection {

    @Value("#{target.getClient().getName()}")
    String getClientName();

    Integer getMoney();

    String getNumber();
}

kubawieczorek

@Repository
public interface AccountRepository extends CrudRepository<Account, Integer> {
}

kubawieczorek

@RestController
@RequestMapping("/accounts")
public class AccountsController {

    private final AccountService accountService;

    @Autowired
    public AccountsController(AccountService accountService) {
        this.accountService = accountService;
    }