时间戳

首页 > 解决方案 > Android @DatabaseView 找不到我的视图

android - Android @DatabaseView 找不到我的视图

问题描述

我创建了一个复杂的数据库视图来从我的获取一些数据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我想select everything从View：

@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)

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

标签： androidsqliteandroid-roomdatabase-view

解决方案

如果添加新视图或表，则必须增加数据库的版本。所以尝试更新PersonalDevelopmentDatabase到版本 2。

推荐阅读