swift - sqlite.swift，如何通过名称给出字段值？

Question

作为example :

for user in try db.prepare(users.select(id, email)) {
   print("id: (user[id]), email: (user[email])")
   // id: 1, email: alice@mac.com
}
  // SELECT "id", "email" FROM "users"

但我想知道是否可以使用名称但表达式或索引？

我的意思是:

let id = user["email"] 然后获取'email'字段的值

好像不支持？

Answer 1

不，SQLite.swift 不支持通过名称访问行列。

替代方案是 GRDB.swift ，如果您愿意，它可以让您按列名称访问列值:

// Using raw SQL:
let rows = Row.fetchCursor(db, "SELECT * FROM users")
while let row = rows.next() {
    let id: Int64 = row.value(named: "id")
    let email: String = row.value(named: "email")
}

// Using a "query interface request", and raw row access:
let request = User.all()
let rows = Row.fetchCursor(db, request)
while let row = rows.next() {
    let id: Int64 = row.value(named: "id")
    let email: String = row.value(named: "email")
}

// Using a natural "query interface request":
let users = User.fetchAll(db) // [User]