alexandre-jacquot-ptl

version: "3.1"

services:

  mongo:
    image: mongo
    restart: always
    ports:
      - "27017:27017"
    volumes:

alexandre-jacquot-ptl

version: "3.5"

services:

  postgres:
    container_name: postgres
    image: postgres:13.2
    restart: always
    environment:
      - POSTGRES_USER=admin

alexandre-jacquot-ptl

    <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-webflux</artifactId>
    </dependency>	
    
    <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-data-r2dbc</artifactId>
    </dependency>

alexandre-jacquot-ptl

@Table
@Getter
@Setter
@Accessors(chain = true)
@NoArgsConstructor
public class Item {

    @Id
    private Long id;

alexandre-jacquot-ptl

@Table
@Getter
@Setter
@Accessors(chain = true)
public class Person {

    @Id
    private Long id;

    @Version

alexandre-jacquot-ptl

@Table
@Getter
@Setter
@Accessors(chain = true)
public class Tag {

    @Id
    private Long id;

    @Version

alexandre-jacquot-ptl

@SpringBootApplication
@EnableR2dbcAuditing
public class TodoListApplication {

	public static void main(String[] args) {
		SpringApplication.run(TodoListApplication.class, args);
	}

}

alexandre-jacquot-ptl

databaseChangeLog:

  ...

  - changeSet:
      id: create-item-table
      author: ajacquot
      changes:
        - createTable:
            schema: public

alexandre-jacquot-ptl

# Liquibase (schema update)
spring.liquibase.change-log=classpath:/db/db.changelog.yaml
spring.liquibase.url=jdbc:postgresql://127.0.0.1:5432/todolist
spring.liquibase.user=admin
spring.liquibase.password=password

alexandre-jacquot-ptl

@Repository
public interface ItemRepository extends ReactiveSortingRepository<Item, Long> {

}