fis

type Athlete interface {
	GetAthletesBySporttiID(ctx context.Context, sporttiid int32) ([]AthleteRow, error)
	InsertAthlete(ctx context.Context, in InsertAthleteClean) error
	UpdateAthleteByFiscode(ctx context.Context, in UpdateAthleteClean) error
	DeleteAthleteByFiscode(ctx context.Context, fiscode int32) error
}

type AthleteRow struct {
	Firstname *string `json:"Firstname,omitempty"`
	Lastname  *string `json:"Lastname,omitempty"`
	Fiscode   *int32  `json:"Fiscode,omitempty"`
}

type AthleteStore struct {
	// contains filtered or unexported fields
}

type Competitors interface {
	GetAthletesBySector(ctx context.Context, sector string) ([]AthleteRow, error)
	GetNationsBySector(ctx context.Context, sector string) ([]string, error)
	GetLastRowCompetitor(ctx context.Context) (fissqlc.ACompetitor, error)
	InsertCompetitor(ctx context.Context, in InsertCompetitorClean) error
	UpdateCompetitorByID(ctx context.Context, in UpdateCompetitorClean) error
	DeleteCompetitorByID(ctx context.Context, competitorID int32) error
	GetCompetitorIDByFiscodeCC(ctx context.Context, fiscode int32) (int32, error)
	GetCompetitorIDByFiscodeJP(ctx context.Context, fiscode int32) (int32, error)
	GetCompetitorIDByFiscodeNK(ctx context.Context, fiscode int32) (int32, error)
	SearchCompetitors(ctx context.Context, nationcode, sectorcode, gender *string, birthdateMin, birthdateMax *time.Time) ([]fissqlc.ACompetitor, error)
	GetCompetitorCountsByNation(ctx context.Context, sectorcode, gender *string, birthdateMin, birthdateMax *time.Time) ([]fissqlc.GetCompetitorCountsByNationRow, error)
}

type CompetitorsStore struct {
	// contains filtered or unexported fields
}

type FISStorage struct {
	// contains filtered or unexported fields
}

type InsertAthleteClean struct {
	Fiscode   int32
	Sporttiid *int32
	Firstname *string
	Lastname  *string
}

type InsertCompetitorClean struct {
	Competitorid       int32
	Personid           *int32
	Ipcid              *int32
	Fiscode            *int32
	Birthdate          *time.Time
	StatusDate         *time.Time
	Fee                *string
	Dateofcreation     *time.Time
	Injury             *int32
	Version            *int32
	Compidmssql        *int32
	Carving            *int32
	Photo              *int32
	Notallowed         *int32
	Published          *int32
	Team               *int32
	PhotoBig           *int32
	Lastupdate         *time.Time
	Statusnextlist     *string
	Alternatenamecheck *string
	Deletedat          *string
	Doped              *string
	Createdby          *string
	Categorycode       *string
	Classname          *string
	Data               *string
	Lastupdateby       *string
	Disciplines        *string
	Type               *string
	Sectorcode         *string
	Classcode          *string
	Lastname           *string
	Firstname          *string
	Gender             *string
	Natteam            *string
	Nationcode         *string
	Nationalcode       *string
	Skiclub            *string
	Association        *string
	Status             *string
	StatusOld          *string
	StatusBy           *string
	Tragroup           *string
}

