| 187 | } |
| 188 | |
| 189 | func (s *Server) getHourlyStats(startTime, endTime time.Time) (hourlyStatResult, error) { |
| 190 | var result hourlyStatResult |
| 191 | err := s.DB.Table("group_hourly_stats"). |
| 192 | Where("time >= ? AND time < ?", startTime, endTime). |
| 193 | Where("group_id NOT IN (?)", |
| 194 | s.DB.Table("groups").Select("id").Where("group_type = ?", "aggregate")). |
| 195 | Select("COALESCE(SUM(success_count), 0) + COALESCE(SUM(failure_count), 0) as total_requests, COALESCE(SUM(failure_count), 0) as total_failures"). |
| 196 | Scan(&result).Error |
| 197 | return result, err |
| 198 | } |
| 199 | |
| 200 | type rpmStatResult struct { |
| 201 | CurrentRequests int64 |