无法运行Go服务器，原因是“panic: reflect.StructOf: 重复字段”。

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

Unable to run Go server due to "panic: reflect.StructOf: duplicate field"

问题

我正在尝试创建一个包含3个主要模型和3个控制器的后端API，但是每当我运行go run main.go时遇到问题，因为它给我返回了一个错误消息，指出我有一个重复的DeveloperID字段：

  1. [GIN-debug] [WARNING] Creating an Engine instance with the Logger and Recovery middleware already attached.
  3. [GIN-debug] [WARNING] Running in "debug" mode. Switch to "release" mode in production.
  4.  - using env:   export GIN_MODE=release
  5.  - using code:  gin.SetMode(gin.ReleaseMode)
  7. panic: reflect.StructOf: duplicate field DeveloperID
  9. goroutine 1 [running]:
  10. reflect.StructOf({0xc0003ee000, 0x3, 0xc00039e980})
  11.         /snap/go/8627/src/reflect/type.go:2597 +0x1d45
  12. gorm.io/gorm/schema.(*Schema).buildMany2ManyRelation(0xc00000c3c0, 0xc0001fcab0, 0xc0003cb6c0, {0x9a9922, 0xc0003b7470})
  13.         /home/nero/go/pkg/mod/gorm.io/gorm@v1.22.3/schema/relationship.go:270 +0xc25
  14. gorm.io/gorm/schema.(*Schema).parseRelation(0xc00000c3c0, 0xc0003cb6c0)
  15.         /home/nero/go/pkg/mod/gorm.io/gorm@v1.22.3/schema/relationship.go:79 +0x31f
  16. gorm.io/gorm/schema.ParseWithSpecialTableName({0x9ab3c0, 0xc0000de580}, 0xc0003b74d0, {0xb35250, 0xc0003b7470}, {0x0, 0x0})
  17.         /home/nero/go/pkg/mod/gorm.io/gorm@v1.22.3/schema/schema.go:275 +0x2105
  18. gorm.io/gorm.(*Statement).ParseWithSpecialTableName(0xc0003ca540, {0x9ab3c0, 0xc0000de580}, {0x0, 0x203000})
  19.         /home/nero/go/pkg/mod/gorm.io/gorm@v1.22.3/statement.go:463 +0x67
  20. gorm.io/gorm.(*Statement).Parse(...)
  21.         /home/nero/go/pkg/mod/gorm.io/gorm@v1.22.3/statement.go:459
  22. gorm.io/gorm/migrator.Migrator.ReorderModels.func1({0x9ab3c0, 0xc0000de580}, 0x1)
  23.         /home/nero/go/pkg/mod/gorm.io/gorm@v1.22.3/migrator/migrator.go:702 +0x179
  24. gorm.io/gorm/migrator.Migrator.ReorderModels({{0x60, 0xc0003b77a0, {0xb37360, 0xc0003b77d0}}}, {0xc0003d8460, 0x1, 0xa51940}, 0x1)
  25.         /home/nero/go/pkg/mod/gorm.io/gorm@v1.22.3/migrator/migrator.go:765 +0x630
  26. gorm.io/gorm/migrator.Migrator.AutoMigrate({{0x0, 0xc0003b77a0, {0xb37360, 0xc0003b77d0}}}, {0xc0003d8460, 0x0, 0x0})
  27.         /home/nero/go/pkg/mod/gorm.io/gorm@v1.22.3/migrator/migrator.go:90 +0x6d
  28. gorm.io/gorm.(*DB).AutoMigrate(0xb371a8, {0xc0003d8460, 0x1, 0x1})
  29.         /home/nero/go/pkg/mod/gorm.io/gorm@v1.22.3/migrator.go:26 +0x43
  30. SMS-Go/models.ConnectDatabase()
  31.         /home/nero/go/src/SMS-Go/models/setup.go:17 +0x111
  32. main.main()
  33.         /home/nero/go/src/SMS-Go/main.go:13 +0x27
  34. exit status 2

