How can I represent a “many to many” relation with Android Room when column names are same?

by

I had a similar issue. Here is my solution.

You can use an extra entity (ReservationGuest) which keeps the relation between Guest and Reservation.

@Entity data class Guest(
    @PrimaryKey val id: Long,
    val name: String,
    val email: String
)

@Entity data class Reservation(
    @PrimaryKey val id: Long,
    val table: String
)

@Entity data class ReservationGuest(
    @PrimaryKey(autoGenerate = true) val id: Long,
    val reservationId: Long,
    val guestId: Long
)

You can get reservations with their list of guestIds. (Not the guest objects)

data class ReservationWithGuests(
    @Embedded val reservation:Reservation,
    @Relation(
        parentColumn = "id",
        entityColumn = "reservationId",
        entity = ReservationGuest::class,
        projection = "guestId"
    ) val guestIdList: List<Long>
)

You can also get guests with their list of reservationIds. (Not the reservation objects)

data class GuestWithReservations(
    @Embedded val guest:Guest,
    @Relation(
        parentColumn = "id",
        entityColumn = "guestId",
        entity = ReservationGuest::class,
        projection = "reservationId"
   ) val reservationIdList: List<Long>
)

Since you can get the guestIds and reservationIds, you can query Reservation and Guest entities with those.

I’ll update my answer if I find an easy way to fetch Reservation and Guest object list instead of their ids.

Similar answer

More Related Contents:

  1. Room Persistence: Error:Entities and Pojos must have a usable public constructor
  2. Android Room – simple select query – Cannot access database on the main thread
  3. Android Persistence room: “Cannot figure out how to read this field from a cursor”
  4. Android Room: Insert relation entities using Room
  5. Room – LiveData observer does not trigger when database is updated
  6. Android Room – Select query with LIKE
  7. Return type for Android Room joins
  8. How to save enum field in the database room?
  9. How to make primary key as autoincrement for Room Persistence lib
  10. How I can retrieve current fragment in NavHostFragment?
  11. How to combine two live data one after the other?
  12. Backup Room database
  13. Print nubers 1, 3, 6, 10, 15, 21 from a given range using Kotlin [closed]
  14. How to add image background in button Android studio
  15. Updating Paging 3 alpha to stable cause indexing issue Android
  16. Deprecated Gradle features were used in this build, making it incompatible with Gradle 5.0
  17. Sharing data between fragments using new architecture component ViewModel
  18. Error:Execution failed for task ‘:app:compileDebugKotlin’. > Compilation error. See log for more details
  19. IllegalArgumentException: navigation destination xxx is unknown to this NavController
  20. Opening Android Settings programmatically
  21. android.view.View.systemUiVisibility deprecated. What is the replacement?
  22. How to call a function after delay in Kotlin?
  23. Why there’s a separate MutableLiveData subclass of LiveData?
  24. How to use Data Binding and Kotlin in Android Studio 3.0.0
  25. ViewPager with Navigation architecture components [duplicate]
  26. How insert image in room persistence library?
  27. JaCoCo returning 0% Coverage with Kotlin and Android 3.0
  28. Why Kotlin data classes can have nulls in non-nullable fields with Gson?
  29. lateinit modifier is not allowed on primitive type properties in Kotlin
  30. Exposed drop-down menu for jetpack compose

Leave a Comment