会议室数据库更新列 （CHeckbox）

问：

我最近开始编写应用程序，但还没有那么多经验。尤其是数据库编程。

我有购物清单，想检查商品。

我仍然无法更新该列。我在互联网上找到了一些东西，但无法将它们放在一起。例如，我不知道如何从项目中获取 id。或者我根本不需要身份证件？

我寻求帮助。谢谢！

实体：

@Entity
data class ShoppingList(
    val Name: String,
    val Einheit: String,
    val Menge: String,
    @ColumnInfo(name = "isChecked", defaultValue = "0")
    val isChecked: Boolean,
    @PrimaryKey(autoGenerate = true)
    val id: Int = 0

道：

@Dao
interface ShoppingListDao {

    @Upsert
    suspend fun upsertItem(items: ShoppingList)

    @Query("UPDATE ShoppingList SET isChecked = :isChecked WHERE id = :id")
    suspend fun updateItem(isChecked: Boolean, id: Int)

    @Delete
    suspend fun deleteItem(items: ShoppingList)

    @Query("SELECT * FROM ShoppingList ORDER BY Name ASC")
    fun getItemsOrderByName(): Flow<List<ShoppingList>>

}

事件：

sealed interface ShoppingListEvent{
    object SaveItem: ShoppingListEvent
    data class SetName(val Name: String): ShoppingListEvent
    data class SetEinheit(val Einheit: String): ShoppingListEvent
    data class SetMenge(val Menge: String): ShoppingListEvent
    data class SetCheckbox(val isChecked: Boolean): ShoppingListEvent
    object ShowDialog: ShoppingListEvent
    object HideDialog: ShoppingListEvent
    data class SortItems(val sortType: SortType): ShoppingListEvent
    data class DeleteItem(val items: ShoppingList): ShoppingListEvent
}

州：

data class ShoppingListState (
    val items: List<ShoppingList> = emptyList(),
    val Name: String = "",
    val Einheit: String = "",
    val Menge: String = "",
    val isChecked: Boolean = false,
    val isAddingItem: Boolean = false,
    val sortType: SortType = SortType.Name
)

视图模型：

class ShoppingListViewModel(
    private val  dao: ShoppingListDao
): ViewModel() {

    private val _sortType = MutableStateFlow(SortType.Name)
    private val _items = _sortType
        .flatMapLatest { sortType ->
            when(sortType) {
                SortType.Name -> dao.getItemsOrderByName()
            }
        }
        .stateIn(viewModelScope, SharingStarted.WhileSubscribed(), emptyList())

    private val _state = MutableStateFlow(ShoppingListState())
    val state = combine(_state, _sortType, _items) { state, sortType, items ->
        state.copy(
            items = items,
            sortType = sortType
        )
    }.stateIn(viewModelScope, SharingStarted.WhileSubscribed(5000), ShoppingListState())


    fun onEvent(event: ShoppingListEvent){
        when(event){

            ....

            is ShoppingListEvent.SetCheckbox -> {
                
                //I don't know what to do here. 
                
                val isChecked = state.value.isChecked

                viewModelScope.launch {
                    dao.updateItem(isChecked)
                }

            ...

            }

            
        }
    }
}

和复选框：

Checkbox(
    checked = state.isChecked,
    onCheckedChange ={
          onEvent(ShoppingListEvent.SetCheckbox(it))
    }
)

我尝试了几件事。有时什么也没发生，有时所有项目都被检查了。