这是我的模型和正在被读取的控制器：
trigger_controller.go:

  1. /controllers/trigger_controller.go
  3. package controllers
  5. import (
  6. 	"SMS-Go/models"
  7. 	"net/http"
  8. 	"time"
  10. 	"github.com/gin-gonic/gin"
  11. 	uuid "github.com/nu7hatch/gouuid"
  12. )
  14. type MessageInput struct {
  15. 	TeamID  int    `json:"team_id" binding:"required"`
  16. 	Title   string `json:"title" binding:"required"`
  17. 	Content string `json:"content" binding:"required"`
  18. }
  20. // type Response struct {
  21. // 	TeamID string `json:"team_id"`
  22. // 	Sms    Sms    `json:"sms"`
  23. // 	Email  Email  `json:"email"`
  24. // }
  25. // type Sms struct {
  26. // 	ID      string   `json:"id"`
  27. // 	Mobiles []string `json:"mobiles"`
  28. // 	Content string   `json:"content"`
  29. // 	SentAt  string   `json:"sent_at"`
  30. // }
  31. // type Email struct {
  32. // 	ID      string   `json:"id"`
  33. // 	Emails  []string `json:"emails"`
  34. // 	Title   string   `json:"title"`
  35. // 	Content string   `json:"content"`
  36. // 	SentAt  string   `json:"sent_at"`
  37. // }
  39. func Notification(c *gin.Context) {
  40. 	var input MessageInput //input validation
  41. 	if err := c.ShouldBindJSON(&input); err != nil {
  42. 		c.JSON(http.StatusBadRequest, gin.H{"error": err.Error()})
  43. 		return
  44. 	}
  45. 	u1, err := uuid.NewV4()
  46. 	_ = err
  47. 	message := models.Message{TeamID: input.TeamID, Title: input.Title, Content: input.Content}
  48. 	models.DB.Create(&message)
  49. 	mob := models.DB.Raw(`SELECT "developers"."mobile" FROM "developers" INNER JOIN "developer_teams" ON "developers"."id" = "developer_teams"."developer_id" WHERE "developer_teams"."team_id"`)
  50. 	mail := models.DB.Raw(`SELECT "developers"."email" FROM "developers" INNER JOIN "developer_teams" ON "developers"."id" = "developer_teams"."developer_id" WHERE "developer_teams"."team_id"`)
  52. 	c.JSON(http.StatusOK, gin.H{
  53. 		"team_id": input.TeamID,
  54. 		"sms": gin.H{
  55. 			"id":      u1,
  56. 			"mobiles": mob,
  57. 			"content": input.Content,
  58. 			"sent_at": time.Now(),
  59. 		},
  60. 		"email": gin.H{
  61. 			"id":      u1,
  62. 			"emails":  mail,
  63. 			"title":   input.Title,
  64. 			"content": input.Content,
  65. 			"sent_at": time.Now(),
  66. 		},
  67. 	},
  68. 	)
  70. }

team.go:

  1. /models/team.go
  3. package models
  5. import "gorm.io/gorm"
  7. type Team struct {
  8. 	gorm.Model
  9. 	ID       uint   `json:"id" gorm:"primary_key"`
  10. 	Name     string `json:"name"`
  11. 	Dept     string `json:"dept_name"`
  12. 	Messages []Message
  13. }

developer.go:

  1. /models/developer.go
  3. package models
  5. import "gorm.io/gorm"
  7. type Developer struct {
  8. 	gorm.Model
  9. 	ID         uint        `json:"id" gorm:"primary_key"`
  10. 	Full_name  string      `json:"full_name"`
  11. 	Email      string      `json:"email"`
  12. 	Mobile     string      `json:"mobile"`
  13. 	Developers []Developer `gorm:"many2many:developer_teams"`
  14. }

message.go:

  1. /models/message.go
  3. package models
  5. import "gorm.io/gorm"
  7. type Message struct {
  8. 	gorm.Model
  9. 	ID      uint   `json:"id" gorm:"primary_key"`
  10. 	TeamID  int    `json:"team_id"`
  11. 	Title   string `json:"title"`
  12. 	Content string `json:"content"`
  13. 	Team    Team
  14. }

