2015년 3월 17일 화요일

mongodb create insert statement from collection using script

mongodb create insert statement from collection using script

yep~ i know this is a just trick but it is useful when developing system
  1. code
    var c = db.testType.find();
    while(c.hasNext()){
     var data = c.next();
     print('db.testType.insert(')
     printjson(data);
     print(');')
    }
    
  2. result
    db.testType.insert(
    { "_id" : "global", "serviceName" : "a", "url" : "global" }
    );
    db.testType.insert(
    { "_id" : "seoul", "serviceName" : "a ", "url" : "seoul" }
    );
    db.testType.insert(
    { "_id" : "jeju", "serviceName" : "a ", "url" : "jeju" }
    );
    db.testType.insert(
    { "_id" : "honkong", "serviceName" : "a ", "url" : "honkong" }
    );
    db.testType.insert(
    { "_id" : "taifei", "serviceName" : "a ", "url" : "taifei" }
    );
    db.testType.insert(
    { "_id" : "japan", "serviceName" : "a ", "url" : "japan" }
    );
    db.testType.insert(
    { "_id" : "taiwan", "serviceName" : "a ", "url" : "taiwan" }
    );