type InsertRaceCCClean struct {
	Raceid            int32
	Eventid           *int32
	Seasoncode        *int32
	Racecodex         *int32
	Disciplineid      *string
	Disciplinecode    *string
	Catcode           *string
	Catcode2          *string
	Catcode3          *string
	Catcode4          *string
	Gender            *string
	Racedate          *time.Time
	Starteventdate    *time.Time
	Description       *string
	Place             *string
	Nationcode        *string
	Receiveddate      *time.Time
	Validdate         *time.Time
	Td1id             *int32
	Td1name           *string
	Td1nation         *string
	Td1code           *int32
	Td2id             *int32
	Td2name           *string
	Td2nation         *string
	Td2code           *int32
	Calstatuscode     *string
	Procstatuscode    *string
	Displaystatus     *string
	Fisinterncomment  *string
	Webcomment        *string
	Pursuit           *string
	Masse             *string
	Relay             *string
	Distance          *string
	Hill              *string
	Style             *string
	Qualif            *string
	Finale            *string
	Homol             *string
	Published         *int32
	Validforfispoints *int32
	Usedfislist       *string
	Tolist            *string
	Discforlistcode   *string
	Calculatedpenalty *string
	Appliedpenalty    *string
	Appliedscala      *string
	Penscafixed       *string
	Version           *int32
	Nationraceid      *int32
	Provraceid        *int32
	Msql7evid         *int32
	Mssql7id          *int32
	Topbanner         *string
	Bottombanner      *string
	Toplogo           *string
	Bottomlogo        *string
	Gallery           *string
	Indi              *int32
	Team              *int32
	Tabcount          *int32
	Columncount       *int32
	Level             *string
	Hloc1             *string
	Hloc2             *string
	Hloc3             *string
	Hcet1             *string
	Hcet2             *string
	Hcet3             *string
	Live              *int32
	Livestatus1       *string
	Livestatus2       *string
	Livestatus3       *string
	Liveinfo1         *string
	Liveinfo2         *string
	Liveinfo3         *string
	Passwd            *string
	Timinglogo        *string
	Results           *int32
	Pdf               *int32
	Noepr             *int32
	Tddoc             *int32
	Timingreport      *int32
	SpecialCupPoints  *int32
	SkipWcsl          *int32
	Validforowg       *int32
	Lastupdate        *time.Time
}

type InsertRaceJPClean struct {
	Raceid            int32
	Eventid           *int32
	Seasoncode        *int32
	Racecodex         *int32
	Disciplineid      *string
	Disciplinecode    *string
	Catcode           *string
	Catcode2          *string
	Catcode3          *string
	Catcode4          *string
	Gender            *string
	Racedate          *time.Time
	Starteventdate    *time.Time
	Description       *string
	Place             *string
	Nationcode        *string
	Receiveddate      *time.Time
	Td1id             *int32
	Td1name           *string
	Td1nation         *string
	Td1code           *int32
	Td2id             *int32
	Td2name           *string
	Td2nation         *string
	Td2code           *int32
	Calstatuscode     *string
	Procstatuscode    *string
	Pursuit           *string
	Masse             *string
	Relay             *string
	Distance          *string
	Hill              *int32
	Style             *string
	Qualif            *string
	Finale            *string
	Homol             *string
	Webcomment        *string
	Displaystatus     *string
	Fisinterncomment  *string
	Published         *int32
	Validforfispoints *int32
	Usedfislist       *string
	Tolist            *string
	Discforlistcode   *string
	Calculatedpenalty *string
	Appliedpenalty    *string
	Appliedscala      *string
	Penscafixed       *string
	Version           *int32
	Nationraceid      *int32
	Provraceid        *int32
	Msql7evid         *int32
	Mssql7id          *int32
	Results           *int32
	Pdf               *int32
	Topbanner         *string
	Bottombanner      *string
	Toplogo           *string
	Bottomlogo        *string
	Gallery           *string
	Indi              *int32
	Team              *int32
	Tabcount          *int32
	Columncount       *int32
	Level             *string
	Hloc1             *time.Time
	Hloc2             *time.Time
	Hloc3             *time.Time
	Hcet1             *time.Time
	Hcet2             *time.Time
	Hcet3             *time.Time
	Live              *int32
	Livestatus1       *string
	Livestatus2       *string
	Livestatus3       *string
	Liveinfo1         *string
	Liveinfo2         *string
	Liveinfo3         *string
	Passwd            *string
	Timinglogo        *string
	Validdate         *time.Time
	Noepr             *int32
	Tddoc             *int32
	Timingreport      *int32
	SpecialCupPoints  *int32
	SkipWcsl          *int32
	Lastupdate        *time.Time
	Validforowg       *string
}

