我在android上使用OrmLite进行类似于以下结构的结构:
Book类具有主要的BookArticle集合和次要的BookArticle集合:
@DatabaseTable(tableName = "BookV1", daoClass = BookDaoImplV1.class)
public class Book implements IBook {
@DatabaseField(id = true)
private String id;
@ForeignCollectionField(eager = false)
private ForeignCollection primaryArticles;
@ForeignCollectionField(eager = false)
private ForeignCollection secondaryArticles;
// constructor getters setters etc...
}
然后将BookArticle声明如下:
@DatabaseTable(tableName = "BookArticleV1", daoClass = BookArticleDaoImplV1.class)
public class BookArticle implements IBookArticle {
@DatabaseField(id = true)
private String id;
@DatabaseField
private String title;
@DatabaseField
private String summary;
// for ORM mapping only
@DatabaseField(foreign = true, foreignAutoRefresh = true, columnName = BOOK_FIELDNAME, index = true)
private Book book;
// constructor getters setters etc..
}
现在使用DAO保存BookArticles和Book可以很好地工作,但是当我想从数据库中获取Book实体并访问主要或次要文章(在refresh()之后)时,我遇到了问题,因为两个馆藏都保存了所有文章(主要和次要)二级),其“图书”列中包含该图书的ID.
显然,从数据库中获取时,我需要将这些主要文章和辅助文章分开.
我本来希望“ foreignFieldName”是我的问题的答案.
@ForeignCollectionField(eager = false, foreignFieldName = "secondaryArticles")
private ForeignCollection secondaryArticles;
但显然,这种方式行不通.
有没有办法让我区分这两个系列?
也许使用简单的注释参数(例如“ owningFieldName”或类似的参数)与BookArticle数据一起保留在DB中?
非常感谢您的帮助.
亚历克斯