Gozero学习：报错sql: expected 6 destination arguments in Scan, not 1

weixin_58860161

已于 2024-12-23 14:38:33 修改

阅读量217

点赞数 3

文章标签：学习 sql windows golang 数据库

于 2024-12-23 14:37:08 首次发布

本文链接：https://blog.csdn.net/weixin_58860161/article/details/144665888

版权

这是我查询数据库列表得逻辑代码

func (l *ProductTypeListLogic) ProductTypeList(req *types.ProductTypeListRequest) (resp *types.ProductTypeListResponse, err error) {
	list := []model.ProductType{}
	total := int64(0)
	sqlQuery := l.svcCtx.DB.Model(&model.ProductType{})
	totalQuery := l.svcCtx.DB.Model(&model.ProductType{})
	if req.PageSize > 0 && req.PageNum > 0 {
		sqlQuery.Offset((req.PageNum - 1) * req.PageSize).Limit(req.PageSize)
	}
	if req.ProductTypeName != nil {
		sqlQuery.Where("product_type_name LIKE ?", "%"+*req.ProductTypeName+"%")
		totalQuery.Where("product_type_name LIKE ?", "%"+*req.ProductTypeName+"%")
	}
	err = sqlQuery.Find(&list).Error
	err = totalQuery.Find(&total).Error
	if err != nil {
		return nil, err
	}
	resList := []types.ProductTypeDetailResponse{}
	for _, v := range list {
		resList = append(resList, types.ProductTypeDetailResponse{
			Id:              v.Id,
			ProductTypeName: v.ProductTypeName,
			ProductTypeCode: v.ProductTypeCode,
			ProductTypeDesc: v.ProductTypeDesc,
			SortCode:        v.SortCode,
		})
	}
	resp = &types.ProductTypeListResponse{
		List:  resList,
		Total: total,
	}
	return
}

数据库表定义：

type ProductType struct {
	Id              string `json:"id" gorm:"primaryKey;type:varchar(36);column:id"`
	ProductTypeName string `json:"product_type_name" gorm:"type:varchar(255);column:product_type_name;uniqueIndex;not null"`
	ProductTypeCode string `json:"product_type_code" gorm:"type:varchar(255);column:product_type_code"`
	ProductTypeDesc string `json:"product_type_desc" gorm:"type:text;column:product_type_desc"`
	SortCode        int64  `json:"sort_code" gorm:"type:bigint;column:sort_code;uniqueIndex;not null"`
	CreatedAt       time.Time
}

查询表中数据列表时报错：