I have the following documents in a MongoDB database, but sometimes I don't know the structure for certain:
{
"_id" : ObjectId("54e58ea6128ae6385faa576e"),
"date" : ISODate("2015-02-19T00:00:00.000Z"),
"lat" : "53.5558774",
"lng" : "-113.4939486",
"apparentTemp" : -1.727777777777777,
"timezone" : "America/Edmonton",
"humidity" : 0.92,
"city" : "Edmonton",
"dewPoint" : 26.85,
"temp" : -1.727777777777777,
"summary" : "Light Snow",
"gmt_offset" : -7,
"windSpeed" : 0.13,
"windBearing" : 87,
"precipIntensity" : 0.0086,
"precipProbability" : 0.44,
"forecast" : [
{
"humidity" : 0.86,
"windSpeed" : 0.86,
"precipProbability" : 0.83,
"dewPoint" : 28.26,
"temp" : -0.02777777777777817,
"date" : ISODate("2015-02-19T00:00:00.000Z"),
"windBearing" : 63,
"precipIntensity" : 0.0528,
"apparentTemp" : -0.02777777777777817,
"summary" : "Snow (Under 1 in.)"
}
]
}
I have used the following code to query the database and am attempting to build an array of just the "date" and "temp" from forecast sub-document and have so far used the following code, but can't get to the point where I can query on the key to get the value:
var results bson.M
err2 := collection.Find(bson.M{
"city": vars["city"],
"forecast.1": bson.M{"$exists": true},
}).Sort("-date").One(&results)
if err2 != nil {
log.Fatal(err2)
}
switch reflect.TypeOf(results["forecast"]).Kind() {
case reflect.Slice:
s := reflect.ValueOf(results["forecast"])
for i := 0; i < s.Len(); i++ {
hourly_temps := s.Index(i).Interface()
fmt.Fprintln(w, hourly_temps)
}
}
The output I'm getting is:
map[humidity:0.86 temp:-.0277777777777817 windBearing:63 windSpeed:0.86 precipProbability:0.83 dewPoint:28.26 date:2015-02-19 00:00:00 -0700 MST precipIntensity:0.0528 apparentTemp:-0.02777777777777817 summary:Snow (Under 1 in.)]
I am fairly new to go and unsure of how to extract the value from date and temp. Any help would be greatly appreciated.