type InsertRaceNKClean struct {
	Raceid            int32
	Eventid           *int32
	Seasoncode        *int32
	Racecodex         *int32
	Disciplineid      *string
	Disciplinecode    *string
	Catcode           *string
	Catcode2          *string
	Catcode3          *string
	Catcode4          *string
	Gender            *string
	Racedate          *time.Time
	Starteventdate    *time.Time
	Description       *string
	Place             *string
	Nationcode        *string
	Td1id             *int32
	Td1name           *string
	Td1nation         *string
	Td1code           *int32
	Td2id             *int32
	Td2name           *string
	Td2nation         *string
	Td2code           *int32
	Calstatuscode     *string
	Procstatuscode    *string
	Receiveddate      *time.Time
	Pursuit           *string
	Masse             *string
	Relay             *string
	Distance          *string
	Hill              *int32
	Style             *string
	Qualif            *string
	Finale            *string
	Homol             *string
	Webcomment        *string
	Displaystatus     *string
	Fisinterncomment  *string
	Published         *int32
	Validforfispoints *int32
	Usedfislist       *string
	Tolist            *string
	Discforlistcode   *string
	Calculatedpenalty *string
	Appliedpenalty    *string
	Appliedscala      *string
	Penscafixed       *string
	Version           *int32
	Nationraceid      *int32
	Provraceid        *int32
	Msql7evid         *int32
	Mssql7id          *int32
	Results           *int32
	Pdf               *int32
	Topbanner         *string
	Bottombanner      *string
	Toplogo           *string
	Bottomlogo        *string
	Gallery           *string
	Indi              *int32
	Team              *int32
	Tabcount          *int32
	Columncount       *int32
	Level             *string
	Hloc1             *time.Time
	Hloc2             *time.Time
	Hloc3             *time.Time
	Hcet1             *time.Time
	Hcet2             *time.Time
	Hcet3             *time.Time
	Live              *int32
	Livestatus1       *string
	Livestatus2       *string
	Livestatus3       *string
	Liveinfo1         *string
	Liveinfo2         *string
	Liveinfo3         *string
	Passwd            *string
	Timinglogo        *string
	Validdate         *time.Time
	Noepr             *int32
	Tddoc             *int32
	Timingreport      *int32
	SpecialCupPoints  *int32
	SkipWcsl          *int32
	Validforowg       *int32
	Lastupdate        *time.Time
}

type InsertResultCCClean struct {
	Recid          int32
	Raceid         *int32
	Competitorid   *int32
	Status         *string
	Reason         *string
	Position       *string // numeric(10,5) in DB, but handled as string
	Pf             *int32
	Status2        *string
	Bib            *string // numeric(10,5) in DB, but handled as string
	Bibcolor       *string
	Fiscode        *int32
	Competitorname *string
	Nationcode     *string
	Stage          *string
	Level          *string
	Heat           *string
	Timer1         *string
	Timer2         *string
	Timer3         *string
	Timetot        *string
	Valid          *string // numeric(10,5) in DB, but handled as string
	Racepoints     *string // numeric(10,5) in DB, but handled as string
	Cuppoints      *string // numeric(10,5) in DB, but handled as string
	Bonustime      *string
	Bonuscuppoints *string
	Version        *string
	Rg1            *string
	Rg2            *string
	Lastupdate     *time.Time
}

