How to insert null value in JSON type in golang

Question

i have create remote schema for some purpose i have to insert a json value like this

"convert_to_money": {"IDR":10000},

i create a mutation field like this

"convert_to_money": {
 Type: scalar.JSON,
},

resolver like this :

Convert_to_money := p.Args["convert_to_money"].(map[string]interface{})

struct like this :

type TimeOvertimePolicy struct {
    ConvertToMoney          JSONB
}

and handler like this :

func UpdateOvertimesPolicy(Convert_to_money model.JSONB) (res gqltypes.SuccessType, err error) {
  timeOvertimesPolicy := model.TimeOvertimePolicy{
        ConvertToMoney:         Convert_to_money,
    }

  err = pg.DB.Transaction(func(tx *gorm.DB) error {
    d := tx.Create(&timeOvertimesPolicy)
  }
}

How can i do input null value for case like this?

Which is running now I have to insert a variable "convert_to_money": {} like this if the variable is null

I wish i can insert variable like this if null

"convert_to_money": null

Em Ae · Accepted Answer · 2021-07-14 03:39:39Z

1

In go nil (null) exist for pointers. So if you want to insert a nil value then your Convert_to_money should be of a pointer type.

answered Jul 14, 2021 at 3:39

Em Ae

8,83432 gold badges108 silver badges176 bronze badges

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

Comments

M_x · Accepted Answer · 2021-07-16 07:28:30Z

0

You can insert vairable like this

"convert_to_money": nil

answered Jul 16, 2021 at 7:28

M_x

8982 gold badges9 silver badges28 bronze badges

Comments

Jack · Accepted Answer · 2023-06-20 06:42:15Z

0

If you're using gorm, you can use pgtype.JSONB to init a "null" value:

pgtype.JSONB{Status: pgtype.Null}

answered Jun 20, 2023 at 6:42

Jack

491 silver badge6 bronze badges

Collectives™ on Stack Overflow

How to insert null value in JSON type in golang

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related