How to use entities with many to many relations ? about ktorm HOT 6 CLOSED

AFAIK, Ktorm doesn't currently support many to many relations out of the box.
I usually work around this by having a function, which returns a list through a query.
So in your case it would be:

interface Recipe: Entity<Recipe>{
    val id: Int
    val name: String
    fun getTags(): List<Tag> = TagRecipes.findList { it.idRecipe eq id }
}

from ktorm.

On another note, you might want to change your TagRecipes joining table schema to use references (foreign keys), instead of manually setting the ids in your code. https://ktorm.liuwj.me/en/entities-and-column-binding.html#Column-Binding

from ktorm.

Ok, thanks

from ktorm.

Comparing to writing a function, I'd prefer using a property with a custom getter:

interface Recipe: Entity<Recipe>{
    val id: Int
    val name: String
    val tags get() = TagRecipes.findList { it.idRecipe eq id }
}

from ktorm.

Now that findList is deprecated in favor of database.sequenceOf(), what is the suggested way to do this?

from ktorm.

@DavidGrinberg Here is our discussions about this problem #73

from ktorm.