This is sample for Micronaut Data using Oracle Json Duality View.

It uses test container with docker image "gvenzl/oracle-free:latest-faststart" by default and then datasource configuration is taken from the container before starting Micronaut application context.

When app is ready, to create initial data, you can use this:

curl -X POST http://localhost:8080/init

And to list all students, use this:

curl http://localhost:8080/students

To find student by id:

curl http://localhost:8080/students/1

Find student by name:

curl http://localhost:8080/students/student/Peter

Create new student with classes

curl -d '{"student":"Peter", "averageGrade":9.8, "classes": ["Math", "English"]}' -H "Content-Type: application/json" -X POST http://localhost:8080/students

To update student average grade

curl -X PUT http://localhost:8080/students/1/average_grade/9.8

Find max average grade:

curl http://localhost:8080/students/max_average_grade

Update student name:

curl -X PUT http://localhost:8080/students/1/student/NewName

In order to delete student by id

curl -X DELETE http://localhost:8080/students/1