본문 바로가기
데이터베이스

mongo run javascript file

by 혜룐 2018. 5. 24.


server@server001:~/tmp/by_catherine$ mongo localhost:27017/database_name < javascript_file.js > dump_`date +%Y%m%d`.log




localhost:포트/데이터베이스명 < 실행할 자바스크립트파일 > print stdout 결과파일 년월일 로그파일



javascript_file.js  파일내용

$ cat users_users_dump.js

//print("Start");

use users;

//show collections;

rs.slaveOk();

//db.users.findOne();

//db.users.find({"_id" : ObjectId("55c143ceeb0a190923b5c215")});

//db.users.find({"birthday" : {$gt: ISODate("2001-12-18T00:00:00Z") }}).count();

db.users.find({"state": "enabled"}).forEach(function(d){

if(!d.email.startsWith("test-")){

var open_ac_map = d.open_ac;

ts_created_at = Math.floor(new Date(d.created_at) / 1000);

if( typeof(open_ac_map) !== 'undefined' && open_ac_map !== null ){

    print(d._id +"\t"+ d.birthday +"\t"+d.timezone+"\t"+ ts_created_at +"\t"+ d.email +"\t"+ d.last_seen_at +"\t"+ d.state +"\t"+ d.friend_ids.length +"\t"+ d.gender+"\t"+d.open_ac["created_at"]+"\t"+d.open_ac["state"]+ "\t"+d.om_count);

}

}

});