Mongodb Timeseries / Golang -[“时间戳”必须存在并包含有效的BSON UTC日期时间值]

aurhwmvo  于 2023-02-27  发布在  Go
关注(0)|答案(1)|浏览(258)

我有下面的Go语言示例代码,它将来自REST请求(GIN)的数据插入MongoDB,但是它失败了,并显示:

['timestamp' must be present and contain a valid BSON UTC datetime value]

代码:

func CreateDevicesReadings(c *gin.Context) {

var devicesReadings DevicesReadings
c.BindJSON(&devicesReadings)

// Connect to MongoDB
client, err := mongo.Connect(context.Background(), clientOptions)
if err != nil {
    c.JSON(500, gin.H{
        "message": "Internal Server Error. Could not connect to the database.",

    })
    log.Default().Println(err)
}

collection := client.Database("florly").Collection("devicesReadings")
ctx, _ := context.WithTimeout(context.Background(), 5*time.Second)

// Set timestamp to the current time at the moment of the request
for i := 0; i < len(devicesReadings.DevicesReadings); i++ {
    devicesReadings.DevicesReadings[i].Timestamp = time.Now().UTC()
} 
_, err = collection.InsertOne(ctx, devicesReadings)
if err != nil {
    c.JSON(500, gin.H{
        "message": "Internal Server Error. Could not insert the data into the database.",
    })
    log.Default().Println(err)
} else {
    log.Default().Println("Data inserted successfully.")
}

client.Disconnect(context.Background())
}

type DeviceReadings struct {
    ID      primitive.ObjectID `json:"_id,omitempty" bson:"_id,omitempty"`
    Alias          string `json:"alias" bson:"alias"`
    Timestamp   time.Time `json:"timestamp,omitempty" bson:"timestamp"`
    SystemReadings SystemReadings `json:"systemReadings" bson:"systemReadings"`
    SensorReadings SensorReadings `json:"sensorsReadings" bson:"sensorsReadings"`
}

我做错了什么?我以为Mongodb完成了将time.time类型转换为MongoDB所需类型的整个过程。

8ehkhllq

8ehkhllq1#

调用Collection.InsertOne(),它可以用来插入单个文档,但是devicesReadings是多个文档的切片。
因此,要么遍历所有文档并将它们分别传递给Collection.InsertOne(),要么使用Collection.InsertMany(),使用要插入的多个文档的切片。

相关问题