python - mongodb group and combine -


i have doc has schema {'year-month-day','others'} , want convert 'year-month-day isodate time can use $match:{'$gte:targetdate'}

i have several problems:

  1. i using pymongo, dones support javaciprt, can not use new date() in python , @ same time datetime not working because can not read '$year'.

i think 1 way achieve above goal first substrings of 'year-month-day' , after aggregation can use foreach(function(x){...}) create isodate each date , compare target doing means have scan through every docs in database dont think choice.

  1. if first not doable in pymongo, how can mongodb query? how can use project create column new data type?(like did in second project).

  2. is there way javascrip inside pymongo?

my script following:

collection.aggregate([                                     {                     '$project':{                         'year':{'$substr':['$year-month-day',0,4]},                         'month':{'$substr':['$year-month-day',5,2]},                         'day':{'$substr':['$year-month-day',8,2]},                         'others':'others'                      }                     },                 {                     '$project':{                         'approtime':new date(date.utc('$year','$month','$day')),                         'others':'others'                      }                     },                 {                     '$group':{                         '_id':{                             'approtime':'$approtime',                             'others':'others'                         },                         'count':{'$sum':1}                     }                 }

you try converting field 'year-month-day' mongodb native isodate data type using datetime module stored under hood native date object in mongodb:

from pymongo import mongoclient datetime import datetime  client = mongoclient('host', port) db = client['database'] col = db['collection'] attr = 'year-month-day' date_format = "%y-%m-%d %h:%m:%s.%f" #date_format format of string eg : "%y-%m-%d %h:%m:%s.%f" doc in col.find():     if doc[attr]:         if type(doc[attr]) not datetime:             isodate = datetime.strptime(doc[attr], date_format)             col.update({'_id': doc['_id']}, {'$set': {attr: isodate}})

this can done in mongo shell as:

db.collection.find({     "$and": [         { "year-month-day": { "$exists": true } },         { "year-month-day": { "$not": {"$type": 9} } }     ] }).foreach(function(doc) {      doc["year-month-day"] = new date(doc["year-month-day"]);     db.collection.save(doc);  })

Comments

Post a Comment

Popular posts from this blog

timeout - Handshake_timeout on RabbitMQ using python and pika from remote vm -

i have several vm's around world, identical , same python code (and same library version of pika 0.9.13). 1 of them failing because of handshake_timeout: =error report==== 17-jun-2015::12:27:07 === closing amqp connection <0.290.0> (yy.yy.yy.yy:47232 -> xx.xx.xx.xx:5672): {handshake_timeout,handshake} that taken rabbitmq log, in client code see like error:pika.adapters.base_connection:connection xx.xx.xx.xx:5672 failed: timeout unhandled exception in thread started <function listen_for_start_download_message @ 0x1e5bcf8> i have tested connection telnet following guide: http://rubybunny.info/articles/troubleshooting.html i increased handshake_timeout 40000 milliseconds , ssl_handshake_timeout 20000 milliseconds , error persists, ping rabbitmq server machine little bit higher in other machines nothing abnormal (136ms). has found similar problem sometime or can recommend way test rabbitmq connection? i'm not sure if solution problem in case pr...
Read more

gcc - MinGW's ld cannot perform PE operations on non PE output file -

i know there other similar questions out there, stackoverflow or not. i've researched lot this, , still didn't find single solution. i'm doing operative system side project. i've been doing in assembly, wanna join c code. test, made assembly code file (called test.asm): [bits 32] global _a section .text _a: jmp $ then made c file (called main.c): extern void a(void); int main(void) { a(); } to link, used file (called make.bat): "c:\mingw\bin\gcc.exe" -ffreestanding -c -o c.o main.c nasm -f coff -o asm.o test.asm "c:\mingw\bin\ld.exe" -ttext 0x100000 --oformat binary -o out.bin c.o asm.o pause i've been researching ages, , i'm still struggling find answer. hope won't flagged duplicate. acknowledge existence of similar questions, have different answers, , none work me. question: what doing wrong? old mingw versions had problem "ld" not able create non-pe files @ all. maybe current versions...
Read more

c# - Search and Add Comment with OpenXML for Word -

i'm newbie openxml sdk. i need perform following tasks on word docx on server side, , believe openxml sdk first place should into. so requirements follows: look specific text in document add comment in location of found text. is possible openxml sdk? tried go through docs, , found way search , replace text, couldn't find way add comment in appropriate location. thanks! the link ron gave indicate how insert comment. insert want, can find paragraph like paragraph p = body.descendants<paragraph>().where(p.innertext.contains(searchstring)).firstordefault(); if (p != null) { // here follow link ron post create comment // insert comment p p.insertafter() said in link } maybe have adapt bit depending matching criteria
Read more