使用参数以编程方式创建表视图- swift

import SQLite

// 创建数据库连接
let db = try Connection("path_to_database")

// 定义表结构
let users = Table("users")
let id = Expression<Int>("id")
let name = Expression<String>("name")
let age = Expression<Int>("age")

// 创建表
try db.run(users.create { t in
    t.column(id, primaryKey: true)
    t.column(name)
    t.column(age)
})

// 创建表视图
let filteredUsers = users.filter(age >= 18) // 使用参数过滤数据
let sortedUsers = filteredUsers.order(name.asc) // 使用参数排序数据
let usersView = filteredUsers.asView(viewName: "users_view") // 创建表视图

// 打印表视图结果
for user in try db.prepare(usersView) {
    print("ID: \(user[id]), Name: \(user[name]), Age: \(user[age])")
}