ddr_db

type DdrDbCommunication interface {
	AddSongs(songs []ddr_models.Song) (errs []error)
	RetrieveSongIds() (songIds []string, errs []error)
	RetrieveSongsById(songIds []string, ordering []string) (songs []ddr_models.Song, errs []error)
	RetrieveJacketForSongId(songId string) (jacket string, errs []error)
	RetrieveJacketsForSongIds(songIds []string) (jackets map[string]string, errs []error)

	AddDifficulties(difficulties []ddr_models.SongDifficulty) (errs []error)
	RetrieveDifficulties() (difficulties []ddr_models.SongDifficulty, errs []error)
	RetrieveValidDifficulties() (difficulties []ddr_models.SongDifficulty, errs []error)
	RetrieveDifficultiesById(songIds []string) (difficulties []ddr_models.SongDifficulty, errs []error)
	RetrieveValidDifficultiesById(songIds []string) (difficulties []ddr_models.SongDifficulty, errs []error)

	AddPlayerDetails(details ddr_models.PlayerDetails) (errs []error)
	RetrievePlayerDetailsByEaGateUser(eaGateUser string) (details ddr_models.PlayerDetails, errs []error)
	RetrievePlayerDetailsByPlayerCode(code int) (details ddr_models.PlayerDetails, errs []error)

	AddPlaycounts(playcountDetails []ddr_models.Playcount) (errs []error)
	RetrievePlaycountsByPlayerCode(code int) (playcounts []ddr_models.Playcount, errs []error)
	RetrieveLatestPlaycountByPlayerCode(code int) (playcount ddr_models.Playcount, errs []error)
	RetrievePlaycountsByPlayerCodeInDateRange(code int, startDate time.Time, endDate time.Time) (playcounts []ddr_models.Playcount, errs []error)

	AddSongStatistics(statistics []ddr_models.SongStatistics) (errs []error)
	RetrieveSongStatisticsByPlayerCode(code int, songIds []string) (statistics []ddr_models.SongStatistics, errs []error)

	AddScores(scores []ddr_models.Score) (errs []error)
	RetrieveScoresByPlayerCode(code int) (scores []ddr_models.Score, errs []error)
	RetrieveSongScores(code int, songId string, mode string, difficulty string, ordering []string) (scores []ddr_models.Score, errs []error)

	AddWorkoutData(workoutData []ddr_models.WorkoutData) (errs []error)
	RetrieveWorkoutDataByPlayerCode(code int) (workoutData []ddr_models.WorkoutData, errs []error)
	RetrieveWorkoutDataByPlayerCodeInDateRange(code int, startDate time.Time, endDate time.Time) (workoutData []ddr_models.WorkoutData, errs []error)

	RetrieveExtendedScoreStatisticsByPlayerCode(code int) (statisticsJson string, errs []error)
}

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

type DdrStatisticsTable struct {
	Level      int    `json:"level"`
	Title      string `json:"title"`
	Artist     string `json:"artist"`
	Mode       string `json:"mode"`
	Difficulty string `json:"difficulty"`
	Lamp       string `json:"lamp"`
	Rank       string `json:"rank"`
	Score      int    `json:"score"`
	PlayCount  int    `gorm:"column:playcount" json:"playcount"`
	ClearCount int    `gorm:"column:clearcount" json:"clearcount"`
	MaxCombo   int    `gorm:"column:maxcombo" json:"maxcombo"`
	Id         string `gorm:"column:id" json:"id"`
}