package repos

import "demoon/internal/models"

type QuestionsRepo interface {
	DBGetQuestion(id string) (*models.Question, error)
	DBGetMixedUbung(id uint32) (*models.MixedUbung, error)
}

func (p *Provider) DBGetMixedUbung(id uint32) (*models.MixedUbung, error) {
	var ubung models.MixedUbung
	err := p.db.Get(&ubung, "SELECT * FROM mixed_ubungs WHERE mixed_id = ?", id)
	if err != nil {
		return nil, err
	}
	return &ubung, nil
}

func (p *Provider) DBGetQuestion(id string) (*models.Question, error) {
	var question models.Question
	err := p.db.Get(&question, "SELECT * FROM questions WHERE id = ?", id)
	if err != nil {
		return nil, err
	}
	return &question, nil
}