我试图使得当您在trigger_notification中以JSON格式输入字段时，它会返回一个JSON响应，显示属于特定团队的所有开发人员，通过mobile和email对象。
响应应该类似于这样：

  1. {
  2.  	"team_id": "team_id",
  3.  	"sms": {
  4.  		"id": "ARANDOMID",
  5.  		"mobiles": ["numer1","number2"],
  6.  		"content": "the content of this message",
  7.  		"sent_at": "18:54:34 IST 2021"
  8.  	},
  9.  	"email": {
  10.  		"id": "ARANDOMID",
  11.  		"emails": ["email1@email.com", "email2@email.com"],
  12.  		"title": "Used in emails for title",
  13.  		"content": "the content of this message",
  14.  		"sent_at": "18:54:34 IST 2021"
  15.  	}
  16. }

setup.go:

  1. package models
  3. import (
  4. 	"gorm.io/driver/sqlite"
  5. 	"gorm.io/gorm"
  6. )
  8. var DB *gorm.DB
  10. func ConnectDatabase() {
  11. 	database, err := gorm.Open(sqlite.Open("sms-go.db"), &gorm.Config{})
  13. 	if err != nil {
  14. 		panic("Failure to connect to database")
  15. 	}
  17. 	database.AutoMigrate(&Developer{})
  18. 	database.AutoMigrate(&Message{})
  19. 	database.AutoMigrate(&Team{})
  21. 	DB = database
  22. }
英文:

I'm trying to create a backend API that contains 3 main models and 3 controllers but I'm running into trouble whenever I run go run main.go because it gives me this error message stating that I have a duplicate DeveloperID field:

  1. [GIN-debug] [WARNING] Creating an Engine instance with the Logger and Recovery middleware already attached.
  3. [GIN-debug] [WARNING] Running in "debug" mode. Switch to "release" mode in production.
  4.  - using env:   export GIN_MODE=release
  5.  - using code:  gin.SetMode(gin.ReleaseMode)
  7. panic: reflect.StructOf: duplicate field DeveloperID
  9. goroutine 1 [running]:
  10. reflect.StructOf({0xc0003ee000, 0x3, 0xc00039e980})
  11.         /snap/go/8627/src/reflect/type.go:2597 +0x1d45
  12. gorm.io/gorm/schema.(*Schema).buildMany2ManyRelation(0xc00000c3c0, 0xc0001fcab0, 0xc0003cb6c0, {0x9a9922, 0xc0003b7470})
  13.         /home/nero/go/pkg/mod/gorm.io/gorm@v1.22.3/schema/relationship.go:270 +0xc25
  14. gorm.io/gorm/schema.(*Schema).parseRelation(0xc00000c3c0, 0xc0003cb6c0)
  15.         /home/nero/go/pkg/mod/gorm.io/gorm@v1.22.3/schema/relationship.go:79 +0x31f
  16. gorm.io/gorm/schema.ParseWithSpecialTableName({0x9ab3c0, 0xc0000de580}, 0xc0003b74d0, {0xb35250, 0xc0003b7470}, {0x0, 0x0})
  17.         /home/nero/go/pkg/mod/gorm.io/gorm@v1.22.3/schema/schema.go:275 +0x2105
  18. gorm.io/gorm.(*Statement).ParseWithSpecialTableName(0xc0003ca540, {0x9ab3c0, 0xc0000de580}, {0x0, 0x203000})
  19.         /home/nero/go/pkg/mod/gorm.io/gorm@v1.22.3/statement.go:463 +0x67
  20. gorm.io/gorm.(*Statement).Parse(...)
  21.         /home/nero/go/pkg/mod/gorm.io/gorm@v1.22.3/statement.go:459
  22. gorm.io/gorm/migrator.Migrator.ReorderModels.func1({0x9ab3c0, 0xc0000de580}, 0x1)
  23.         /home/nero/go/pkg/mod/gorm.io/gorm@v1.22.3/migrator/migrator.go:702 +0x179
  24. gorm.io/gorm/migrator.Migrator.ReorderModels({{0x60, 0xc0003b77a0, {0xb37360, 0xc0003b77d0}}}, {0xc0003d8460, 0x1, 0xa51940}, 0x1)
  25.         /home/nero/go/pkg/mod/gorm.io/gorm@v1.22.3/migrator/migrator.go:765 +0x630
  26. gorm.io/gorm/migrator.Migrator.AutoMigrate({{0x0, 0xc0003b77a0, {0xb37360, 0xc0003b77d0}}}, {0xc0003d8460, 0x0, 0x0})
  27.         /home/nero/go/pkg/mod/gorm.io/gorm@v1.22.3/migrator/migrator.go:90 +0x6d
  28. gorm.io/gorm.(*DB).AutoMigrate(0xb371a8, {0xc0003d8460, 0x1, 0x1})
  29.         /home/nero/go/pkg/mod/gorm.io/gorm@v1.22.3/migrator.go:26 +0x43
  30. SMS-Go/models.ConnectDatabase()
  31.         /home/nero/go/src/SMS-Go/models/setup.go:17 +0x111
  32. main.main()
  33.         /home/nero/go/src/SMS-Go/main.go:13 +0x27
  34. exit status 2

