mongodb表字段处理生成域名字段


//
db.getMongo().setSlaveOk(); //db.user.drop(); //db.user.save({"a":"111@34.com","b":"222"}); //db.user.save({"a":"222@55.com","b":"333"}); var stime=new Date; print(stime); var teststr="001_0010@osmaauto.com_1379305393"; var teststr1="001_0010@osmaauto.com_1379305393.cn"; function getDomain(teststr) { //print("length:"+len); var len=teststr.length; var ltidx=teststr.lastIndexOf('_'); if(ltidx!=-1) { //print('last index of '+ltidx); var tm=teststr.substr(ltidx+1,len-ltidx); //print('domain '+tm) var idx1=teststr.indexOf('@'); var fidx=tm.indexOf('.'); if( fidx != -1 ) { //print("!=-1"); return teststr.substr(idx1+1); } else { //print("==-1"); //print('@:'+(idx1+1)); //print('_:'+ltidx); var ss=teststr.substring(idx1+1,ltidx); return (ss) } } } //print('domain com: '+getDomain(teststr)); //print('domain cn: '+getDomain(teststr1)); i=0; var cursor=db.user_dict.find().snapshot(); while(cursor.hasNext()) { var rec=cursor.next(); i++; print(rec["_id"]); print(i); //var dom=rec["_id"].split("@"); //print(dom[1]); var dom=getDomain(rec["_id"]); db.user_dict.update({_id:rec["_id"]},{$set:{domain:dom,cip_name:"cip1"}}); } var endtime=new Date; print(endtime);
原文地址:https://www.cnblogs.com/mytech/p/3499389.html