尝试使用Fiber和GORM编写一个创建数据库的POST请求，但是出现了错误。

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

Trying to write a post request to create a database with fiber and gorm and it gives me an error

问题

尝试使用gorm作为数据库和fiber作为golang框架来输出一个POST请求，但似乎有时候不起作用，有时候返回"json: unmarshal(non-pointer, main.AcctDetails)"的错误。请有人帮我解决这个问题，我已经卡在这里很长时间了。

  1. package main
  3. import (
  4.     "github.com/gofiber/fiber/v2"
  5.     "gorm.io/driver/sqlite"
  6.     "gorm.io/gorm"
  7. )
  9. var (
  10.     DB  *gorm.DB
  11.     err error
  12. )
  14. type AcctDetails struct {
  15.     gorm.Model
  16.     ID           uint   `json:"id"`
  17.     AcctName     string `json:"acctname"`
  18.     AcctNumber   string `json:"acctnumber"`
  19.     UsersPhoneNo string `json:"usersphoneno"`
  20. }
  22. func Routers(app *fiber.App) {
  23.     app.Post("/bank", CreateUser)
  24. }
  26. func CreateUser(c *fiber.Ctx) error {
  27.     info := new(AcctDetails)
  29.     if err := c.BodyParser(info); err != nil {
  30.         return c.Status(500).SendString(err.Error())
  31.     }
  33.     DB.Create(&info)
  34.     return c.Status(200).JSON(&info)
  35. }
  37. func main() {
  38.     app := fiber.New()
  39.     db, err := gorm.Open(sqlite.Open("test.db"), &gorm.Config{})
  40.     if err != nil {
  41.         panic("Cannot Connect To Database")
  42.     }
  43.     DB = db
  44.     DB.AutoMigrate(&AcctDetails{})
  45.     Routers(app)
  46.     app.Listen(":3000")
  47. }

它返回以下错误：

  1. PS C:\Users\Chinonso\Desktop\New folder\GO\main> go run main.go
  3. 2022/04/29 22:47:51 C:/Users/Chinonso/Desktop/New folder/GO/main/main.go:45 SLOW SQL >= 200ms
  4. [272.120ms] [rows:0] CREATE TABLE `acct_details` (`id` integer,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`acct_name` text,`acct_number` text,`users_phone_no` text,PRIMARY KEY (`id`))
  6. *this is after the server starts*
  8. panic: runtime error: invalid memory address or nil pointer dereference
  9. [signal 0xc0000005 code=0x0 addr=0x0 pc=0x7ff7bc6f05a2]
  11. goroutine 8 [running]:
  12. gorm.io/gorm.(*DB).Create(0xc0000c0000, {0x7ff7bc92e820, 0xc0000b4010})
  13.         C:/Users/Chinonso/go/pkg/mod/gorm.io/gorm@v1.23.5/finisher_api.go:18 +0x22
  14. main.CreateUser(0xc0000c0000)
  15.         C:/Users/Chinonso/Desktop/New folder/GO/main/main.go:35 +0xe5
  16. github.com/gofiber/fiber/v2.(*App).next(0xc0000023c0, 0xc0000c0000)
  17.         C:/Users/Chinonso/go/pkg/mod/github.com/gofiber/fiber/v2@v2.32.0/router.go:132 +0x1be
  18. github.com/gofiber/fiber/v2.(*App).handler(0xc0000023c0, 0x7ff7bc3a19b7)
  19.         C:/Users/Chinonso/go/pkg/mod/github.com/gofiber/fiber/v2@v2.32.0/router.go:159 +0x45
  20. github.com/valyala/fasthttp.(*Server).serveConn(0xc000127440, {0x7ff7bca94f30, 0xc000006ef8})
  21.         C:/Users/Chinonso/go/pkg/mod/github.com/valyala/fasthttp@v1.35.0/server.go:2338 +0x11ae
  22. github.com/valyala/fasthttp.(*workerPool).workerFunc(0xc0002a9360, 0xc0002bd440)
  23.         C:/Users/Chinonso/go/pkg/mod/github.com/valyala/fasthttp@v1.35.0/workerpool.go:224 +0xa9
  24. github.com/valyala/fasthttp.(*workerPool).getCh.func1()
  25.         C:/Users/Chinonso/go/pkg/mod/github.com/valyala/fasthttp@v1.35.0/workerpool.go:196 +0x38
  26. created by github.com/valyala/fasthttp.(*workerPool).getCh
  27.         C:/Users/Chinonso/go/pkg/mod/github.com/valyala/fasthttp@v1.35.0/workerpool.go:195 +0x1b5
  28. exit status 2
  29. PS C:\Users\Chinonso\Desktop\New folder\GO\main>

请有人帮我解决这段代码，这个问题困扰了我两个月了。

英文:

trying to oupt a post (create) request using gorm as my database and fiber as my golang framewor but it seems like it is not working sometimes it returns "json: unmarshal(non-pointer, main.AcctDetails)" someone should please help me out i have been stuck here for quite a long time

  1. package main
  3. import (
  5.     "github.com/gofiber/fiber/v2"
  6. 	"gorm.io/driver/sqlite"
  7. 	"gorm.io/gorm"
  8. )
  10. var (
  11. 	DB	*gorm.DB
  12. 	err error
  13. )
  15. type AcctDetails struct {
  16. 		gorm.Model
  17. 		ID           uint	 `json:"id"`
  18. 		AcctName     string	 `json:"acctname"`
  19. 		AcctNumber   string	 `json:"acctnumber"`
  20. 		UsersPhoneNo string	 `json:"usersphoneno"`
  21. 	}
  24. func Routers(app *fiber.App) {
  25. 	app.Post("/bank", CreateUser)
  26. }
  28. func CreateUser(c *fiber.Ctx) error {
  29. 	info := new(AcctDetails)
  30. 	
  31. 	if err := c.BodyParser(info); err != nil {
  32. 		return c.Status(500).SendString(err.Error())
  33. 	}
  35. 	DB.Create(&info)
  36. 	return c.Status(200).JSON(&info)
  37. }
  39. func main() {
  40. 	app := fiber.New()
  41. 	db, err := gorm.Open(sqlite.Open("test.db"), &gorm.Config{})
  42. 	if err != nil {
  43. 		panic("Cannot Connect To Database")
  44. 	}
  45. 	db.AutoMigrate(&AcctDetails{})
  46. 	Routers(app)
  47. 	app.Listen(":3000")
  48. }

and it returns this as error

  1. PS C:\Users\Chinonso\Desktop\New folder\GO\main> go run main.go
  3. 2022/04/29 22:47:51 C:/Users/Chinonso/Desktop/New folder/GO/main/main.go:45 SLOW SQL >= 200ms
  4. [272.120ms] [rows:0] CREATE TABLE `acct_details` (`id` integer,`created_at` datetime,`updated_at` datetime,`deleted_at` datetime,`acct_name` text,`acct_number` text,`users_phone_no` text,PRIMARY KEY (`id`))
  6. *this is after the server starts*
  8. panic: runtime error: invalid memory address or nil pointer dereference
  9. [signal 0xc0000005 code=0x0 addr=0x0 pc=0x7ff7bc6f05a2]
  11. goroutine 8 [running]:
  12. gorm.io/gorm.(*DB).Create(0xc0000c0000, {0x7ff7bc92e820, 0xc0000b4010})
  13.         C:/Users/Chinonso/go/pkg/mod/gorm.io/gorm@v1.23.5/finisher_api.go:18 +0x22
  14. main.CreateUser(0xc0000c0000)
  15.         C:/Users/Chinonso/Desktop/New folder/GO/main/main.go:35 +0xe5
  16. github.com/gofiber/fiber/v2.(*App).next(0xc0000023c0, 0xc0000c0000)
  17.         C:/Users/Chinonso/go/pkg/mod/github.com/gofiber/fiber/v2@v2.32.0/router.go:132 +0x1be
  18. github.com/gofiber/fiber/v2.(*App).handler(0xc0000023c0, 0x7ff7bc3a19b7)
  19.         C:/Users/Chinonso/go/pkg/mod/github.com/gofiber/fiber/v2@v2.32.0/router.go:159 +0x45
  20. github.com/valyala/fasthttp.(*Server).serveConn(0xc000127440, {0x7ff7bca94f30, 0xc000006ef8})
  21.         C:/Users/Chinonso/go/pkg/mod/github.com/valyala/fasthttp@v1.35.0/server.go:2338 +0x11ae
  22. github.com/valyala/fasthttp.(*workerPool).workerFunc(0xc0002a9360, 0xc0002bd440)
  23.         C:/Users/Chinonso/go/pkg/mod/github.com/valyala/fasthttp@v1.35.0/workerpool.go:224 +0xa9
  24. github.com/valyala/fasthttp.(*workerPool).getCh.func1()
  25.         C:/Users/Chinonso/go/pkg/mod/github.com/valyala/fasthttp@v1.35.0/workerpool.go:196 +0x38
  26. created by github.com/valyala/fasthttp.(*workerPool).getCh
  27.         C:/Users/Chinonso/go/pkg/mod/github.com/valyala/fasthttp@v1.35.0/workerpool.go:195 +0x1b5
  28. exit status 2
  29. PS C:\Users\Chinonso\Desktop\New folder\GO\main>

please someone should help me resolve this code it's giving me headach since two months now.

答案1

得分: 1

你正在尝试访问DB.Create()，但没有将db赋值给全局变量DB。

在之前的代码中：

  1.     db, err := gorm.Open(sqlite.Open("test.db"), &gorm.Config{})

修改后的代码如下：

  1.     DB, err = gorm.Open(sqlite.Open("test.db"), &gorm.Config{})
英文:

You are trying to access DB.Create() but didn't assign db to global variable DB.
Note: using debugger could prevent a lot of headaches

Before

  1.     db, err := gorm.Open(sqlite.Open("test.db"), &gorm.Config{})

After

  1.     DB, err = gorm.Open(sqlite.Open("test.db"), &gorm.Config{})

huangapple
  • 本文由 发表于 2022年4月30日 06:07:09
  • 转载请务必保留本文链接：https://go.coder-hub.com/72064116.html
  • go
  • go-fiber
  • go-gorm
匿名

发表评论

匿名网友

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

确定