yshameer/spring-reactive-mysql

Spring Boot R2DBC MySQL REST Application

Spring Reactive MySQL

App provides basic CRUD operations connecting to MySql database using reactive relational database driver (R2DBC)

This app is tested connecting to Aurora MySQL

Pre-Req: Update below properties in application.properties file to connect to your MySQL db of choice

spring.r2dbc.url=r2dbc:pool:mysql://<<Your MySQL Host>>:3306/customer
spring.r2dbc.username=<<User Name>>
spring.r2dbc.password=<<Password>>

Create table in your mysql schema

CREATE TABLE customer ( id SERIAL PRIMARY KEY, customer_name VARCHAR(100) NOT NULL, customer_type VARCHAR(100) NOT NULL, customer_status VARCHAR(100) NOT NULL);

Start app:

./mvnw spring-boot:run

Sample requests to test APIs

Create a record:

curl --header "Content-Type: application/json" \
    --request POST \
    --data '{"customer_name":"Bob","customer_type":"Publisher","customer_status": "Active"}' \
    http://127.0.0.1:8080

Get all customers:

curl http://127.0.0.1:8080

Get a record:

curl http://127.0.0.1:8080/customer?id=2

Update a record:

curl --header "Content-Type: application/json" \
    --request PUT \
    --data '{"id":"3","customer_name":"Bob","customer_type":"Publisher","customer_status": "InActive"}' \
    http://127.0.0.1:8080

Delete a record:

curl --header "Content-Type: application/json" \
    --request DELETE \
    http://127.0.0.1:8080?id=2

Test profile uses in memory (H2) database