type InsertResultJPClean struct {
	Recid          int32
	Raceid         *int32
	Competitorid   *int32
	Status         *string
	Status2        *string
	Position       *int32
	Bib            *int32
	Fiscode        *int32
	Competitorname *string
	Nationcode     *string
	Level          *string
	Heat           *string
	Stage          *string

	J1r1     *string
	J2r1     *string
	J3r1     *string
	J4r1     *string
	J5r1     *string
	Speedr1  *string
	Distr1   *string
	Disptsr1 *string
	Judptsr1 *string
	Totrun1  *string
	Posr1    *string
	Statusr1 *string

	J1r2     *string
	J2r2     *string
	J3r2     *string
	J4r2     *string
	J5r2     *string
	Speedr2  *string
	Distr2   *string
	Disptsr2 *string
	Judptsr2 *string
	Totrun2  *string
	Posr2    *string
	Statusr2 *string

	J1r3     *string
	J2r3     *string
	J3r3     *string
	J4r3     *string
	J5r3     *string
	Speedr3  *string
	Distr3   *string
	Disptsr3 *string
	Judptsr3 *string
	Totrun3  *string
	Posr3    *string
	Statusr3 *string

	J1r4     *string
	J2r4     *string
	J3r4     *string
	J4r4     *string
	J5r4     *string
	Speedr4  *string
	Distr4   *string
	Disptsr4 *string
	Judptsr4 *string

	Gater1    *string
	Gater2    *string
	Gater3    *string
	Gater4    *string
	Gateptsr1 *string
	Gateptsr2 *string
	Gateptsr3 *string
	Gateptsr4 *string

	Windr1    *string
	Windr2    *string
	Windr3    *string
	Windr4    *string
	Windptsr1 *string
	Windptsr2 *string
	Windptsr3 *string
	Windptsr4 *string

	Reason     *string
	Totrun4    *string
	Tot        *string
	Valid      *int32
	Racepoints *string
	Cuppoints  *string
	Version    *string
	Lastupdate *time.Time
	Posr4      *string
	Statusr4   *string
}

type InsertResultNKClean struct {
	Recid          int32
	Raceid         *int32
	Competitorid   *int32
	Status         *string
	Status2        *string
	Reason         *string
	Position       *int32
	Pf             *int32
	Bib            *int32
	Bibcolor       *string
	Fiscode        *int32
	Competitorname *string
	Nationcode     *string
	Level          *string
	Heat           *string
	Stage          *string

	J1r1      *string
	J2r1      *string
	J3r1      *string
	J4r1      *string
	J5r1      *string
	Speedr1   *string
	Distr1    *string
	Disptsr1  *string
	Judptsr1  *string
	Gater1    *string
	Gateptsr1 *string
	Windr1    *string
	Windptsr1 *string
	Totrun1   *string
	Posr1     *string
	Statusr1  *string

	J1r2      *string
	J2r2      *string
	J3r2      *string
	J4r2      *string
	J5r2      *string
	Speedr2   *string
	Distr2    *string
	Disptsr2  *string
	Judptsr2  *string
	Gater2    *string
	Gateptsr2 *string
	Windr2    *string
	Windptsr2 *string
	Totrun2   *string
	Posr2     *string
	Statusr2  *string

	Pointsjump *string
	Behindjump *string
	Posjump    *string
	Timecc     *string
	Timeccint  *string
	Poscc      *string
	Starttime  *string
	Statuscc   *string
	Totbehind  *string
	Timetot    *string
	Timetotint *int32
	Valid      *int32
	Racepoints *string
	Cuppoints  *string
	Version    *string
	Lastupdate *time.Time
}

type RaceCCStore struct {
	// contains filtered or unexported fields
}

type RaceJPStore struct {
	// contains filtered or unexported fields
}

type RaceNKStore struct {
	// contains filtered or unexported fields
}

type Racecc interface {
	GetCrossCountrySeasons(ctx context.Context) ([]int32, error)
	GetCrossCountryDisciplines(ctx context.Context) ([]string, error)
	GetCrossCountryCategories(ctx context.Context) ([]string, error)
	GetRacesCC(ctx context.Context, seasons []int32, disciplines, cats []string) ([]fissqlc.ARacecc, error)
	GetLastRowRaceCC(ctx context.Context) (fissqlc.ARacecc, error)
	InsertRaceCC(ctx context.Context, in InsertRaceCCClean) error
	UpdateRaceCCByID(ctx context.Context, in UpdateRaceCCClean) error
	DeleteRaceCCByID(ctx context.Context, raceID int32) error
	SearchRacesCC(ctx context.Context, seasoncode *int32, nationcode, gender, catcode *string) ([]fissqlc.SearchRacesCCRow, error)
	GetRacesByIDsCC(ctx context.Context, raceIDs []int32) ([]fissqlc.ARacecc, error)
	GetRaceCountsByCategoryCC(ctx context.Context, seasoncode int32, nationcode, gender *string) ([]fissqlc.GetRaceCountsByCategoryCCRow, error)
	GetRaceCountsByNationCC(ctx context.Context, seasoncode int32, catcode, gender *string) ([]fissqlc.GetRaceCountsByNationCCRow, error)
	GetRaceTotalCC(ctx context.Context, seasoncode int32, catcode, gender *string) (int64, error)
}