Here are my models and the controller that is being read:
trigger_controller.go:

  2. /controllers/trigger_controller.go
  4. package controllers
  6. import (
  7. 	"SMS-Go/models"
  8. 	"net/http"
  9. 	"time"
  11. 	"github.com/gin-gonic/gin"
  12. 	uuid "github.com/nu7hatch/gouuid"
  13. )
  15. type MessageInput struct {
  16. 	TeamID  int    `json:"team_id" binding:"required"`
  17. 	Title   string `json:"title" binding:"required"`
  18. 	Content string `json:"content" binding:"required"`
  19. }
  21. // type Response struct {
  22. // 	TeamID string `json:"team_id"`
  23. // 	Sms    Sms    `json:"sms"`
  24. // 	Email  Email  `json:"email"`
  25. // }
  26. // type Sms struct {
  27. // 	ID      string   `json:"id"`
  28. // 	Mobiles []string `json:"mobiles"`
  29. // 	Content string   `json:"content"`
  30. // 	SentAt  string   `json:"sent_at"`
  31. // }
  32. // type Email struct {
  33. // 	ID      string   `json:"id"`
  34. // 	Emails  []string `json:"emails"`
  35. // 	Title   string   `json:"title"`
  36. // 	Content string   `json:"content"`
  37. // 	SentAt  string   `json:"sent_at"`
  38. // }
  40. func Notification(c *gin.Context) {
  41. 	var input MessageInput //input validation
  42. 	if err := c.ShouldBindJSON(&input); err != nil {
  43. 		c.JSON(http.StatusBadRequest, gin.H{"error": err.Error()})
  44. 		return
  45. 	}
  46. 	u1, err := uuid.NewV4()
  47. 	_ = err
  48. 	message := models.Message{TeamID: input.TeamID, Title: input.Title, Content: input.Content}
  49. 	models.DB.Create(&message)
  50. 	mob := models.DB.Raw(`SELECT "developers"."mobile" FROM "developers" INNER JOIN "developer_teams" ON "developers"."id" = "developer_teams"."developer_id" WHERE "developer_teams"."team_id"`)
  51. 	mail := models.DB.Raw(`SELECT "developers"."email" FROM "developers" INNER JOIN "developer_teams" ON "developers"."id" = "developer_teams"."developer_id" WHERE "developer_teams"."team_id"`)
  53. 	c.JSON(http.StatusOK, gin.H{
  54. 		"team_id": input.TeamID,
  55. 		"sms": gin.H{
  56. 			"id":      u1,
  57. 			"mobiles": mob,
  58. 			"content": input.Content,
  59. 			"sent_at": time.Now(),
  60. 		},
  61. 		"email": gin.H{
  62. 			"id":      u1,
  63. 			"emails":  mail,
  64. 			"title":   input.Title,
  65. 			"content": input.Content,
  66. 			"sent_at": time.Now(),
  67. 		},
  68. 	},
  69. 	)
  71. }

