func (repo *PgRepository) FindAllLeagues() ([]model.League, error) {
rows, err := repo.manager.db.Query(`SELECT id, name, sport, created, modified
FROM league`)
if err != nil {
return []model.League{}, err
}
var leagues []model.League
for rows.Next() {
league, err := marshal.League(rows)
if err != nil {
return []model.League{}, err
}
if leagues == nil {
leagues = make([]model.League, 0, 1)
}
leagues = append(leagues, *league)
}
err = rows.Err()
if err != nil {
return []model.League{}, err
}
return leagues, nil
}
func (repo *PgRepository) FindLeagueByID(id int) (*model.League, error) {
row := repo.manager.db.QueryRow(`SELECT id, name, sport, created, modified
FROM league
WHERE id = $1`, id)
league, err := marshal.League(row)
if err != nil {
return nil, err
}
return league, nil
}