type Racejp interface {
	GetSkiJumpingSeasons(ctx context.Context) ([]int32, error)
	GetSkiJumpingDisciplines(ctx context.Context) ([]string, error)
	GetSkiJumpingCategories(ctx context.Context) ([]string, error)
	GetRacesJP(ctx context.Context, seasons []int32, disciplines, cats []string) ([]fissqlc.ARacejp, error)
	GetLastRowRaceJP(ctx context.Context) (fissqlc.ARacejp, error)
	InsertRaceJP(ctx context.Context, in InsertRaceJPClean) error
	UpdateRaceJPByID(ctx context.Context, in UpdateRaceJPClean) error
	DeleteRaceJPByID(ctx context.Context, raceID int32) error
	SearchRacesJP(ctx context.Context, seasoncode *int32, nationcode, gender, catcode *string) ([]fissqlc.SearchRacesJPRow, error)
	GetRacesByIDsJP(ctx context.Context, raceIDs []int32) ([]fissqlc.ARacejp, error)
	GetRaceCountsByCategoryJP(ctx context.Context, seasoncode int32, nationcode, gender *string) ([]fissqlc.GetRaceCountsByCategoryJPRow, error)
	GetRaceCountsByNationJP(ctx context.Context, seasoncode int32, catcode, gender *string) ([]fissqlc.GetRaceCountsByNationJPRow, error)
	GetRaceTotalJP(ctx context.Context, seasoncode int32, catcode, gender *string) (int64, error)
}

type Racenk interface {
	GetNordicCombinedSeasons(ctx context.Context) ([]int32, error)
	GetNordicCombinedDisciplines(ctx context.Context) ([]string, error)
	GetNordicCombinedCategories(ctx context.Context) ([]string, error)
	GetRacesNK(ctx context.Context, seasons []int32, disciplines, cats []string) ([]fissqlc.ARacenk, error)
	GetLastRowRaceNK(ctx context.Context) (fissqlc.ARacenk, error)
	InsertRaceNK(ctx context.Context, in InsertRaceNKClean) error
	UpdateRaceNKByID(ctx context.Context, in UpdateRaceNKClean) error
	DeleteRaceNKByID(ctx context.Context, raceID int32) error
	SearchRacesNK(ctx context.Context, seasoncode *int32, nationcode, gender, catcode *string) ([]fissqlc.SearchRacesNKRow, error)
	GetRacesByIDsNK(ctx context.Context, raceIDs []int32) ([]fissqlc.ARacenk, error)
	GetRaceCountsByCategoryNK(ctx context.Context, seasoncode int32, nationcode, gender *string) ([]fissqlc.GetRaceCountsByCategoryNKRow, error)
	GetRaceCountsByNationNK(ctx context.Context, seasoncode int32, catcode, gender *string) ([]fissqlc.GetRaceCountsByNationNKRow, error)
	GetRaceTotalNK(ctx context.Context, seasoncode int32, catcode, gender *string) (int64, error)
}

type ResultCCStore struct {
	// contains filtered or unexported fields
}

type ResultJPStore struct {
	// contains filtered or unexported fields
}

type ResultNKStore struct {
	// contains filtered or unexported fields
}

type Resultcc interface {
	GetLastRowResultCC(ctx context.Context) (fissqlc.AResultcc, error)
	InsertResultCC(ctx context.Context, in InsertResultCCClean) error
	UpdateResultCCByRecID(ctx context.Context, in UpdateResultCCClean) error
	DeleteResultCCByRecID(ctx context.Context, recid int32) error
	GetRaceResultsCCByRaceID(ctx context.Context, raceID int32) ([]fissqlc.AResultcc, error)
	GetAthleteResultsCC(ctx context.Context, competitorID int32, seasons []int32, disciplines, cats []string) ([]fissqlc.GetAthleteResultsCCRow, error)
	GetSeasonsCatcodesCCByCompetitor(ctx context.Context, competitorID int32) ([]fissqlc.GetSeasonsCatcodesCCByCompetitorRow, error)
	GetLatestResultsCC(ctx context.Context, competitorID int32, seasoncode *int32, catcodes []string, limit *int32) ([]fissqlc.GetLatestResultsCCRow, error)
}

