【入门夯实】迁移字段清单：合服数据不完整的教训

local manualFields = { "name", "level", "gold", "guild" }
for _, f in ipairs(manualFields) do
    migrateField(f)
end

local function buildFieldList(sourceTable)
    local fields = getSourceColumns(sourceTable)
    if #fields == 0 then
        error("源表字段清单为空，拒绝迁移")
    end
    return fields
end
local function migrateTable(sourceTable, targetTable)
    local fields = buildFieldList(sourceTable)
    for _, f in ipairs(fields) do
        copyColumn(sourceTable, targetTable, f)
    end
    return #fields
end

local n = migrateTable("roles_old", "roles_new")
sendmsg(nil, 1, "已迁移字段 " .. n .. " 个")

local function tableDigest(rows)
    local sum = 0
    for _, r in ipairs(rows) do
        sum = sum + r.gold
    end
    return #rows, sum
end