Vapor 大型教程
Fluent 查询
除了简单的 all() / first()，Fluent 还能做条件过滤、或查询、取首条和排序。本文给出 Vapor 3 写法下的常用查询代码示例。
请求示例：http://localhost:8080/api/acronyms/search?term={searchItem}
Search：单字段过滤
router.get("api", "acronyms", "search") { (req) -> Future<[Acronym]> in
guard let searchItem = req.query[String.self, at: "term"] else {
throw Abort(.badRequest)
}
return Acronym.query(on: req)
.filter(\.short == searchItem)
.all()
}Search：多字段或查询
router.get("api", "acronyms", "search") { (req) -> Future<[Acronym]> in
guard let searchItem = req.query[String.self, at: "term"] else {
throw Abort(.badRequest)
}
return Acronym.query(on: req).group(.or) { (or) in
or.filter(\.short == searchItem)
or.filter(\.long == searchItem)
}
.all()
}First
router.get("api","acronyms","first") { (req) -> Future<Acronym> in
return Acronym.query(on: req).first().map(to: Acronym.self) { (acronym) in
guard let acronym = acronym else {
throw Abort(.notFound)
}
return acronym
}
}或者更简单一点就是：
func firstHandler(_ req: Request) throws -> Future<Acronym> {
return Acronym.query(on: req).first().unwrap(or: Abort(.notFound))
}Sort
router.get("api","acronyms","sorted") { (req) -> Future<[Acronym]> in
return Acronym.query(on: req).sort(\.short, .ascending).all()
}