rwaltersma / stockpricegenerator Goto Github PK

Hi Robert, I read your "Time Series Data and MongoDB" and was wondering .. on page 2 in "Scenario 2: Time-based bucketing of one document per minute" and also in your stockgen.py you add the data like

{ "_id" : ObjectId("5e17a9e4ce7bcd11be997265"), "p" : { "56" : 13.01, "54" : 13.01, ... "18" : 13.02, "57" : 13.01, "50" : 13.01 }, "symbol" : "GOOG", "d" : ISODate("2020-01-08T00:03:00Z")

I am wondering, if I work with something that delivers the data per second, and does not add them as a bunch, I always get the data in the p subdocument added as array like

{ "_id" : ObjectId("5e17a9e4ce7bcd11be997265"), "p" : { [ "56" : 13.01, "54" : 13.01, ... "18" : 13.02, "57" : 13.01, "50" : 13.01 ] }, "symbol" : "GOOG", "d" : ISODate("2020-01-08T00:03:00Z")

I used the db.collection.update method and tried to

db.collection('bc').update( query, { $push : { p : sensordata, }, }, { upsert: true, multi: false, }

where each of my sensordata is an object like

30 : 2332

can you tell me, am I doing anything wrong here or where is the error ?

kind regards, Simon