Persistence

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12

// File: io.gh.boundaries.coffeestore.java-application-conventions.gradle

dependencies {
    // ... existing dependencies

    implementation('org.springframework.boot:spring-boot-starter-data-jpa')

    implementation('org.flywaydb:flyway-core:9.8.3')

    testImplementation('org.testcontainers:postgresql:1.17.6')
    testImplementation('org.testcontainers:junit-jupiter:1.17.6')
}

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13

-- File: app/src/main/resources/db/migration/V1__Add_coffee_bag_table.sql

CREATE TABLE coffee_bag (
    id UUID NOT NULL PRIMARY KEY,
    name varchar(255) NOT NULL,
    description text NOT NULL,
    roasting_profile varchar(50) NOT NULL,
    roasting_date date NOT NULL,
    roasting_vendor VARCHAR(200) NOT NULL,
    weight_code varchar(5) NOT NULL,
    weight_text varchar(50) NOT NULL,
    weight_value numeric NOT NULL
);

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51

// File: app/src/main/java/io/gh/boundaries/coffeestore/bag/persistence/CoffeeBagEntity.java

@Entity(name = "coffee_bag")
@AllArgsConstructor
@ToString
public class CoffeeBagEntity {
    @Id
    @Column(name = "id", nullable = false)
    private UUID id;

    @Column(name = "name", nullable = false)
    private String name;

    @Column(name = "description", nullable = false)
    private String description;

    @Column(name = "roasting_profile", nullable = false)
    private RoastingProfile roastingProfile;

    @Column(name = "roasting_date", nullable = false)
    private LocalDate roastingDate;

    @Column(name = "roasting_vendor", nullable = false)
    private String roastingVendor;

    @Column(name = "weight_code", nullable = false)
    private String weightCode;

    @Column(name = "weight_text", nullable = false)
    private String weightText;

    @Column(name = "weight_value", nullable = false)
    private BigDecimal weightValue;

    private CoffeeBagEntity() {
        this(null, null, null, null, null, null, null, null, null);
    }

    @Override
    public boolean equals(Object o) {
        if (this == o) return true;
        if (o == null || Hibernate.getClass(this) != Hibernate.getClass(o)) return false;
        CoffeeBagEntity that = (CoffeeBagEntity) o;
        return id != null && Objects.equals(id, that.id);
    }

    @Override
    public int hashCode() {
        return getClass().hashCode();
    }
}

1
2
3

// File: app/src/main/java/io/gh/boundaries/coffeestore/bag/persistence/CoffeeBagsRepository.java

public interface CoffeeBagsRepository extends JpaRepository<CoffeeBagEntity, UUID> {}

1
2
3
4
5
6
7

# app/src/test/resources/application-test.yml

spring:
    datasource:
      url: jdbc:tc:postgresql:15:///coffeebags
      username: user
      password: password

1
2
3
4
5
6
7
8
9

// File: buildSrc/src/main/groovy/io.gh.boundaries.coffeestore.java-application-conventions.gradle

test {
    systemProperty 'spring.profiles.active', 'test'
    environment = [
            'TESTCONTAINERS_DOCKER_SOCKET_OVERRIDE': '/var/run/docker.sock',
            'DOCKER_HOST': "unix://${System.getenv('HOME')}/.colima/docker.sock"
    ]
}

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26

// File: app/src/test/java/io/gh/boundaries/coffeestore/bag/persistence/CoffeeBagsRepositoryTest.java

@DataJpaTest
@AutoConfigureTestDatabase(replace = AutoConfigureTestDatabase.Replace.NONE)
class CoffeeBagsRepositoryTest {
    @Autowired
    CoffeeBagsRepository repository;

    @Test
    void retrievesAllCoffeeBags() throws Exception {
        CoffeeBagEntity coffeeBagEntity = new CoffeeBagEntity(
                UUID.randomUUID(),
                "Iridescent",
                "Includes coffees from Ethiopia, Kenya, and Latin America. It’s a  combination of some of our best, most interesting coffees, and features notes of dark chocolate and berry. Each year, we donate $1 per pound from Iridescent to fund transformative projects in coffee-producing countries through our Seeds fund—a program that awards grants to producer-driven sustainability projects. Because good work, good cheer, and great coffee is more than just a winter theme.",
                RoastingProfile.Dark,
                LocalDate.now().minusDays(2),
                "https://counterculturecoffee.com",
                "GRM",
                "g",
                new BigDecimal("340"));

        repository.saveAll(List.of(coffeeBagEntity));

        assertThat(repository.findAll()).containsOnly(coffeeBagEntity);
    }
}