Question 115606 in Mongodb Question posted in
The official documentation can be found here.

Mongodb – How to insert string as ISODate to mongo db, using golang?

I have the following transaction struct

type Transaction struct {
    ID       primitive.ObjectID `json:"id" bson:"_id"`
    Category primitive.ObjectID `bson:"category,omitempty"`
    Amount   string             `json:"amount" binding:"required"`
    Owner    primitive.ObjectID `bson:"owner,omitempty"`
    Date     primitive.DateTime `bson:"date" json:"date"`
    //Date     time.Time          `bson:"date" json:"date"`
}
var transaction models.Transaction
if err := c.ShouldBindJSON(&transaction); err != nil {
    c.JSON(http.StatusBadRequest, gin.H{"error": err.Error()})
    return
}
createdTransaction, createErr := handler.collection.InsertOne(handler.ctx, transaction)

I am trying to pass the date, in the following format Mon Jan 30 2023 17:27:16 GMT+0200 (Eastern European Standard Time), and I get the Bad Request error.
How can I insert the following date format as ISODate into mongodb?

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0 
    type Transaction struct {
    ID       primitive.ObjectID       `json:"id" bson:"_id"`
    Category primitive.ObjectID       `bson:"category,omitempty" json:"category"`
    Amount   string                   `json:"amount" binding:"required"`
    Owner    primitive.ObjectID       `bson:"owner,omitempty" json:"owner"`
    InvDt    primitive.DateTime       `bson:"invdt,omitempty" json:"invdt,omitempty"`
    Date     string                   `json:"date" binding:"required"`
    Cat      []map[string]interface{} `json:"cat" bson:"cat"`
}
const shortForm = "2006-01-02"
dt, _ := time.Parse(shortForm, transaction.Date)
transaction.InvDt = primitive.NewDateTimeFromTime(dt)

    As was mentioned before, i need to use parse time as string


  2. 0

    Change this line:

    createdTransaction, createErr := handler.collection.InsertOne(handler.ctx, transaction)

    To include &transaction like this as the final parameter InsertOne takes a reference to the data to be stored, not a value:

    createdTransaction, createErr := handler.collection.InsertOne(handler.ctx, &transaction)
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search