type Resultjp interface {
	GetLastRowResultJP(ctx context.Context) (fissqlc.AResultjp, error)
	InsertResultJP(ctx context.Context, in InsertResultJPClean) error
	UpdateResultJPByRecID(ctx context.Context, in UpdateResultJPClean) error
	DeleteResultJPByRecID(ctx context.Context, recid int32) error
	GetRaceResultsJPByRaceID(ctx context.Context, raceID int32) ([]fissqlc.AResultjp, error)
	GetAthleteResultsJP(ctx context.Context, competitorID int32, seasons []int32, disciplines, cats []string) ([]fissqlc.GetAthleteResultsJPRow, error)
	GetSeasonsCatcodesJPByCompetitor(ctx context.Context, competitorID int32) ([]fissqlc.GetSeasonsCatcodesJPByCompetitorRow, error)
	GetLatestResultsJP(ctx context.Context, competitorID int32, seasoncode *int32, catcodes []string, limit *int32) ([]fissqlc.GetLatestResultsJPRow, error)
}

type Resultnk interface {
	GetLastRowResultNK(ctx context.Context) (fissqlc.AResultnk, error)
	InsertResultNK(ctx context.Context, in InsertResultNKClean) error
	UpdateResultNKByRecID(ctx context.Context, in UpdateResultNKClean) error
	DeleteResultNKByRecID(ctx context.Context, recid int32) error
	GetRaceResultsNKByRaceID(ctx context.Context, raceID int32) ([]fissqlc.AResultnk, error)
	GetAthleteResultsNK(ctx context.Context, competitorID int32, seasons []int32, disciplines, cats []string) ([]fissqlc.GetAthleteResultsNKRow, error)
	GetSeasonsCatcodesNKByCompetitor(ctx context.Context, competitorID int32) ([]fissqlc.GetSeasonsCatcodesNKByCompetitorRow, error)
	GetLatestResultsNK(ctx context.Context, competitorID int32, seasoncode *int32, catcodes []string, limit *int32) ([]fissqlc.GetLatestResultsNKRow, error)
}

type UpdateAthleteClean struct {
	Fiscode   int32
	Sporttiid *int32
	Firstname *string
	Lastname  *string
}

type UpdateCompetitorClean struct {
	Competitorid       int32
	Personid           *int32
	Ipcid              *int32
	Type               *string
	Sectorcode         *string
	Fiscode            *int32
	Lastname           *string
	Firstname          *string
	Gender             *string
	Birthdate          *time.Time
	Nationcode         *string
	Nationalcode       *string
	Skiclub            *string
	Association        *string
	Status             *string
	StatusOld          *string
	StatusBy           *string
	StatusDate         *time.Time
	Statusnextlist     *string
	Alternatenamecheck *string
	Fee                *string
	Dateofcreation     *time.Time
	Createdby          *string
	Injury             *int32
	Version            *int32
	Compidmssql        *int32
	Carving            *int32
	Photo              *int32
	Notallowed         *int32
	Natteam            *string
	Tragroup           *string
	Published          *int32
	Doped              *string
	Team               *int32
	PhotoBig           *int32
	Data               *string
	Lastupdateby       *string
	Disciplines        *string
	Lastupdate         *time.Time
	Deletedat          *string
	Categorycode       *string
	Classname          *string
	Classcode          *string
}

type UpdateRaceCCClean = InsertRaceCCClean

type UpdateRaceJPClean = InsertRaceJPClean

type UpdateRaceNKClean = InsertRaceNKClean

type UpdateResultCCClean = InsertResultCCClean

type UpdateResultJPClean = InsertResultJPClean

type UpdateResultNKClean = InsertResultNKClean