go-gorm，postgres：简单插入返回错误

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

go-gorm, postgres: simple inserts return error

问题

我正在尝试进行简单的插入操作，想要评估Postgres的实用性，因为最近有点炒作。我是一个MongoDB的用户。以下是我正在尝试做的事情：

  1. db, e := gorm.Open("postgres", fmt.Sprintf("host=%s user=%s dbname=%s password=%s sslmode=disable", pgHost, pgUser, pgDatabase, pgPass))
  2. if e != nil {
  3.     log.Fatal(e.Error())
  4. }
  5. defer db.Close()
  6. db.AutoMigrate(&model.Customer{}, &model.Email{}, &model.Address{}, &model.Name{}, &model.Logindata{})
  8. name := new(model.Name)
  9. email := new(model.Email)
  10. customer := &model.Customer{
  11.     Name:         name,
  12.     PrimaryEmail: email,
  13. }
  14. customer.Name.First = "Darko"
  15. customer.Name.Last = "Luketic"
  16. customer.Name.Middle = "" // also tried without this line
  17. customer.PrimaryEmail.Address = "my@mail.come"
  18. customer.PrimaryEmail.Verified = true
  19. tx := db.Begin()
  21. if e := tx.Create(name); e != nil {
  22.     tx.Rollback()
  23.     log.Fatal("create name", e.Error)
  24. }
  26. if e := tx.Create(email); e != nil {
  27.     tx.Rollback()
  28.     log.Fatal("create email", e.Error)
  29. }
  31. if e := tx.Create(customer); e != nil {
  32.     tx.Rollback()
  33.     log.Fatal("create customer", e.Error)
  34. }
  36. tx.Commit()

其中模型定义如下：

  1. package model
  3. import "github.com/jinzhu/gorm"
  5. type Customer struct {
  6.     gorm.Model
  7.     Name            *Name
  8.     BillingAddress  *Address
  9.     ShippingAddress *Address
  10.     PrimaryEmail    *Email
  11.     AlternateEmails []*Email
  12.     Logindata       *Logindata
  13. }
  15. type Name struct {
  16.     gorm.Model
  17.     First  string `json:"first"`
  18.     Middle string `json:"middle"`
  19.     Last   string `json:"last"`
  20. }
  22. type Logindata struct {
  23.     gorm.Model
  24.     Username string
  25.     Password []byte
  26. }
  28. type Email struct {
  29.     gorm.Model
  30.     Address  string
  31.     Verified bool
  32. }
  34. type Address struct {
  35.     gorm.Model
  36.     Address1 string
  37.     Address2 string
  38.     City     string
  39.     Code     string
  40.     Country  string
  41. }

输出结果为：

  1. go run main.go migrate
  2. migrate called
  3. 2017/08/01 17:10:26 create name<nil>
  4. exit status 1

我做错了什么？
为什么没有错误消息？
我该如何修复它？

英文:

I'm trying to do simple inserts, trying to evaluate the usefulness of Postgres because of this recent hype. I'm a mongoDB guy. And this is what I'm trying to do:

  1. db, e := gorm.Open(&quot;postgres&quot;, fmt.Sprintf(&quot;host=%s user=%s dbname=%s password=%s sslmode=disable&quot;, pgHost, pgUser, pgDatabase, pgPass))
  2. if e != nil {
  3. 	log.Fatal(e.Error())
  4. }
  5. defer db.Close()
  6. db.AutoMigrate(&amp;model.Customer{}, &amp;model.Email{}, &amp;model.Address{}, &amp;model.Name{}, &amp;model.Logindata{})
  8. name := new(model.Name)
  9. email := new(model.Email)
  10. customer := &amp;model.Customer{
  11. 	Name:         name,
  12. 	PrimaryEmail: email,
  13. }
  14. customer.Name.First = &quot;Darko&quot;
  15. customer.Name.Last = &quot;Luketic&quot;
  16. customer.Name.Middle = &quot;&quot; // also tried without this line
  17. customer.PrimaryEmail.Address = &quot;my@mail.come&quot;
  18. customer.PrimaryEmail.Verified = true
  19. tx := db.Begin()
  21. if e := tx.Create(name); e != nil {
  22. 	tx.Rollback()
  23. 	log.Fatal(&quot;create name&quot;, e.Error)
  24. }
  26. if e := tx.Create(email); e != nil {
  27. 	tx.Rollback()
  28. 	log.Fatal(&quot;create email&quot;, e.Error)
  29. }
  31. if e := tx.Create(customer); e != nil {
  32. 	tx.Rollback()
  33. 	log.Fatal(&quot;create customer&quot;, e.Error)
  34. }
  36. tx.Commit()

with the models being

  1. package model
  3. import &quot;github.com/jinzhu/gorm&quot;
  5. type Customer struct {
  6. 	gorm.Model
  7. 	Name            *Name
  8. 	BillingAddress  *Address
  9. 	ShippingAddress *Address
  10. 	PrimaryEmail    *Email
  11. 	AlternateEmails []*Email
  12. 	Logindata       *Logindata
  13. }
  15. type Name struct {
  16. 	gorm.Model
  17. 	First  string `json:&quot;first&quot;`
  18. 	Middle string `json:&quot;middle&quot;`
  19. 	Last   string `json:&quot;last&quot;`
  20. }
  22. type Logindata struct {
  23. 	gorm.Model
  24. 	Username string
  25. 	Password []byte
  26. }
  28. type Email struct {
  29. 	gorm.Model
  30. 	Address  string
  31. 	Verified bool
  32. }
  34. type Address struct {
  35. 	gorm.Model
  36. 	Address1 string
  37. 	Address2 string
  38. 	City     string
  39. 	Code     string
  40. 	Country  string
  41. }

