在Room数据库Android中为@DatabaseView传递参数

Question

我有一个像这样的数据库视图代码。

@DatabaseView("SELECT * FROM Product")
data class ProductDatabaseView(
    var productCode: String? = "",
    var productName: String? = "",
    var longDescription: String? = "",
    var productUom: String? = "",
    var customerCode: String? = "",
    var price: String? = ""
)

我希望能够像我们在DAO中做的那样传递一些值。

@DatabaseView("SELECT * FROM Product WHERE priceListCode = :priceListCode")
data class ProductDatabaseView(
    var productCode: String? = "",
    var productName: String? = "",
    var longDescription: String? = "",
    var productUom: String? = "",
    var customerCode: String? = "",
    var price: String? = ""
)

这种方式是否能够传递值或者有没有其他可用的选项可以通过View来帮助实现。

- Android Rajaganapathi

Answer 1

据我所知，您不能将参数传递给 @DatabaseView。它们与 sqlite 中的视图工作方式相同，不允许在视图中使用参数。

- Biscuit