Example #1
0
func Season(row MultiScanner) (*model.Season, error) {
	//s.id, s.name, s.start_date, s.end_date, s.created, s.modified, l.id, l.name, l.sport, l.created, l.modified
	var season model.Season
	var league model.League

	err := row.Scan(&season.ID, &league.ID, &season.Name, &season.StartDate, &season.EndDate, &season.Created, &season.Modified)

	if err != nil {
		return nil, err
	}

	season.League = &league

	return &season, nil
}
Example #2
0
func (repo *PgRepository) CreateSeason(season *model.Season) error {
	err := season.Validate(repo)
	if err != nil {
		return err
	}

	t := time.Now()

	var id int
	err = repo.manager.db.QueryRow(`INSERT INTO season(league_id, name, start_date, end_date, created, modified)
	    VALUES($1, $2, $3, $4, $5, $6) RETURNING id`,
		season.League.ID, season.Name, season.StartDate, season.EndDate, t, t).Scan(&id)

	if err != nil {
		return err
	}

	season.ID = id
	season.Created = t
	season.Modified = t

	return nil
}