How to insert Data in JSONB Field of Postgres using GORM

Question

I have model like this in

model.go

type yourTableName struct {
   Name             string `gorm:"type:varchar(50)" json:"name"`
   Email            string `gorm:"type:varchar(50)" json:"email"`
   FieldNameOfJsonb JSONB  `gorm:"type:jsonb" json:"fieldnameofjsonb"`
}

I want to insert FieldNameOfJsonb as an array of object in postgres using GORM
Like given below

{
    "name": " james",
    "email": "[email protected]",
    "FieldNameOfJsonb": [
        {
            "someField1": "value",
            "someFiedl2": "somevalue",    
        },
        {
            "Field1": "value1",
            "Fiedl2": "value2",
        }
    ],

M_x · Accepted Answer · 2020-12-24 05:02:46Z

12

Just add this below code in Model.go (referenceLink)


import (
    "errors"
    "database/sql/driver"
    "encoding/json"
)

// JSONB Interface for JSONB Field of yourTableName Table
type JSONB []interface{}

// Value Marshal
func (a JSONB) Value() (driver.Value, error) {
    return json.Marshal(a)
}

// Scan Unmarshal
func (a *JSONB) Scan(value interface{}) error {
    b, ok := value.([]byte)
    if !ok {
        return errors.New("type assertion to []byte failed")
    }
    return json.Unmarshal(b,&a)
}

-> reference Link for Marshal, Unmarshal

now you can insert data using DB.Create(&yourTableName)

edited Dec 24, 2020 at 5:02

answered Dec 24, 2020 at 4:51

M_x

8982 gold badges9 silver badges28 bronze badges

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

2 Comments

Doron Segal Over a year ago

I would change the type to: type JSONB map[string]interface{}

M_x Over a year ago

obviously we can change as per our requirement

Yari · Accepted Answer · 2022-03-27 12:18:12Z

12

I have answered a similar question in https://stackoverflow.com/a/71636216/13719636 .

The simplest way to use JSONB in Gorm is to use pgtype.JSONB.

Gorm uses pgx as it driver, and pgx has package called pgtype, which has type named pgtype.JSONB.

If you have already install pgx as Gorm instructed, you don't need install any other package.

This method should be the best practice since it using underlying driver and no custom code is needed.

type User struct {
    gorm.Model
    Data pgtype.JSONB `gorm:"type:jsonb;default:'[]';not null"`
}

Get value from DB

u := User{}
db.find(&u)

var data []string

err := u.Data.AssignTo(&data)
if err != nil {
    t.Fatal(err)
}

Set value to DB

u := User{}

err := u.Data.Set([]string{"abc","def"})
if err != nil {
    return
}

db.Updates(&u)

answered Mar 27, 2022 at 12:18

Yari

1802 silver badges7 bronze badges

6 Comments

Tony Hart Over a year ago

dsnt wok for me

Hari Prasanth Over a year ago

Unfortunately, it doesn't work for me either

Aniket Divekar Over a year ago

any working solution for this?

Aniket Divekar Over a year ago

Metadata pgtype.JSONB json:"-" gorm:"column:metadata" helps.. "type:jsonb" was causing issue for me.. remove it and it works :)

arun Over a year ago

thanks, it worked for me, my type was a slice of int, and used the same code as its above

|

Dariush Abbasi · Accepted Answer · 2021-10-20 13:06:50Z

2

You can use gorm-jsonb package.

answered Oct 20, 2021 at 13:06

Dariush Abbasi

4701 gold badge4 silver badges15 bronze badges

Comments

Thiago Pacheco · Accepted Answer · 2024-09-09 14:51:23Z

2

I was able to make it work by simply adding serializer:json into the struct attribute, like so:

type yourTableName struct {
   Name             string `gorm:"type:varchar(50)" json:"name"`
   Email            string `gorm:"type:varchar(50)" json:"email"`
   FieldNameOfJsonb JSONB  `gorm:"type:jsonb;serializer:json" json:"fieldnameofjsonb"`
}

answered Sep 9, 2024 at 14:51

Thiago Pacheco

212 bronze badges

Collectives™ on Stack Overflow

How to insert Data in JSONB Field of Postgres using GORM

4 Answers 4

2 Comments

6 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

6 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related