def get(self): print 'get' # args = parser.parse_args() # print 'args=',args client = MongoClient(util.getMydbip()) db = client.test_database print "list get=",request searchword = request.args.get('where', '') offset = int(request.args.get('offset', '0')) limit = int(request.args.get('limit', '0')) print 'searchword=',searchword print 'offset=',offset print 'limit=',limit # ret = db.news.find_one() if searchword=='': print 'searchword=null' #sort({"createdAt":-1}) try: if limit==0: if offset ==0: ret = db[self.documentname].find().sort([('_id', -1)]) else: ret = db[self.documentname].find().sort([('_id', -1)]).offset(offset); else: if offset == 0 : ret = db[self.documentname].find().sort([('_id', -1)]).limit(limit) else: ret = db[self.documentname].find().sort([('_id', -1)]).skip(offset).limit(limit) except Exception,e: print e
def put(self, todo_id): print "put=", request print 'todo_id', todo_id try: print "put request=", request.json # newtodo_id = request.json['id']; # print "newtodo_id=",newtodo_id; client = MongoClient(util.getMydbip()) try: del request.json["id"] except Exception, e: print e db = client.test_database opword = request.args.get('op', '') print 'opword=', opword op = getUserAcl(self.appsecretkey, request) print 'op=', op dict = {} dict['_id'] = ObjectId(todo_id) for (d, x) in op.items(): dict[d] = x request.json['updatedAt'] = MongoResource.getIso8601() if opword == '': ret = db[self.documentname].update(dict, {"$set": request.json}) else: ret = db[self.documentname].update(dict, {opword: request.json}) print 'ret=', ret retdict = {"id": todo_id, "updatedAt": request.json['updatedAt']} return json.dumps(retdict)
def post(self): print "post=",request print request.url print 'request=',request form = request.form if not self.before_save(): return "111",404 try: print "post request=",request.form client = MongoClient(util.getMydbip()) db = client.test_database # timestr= time.strftime('%Y-%m-%d %H:%M:%S') ## request.form['createdAt']=timestr data = dict((key, request.form.getlist(key)) for key in request.form.keys()) print 'data=',data # data['createdAt']=timestr data['created']=int( time()) data['refunded']=False data['pay']=False data['time_expire']=int( time())+3600*2 ret = db[self.documentname].insert(data) print str(ret) # retdict = {"objectId":str(ret),'createdAt':timestr} self.after_save(); print 'data=',data if data.get("id")==None: oid = str(data["_id"]) del data["_id"] data['id']=oid return json.dumps(data),201 except Exception,e: print e
def postResource(documentname, request): print "post=", request # if not self.before_save(): # return "111",404 try: client = MongoClient(util.getMydbip()) db = client.test_database timestr = MongoResource.getIso8601() request['createdAt'] = timestr if request.has_key("location"): print 'find location' location = request['location'] del location["__type"] ret = db[documentname].insert(request) print str(ret) retdict = {"objectId": str(ret), 'createdAt': timestr} # self.after_save(); # return json.dumps(retdict),201 retstr = json.dumps(retdict, default=json_util.default) return retstr except Exception, e: print e
def put(self, todo_id): print "put=", request print 'todo_id', todo_id try: print "put request=", request.json # newtodo_id = request.json['id']; # print "newtodo_id=",newtodo_id; client = MongoClient(util.getMydbip()) try: del request.json["id"] except Exception, e: print e db = client.test_database opword = request.args.get('op', '') print 'opword=', opword updatedAt = time.strftime('%Y-%m-%d %H:%M:%S') request.json['updatedAt'] = time.strftime('%Y-%m-%d %H:%M:%S') if opword == '': ret = db[self.documentname].update({'_id': ObjectId(todo_id)}, {"$set": request.json}) else: ret = db[self.documentname].update({'_id': ObjectId(todo_id)}, {opword: request.json}) print 'ret=', ret retdict = {"id": todo_id, "updatedAt": updatedAt} return json.dumps(retdict)
def post(self): print "post=", request print request.url print 'request=', request form = request.form if not self.before_save(): return "111", 404 try: print "post request=", request.form client = MongoClient(util.getMydbip()) db = client.test_database # timestr= time.strftime('%Y-%m-%d %H:%M:%S') ## request.form['createdAt']=timestr data = dict((key, request.form.getlist(key)) for key in request.form.keys()) print 'data=', data # data['createdAt']=timestr data['created'] = int(time()) data['refunded'] = False data['pay'] = False data['time_expire'] = int(time()) + 3600 * 2 ret = db[self.documentname].insert(data) print str(ret) # retdict = {"objectId":str(ret),'createdAt':timestr} self.after_save() print 'data=', data if data.get("id") == None: oid = str(data["_id"]) del data["_id"] data['id'] = oid return json.dumps(data), 201 except Exception, e: print e
def putResource(documentname, request, todo_id): print "put=", request print 'todo_id', todo_id try: # print "put request=",request.json # newtodo_id = request.json['id']; # print "newtodo_id=",newtodo_id; client = MongoClient(util.getMydbip()) try: del request["id"] except Exception, e: print e opword = request.get('op', '') print 'opword=', opword db = client.test_database updatedAt = MongoResource.getIso8601() request['updatedAt'] = updatedAt # aclcondition = getAcl(request) # print 'aclcondition',aclcondition if opword == '': ret = db[documentname].update({'_id': ObjectId(todo_id)}, {"$set": request}) else: ret = db[documentname].update({'_id': ObjectId(todo_id)}, {opword: request}) print 'ret=', ret retdict = {"id": todo_id, "updatedAt": updatedAt} retstr = json.dumps(retdict, default=json_util.default) return retstr
def reviewBarber(obarberid): client = MongoClient(util.getMydbip()) db = client.test_database dict = {} document = db["barber"].find_one({'_id': ObjectId(obarberid)}) print 'document=', document updatedAt = MongoResource.getIso8601() if document == None: return None ret = db["barber"].update( {'_id': ObjectId(obarberid)}, {"$set": { "isreview": 1, "updatedAt": updatedAt }}) print 'ret=', ret phonenum = document['phonenum'] oshopid = document['oshopid'] print 'phonenum=', phonenum user = User.objects.filter(username=phonenum).first() if user is not None: print 'user='******'user=none' return updatedAt
def delete(self, todo_id): print 'todo_id',todo_id # abort_if_todo_doesnt_exist(todo_id) client = MongoClient(util.getMydbip()) db = client.test_database ret = db[self.documentname].remove({'_id': ObjectId(todo_id)}) print 'ret=',ret return '', 204
def updateDocument(document,todo_id,json): client = MongoClient(util.getMydbip()) db = client.stylemaster ret = db[document].update({'_id': ObjectId(todo_id)},{"$set":json}) print 'ret=',ret client.close()
def delete(self, todo_id): print 'todo_id', todo_id # abort_if_todo_doesnt_exist(todo_id) client = MongoClient(util.getMydbip()) db = client.test_database ret = db[self.documentname].remove({'_id': ObjectId(todo_id)}) print 'ret=', ret return '', 204
def getNextSequence(documentname): print 'getNextSequence' client = MongoClient(util.getMydbip()) db = client.test_database # ret = db[documentname].find_one_and_update( {'_id': 'userid'}, {'$inc': {'seq': 1}}, projection={'seq': True, '_id': False}, upsert=True, return_document=ReturnDocument.AFTER) ret = db[documentname].find_and_modify( {'_id': 'orderid1'}, {'$inc': {'seq': 1}}, projection={'seq': True, '_id': False}, upsert=True,new=True) print ret return ret['seq'];
def newUpload(documentname): try: client = MongoClient(util.getMydbip()) db = client.test_database ret = db[documentname].insert({}) print str(ret) return str(ret) except Exception,e: print e
def newSmslogpass( phone,smscode): client = MongoClient(util.getMydbip()) db = client.test_database ret = db['smslogpass'].find_one({'phone':phone}) if ret is None: ret = db['smslogpass'].insert({"phone":phone,"smscode":smscode}) print 'ret=',ret else: ret = db['smslogpass'].update ({'phone':phone}, {"$set": { "smscode":smscode }}) print 'ret=',ret
def querySmslog1(smscode): client = MongoClient(util.getMydbip()) db = client.test_database ret = db['smslog'].find_one({'smscode':smscode}) print 'ret=',ret if ret is not None: # client.close() return ret['phone'] else: # client.close() None
def pushEvent(document,objectjson,datajson,action): client = MongoClient(util.getMydbip()) db = client.test_database dict={}; dict['objectname']=document dict['object']= objectjson dict['data']= datajson dict['action']=action dict['createdAt']=getIso8601() ret = db["event"].insert(dict) print 'push event=',ret
def getResouce(database, documentname, request): print 'get1' print 'message where=', request['where'] client = MongoClient(util.getMydbip()) db = client[database] print "list get=", request searchword = request.get('where', '') offset = int(request.get('skip', '0')) limit = int(request.get('limit', '0')) order = request.get('order', '') count = request.get("count", "0") print 'searchword1=', searchword print 'offset=', offset print 'limit=', limit print 'order=', order # ret = db.news.find_one() if searchword == '' or searchword == '{}': print 'searchword=null' #sort({"createdAt":-1}) orderv = order.split(",") print 'orderv=', orderv sortlist = [] if order is not "": print 'order sort' for sortvalue in orderv: if sortvalue.startswith("-"): sortlist.append((sortvalue[1:], -1)) else: sortlist.append((sortvalue, 1)) if count == 1: ret = db[documentname].find(dict).count() retdict = {} retdict['count'] = ret retstr = json.dumps(retdict, default=json_util.default) return retstr try: ret = db[documentname].find({}, skip=offset, limit=limit, sort=sortlist) except Exception, e: print e
def newBucketUpload(documentname,size,bucket,url,name): try: client = MongoClient(util.getMydbip()) db = client.test_database print 'datetime=',datetime.utcnow() print 'datetime=',time.strftime('%Y-%m-%dT%H:%M:%S') datadict = {"size":size,"bucket":bucket,"url":url,"name":name, "createdAt": time.strftime('%Y-%m-%dT%H:%M:%S')} ret = db[documentname].insert(datadict) print str(ret) del datadict["_id"] datadict['objectId']= str(ret) return datadict except Exception,e: print e
def groupDocument(document, key): client = MongoClient(util.getMydbip()) db = client.test_database reducer = Code(""" function(obj, prev){ prev.count++; } """) results = db[document].group(key={"category": 1}, condition={}, initial={"count": 0}, reduce=reducer) print 'results1=', results mydict = reduce(toDict, results, {}) print 'mydict=', mydict return mydict
def newBarber(oshopid, phonenum, barbername): client = MongoClient(util.getMydbip()) db = client.test_database document = db["barber"].find_one({'phonenum': phonenum}) print 'document=', document if document is not None: print 'exist' return False dict = {} dict['oshopid'] = oshopid dict['isreview'] = 0 dict['phonenum'] = phonenum dict['barbername'] = barbername dict['createdAt'] = MongoResource.getIso8601() ret = db["barber"].insert(dict) print 'newBarber=', ret return True
def getDocument(documentname,todo_id): client = MongoClient(util.getMydbip()) db = client.stylemaster document = db[documentname].find_one({'_id': ObjectId(todo_id)}) print 'document=',document if document==None: return"" # return json.dumps(document,default=json_util.default) oid = str(document["_id"]) del document["_id"] del document["password"] document['id']=oid document['objectId']=oid retstr = json.dumps(document,default=json_util.default) print 'retstr=',retstr client.close() return retstr
def deleteResource(documentname, request, todo_id): print "delete=", request print 'todo_id', todo_id try: # print "put request=",request.json # newtodo_id = request.json['id']; # print "newtodo_id=",newtodo_id; client = MongoClient(util.getMydbip()) try: del request["id"] except Exception, e: print e db = client.test_database todov = todo_id.split(",") for oid in todov: ret = db[documentname].remove({'_id': ObjectId(oid)}) print 'ret=', ret return json.dumps({"code": 200}, default=json_util.default)
def get(self, todo_id): print 'MResource get todo_id',todo_id client = MongoClient(util.getMydbip()) db = client.test_database # abort_if_todo_doesnt_exist(todo_id) # return TODOS[todo_id] document = db[self.documentname].find_one({'_id': ObjectId(todo_id)}) print 'document=',document if document==None: abort(404, message="{} doesn't exist".format(todo_id)) # return json.dumps(document,default=json_util.default) oid = str(document["_id"]) del document["_id"] document['id']=oid document['objectId']=oid retstr = json.dumps(document,default=json_util.default) print 'retstr=',retstr newdict = json.loads(retstr) return newdict
def searchDocument(documentname,projectfields,query,offset, limit,order): print 'search' client = MongoClient(util.getMydbip()) db = client.test_database # print 'offset=',offset # print 'limit=',limit # print 'order=',order dict = {'tags':{'$in':query}} # ret = db.news.find_one() # text_results = db.command('text', documentname, search=query, filter={'related':True}, limit=10) ret = db[documentname].find(dict,projection=projectfields,skip=offset,limit=limit) newsv=[] for news in ret: print 'news=',news print 'news get id',news.get("id") if news.get("id")==None: oid = str(news["_id"]) del news["_id"] # news['id']=oid news['objectId']=oid newsv.append(news) print 'newsv=',newsv retdict={} retdict['results']=newsv # return json.dumps(newsv,default=json_util.default) retstr= json.dumps(newsv,default=json_util.default) newdict = json.loads(retstr) return retdict
def get_userbywhere(): try: print 'get_user' searchword = request.args.get('where', '') print 'searchword=', searchword client = MongoClient(util.getMydbip()) db = client.stylemaster if searchword == '': ret = db["user"].find() else: dict = json.loads(searchword) if dict.has_key("objectId"): dict['_id'] = ObjectId(dict['objectId']) del dict['objectId'] print 'dict=', dict ret = db["user"].find(dict) newsv = [] print 'ret=', ret for news in ret: print 'news=', news print 'news get id', news.get("id") if news.get("id") == None: oid = str(news["_id"]) del news["_id"] # news['id']=oid news['objectId'] = oid newsv.append(news) print 'newsv=', newsv retdict = {} retdict['results'] = newsv return jsonify(retdict) # return jsonify({'sessionToken':user.sessionToken,'username': user.username,"createdAt":user.createdAt,"updatedAt":user.updatedAt,"objectId":oid,"mobilePhone":user.MobilePhoneNumber} ) except Exception, e: print e
def get(self): print 'get' # args = parser.parse_args() # print 'args=',args client = MongoClient(util.getMydbip()) db = client.test_database print "list get=", request searchword = request.args.get('where', '') offset = int(request.args.get('offset', '0')) limit = int(request.args.get('limit', '0')) print 'searchword=', searchword print 'offset=', offset print 'limit=', limit # ret = db.news.find_one() if searchword == '': print 'searchword=null' #sort({"createdAt":-1}) try: if limit == 0: if offset == 0: ret = db[self.documentname].find().sort([('_id', -1)]) else: ret = db[self.documentname].find().sort([ ('_id', -1) ]).offset(offset) else: if offset == 0: ret = db[self.documentname].find().sort([ ('_id', -1) ]).limit(limit) else: ret = db[self.documentname].find().sort([ ('_id', -1) ]).skip(offset).limit(limit) except Exception, e: print e
def get(self, todo_id): print 'MResource get todo_id', todo_id client = MongoClient(util.getMydbip()) db = client.test_database # abort_if_todo_doesnt_exist(todo_id) # return TODOS[todo_id] document = db[self.documentname].find_one({'_id': ObjectId(todo_id)}) print 'document=', document if document == None: abort(404, message="{} doesn't exist".format(todo_id)) # return json.dumps(document,default=json_util.default) oid = str(document["_id"]) del document["_id"] document['id'] = oid document['objectId'] = oid retstr = json.dumps(document, default=json_util.default) print 'retstr=', retstr newdict = json.loads(retstr) return newdict
def put(self, todo_id): print "put=",request print 'todo_id',todo_id try: print "put request=",request.json # newtodo_id = request.json['id']; # print "newtodo_id=",newtodo_id; client = MongoClient(util.getMydbip()) try: del request.json["id"]; except Exception,e: print e db = client.test_database opword = request.args.get('op', '') print 'opword=',opword; updatedAt= time.strftime('%Y-%m-%d %H:%M:%S') request.json['updatedAt']=time.strftime('%Y-%m-%d %H:%M:%S') if opword=='': ret = db[self.documentname].update({'_id': ObjectId(todo_id)},{"$set":request.json}) else: ret = db[self.documentname].update({'_id': ObjectId(todo_id)},{opword:request.json}) print 'ret=',ret retdict = {"id":todo_id,"updatedAt":updatedAt} return json.dumps(retdict)
def getResoucegroup(database, documentname, request): print 'get' print 'message where=', request['where'] client = MongoClient(util.getMydbip()) db = client[database] print "list get=", request searchword = request.get('where', '') offset = int(request.get('offset', '0')) limit = int(request.get('limit', '0')) print 'searchword=', searchword print 'offset=', offset print 'limit=', limit # ret = db.news.find_one() if searchword == '' or searchword == '{}': print 'searchword=null' #sort({"createdAt":-1}) try: if limit == 0: if offset == 0: ret = db[documentname].find().sort([('_id', -1)]) else: ret = db[documentname].find().sort([('_id', -1) ]).offset(offset) else: if offset == 0: ret = db[documentname].find().sort([('_id', -1) ]).limit(limit) else: ret = db[documentname].find().sort([ ('_id', -1) ]).skip(offset).limit(limit) except Exception, e: print e
api.add_resource(Store, '/store/<string:story_id>') api.add_resource(GameScoreList, '/1.1/classes/GameScore') api.add_resource(GameScore, '/1.1/classes/GameScore/<string:todo_id>') api.add_resource(feedbackList, '/1.1/classes/feedback') api.add_resource(feedback, '/1.1/classes/feedback/<string:todo_id>') api.add_resource(ObjectDemoTableReadList, '/1.1/classes/ObjectDemoTableRead') api.add_resource(ObjectDemoTableRead, '/1.1/classes/ObjectDemoTableRead/<string:todo_id>') api.add_resource(users, '/1.1/classes/users/<string:todo_id>') if __name__ == '__main__': # connect('stylemaster',host=util.getMydbip()) connect('stylemaster', host=util.getMydbip(), read_preference=read_preferences.ReadPreference.PRIMARY) print 'app.debug', app.debug if len(sys.argv) >= 1: print 'sys', sys.argv[1] localpath = sys.argv[1] else: localpath = '../../../static' port = 5002 if len(sys.argv) >= 3: port = int(sys.argv[2]) if 1: app.wsgi_app = SharedDataMiddleware(app.wsgi_app, {'/static': localpath})
from pymongo import collection from bson import json_util from bson.objectid import ObjectId import util import time from datetime import datetime import MongodbOperation from mongoengine import Document, EmailField, StringField, BooleanField, queryset_manager from passlib.apps import custom_app_context as pwd_context #from passlib.hash import pbkdf2_sha256 #from passlib.utils import consteq from pymongo import read_preferences import restobject client1 = MongoClient(util.getMydbip()) def getMclient(): return client1 def getIso8601(): return datetime.utcnow().strftime('%Y-%m-%dT%H:%M:%S.%f')[:-3]+"Z" def pushEvent(document,objectjson,datajson,action): client = MongoClient(util.getMydbip()) db = client.test_database dict={}; dict['objectname']=document dict['object']= objectjson
del user_dict["_id"] print 'test2' return (jsonify(user_dict),200) else: user = User(username=username) # user.hash_password(password) user.createdAt=MongoResource.getIso8601() user.updatedAt=MongoResource.getIso8601() user.mobilePhoneVerified=True user.save() print 'user.id=',user.id user.generate_auth_token(app.config['SECRET_KEY']) print 'sessionToken',user.sessionToken user.save() oid = str(user.id) return jsonify({ "objectId":oid,'sessionToken':user.sessionToken,"createdAt":user.createdAt,"updatedAt":user.updatedAt}) else: return (jsonify({'status': "fail"}), 400) except Exception,e: print e if __name__ == '__main__': connect('stylemaster',host=util.getMydbip(),read_preference=read_preferences.ReadPreference.PRIMARY) capp.send_task('smscloud.smstasks.sendsms', args=["13906917736", "456789"], kwargs={}) app.run(host="0.0.0.0",debug=True)