安卓@DatabaseView找不到我的观点

Question

我创建了一个复杂的数据库视图来从我的tables中获取一些数据：

@DatabaseView(viewName = "VIEW_SEDINTE_SPECIALE",
value = "SELECT descriere AS description, UPPER(titlu) AS upperTitle," +
"(CASE " +
"WHEN puncte_premiu * 2 > 100 THEN 100 " +
"ELSE puncte_premiu * 2 " +
"END) AS doubledRewards " +
"FROM sarcini")
public class SpecialTask {
public String upperTitle;
public String description;
public Long doubledRewards;
public SpecialTask(String upperTitle, String description, Long doubledRewards) {
this.upperTitle = upperTitle;
this.description = description;
this.doubledRewards = doubledRewards;
}
}

根据文档，我指定了数据库的视图：

@Database(
entities = {
Role.class, Task.class, TaskHistory.class, User.class,
Feedback.class, Location.class, Material.class,
SessionMaterial.class, SessionTask.class,
Problem.class, Session.class
},
views = {
SpecialTask.class
},
version = 1
)
@TypeConverters(DateConverter.class)
public abstract class PersonalDevelopmentDatabase extends RoomDatabase { ... }

在我的QueriesDao中，我想从Viewselect everything：

@Dao
public interface QueriesDao {
@Query("SELECT * FROM VIEW_SEDINTE_SPECIALE")
LiveData<List<SpecialTask>> getSpecialTasks();
}

我遇到了以下错误：

There is a problem with the query: [SQLITE_ERROR] SQL error or missing database (no such table: VIEW_SEDINTE_SPECIALE)

我浏览了很多帖子，但没有解决方案帮助我。我应该如何解决这个问题？

Answer 1

如果添加新的视图或表，则必须递增数据库的版本。因此，请尝试将PersonalDevelopmentDatabase更新到版本 2。