# PostgreSQL JSON and enum column support

This project demonstrates a reactive Spring Boot application using R2DBC with PostgreSQL JSON column support. It implements a blog-like system with posts and comments, featuring pagination and reactive endpoints.

***

## Features

* Reactive REST API using Spring WebFlux
* R2DBC with PostgreSQL for reactive database operations
* JSON column support for flexible data storage
* Flyway database migrations
* Pagination and sorting support
* Docker support with health checks
* Comprehensive test coverage using TestContainers
* Metrics and tracing with Micrometer

***

## Prerequisites

* JDK 21
* Docker and Docker Compose
* PostgreSQL 15+

***

## Getting Started

1. Clone the repository
2. Run PostgreSQL using Docker:

   ```bash
   docker-compose -f docker/docker-compose.yml up -d
   ```
3. Run the application.

   ```shell
   ./mvnw spring-boot:run
   ```

***

## API Endpoints

* `GET /posts?page=0&size=10&sort=title&direction=ASC` - Get paginated posts
* `GET /posts/{id}` - Get a specific post
* `POST /posts` - Create a new post
* `PUT /posts/{id}` - Update a post
* `DELETE /posts/{id}` - Delete a post
* `GET /posts/{postId}/comments` - Get comments for a post
* `POST /posts/{postId}/comments` - Add a comment to a post

***

## Architecture

```mermaid
sequenceDiagram
    participant Client
    participant WebRouter
    participant PostHandler
    participant PostRepository
    participant CommentRepository
    participant Database

    Client->>WebRouter: GET /posts?page=0&size=10
    WebRouter->>PostHandler: route to handler
    PostHandler->>PostRepository: findAllWithPagination(offset, size, sort, direction)
    PostRepository->>Database: Execute query
    Database-->>PostRepository: Return posts
    PostHandler->>CommentRepository: findAllByPostIdIn(postIds)
    CommentRepository->>Database: Execute query
    Database-->>CommentRepository: Return comments
    PostHandler->>PostHandler: Combine posts with comments
    PostHandler-->>Client: Return PagedResult<Post>
```

***

## Running Tests

The project includes both unit and integration tests using TestContainers:

```bash
./mvnw verify
```

***

## Docker Deployment

Build and run the application using Docker:

```bash
./mvnw spring-boot:build-image
docker-compose -f docker/docker-compose-app.yml up -d
```

***

## Monitoring

The application exposes various actuator endpoints for monitoring:

* Health: `/actuator/health`
* Metrics: `/actuator/metrics`
* Info: `/actuator/info`

***

## Configuration

Key application properties can be configured in `application.properties`:

* Database connection settings
* Logging levels
* Jackson JSON settings
* Management endpoints


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://rajadilipkolli.gitbook.io/my-spring-boot-experiments/r2dbc/boot-r2dbc-json-column.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.