How can I input data into a mysql model from an array in GO?

huangapple
go评论107阅读模式
英文:

How can I input data into a mysql model from an array in GO?

问题

所以，我正在使用GO和GORM开发这个MySQL模型，用户可以输入他们的数据。

  1. package table
  3. import (
  4. 	// "gorm.io/driver/mysql"
  5. 	"gorm.io/gorm"
  6. )
  8. var Department = []string{"计算机科学", "工程", "医学科学"}
  10. type Account struct {
  11. 	gorm.Model
  12. 	Accountname  string `json:"name"`    //AccountName
  13. 	AccontNumber int64  `json:"number"`  //AccountNumber		Text(40)
  14. 	//需要用户从Department数组中选择一个值
  15. }

我希望用户可以从提供的Department数组中选择一个值，并将其存储在我的表中，我该如何做到这一点？

英文:

So, I'm working on this mysql model Using GO and GORM where the user can input their data

  1. `package table
  3. import (
  4. 	//"gorm.io/driver/mysql"
  5. 	"gorm.io/gorm"
  6. )
  8. var Department = []string{"Computer Science", "Engineering", "Medical Science"}
  10. type Account struct {
  11. 	gorm.Model
  12. 	Accountname  string `json:"name"`    //AccountName
  13. 	AccontNumber int64  ` json:"number"` //AccountNumber		Text(40)
  14.    //need users to select one of the values from the Department Array
  15. }`

I want my user to select a value from the ones provided in the Department array and store it in my table, how can I go about doing it?

答案1

得分: 2

你可以为部门定义一个自定义字符串类型，但你仍然需要显式地检查用户提供的字符串是否正确：

  1. type DepartmentName string
  3. const (
  4.     DepartmentComputerScience DepartmentName = "计算机科学"
  5.     DepartmentNameEngineering DepartmentName = "工程"
  6.     DepartmentNameMedicalScience DepartmentName = "医学科学"
  7. )
  9. var DepartmentsMap = map[DepartmentName]bool{
  10.     DepartmentComputerScience: true, 
  11.     DepartmentNameEngineering: true, 
  12.     DepartmentNameMedicalScience: true,
  13. }
  15. type Account struct {
  16.     gorm.Model
  17.     Accountname  string         `json:"name"`    //AccountName
  18.     AccontNumber int64          `json:"number"` //AccountNumber        Text(40)
  19.     Department   DepartmentName `json:"department"`
  20. }
  22. func (d DepartmentName) Valid() error {
  23.     if _, ok := DepartmentsMap[d]; ok {
  24.         return nil
  25.     }
  26.     return errors.New("无效的部门")
  27. }
英文:

You can define a custom string type for departments, but you still will have to explicitly check that the user provided string is correct:

  1. type DepartmentName string
  3. const (
  4.     DepartmentComputerScience DepartmentName "Computer Science"
  5.     DepartmentNameEngineering DepartmentName "Engineering"
  6.     DepartmentNameMedicalScience DepartmentName "Medical Science"
  8. )
  9. var DepartmentsMap = map[DepartmentName]bool{
  10.     DepartmentComputerScience: true, 
  11.     DepartmentNameEngineering: true, 
  12.     DepartmentNameMedicalScience: true,
  13. }
  16. type Account struct {
  17. 	gorm.Model
  18. 	Accountname  string         `json:"name"`    //AccountName
  19. 	AccontNumber int64          ` json:"number"` //AccountNumber        Text(40)
  20. 	Department   DepartmentName `json:"department"`
  21. }
  23. func (d DepartmentName) Valid() error {
  24.     if _, ok := DepartmentsMap[d]; ok {
  25.         return nil
  26.     }
  27.     return errors.New("invalid department")
  28. }

huangapple
  • 本文由 发表于 2022年5月17日 16:47:17
  • 转载请务必保留本文链接：https://go.coder-hub.com/72270894.html
  • go
  • go-gorm
  • mysql
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定