preview_data_table.go 1.4 KB
package command

import (
	"fmt"
	"gitlab.fjmaimaimai.com/allied-creation/character-library-metadata-bastion/pkg/domain"
	"reflect"
	"strings"

	"github.com/beego/beego/v2/core/validation"
)

type TablePreviewCommand struct {
	// 表Id
	TableId    int          `cname:"表Id" json:"objectId" valid:"Required"`
	ObjectType string       `json:"objectType"`
	PageNumber int          `json:"pageNumber"`
	PageSize   int          `json:"pageSize"`
	Where      domain.Where `json:"where"`
	UseCache   bool         `json:"useCache"`
}

func (cmd *TablePreviewCommand) Valid(validation *validation.Validation) {
	if cmd.UseCache && cmd.PageSize == 0 {
		cmd.PageNumber = 1
		cmd.PageSize = 30000 //默认缓存前30000条
	}
	if cmd.PageSize > 0 {
		cmd.Where.PageNumber = cmd.PageNumber
		cmd.Where.PageSize = cmd.PageSize
	}
	if err := cmd.Where.ValidSql(); err != nil {
		validation.Error(err.Error())
	}
}

func (cmd *TablePreviewCommand) ValidateCommand() error {
	valid := validation.Validation{}
	if cmd.TableId == 0 {
		return fmt.Errorf("暂无数据可预览")
	}
	b, err := valid.Valid(cmd)
	if err != nil {
		return err
	}
	if !b {
		elem := reflect.TypeOf(cmd).Elem()
		for _, validErr := range valid.Errors {
			field, isExist := elem.FieldByName(validErr.Field)
			if isExist {
				return fmt.Errorf(strings.Replace(validErr.Message, validErr.Field, field.Tag.Get("cname"), -1))
			} else {
				return fmt.Errorf(validErr.Message)
			}
		}
	}
	return nil
}