github.com/ars0915/glossika-exercise@v0.0.0-20240904180321-a5617a00d892/repo/db/task.go (about) 1 package db 2 3 import ( 4 "github.com/ars0915/glossika-exercise/entity" 5 ) 6 7 func (s *AppRepo) ListTasks(param entity.ListTaskParam) (t []entity.Task, err error) { 8 db := s.db.Model(entity.Task{}) 9 if param.Offset != nil && param.Limit != nil { 10 db = db.Limit(*param.Limit) 11 db = db.Offset(*param.Offset) 12 } 13 14 if err = db.Find(&t).Error; err != nil { 15 return 16 } 17 return t, nil 18 } 19 20 func (s *AppRepo) GetTasksCount() (count int64, err error) { 21 db := s.db.Model(entity.Task{}) 22 db = db.Limit(-1) 23 db = db.Offset(-1) 24 err = db.Count(&count).Error 25 return 26 } 27 28 func (s *AppRepo) CreateTask(t entity.Task) (entity.Task, error) { 29 if err := s.db.Create(&t).Error; err != nil { 30 return t, err 31 } 32 33 return t, nil 34 } 35 36 func (s *AppRepo) UpdateTask(id uint, t entity.Task) error { 37 return s.db.Model(entity.Task{}).Where(`"id" = ?`, id).Updates(t).Error 38 } 39 40 func (s *AppRepo) GetTask(id uint) (task entity.Task, err error) { 41 if err = s.db.Where(`"id" = ?`, id).First(&task).Error; err != nil { 42 return task, err 43 } 44 return 45 } 46 47 func (s *AppRepo) DeleteTask(id uint) (err error) { 48 if err = s.db.Where(`"id" = ?`, id).Delete(&entity.Task{}).Error; err != nil { 49 return err 50 } 51 return 52 }