def index(request,route): close_old_connections() if route == 'wxGetJoinTask': callBackDict = TaskInfo.wxGetJoinTask(request) elif route == 'wxGetALLTask': callBackDict = TaskInfo.wxGetALLTask(request) elif route == 'wxReceiveTask': callBackDict = TaskInfo.wxReceiveTask(request) elif route == 'wxdoTask': callBackDict = DoTask.wxdoTask(request) elif route == 'adminGetALLTask': callBackDict = TaskInfo.adminGetALLTask(request) elif route == 'adminCreateTask': callBackDict = TaskInfo.adminCreateTask(request) elif route == 'adminDelTask': callBackDict = TaskInfo.adminDelTask(request) elif route == 'getUserAllDoTaskList': callBackDict = TaskInfo.getUserAllDoTaskList(request) elif route == 'wxGetTaskInfo': callBackDict = TaskInfo.wxGetTaskInfo(request) else: return HttpResponse("no found !!!") if callBackDict == None : callBackDict = {"code":-1,'msg':'系统异常'} return HttpResponse(json.dumps(callBackDict))
def initializeDB(self, metadata, engine): taskInfos = TaskInfo.dbDesign(metadata) inputFiles = InputFile.dbDesign(metadata) outputFiles = OutputFile.dbDesign(metadata) arguments = Argument.dbDesign(metadata) gridTasks = GridTask.dbDesign(metadata) hosts = Host.dbDesign(metadata) taskGroups = TaskGroup.dbDesign(metadata) metadata.create_all(engine)
engine = create_engine('mysql://'+base.dbUser+':'+base.dbPassword+'@localhost', echo=False) try: engine.execute("CREATE DATABASE DistributedController") #create db except: print ("database already exists") engine.execute("USE DistributedController") # select new db mySessionClass = sessionmaker(bind=engine) mySession = mySessionClass() metadata = MetaData() taskInfos = TaskInfo.dbDesign(metadata) inputFiles = InputFile.dbDesign(metadata) outputFiles = OutputFile.dbDesign(metadata) arguments = Argument.dbDesign(metadata) gridTasks = GridTask.dbDesign(metadata) taskGroups = TaskGroup.dbDesign(metadata) metadata.create_all(engine) #create task group
def wxdoTask(request): callBackDict = {} # 验证用户的openID userObj = Jurisdiction.jurisdictGETOpenId(request, callBackDict) if userObj == None: return callBackDict getgetTaskId = Comm.tryTranslate(request, "getTaskId") getadImgs = Comm.tryTranslate(request, "adImgs") getlatitude = Comm.tryTranslate(request, "latitude") getlongitude = Comm.tryTranslate(request, "longitude") if Comm.tryTranslateNull("getTaskId", getgetTaskId, callBackDict) == False: return callBackDict if Comm.tryTranslateNull("adImgs", getadImgs, callBackDict) == False: return callBackDict try: try: getTaskObj = getTask.objects.get(id=getgetTaskId) # 判断车辆和任务的审核状态 taskMsg = TaskInfo.judgeAuditStatusTaskId(getTaskObj.taskId) if taskMsg != None: return Comm.callBackFail(callBackDict, -1, taskMsg) catMsg = TaskInfo.judgeAuditStatusCarId(getTaskObj.carId) if catMsg != None: return Comm.callBackFail(callBackDict, -1, catMsg) getgetTaskMsg = TaskInfo.judgeAuditStatusgetTaskObj(getgetTaskId) if getgetTaskMsg != None: return Comm.callBackFail(callBackDict, -1, getgetTaskMsg) except BaseException as e: return Comm.callBackFail(callBackDict, -1, "领取任务的ID不存在") getcreateTime = int(time.time() * 1000) doTaskObj = doTask.objects.create(userId=userObj.id, openId=userObj.openId, getTaskId=getgetTaskId, adImgs=getadImgs, createTime=getcreateTime) if getlatitude and getlongitude: doTaskObj.latitude = getlatitude doTaskObj.longitude = getlongitude # 同时添加为经常活动的范围 try: activityRangeObj = activityRange.objects.create( latitude=getlatitude, longitude=getlongitude, userId=userObj.id, openId=userObj.openId, carInfoId=getTaskObj.carId, createTime=getcreateTime) activityRangeObj.save() except BaseException as e: return Comm.callBackFail(callBackDict, -1, "添加为经常活动的范围异常") # 保存领取的任务 doTaskObj.save() # 创建一条审核的任务 logger = logging.getLogger("django") logger.info("创建一条审核的记录:" + str(doTaskObj.id)) CheckInfo.createCheck(doTaskObj.id, 3, userObj.id) Comm.callBackSuccess(callBackDict, 1, doTaskObj.id) except BaseException as e: Comm.callBackFail(callBackDict, -1, "系统异常") logger = logging.getLogger("django") logger.info(str(e)) return callBackDict