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  }