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  }