登录
首页 >  Golang >  Go问答

Golang中的嵌套json如何解组为简单的json对象?

来源:stackoverflow

时间:2024-02-08 09:36:24 232浏览 收藏

最近发现不少小伙伴都对Golang很感兴趣,所以今天继续给大家介绍Golang相关的知识,本文《Golang中的嵌套json如何解组为简单的json对象?》主要内容涉及到等等知识点,希望能帮到你!当然如果阅读本文时存在不同想法,可以在评论中表达,但是请勿使用过激的措辞~

问题内容

嗨,我需要一些帮助,我来自nodejs,正在寻找一种方法来解组嵌套的json,使其成为简单的json对。 这是我的嵌套 json 的示例。

{
    "id": 1000004,
    "reference": "t0000",
    "amount": 700000,
    "paid_at": "2022-07-24t00:49:13.000z",
    "created_at": "2022-07-24t00:49:08.000z",
    "metadata": {
        "custom_fields": [
            {
                "display_name": "meternumber",
                "value": "123456789"
            },
            {
                "display_name": "accountnumber",
                "value": "123456"
            }
        ]
    }
}

我想实现这个:

{
    "id": 1000004,
    "reference": "t0000",
    "amount": 700000,
    "paid_at": "2022-07-24t00:49:13.000z",
    "created_at": "2022-07-24t00:49:08.000z",
    "meter_number": "123456789",
    "account_number": "123456",
}

它曾经是一个深根嵌套的有效负载,我已经使用结构类型来隔离相关的对和数组,但它仍然不是我需要传递到数据库的格式。 指针和更正将不胜感激。

如何将嵌套的 json 解组为简单的 json 对 golang?

这是原始数据

data = []byte(`{
    "status": true,
    "message": "transactions retrieved",
    "data": [
        {
            "id": 10000000,
            "domain": "test",
            "status": "success",
            "reference": "t0000000000",
            "amount": 700000,
            "message": null,
            "gateway_response": "successful",
            "paid_at": "2022-07-24t00:49:13.000z",
            "created_at": "2022-07-24t00:49:08.000z",
            "channel": "card",
            "currency": "ngn",
            "ip_address": "102.89.32.12",
            "metadata": {
                "custom_fields": [
                    {
                        "display_name": "meternumber",
                        "variable_name": "meternumber",
                        "value": "123456789"
                    },
                    {
                        "display_name": "accountnumber",
                        "variable_name": "accountnumber",
                        "value": "123456"
                    }
                ],
                "referrer": "https://example.com/"
            },
            "log": {
                "start_time": 1658623749,
                "time_spent": 4,
                "attempts": 1,
                "errors": 0,
                "success": true,
                "mobile": false,
                "input": [],
                "history": [
                    {
                        "type": "action",
                        "message": "attempted to pay with card",
                        "time": 2
                    },
                    {
                        "type": "success",
                        "message": "successfully paid with card",
                        "time": 4
                    }
                ]
            },
            "fees": 20500,
            "fees_split": null,
            "customer": {
                "id": 87000000,
                "first_name": "foo",
                "last_name": "foo",
                "email": "[email protected]",
                "phone": "08090000000",
                "metadata": null,
                "customer_code": "cus_foo",
                "risk_action": "default"
            },
            "authorization": {
                "authorization_code": "auth_foo",
                "bin": "40123456789",
                "last4": "40000",
                "exp_month": "12",
                "exp_year": "2030",
                "channel": "card",
                "card_type": "visa ",
                "bank": "test bank",
                "country_code": "ng",
                "brand": "visa",
                "reusable": true,
                "signature": "sig_foo",
                "account_name": null
            },
            "plan": {},
            "split": {},
            "subaccount": {},
            "order_id": 800000,
            "paidat": "2022-07-24t00:49:13.000z",
            "createdat": "2022-07-24t00:49:08.000z",
            "requested_amount": 700000,
            "source": {
                "source": "checkout",
                "type": "web",
                "identifier": null,
                "entry_point": "request_inline"
            },
            "pos_transaction_data": null
        },
        {
            "id": 1000000,
            "domain": "test",
            "status": "success",
            "reference": "t13456789",
            "amount": 500000,
            "message": null,
            "gateway_response": "successful",
            "paid_at": "2022-07-24t00:28:34.000z",
            "created_at": "2022-07-24t00:28:08.000z",
            "channel": "card",
            "currency": "ngn",
            "ip_address": "192.168.1.1",
            "metadata": {
                "custom_fields": [
                    {
                        "display_name": "meternumber",
                        "variable_name": "meternumber",
                        "value": "123456789"
                    },
                    {
                        "display_name": "accountnumber",
                        "variable_name": "accountnumber",
                        "value": "123456"
                    }
                ],
                "referrer": "https://example.com"
            },
            "log": {
                "start_time": 1658622488,
                "time_spent": 26,
                "attempts": 1,
                "errors": 0,
                "success": true,
                "mobile": false,
                "input": [],
                "history": [
                    {
                        "type": "action",
                        "message": "set payment method to: bank",
                        "time": 15
                    },
                    {
                        "type": "action",
                        "message": "set payment method to: ussd",
                        "time": 16
                    },
                    {
                        "type": "action",
                        "message": "set payment method to: bank",
                        "time": 19
                    },
                    {
                        "type": "action",
                        "message": "set payment method to: card",
                        "time": 22
                    },
                    {
                        "type": "action",
                        "message": "attempted to pay with card",
                        "time": 25
                    },
                    {
                        "type": "success",
                        "message": "successfully paid with card",
                        "time": 26
                    }
                ]
            },
            "fees": 17500,
            "fees_split": null,
            "customer": {
                "id": 870000000,
                "first_name": "foo",
                "last_name": "foo",
                "email": "[email protected]",
                "phone": "0809000000",
                "metadata": null,
                "customer_code": "cus_xxxx",
                "risk_action": "default"
            },
            "authorization": {
                "authorization_code": "auth_xxxx",
                "bin": "400000",
                "last4": "40000",
                "exp_month": "12",
                "exp_year": "2030",
                "channel": "card",
                "card_type": "visa ",
                "bank": "test bank",
                "country_code": "ng",
                "brand": "visa",
                "reusable": true,
                "signature": "xxxxxx",
                "account_name": null
            },
            "plan": {},
            "split": {},
            "subaccount": {},
            "order_id": 827512,
            "paidat": "2022-07-24t00:28:34.000z",
            "createdat": "2022-07-24t00:28:08.000z",
            "requested_amount": 500000,
            "source": {
                "source": "checkout",
                "type": "web",
                "identifier": null,
                "entry_point": "request_inline"
            },
            "pos_transaction_data": null
        }
    ],
    "meta": {
        "total": 2,
        "total_volume": 12000,
        "skipped": 0,
        "perpage": 50,
        "page": 1,
        "pagecount": 1
    }
    }`)

