github.com/predbdotovh/pre-api@v0.0.0-20211230223408-096f265fde6a/team.go (about) 1 package main 2 3 import ( 4 "database/sql" 5 "fmt" 6 "log" 7 ) 8 9 type teamRow struct { 10 Team string `json:"team"` 11 FirstPre int `json:"firstPre"` 12 LatestPre int `json:"latestPre"` 13 Count int `json:"count"` 14 } 15 16 const maxListedTeams = 1000 17 18 func listTeams(tx *sql.Tx) ([]teamRow, error) { 19 sqlQuery := fmt.Sprintf("SELECT team, MIN(pre_at), MAX(pre_at), COUNT(*) AS count FROM %s GROUP BY team ORDER BY count DESC LIMIT %d", sphinxTable, maxListedTeams) 20 21 rows, err := tx.Query(sqlQuery) 22 if err != nil { 23 return nil, err 24 } 25 defer rows.Close() 26 27 res := make([]teamRow, 0) 28 for rows.Next() { 29 var r teamRow 30 err := rows.Scan(&r.Team, &r.FirstPre, &r.LatestPre, &r.Count) 31 if err != nil { 32 log.Print(err) 33 continue 34 } 35 36 res = append(res, r) 37 } 38 39 return res, nil 40 }