问题描述
我如何代表多对多"广告?与Room
有关系?我的列名也相同.
How can I represent a "many to many" relation with Room
? My column names are also the same.
例如我有Guest
和Reservation
. Reservation
可以有许多Guest
,而Guest
可以是许多保留的一部分.
e.g. I have Guest
and Reservation
. Reservation
can have many Guest
's and a Guest
can be part of many Reservations.
这是我的实体定义:
@Entity data class Reservation(
@PrimaryKey val id: Long,
val table: String,
val guests: List<Guest>
)
@Entity data class Guest(
@PrimaryKey val id: Long,
val name: String,
val email: String
)
在查看文档时,我遇到了 @Relation
.我发现这确实令人困惑.
While looking into docs I came across @Relation
. I found it really confusing though.
据此,我想创建一个POJO并在其中添加关系.因此,在我的示例中,我执行了以下操作:
According to this I would want to create a POJO and add the relationships there. So, with my example I did the following:
data class ReservationForGuest(
@Embedded val reservation: Reservation,
@Relation(
parentColumn = "reservation.id",
entityColumn = "id",
entity = Guest::class
) val guestList: List<Guest>
)
以上,我得到编译器错误:
With above I get the compiler error:
> Cannot figure out how to read this field from a cursor.
我找不到@Relation
的有效样本.
推荐答案
我遇到了类似的问题.这是我的解决方法.
I had a similar issue. Here is my solution.
您可以使用一个额外的实体(ReservationGuest
),该实体保持Guest
和Reservation
之间的关系.
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
)
您可以通过他们的guestId
s列表进行预订. (不是来宾对象)
You can get reservations with their list of guestId
s. (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>
)
您还可以通过其reservationId
列表来邀请客人. (不是保留对象)
You can also get guests with their list of reservationId
s. (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>
)
由于可以获得guestId
和reservationId
,因此可以使用这些查询Reservation
和Guest
实体.
Since you can get the guestId
s and reservationId
s, you can query Reservation
and Guest
entities with those.
如果我找到一种简单的方法来获取预订和来宾对象列表而不是其ID,我将更新答案.
I'll update my answer if I find an easy way to fetch Reservation and Guest object list instead of their ids.
这篇关于如何代表“多对多"广告?列名称相同时与Android Room的关系?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!