英文:
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)"的错误。请有人帮我解决这个问题,我已经卡在这里很长时间了。
package main
import (
"github.com/gofiber/fiber/v2"
"gorm.io/driver/sqlite"
"gorm.io/gorm"
)
var (
DB *gorm.DB
err error
)
type AcctDetails struct {
gorm.Model
ID uint `json:"id"`
AcctName string `json:"acctname"`
AcctNumber string `json:"acctnumber"`
UsersPhoneNo string `json:"usersphoneno"`
}
func Routers(app *fiber.App) {
app.Post("/bank", CreateUser)
}
func CreateUser(c *fiber.Ctx) error {
info := new(AcctDetails)
if err := c.BodyParser(info); err != nil {
return c.Status(500).SendString(err.Error())
}
DB.Create(&info)
return c.Status(200).JSON(&info)
}
func main() {
app := fiber.New()
db, err := gorm.Open(sqlite.Open("test.db"), &gorm.Config{})
if err != nil {
panic("Cannot Connect To Database")
}
DB = db
DB.AutoMigrate(&AcctDetails{})
Routers(app)
app.Listen(":3000")
}
它返回以下错误:
PS C:\Users\Chinonso\Desktop\New folder\GO\main> go run main.go
2022/04/29 22:47:51 C:/Users/Chinonso/Desktop/New folder/GO/main/main.go:45 SLOW SQL >= 200ms
[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`))
*this is after the server starts*
panic: runtime error: invalid memory address or nil pointer dereference
[signal 0xc0000005 code=0x0 addr=0x0 pc=0x7ff7bc6f05a2]
goroutine 8 [running]:
gorm.io/gorm.(*DB).Create(0xc0000c0000, {0x7ff7bc92e820, 0xc0000b4010})
C:/Users/Chinonso/go/pkg/mod/gorm.io/gorm@v1.23.5/finisher_api.go:18 +0x22
main.CreateUser(0xc0000c0000)
C:/Users/Chinonso/Desktop/New folder/GO/main/main.go:35 +0xe5
github.com/gofiber/fiber/v2.(*App).next(0xc0000023c0, 0xc0000c0000)
C:/Users/Chinonso/go/pkg/mod/github.com/gofiber/fiber/v2@v2.32.0/router.go:132 +0x1be
github.com/gofiber/fiber/v2.(*App).handler(0xc0000023c0, 0x7ff7bc3a19b7)
C:/Users/Chinonso/go/pkg/mod/github.com/gofiber/fiber/v2@v2.32.0/router.go:159 +0x45
github.com/valyala/fasthttp.(*Server).serveConn(0xc000127440, {0x7ff7bca94f30, 0xc000006ef8})
C:/Users/Chinonso/go/pkg/mod/github.com/valyala/fasthttp@v1.35.0/server.go:2338 +0x11ae
github.com/valyala/fasthttp.(*workerPool).workerFunc(0xc0002a9360, 0xc0002bd440)
C:/Users/Chinonso/go/pkg/mod/github.com/valyala/fasthttp@v1.35.0/workerpool.go:224 +0xa9
github.com/valyala/fasthttp.(*workerPool).getCh.func1()
C:/Users/Chinonso/go/pkg/mod/github.com/valyala/fasthttp@v1.35.0/workerpool.go:196 +0x38
created by github.com/valyala/fasthttp.(*workerPool).getCh
C:/Users/Chinonso/go/pkg/mod/github.com/valyala/fasthttp@v1.35.0/workerpool.go:195 +0x1b5
exit status 2
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
package main
import (
"github.com/gofiber/fiber/v2"
"gorm.io/driver/sqlite"
"gorm.io/gorm"
)
var (
DB *gorm.DB
err error
)
type AcctDetails struct {
gorm.Model
ID uint `json:"id"`
AcctName string `json:"acctname"`
AcctNumber string `json:"acctnumber"`
UsersPhoneNo string `json:"usersphoneno"`
}
func Routers(app *fiber.App) {
app.Post("/bank", CreateUser)
}
func CreateUser(c *fiber.Ctx) error {
info := new(AcctDetails)
if err := c.BodyParser(info); err != nil {
return c.Status(500).SendString(err.Error())
}
DB.Create(&info)
return c.Status(200).JSON(&info)
}
func main() {
app := fiber.New()
db, err := gorm.Open(sqlite.Open("test.db"), &gorm.Config{})
if err != nil {
panic("Cannot Connect To Database")
}
db.AutoMigrate(&AcctDetails{})
Routers(app)
app.Listen(":3000")
}
and it returns this as error
PS C:\Users\Chinonso\Desktop\New folder\GO\main> go run main.go
2022/04/29 22:47:51 C:/Users/Chinonso/Desktop/New folder/GO/main/main.go:45 SLOW SQL >= 200ms
[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`))
*this is after the server starts*
panic: runtime error: invalid memory address or nil pointer dereference
[signal 0xc0000005 code=0x0 addr=0x0 pc=0x7ff7bc6f05a2]
goroutine 8 [running]:
gorm.io/gorm.(*DB).Create(0xc0000c0000, {0x7ff7bc92e820, 0xc0000b4010})
C:/Users/Chinonso/go/pkg/mod/gorm.io/gorm@v1.23.5/finisher_api.go:18 +0x22
main.CreateUser(0xc0000c0000)
C:/Users/Chinonso/Desktop/New folder/GO/main/main.go:35 +0xe5
github.com/gofiber/fiber/v2.(*App).next(0xc0000023c0, 0xc0000c0000)
C:/Users/Chinonso/go/pkg/mod/github.com/gofiber/fiber/v2@v2.32.0/router.go:132 +0x1be
github.com/gofiber/fiber/v2.(*App).handler(0xc0000023c0, 0x7ff7bc3a19b7)
C:/Users/Chinonso/go/pkg/mod/github.com/gofiber/fiber/v2@v2.32.0/router.go:159 +0x45
github.com/valyala/fasthttp.(*Server).serveConn(0xc000127440, {0x7ff7bca94f30, 0xc000006ef8})
C:/Users/Chinonso/go/pkg/mod/github.com/valyala/fasthttp@v1.35.0/server.go:2338 +0x11ae
github.com/valyala/fasthttp.(*workerPool).workerFunc(0xc0002a9360, 0xc0002bd440)
C:/Users/Chinonso/go/pkg/mod/github.com/valyala/fasthttp@v1.35.0/workerpool.go:224 +0xa9
github.com/valyala/fasthttp.(*workerPool).getCh.func1()
C:/Users/Chinonso/go/pkg/mod/github.com/valyala/fasthttp@v1.35.0/workerpool.go:196 +0x38
created by github.com/valyala/fasthttp.(*workerPool).getCh
C:/Users/Chinonso/go/pkg/mod/github.com/valyala/fasthttp@v1.35.0/workerpool.go:195 +0x1b5
exit status 2
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
。
在之前的代码中:
db, err := gorm.Open(sqlite.Open("test.db"), &gorm.Config{})
修改后的代码如下:
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
db, err := gorm.Open(sqlite.Open("test.db"), &gorm.Config{})
After
DB, err = gorm.Open(sqlite.Open("test.db"), &gorm.Config{})
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论