repository

type Comment struct {
	UserID         uuid.UUID `db:"userId" json:"userId"`
	PresentationID int       `db:"presentationId" json:"presentationId"`
	Text           string    `db:"text" json:"text"`
}

type CommentRepository interface {
	CreateComment(comment *Comment) error
	GetComments(id int) ([]*Comment, error)
}

type Count struct {
	Stamp int `db:"stamp" json:"stamp"`
	Count int `db:"COUNT(stamp)" json:"count"`
}

type CreatePresentation struct {
	Name        string `db:"name"`
	Speakers    string `db:"speakers"`
	Description string `db:"description"`
}

type Presentation struct {
	ID          int          `db:"id" json:"id"`
	Name        utils.String `db:"name" json:"name"`
	Speakers    utils.String `db:"speakers" json:"speakers"`
	Description utils.String `db:"description" json:"description"`
	Prev        utils.Int    `db:"prev" json:"prev"`
	Next        utils.Int    `db:"next" json:"next"`
	CreatedAt   time.Time    `db:"createdAt" json:"createdAt"`
	UpdatedAt   time.Time    `db:"updatedAt" json:"updatedAt"`
}

type PresentationRepository interface {
	CreatePresentation(presentation *CreatePresentation) error
	UpdatePresentation(presentation *Presentation) error
	GetPresentations() ([]*Presentation, error)
	GetFirstPresentation() (*Presentation, error)
	GetPresentation(id int) (*Presentation, error)
	DeletePresentation(id int) error
}

type Reaction struct {
	UserID         uuid.UUID `db:"userId"`
	PresentationID int       `db:"presentationId"`
	Stamp          int       `db:"stamp"`
}

type ReactionRepository interface {
	CreateReaction(reaction *Reaction) error
	GetReactionStatistics(id int) (*ReactionStatistics, error)
}

type ReactionStatistics struct {
	PresentationID int     `json:"presentationID"`
	Counts         []Count `json:"counts"`
}

type Repository interface {
	StateRepository
	PresentationRepository
	ReactionRepository
	CommentRepository
	ReviewRepository
	TokenRepository
}

type Review struct {
	UserId         uuid.UUID `db:"userId"`
	PresentationId int       `db:"presentationId"`
	Score
}

type ReviewRepository interface {
	IsExistReview(userID uuid.UUID, presenID int) (bool, error)
	CreateReview(review *Review) error
	UpdateReview(review *Review) error
	GetReviewStatistics(id int) (*ReviewStatistics, error)
}

type ReviewStatistics struct {
	PresentationId  int     `db:"presentationId" json:"presentationId"`
	Count           int     `db:"COUNT(*)" json:"count"`
	AvgSkill        float64 `db:"AVG(skill)" json:"avgSkill"`
	AvgArtistry     float64 `db:"AVG(artistry)" json:"avgArtistry"`
	AvgIdea         float64 `db:"AVG(idea)" json:"avgIdea"`
	AvgPresentation float64 `db:"AVG(presentation)" json:"avgPresentation"`
}

type Score struct {
	Skill        int `db:"skill"`
	Artistry     int `db:"artistry"`
	Idea         int `db:"idea"`
	Presentation int `db:"presentation"`
}

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

type State struct {
	Status string `db:"status" json:"status"`
	Info   string `db:"info" json:"info"`
}

type StateRepository interface {
	UpdateState(*State) error
	GetState() (*State, error)
}

type Token struct {
	Token     string    `db:"token"`
	UserID    uuid.UUID `db:"userId"`
	CreatedAt time.Time `db:"createdAt"`
}

type TokenRepository interface {
	CreateToken(token *Token) error
	GetTokenUserID(tokenString string) (uuid.UUID, error)
	CleanupExpiredTokens() (int64, error)
}