def update_user(user_info): s = app.helpers.session.get_session() if 'is_active' in user_info: user_info.is_active = '1' else: user_info.is_active = '0' #FIXME: mudar para não precisar de updates separados if user_info.password: result = db.update('users', where='id = $id', vars={'id': user_info.id}, name=user_info.name, is_active=user_info.is_active, comments=user_info.comments, password=create_password(user_info.password), email=user_info.email, lastupdated=int(time.time()), lastupdatedby=s.userid) else: result = db.update('users', where='id = $id', vars={'id': user_info.id}, name=user_info.name, is_active=user_info.is_active, comments=user_info.comments, email=user_info.email, lastupdated=int(time.time()), lastupdatedby=s.userid) logger.info(result) # initiate dictionary records = {} # se result == True, assume que usuario foi atualizado com sucesso if result == 1: # set response message to OK records['Result'] = 'OK' else: records['Result'] = 'ERROR' records['Message'] = 'Nenhuma informação alterada' return json.dumps(records)
def moveImgLine(self, headId, lineIds): if lineIds is None or len(lineIds) == 0: return retHeadId = None imgQty = 0 imgOrd = self.getMaxOrd(headId) imgNameList = [] ids = "" for lineId in lineIds: ids += "," + lineId ids = ids[1:] for line in db.select("imgLine", where="lineId in (" + ids + ")").list(): if retHeadId is None: retHeadId = line["headId"] imgQty += 1 imgOrd += 1 line["headId"] = headId line["imgOrd"] = imgOrd db.update('imgLine', where="lineId=$lineId", vars={'lineId':line["lineId"]}, **line) imgNameList.append(line.get("imgNameP")) imgHeaderDest = self.updateHeadSizeAndQty(headId) imgHeaderSrc = self.updateHeadSizeAndQty(retHeadId) imgPathList = [] for imgName in imgNameList: imgPathList.append(pathJoin(imgHeaderSrc.get("headNum"), imgName)) imgPathList.append(pathJoin(imgHeaderSrc.get("headNum"), "s_" + imgName)) return retHeadId, imgPathList, imgHeaderDest.get("headNum")
def saveImgHead(self, imgHead): headNum = imgHead.get("headNum") if headNum: imgHeadDb = self.getByHeadNum(headNum) if imgHeadDb: headId = imgHeadDb.get("headId") db.update("imgHead", where="headId=$headId", vars={'headId':headId}, **imgHead) else: db.insert("imgHead", **imgHead)
def saveOrUpdate(self, uploadTask): uploadTaskDb = None if uploadTask and uploadTask.headId: uploadTaskDb = self.getByHeadId(uploadTask.headId) if uploadTaskDb: uploadTask['uploadTaskId'] = uploadTaskDb.uploadTaskId db.update("uploadTask", where="uploadTaskId=$uploadTaskId", vars={'uploadTaskId':uploadTaskDb.uploadTaskId}, **uploadTask) else: return self.getById(db.insert("uploadTask", **uploadTask))
def editImgLine(self, lineId, imgOrd, imgNameS): dbImgLine = db.select("imgLine", where="lineId=$lineId", vars={"lineId":lineId}).list()[0] if imgOrd is not None and imgOrd != "": imgOrd = int(imgOrd) dbImgOrd = dbImgLine["imgOrd"] headId = dbImgLine.get("headId") if dbImgOrd > imgOrd: db.query("update imgLine set imgOrd = imgOrd + 1 where headId = " + str(headId) + " and imgOrd >= " + str(imgOrd) + " and imgOrd <" + str(dbImgOrd)) elif dbImgOrd < imgOrd: db.query("update imgLine set imgOrd = imgOrd - 1 where headId = " + str(headId) + " and imgOrd > " + str(dbImgOrd) + " and imgOrd <=" + str(imgOrd)) dbImgLine["imgOrd"] = imgOrd if imgNameS is not None and imgNameS != "": dbImgLine["imgNameS"] = imgNameS db.update("imgLine", where="lineId=$lineId", vars={"lineId":dbImgLine.lineId}, **dbImgLine) return dbImgLine["headId"]
def saveAll(self, headId, imgLines): lineIds = [] dbImgLines = db.select('imgLine', where="headId=$headId", vars={"headId":headId}) for imgLine in dbImgLines: lineIds.append(imgLine.get("lineId")) imgOrd = self.getMaxOrd(headId) ret = [] for imgLine in imgLines: if imgLine.get("lineId") in lineIds: db.update('imgLine', where="lineId=$lineId", vars={'lineId':imgLine.get("lineId")}, **imgLine) ret.append(self.getByLineId(imgLine.get("lineId"))) else: imgOrd += 1 imgLine['imgOrd'] = imgOrd imgLine["headId"] = headId lineId = db.insert('imgLine', **imgLine) ret.append(self.getByLineId(lineId)) return ret
def saveHeadAndLine(self, imgHead): from imgLineDao import ImgLineDao imgLineDao = ImgLineDao() allLines = [] imgLines = imgHead.get("imgLines") # 头表 if imgLines or imgLines is not None and len(imgLines) == 0: del imgHead["imgLines"] headId = imgHead.get('headId') if headId: db.update('imgHead', where="headId=$headId", vars={'headId':headId}, **imgHead) else: headId = db.insert('imgHead', **imgHead) # 行表 if imgLines is None or len(imgLines) == 0: return None dbLines = imgLineDao.saveAll(headId, imgLines) allLines.extend(dbLines) self.updateHeadSizeAndQty(headId) return allLines
def updateImgHeadNum(self, headId, headNum): dbHead = self.getById(headId) userForm = json.loads(dbHead.userForm) for f in userForm: if str(f.get("groupBy"))=="1": f["value"] = headNum break; if userForm: db.update("imgHead", where="headId=$headId", vars={"headId":headId}, **{"headNum":headNum,"userForm":json.dumps(userForm)}) else: db.update("imgHead", where="headId=$headId", vars={"headId":headId}, **{"headNum":headNum}) db.update("imgLine", where="headId=$headId", vars={"headId":headId}, **{"headNum":headNum})
def updateStatusByHeadId(self, headId, status): if headId: db.update("uploadTask", where="headId=$headId", vars={'headId':headId}, status=status)
def updateImgHeadNum(self, headId, headNum): db.update("imgLine", where="headId=$headId", vars={"headId":headId}, **{"headNum":headNum})
def initImgOrd(self, headId): imgOrd = 0 for line in db.select("imgLine", where="headId = $headId" , vars={"headId":headId}).list(): imgOrd += 1 db.update("imgLine", where="lineId=$lineId", vars={"lineId":line.lineId}, **{"imgOrd":imgOrd})
def update_last_login(id): db.update('users', where='id = $id', vars={'id': id}, lastlogin=int(time.time()))
def update(self, imgHead): if imgHead and imgHead.get("headId"): db.update("imgHead", where="headId=$headId", vars={'headId':imgHead.get("headId")}, **imgHead)
def updateStatusByheadId(self, headId, status): if headId: db.update("imgHead", where="headId=$headId", vars={'headId':headId}, status=status)
def updateHeadSizeAndQty(self, headId): from imgLineDao import ImgLineDao imgLineDao = ImgLineDao() headSize = imgLineDao.getHeadSize(headId) imgQty = imgLineDao.getImgQty(headId) db.update('imgHead', where="headId=$headId", vars={'headId':headId}, **{"headSize":headSize, "imgQty":imgQty})
def updateHeadSizeAndQty(self, headId): headSize = self.getHeadSize(headId) imgQty = self.getImgQty(headId) db.update('imgHead', where="headId=$headId", vars={'headId':headId}, **{"headSize":headSize, "imgQty":imgQty}) for head in db.select('imgHead', where="headId=$headId", vars={'headId':headId}).list(): return head
def updateImgLine(self, imgLine): lineId = imgLine.get("lineId") if lineId: db.update("imgLine", where="lineId=$lineId", vars={'lineId':lineId}, **imgLine)
def update(self, ocrResult): resultId = ocrResult.get("resultId") if resultId: db.update("ocrResult", where="resultId=$resultId", vars={'resultId':resultId}, **ocrResult)