mirror of
https://github.com/groue/GRDB.swift
synced 2026-11-22 04:00:39 +00:00
51 lines
2.1 KiB
Swift
51 lines
2.1 KiB
Swift
extension QueryInterfaceRequest where RowDecoder: TableRecord {
|
|
|
|
// MARK: - Association Aggregates
|
|
|
|
private func annotated(with aggregate: AssociationAggregate<RowDecoder>) -> QueryInterfaceRequest {
|
|
var request = self
|
|
let expressionPromise = aggregate.prepare(&request)
|
|
if let key = aggregate.key {
|
|
return request.annotated(with: { db in try [expressionPromise.resolve(db).forKey(key)] })
|
|
} else {
|
|
return request.annotated(with: { db in try [expressionPromise.resolve(db)] })
|
|
}
|
|
}
|
|
|
|
/// Creates a request which appends *aggregates* to the current selection.
|
|
///
|
|
/// // SELECT player.*, COUNT(DISTINCT book.id) AS bookCount
|
|
/// // FROM player LEFT JOIN book ...
|
|
/// var request = Player.all()
|
|
/// request = request.annotated(with: Player.books.count)
|
|
public func annotated(with aggregates: AssociationAggregate<RowDecoder>...) -> QueryInterfaceRequest {
|
|
annotated(with: aggregates)
|
|
}
|
|
|
|
/// Creates a request which appends *aggregates* to the current selection.
|
|
///
|
|
/// // SELECT player.*, COUNT(DISTINCT book.id) AS bookCount
|
|
/// // FROM player LEFT JOIN book ...
|
|
/// var request = Player.all()
|
|
/// request = request.annotated(with: [Player.books.count])
|
|
public func annotated(with aggregates: [AssociationAggregate<RowDecoder>]) -> QueryInterfaceRequest {
|
|
aggregates.reduce(self) { request, aggregate in
|
|
request.annotated(with: aggregate)
|
|
}
|
|
}
|
|
|
|
/// Creates a request which appends the provided aggregate *predicate* to
|
|
/// the eventual set of already applied predicates.
|
|
///
|
|
/// // SELECT player.*
|
|
/// // FROM player LEFT JOIN book ...
|
|
/// // HAVING COUNT(DISTINCT book.id) = 0
|
|
/// var request = Player.all()
|
|
/// request = request.having(Player.books.isEmpty)
|
|
public func having(_ predicate: AssociationAggregate<RowDecoder>) -> QueryInterfaceRequest {
|
|
var request = self
|
|
let expressionPromise = predicate.prepare(&request)
|
|
return request.having(expressionPromise.resolve)
|
|
}
|
|
}
|