team.go:

  1. /models/team.go
  3. package models
  5. import "gorm.io/gorm"
  7. type Team struct {
  8. 	gorm.Model
  9. 	ID       uint   `json:"id" gorm:"primary_key"`
  10. 	Name     string `json:"name"`
  11. 	Dept     string `json:"dept_name"`
  12. 	Messages []Message
  13. }

developer.go:

  1. /models/developer.go
  3. package models
  5. import "gorm.io/gorm"
  7. type Developer struct {
  8. 	gorm.Model
  9. 	ID         uint        `json:"id" gorm:"primary_key"`
  10. 	Full_name  string      `json:"full_name"`
  11. 	Email      string      `json:"email"`
  12. 	Mobile     string      `json:"mobile"`
  13. 	Developers []Developer `gorm:"many2many:developer_teams"`
  14. }

message.go:

  1. /models/message.go
  3. package models
  5. import "gorm.io/gorm"
  7. type Message struct {
  8. 	gorm.Model
  9. 	ID      uint   `json:"id" gorm:"primary_key"`
  10. 	TeamID  int    `json:"team_id"`
  11. 	Title   string `json:"title"`
  12. 	Content string `json:"content"`
  13. 	Team    Team
  14. }

I'm trying to make it such that when you enter the input fields as JSON in trigger_notification, it sends back a JSON response that shows all the developers that are under a specific team via the mobile and email objects.
The response should look something like this:

  1. {
  2. team_id: "team_id",
  3. sms: {
  4. id: "ARANDOMID",
  5. mobiles: ["numer1","number2"]
  6. content: "the content of this message",
  7. sent_at: "18:54:34 IST 2021"
  8. },
  9. email: {
  10. id: "ARANDOMID",
  11. emails: ["email1@email.com", "email2@email.com"]
  12. title: "Used in emails for title",
  13. content: "the content of this message",
  14. sent_at: "18:54:34 IST 2021"
  15. }

setup.go:

  1. package models
  3. import (
  4. 	"gorm.io/driver/sqlite"
  5. 	"gorm.io/gorm"
  6. )
  8. var DB *gorm.DB
  10. func ConnectDatabase() {
  11. 	database, err := gorm.Open(sqlite.Open("sms-go.db"), &gorm.Config{})
  13. 	if err != nil {
  14. 		panic("Failure to connect to database")
  15. 	}
  17. 	database.AutoMigrate(&Developer{})
  18. 	database.AutoMigrate(&Message{})
  19. 	database.AutoMigrate(&Team{})
  21. 	DB = database
  22. }

答案1

得分: 2

对于自引用的多对多关系，您需要使用与模型名称不同的字段名称，例如：

  1. type Developer struct {
  2.     gorm.Model
  3.     ID        uint        `json:"id" gorm:"primary_key"`
  4.     Full_name string      `json:"full_name"`
  5.     Email     string      `json:"email"`
  6.     Mobile    string      `json:"mobile"`
  8.     // 将 `Developers []Developer` 更改为：
  9.     DevTeam []Developer   `gorm:"many2many:developer_teams"`
  10. }

请参阅 gorm.io 文档：自引用的多对多关系。

英文:

For self-referential many2many relationship you need to use a field name that is different from the model's name, for example:

  1. type Developer struct {
  2.     gorm.Model
  3.     ID        uint        `json:"id" gorm:"primary_key"`
  4.     Full_name string      `json:"full_name"`
  5.     Email     string      `json:"email"`
  6.     Mobile    string      `json:"mobile"`
  8.     // Change `Developers []Developer` to:
  9.     DevTeam []Developer   `gorm:"many2many:developer_teams"`
  10. }

See gorm.io docs: Self-Referential Many2Many.

huangapple
  • 本文由 发表于 2021年11月16日 16:12:36
  • 转载请务必保留本文链接：https://go.coder-hub.com/69985721.html
  • go
  • go-gorm
匿名

发表评论

匿名网友

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

确定