extension QueryInterfaceRequest where RowDecoder: TableRecord { // MARK: - Association Aggregates private func annotated(with aggregate: AssociationAggregate) -> 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...) -> 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]) -> 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) -> QueryInterfaceRequest { var request = self let expressionPromise = predicate.prepare(&request) return request.having(expressionPromise.resolve) } }