Hi, is there an example that uses r2dbc, Coroutine...

# spring

[kubele]

Hi, is there an example that uses r2dbc, CoroutineCrudRepository and ManyToOne/ManyToMany relationships?

[Johan]

Of what I remember, it isn't supported yet

[Johan]

I have seen some use transient to solve it. Ex https://gokhana.dev/spring-r2dbc-for-reactive-relational-databases-in-reactive-programming/

[dany giguere]

You could create your own manyToMany relationship (or anyone) by yourself using DataBase Client. And then you can even run queries in parallel. Look at this fully functional demo: https://github.com/danygiguere/spring-boot-3-reactive-with-kotlin-coroutines/blob/main/src/main/kotlin/com/example/demo/post/PostService.kt

// oneToMany relationship query example
    suspend fun findByIdWithImages(id: Long): PostWithImagesDto? = coroutineScope {
        val post = async{findById(id)}
        val images = async{imageRepository.findByPostId(id)?.toList()}
        return@coroutineScope post.await()?.toPostWithImagesDto()?.copy(images = images.await())
    }