这就是我所做的:

type Uservariabledata struct {
    //json.RawMessage `json:"custom_field"` 
    Display_name    string  `json:"display_name"`
    Value   string  `json:"value"`
    }

    //  struct
    type UserDataDetail struct {
    Custom_fields []Uservariabledata
    }

   //  struct
   type UserData struct {
    Id  int  `json:"id"`
    Reference string `json:"reference"`
    Amount uint `json:"amount"`
    Paid_at string `json:"paid_at"`
    Created_at string `json:"created_at"`
    Metadata  UserDataDetail
    }

   // Payload struct
   type Payload struct {
    Status        bool    `json:"status"`
    Message       string    `json:"message"`
    Data          []UserData
    Meta           json.RawMessage     `json:"meta"`
    
    }



    func (p *Payload) UnmarshalJSON(data []byte) error {
    type payload struct {
        Status        bool    `json:"status"`
        Message       string    `json:"message"`
        Data          []UserData
        Meta           json.RawMessage     `json:"meta"`
        
    }
    payld := &payload{}
    err := json.Unmarshal(data, payld)
    if err != nil {
        return err
    }
    p.Status = payld.Status
    p.Message = payld.Message
    p.Data=payld.Data
    p.Meta=payld.Meta
    return nil
    }

    // GetUserAmountPaid endpoint, this was done in my controller.go
    func GetUserAmountPaid(c echo.Context) (err error) {
       respData := Data
       payld := Payload{}

       err = json.Unmarshal(respData, &payld)
       if err != nil {
         panic(err)
    }

    return c.JSON(http.StatusOK, payld.Data)  
    
    }

正确答案


您主要已经确定您希望为“真实数据”和“传输数据”拥有单独的结构。

type realdata struct {
  id int `json:"id"`
  ...
  meternumber   string `json:"meter_number"`
  accountnumber string `json:"account_number"`
}

诀窍在于您的“传输数据”不太正确,它需要与正在解析的 json 的格式相匹配。

type transferdata struct {
  id int
  // ...
  metadata struct {
    custom_fields []struct{
      display_name  string
      variable_name string
      value         string
    }
  }
}

然后只需解组为“传输数据”类型的对象并将其复制到“真实数据”中即可。

func (realData *RealData) UnmarshalJSON(data []byte) error {
  var transferData TransferData
  err := json.Unmarshal(data, &transferData)
  if err != nil {
    return err
  }
  realData.Id = transferData.Id
  // ...

  // Now we must cherry-pick the known custom metadata fields we
  // care about into the desired fields of our real data.
  for _, cf := range transferData.Metadata.Custom_fields {
    switch cf.Display_name {
    case "MeterNumber":
      realData.MeterNumber = cf.Value
    case "AccountNumber":
      realData.AccountNumber = cf.Value
    }
  }
  return nil
}

到这里,我们也就讲完了《Golang中的嵌套json如何解组为简单的json对象?》的内容了。个人认为,基础知识的学习和巩固,是为了更好的将其运用到项目中,欢迎关注golang学习网公众号,带你了解更多关于的知识点!

声明:本文转载于:stackoverflow 如有侵犯,请联系study_golang@163.com删除
相关阅读
更多>
最新阅读
更多>
课程推荐
更多>