persistence

Documentation

Index

• func NewDB(env *env.EnvConfig) *sqlx.DB
• type AcademicFieldRepositoryImpl
  • func NewAcademicFieldRepositoryImpl(db *sqlx.DB) *AcademicFieldRepositoryImpl
  • func (afR *AcademicFieldRepositoryImpl) Get() ([]string, error)
• type ResourceRepositoryImpl
  • func NewResourceRepositoryImpl(db *sqlx.DB) *ResourceRepositoryImpl
  • func (vR *ResourceRepositoryImpl) GetByIds(ids []model.ResourceId) ([]*model.Resource, error)
• type SubjectRepositoryImpl
  • func NewSubjectRepositoryImpl(db *sqlx.DB) *SubjectRepositoryImpl
  • func (sR *SubjectRepositoryImpl) GetById(id model.SubjectId) (*model.Subject, error)
  • func (sR *SubjectRepositoryImpl) GetByIds(ids []model.SubjectId) ([]*model.Subject, error)
  • func (sR SubjectRepositoryImpl) GetByRandom(category string, series string, academicField string, numSubjects int) ([]*model.Subject, error)
  • func (sR SubjectRepositoryImpl) GetBySearchParameter(title string, faculty string, academicField string) ([]*model.Subject, error)
  • func (sR SubjectRepositoryImpl) GetByVideoIds(videoIds []model.VideoId) ([]*model.Subject, error)
• type SyllabusRepositoryImpl
  • func NewSyllabusRepositoryImpl(db *sqlx.DB) *SyllabusRepositoryImpl
  • func (sR *SyllabusRepositoryImpl) GetById(id model.SyllabusId) (*model.Syllabus, error)
  • func (sR *SyllabusRepositoryImpl) GetByIds(ids []model.SyllabusId) ([]*model.Syllabus, error)
• type VideoRepositoryImpl
  • func NewVideoRepositoryImpl(db *sqlx.DB) *VideoRepositoryImpl
  • func (vR *VideoRepositoryImpl) GetByIds(ids []model.VideoId) ([]*model.Video, error)
  • func (vR *VideoRepositoryImpl) GetBySearchParameter(title string, faculty string) ([]*model.Video, error)

Functions

func NewDB

func NewDB(env *env.EnvConfig) *sqlx.DB

Types

type AcademicFieldRepositoryImpl

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

func NewAcademicFieldRepositoryImpl

func NewAcademicFieldRepositoryImpl(db *sqlx.DB) *AcademicFieldRepositoryImpl

func (*AcademicFieldRepositoryImpl) Get

func (afR *AcademicFieldRepositoryImpl) Get() ([]string, error)

type ResourceRepositoryImpl

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

func NewResourceRepositoryImpl

func NewResourceRepositoryImpl(db *sqlx.DB) *ResourceRepositoryImpl

func (*ResourceRepositoryImpl) GetByIds

func (vR *ResourceRepositoryImpl) GetByIds(ids []model.ResourceId) ([]*model.Resource, error)

type SubjectRepositoryImpl

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

func NewSubjectRepositoryImpl

func NewSubjectRepositoryImpl(db *sqlx.DB) *SubjectRepositoryImpl

func (*SubjectRepositoryImpl) GetById

func (sR *SubjectRepositoryImpl) GetById(id model.SubjectId) (*model.Subject, error)

func (*SubjectRepositoryImpl) GetByIds

func (sR *SubjectRepositoryImpl) GetByIds(ids []model.SubjectId) ([]*model.Subject, error)

FIXME: this causes N+1 query problem

func (SubjectRepositoryImpl) GetByRandom

func (sR SubjectRepositoryImpl) GetByRandom(
	category string,
	series string,
	academicField string,
	numSubjects int) ([]*model.Subject, error)

WARNING: This method become slower as the number of subjects increases due to LIMIT clause. This also causes N+1 query problem.

func (SubjectRepositoryImpl) GetBySearchParameter

func (sR SubjectRepositoryImpl) GetBySearchParameter(title string, faculty string, academicField string) ([]*model.Subject, error)

func (SubjectRepositoryImpl) GetByVideoIds

func (sR SubjectRepositoryImpl) GetByVideoIds(videoIds []model.VideoId) ([]*model.Subject, error)

type SyllabusRepositoryImpl

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

func NewSyllabusRepositoryImpl

func NewSyllabusRepositoryImpl(db *sqlx.DB) *SyllabusRepositoryImpl

func (*SyllabusRepositoryImpl) GetById

func (sR *SyllabusRepositoryImpl) GetById(id model.SyllabusId) (*model.Syllabus, error)

func (*SyllabusRepositoryImpl) GetByIds

func (sR *SyllabusRepositoryImpl) GetByIds(ids []model.SyllabusId) ([]*model.Syllabus, error)

type VideoRepositoryImpl

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

func NewVideoRepositoryImpl

func NewVideoRepositoryImpl(db *sqlx.DB) *VideoRepositoryImpl

func (*VideoRepositoryImpl) GetByIds

func (vR *VideoRepositoryImpl) GetByIds(ids []model.VideoId) ([]*model.Video, error)

GetByIds returns videos with the given ids. This function is expected to get videos of one subject.

func (*VideoRepositoryImpl) GetBySearchParameter

func (vR *VideoRepositoryImpl) GetBySearchParameter(title string, faculty string) ([]*model.Video, error)