swift - How to update db data when moving an item in a list? - Stack Overflow

admin管理员组

文章数量:1432359

I am using swiftui to create a list and using .onMove to move items. I want to update the db information stored in sqlite when moving items. I am using the stephencelis/SQLite.swift library for sqlite.

I have created the code as below. But the code below updates the entire list after the item is moved. Is this method efficient? Or is there another way? For example, updating the moved item and the item to the destination.

Can I get a better code that updates the db of sqlite when moving items in the list? Thank you.

@State private var listItem = [Item]()

ForEach(listItem) { item in
        ListCell(
            item: item,
            onDelete: { deleteItem(item) }
        )
}
.onMove(perform: moveItem)

func moveItem(from source : IndexSet, to destination : Int)
{
    var tempDataSet : [Item] = listItem

    listItem.move(fromOffsets : source, toOffset : destination)

    for (index, item) in listItem.enumerated()
    {
        dbManager.updateDbData(listItem[index].date, listItem[index].content, listItem[index].amount, tempDataSet[index].id)
    }
    listItem = dbManager.loadDbData()

}

func updateDbData(_ date : String, _ content : String, _ amount : String, _ id : Int)
{
    do
    {

    let update = MainTable.filter(dbId == id)

    try db.run(update.update(dbContent < -content, dbDate < -date, dbAmount < -amount))
    }
    catch (let err)
    {
        print("updateDbData err = \(err)")
    }
}

本文标签： swiftHow to update db data when moving an item in a listStack Overflow