Decimal type in Go and Postgresql with gorm

Question

So i'm creating an API and I needed to store the price of something.

I'm using gorm and gormigrate for my database migration. I'm just wondering what proper type should I use for storing decimals. I've red somewhere that I shouldn't use floats when storing currencies.

type MyStruct struct {
    Name        string `json:"name" gorm:"not null"`
    Description string `json:"description" gorm:"null"`
    Price <what type should be here> `json:"price"`
}

can you please show an example of how you used it? gorm is throwing an error when i do automigrate — stevenferrer
– stevenferrer, Commented Jun 16, 2018 at 15:30
Sorry, I don't use grom myself and thus don't have any experience using shopspring/decimal with it... — ain
– ain, Commented Jun 16, 2018 at 15:46
@ain, oh, btw thanks for suggesting the package. greatly appreciated! — stevenferrer
– stevenferrer, Commented Jun 16, 2018 at 15:47

stevenferrer · Accepted Answer · 2018-06-18 02:45:25Z

7

So, based on the suggestion of @ain, I used shopspring/decimal. But it's giving me an error when I do automigrate.

It turns out that I only needed to set the type to numeric using a gorm tag to make it work:

type MyStruct struct {
    Name        string `json:"name" gorm:"not null"`
    Description string `json:"description" gorm:"null"`
    Price decimal.Decimal `json:"price" gorm:"type:numeric"`
}

edited Jun 18, 2018 at 2:45

answered Jun 16, 2018 at 15:56

stevenferrer

2,6121 gold badge24 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Decimal type in Go and Postgresql with gorm

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related