作者:陆寥频 | 来源:互联网 | 2023-01-20 11:33
我有两个实体DBList
加入DBListContent
.随着一个之间一对多的关系DBList
和DBListContent
.
这是DBList
班级
@Entity(tableName = "lists")
public class DBList {
@PrimaryKey
private String listId;
private String title;
private String createdDateTime;
}
这里是 DBListContent
@Entity(tableName = "listContents")
public class DBListContent {
@PrimaryKey
public String listContentId;
public String content;
public String lastEditedBy;
public String lastEditedDateTime;
@ForeignKey(entity = DBList.class, parentColumns = "listId", childColumns = "dbListId", OnDelete= CASCADE)
public String dbListId;
}
当我删除lists
表中的行时,表中的相应行listContents
不会被删除.
我使用以下Dao方法删除了行
@Delete
void deleteLists(List dbLists);
@Query("delete from lists")
void deleteLists();
我知道我错过了一些非常明显的东西.请指导我.
1> 小智..:
我不知道回答你的问题为时已晚,但你所犯的错误就是放在@ForeignKey
一个领域.
该@ForeignKeys
MUST进去表声明.
你的代码应该是这样的.
@Entity(tableName = "listContents",foreignKeys ={
@ForeignKey(OnDelete= CASCADE,entity = DBList.class,
parentColumns = "listId",childColumns = "dbListId")},
indices = {
@Index("dbListId"),
})
public class DBListContent {
@PrimaryKey
public String listContentId;
public String content;
public String lastEditedBy;
public String lastEditedDateTime;
public String dbListId;
}