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 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 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)
