DatabaseView

Marks a class as an SQLite view.

The value of the annotation is a SELECT query used when the view is created.

The class will behave like normal data object when it is used in a Dao. You can SELECT FROM a DatabaseView similar to an Entity, but you can not INSERT, DELETE or UPDATE into a DatabaseView.

Similar to an Entity, you can use ColumnInfo and Embedded to customize the data class.

Example:

@DatabaseView(
    """
    SELECT id, name, release_year FROM Song
    WHERE release_year >= 1990 AND release_year <= 1999
    """
)
data class SongFrom90s (
    val id: Long,
    val name: String,
    @ColumnInfo(name = "release_year")
    val releaseYear: Int
)

Views have to be registered to a Room database via Database.views.

Summary

DatabaseView(value: String = "", viewName: String = "")

val value: String

val viewName: String