The output:

  1. go run main.go migrate
  2. migrate called
  3. 2017/08/01 17:10:26 create name&lt;nil&gt;
  4. exit status 1

What am I doing wrong?
Why is there no error message?
How do I fix it?

答案1

得分: 1

根据文档的说明，Create方法返回的是*DB类型，而不是错误。所以你的代码应该更像这样：

  1. if tx = tx.Create(name); tx.Error != nil { /* ... */ }
英文:

According to the docs, Create returns a *DB, not an error. So your code should be more like

  1. if tx = tx.Create(name); tx.Error != nil { /* ... */ }

答案2

得分: 0

此外，

  1. db，e：= gorm.Open（“ postgres”，fmt.Sprintf（“ host =％s user =％s dbname =％s password =％s sslmode = disable”，pgHost，pgUser，pgDatabase，pgPass））
  2. 如果e！= nil {
  3. 	log.Fatal（e.Error（））
  4. }
  5. defer db.Close（）
  6. db.AutoMigrate（＆model.Customer {}，＆model.Email {}，＆model.Address {}，＆model.Name {}，＆model.Logindata {}）
  8. name：= new（model.Name）
  9. email：= new（model.Email）
  10. customer：=＆model.Customer {
  11. 	Name：name，
  12. 	PrimaryEmail：email，
  13. }
  14. customer.Name.First =“ Darko”
  15. customer.Name.Last =“ Luketic”
  16. customer.Name.Middle =“”
  17. customer.PrimaryEmail.Address =“ my@mail.come”
  18. customer.PrimaryEmail.Verified = true
  19. tx：= db.Begin（）
  21. 如果e：= tx.Create（customer）.Error; e！= nil {
  22. 	tx.Rollback（）
  23. 	log.Fatal（“创建客户”，e）
  24. }
  25. tx.Commit（）

我需要更改结构，使它们具有相关字段。我对orm期望更多。这就是为什么它是一个ORM对象关系管理器。
gorm在那里没有管理太多;）

包模型

import "github.com/jinzhu/gorm"

类型客户 struct {
gorm.Model
Name *Name
BillingAddress *Address
ShippingAddress *Address
PrimaryEmail *Email
AlternateEmails []*Email
Logindata *Logindata
}

类型名称 struct {
gorm.Model
CustomerID uint
First string json:"first"
Middle string json:"middle"
Last string json:"last"
}

类型Logindata struct {
gorm.Model
CustomerID uint
Username string
Password []byte
}

类型电子邮件 struct {
gorm.Model
CustomerID uint
Address string
Verified bool
}

类型地址 struct {
gorm.Model
CustomerID uint
Address1 string
Address2 string
City string
Code string
Country string
}

注意CustomerID uint

英文:

Also, additionally,

  1. db, e := gorm.Open(&quot;postgres&quot;, fmt.Sprintf(&quot;host=%s user=%s dbname=%s password=%s sslmode=disable&quot;, pgHost, pgUser, pgDatabase, pgPass))
  2. if e != nil {
  3. 	log.Fatal(e.Error())
  4. }
  5. defer db.Close()
  6. db.AutoMigrate(&amp;model.Customer{}, &amp;model.Email{}, &amp;model.Address{}, &amp;model.Name{}, &amp;model.Logindata{})
  8. name := new(model.Name)
  9. email := new(model.Email)
  10. customer := &amp;model.Customer{
  11. 	Name:         name,
  12. 	PrimaryEmail: email,
  13. }
  14. customer.Name.First = &quot;Darko&quot;
  15. customer.Name.Last = &quot;Luketic&quot;
  16. customer.Name.Middle = &quot;&quot;
  17. customer.PrimaryEmail.Address = &quot;my@mail.come&quot;
  18. customer.PrimaryEmail.Verified = true
  19. tx := db.Begin()
  21. if e := tx.Create(customer).Error; e != nil {
  22. 	tx.Rollback()
  23. 	log.Fatal(&quot;create customer&quot;, e)
  24. }
  25. tx.Commit()

I need to change the structs so they have a related field. I did expect more from an orm. That's why it's an ORM object relationship manager.
gorm doesn't manage much there go-gorm，postgres：简单插入返回错误

  1. package model
  3. import &quot;github.com/jinzhu/gorm&quot;
  5. type Customer struct {
  6. 	gorm.Model
  7. 	Name            *Name
  8. 	BillingAddress  *Address
  9. 	ShippingAddress *Address
  10. 	PrimaryEmail    *Email
  11. 	AlternateEmails []*Email
  12. 	Logindata       *Logindata
  13. }
  15. type Name struct {
  16. 	gorm.Model
  17. 	CustomerID uint
  18. 	First      string `json:&quot;first&quot;`
  19. 	Middle     string `json:&quot;middle&quot;`
  20. 	Last       string `json:&quot;last&quot;`
  21. }
  23. type Logindata struct {
  24. 	gorm.Model
  25. 	CustomerID uint
  26. 	Username   string
  27. 	Password   []byte
  28. }
  30. type Email struct {
  31. 	gorm.Model
  32. 	CustomerID uint
  33. 	Address    string
  34. 	Verified   bool
  35. }
  37. type Address struct {
  38. 	gorm.Model
  39. 	CustomerID uint
  40. 	Address1   string
  41. 	Address2   string
  42. 	City       string
  43. 	Code       string
  44. 	Country    string
  45. }

note the CustomerID uint

huangapple
  • 本文由 发表于 2017年8月1日 23:22:45
  • 转载请务必保留本文链接：https://go.coder-hub.com/45441783.html
  • go
  • go-gorm
  • postgresql
匿名

发表评论

匿名网友

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

确定