Beispiel #1
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
}