swift - 将 sqlite 转换为自定义模型

Question

我想将结果转换为 ModelA 数组，但没有找到方法。

let query = "SELECT t1.columnA, t2.columnB from table1 as t1, table2 as t2 ..."
let results = try! db.prepare(query) as Array<ModelA>() // I do not know how to cast

型号A：

Struct ModelA: Codable{
let columnA: String
let columnB: String
}

标签： swiftsqlitesqlite.swift

Answer 1

您不能直接投射，请尝试map在结果上使用

let models = results.map { ModelA(columnA: $0[0], columnB: $0[1] }