dao

type CreateRecordRequest struct {
	Name      string       `json:"name"`
	Status    RecordStatus `json:"status"`
	CreatedBy uint64       `json:"created_by"`
}

type ListRecordRequest struct {
	NameLike string        `json:"name_like"`
	Status   *RecordStatus `json:"status"`
	LastID   uint64        `json:"last_id"` // 解决深翻页
	Limit    int           `json:"limit"`
	Offset   int           `json:"offset"`
	Order    string        `json:"order"`
	OrderBy  string        `json:"order_by"`
}

type ListRecordResponse struct {
	Total   int       `json:"total"`
	Records []*Record `json:"records"`
}

type QueryRecordRequest struct {
	ID   uint64 `json:"id"`
	Name string `json:"name"`
}

type Record struct {
	gorm.Model
	Name   string       `gorm:"column:name" json:"name"`
	Status RecordStatus `grom:"column:status" json:"status"`

	CreatedBy uint64 `gorm:"column:created_by" json:"created_by"`
	UpdatedBy uint64 `gorm:"column:updated_by" json:"updated_by"`
}

type RecordDao interface {
	Create(context.Context, *CreateRecordRequest) (id uint, err error)
	Update(context.Context, *UpdateRecordRequest) error
	UpdateStatus(context.Context, *UpdateRecordStatusRequest) error
	Get(ctx context.Context, id uint) (*Record, error)
	Query(context.Context, *QueryRecordRequest) (*Record, error)
	List(context.Context, *ListRecordRequest) (*ListRecordResponse, error)
	Delete(ctx context.Context, id uint) error
}

type RecordStatus int8

type UpdateRecordRequest struct {
	ID        uint    `json:"id"`
	Name      *string `json:"name"`
	UpdatedBy uint64  `json:"updated_by"`
}

type UpdateRecordStatusRequest struct {
	ID        uint         `json:"id"`
	Status    RecordStatus `json:"status"`
	UpdatedBy uint64       `json:"updated_by"`
}