def status(self, bugId, status, currentUser): """ 查询调试记录列表 """ try: bugSQL = """ UPDATE man_pro_bug SET BUG_STATUS='{status}', HANDLE_BY='{handleBy}', HANDLE_TIME='{handleTime}' WHERE BUG_ID='{bugId}'; """.format(status='created' if status == 'reset' else status, handleBy=currentUser, handleTime=Utils.getLocalTime(), bugId=bugId) recordSQL = """ INSERT INTO man_bug_record( ID, BUG_ID, BUG_STATUS, HANDLE_BY, HANDLE_TIME )VALUES( '{}','{}','{}','{}','{}' ); """.format(Utils.makeId(), bugId, status, currentUser, Utils.getLocalTime()) Utils.log('更新问题状态SQL', bugSQL) Utils.log('插入调试记录SQL', recordSQL) return PySQL.execute(bugSQL) > 0 and PySQL.execute(recordSQL) > 0 except Exception as e: print('ERROR {}'.format(e)) Utils.log('ERROR {}'.format(e)) return False
def insert(self, proId, proName, modId, modName, bugTitle, bugLevel, bugDes, userId, currentUser): """ 添加新建问题记录 """ count = 0 try: bugId = Utils.makeId() sql = """ INSERT INTO man_pro_bug( BUG_ID, PRO_ID, PRO_NAME, MODULE_ID, MODULE_NAME, BUG_TITLE, BUG_LEVEL, BUG_DES, CREATE_BY, CREATE_TIME, HANDLE_BY, HANDLE_TIME )VALUES( '{}','{}','{}','{}','{}','{}','{}','{}','{}','{}','{}','{}' ); """.format(bugId, proId, proName, modId, modName, bugTitle, bugLevel, bugDes, currentUser, Utils.getLocalTime(), userId if userId else currentUser, Utils.getLocalTime()) recordSQL = """ INSERT INTO man_bug_record( ID, BUG_ID, BUG_STATUS, HANDLE_BY, HANDLE_TIME )VALUES( '{}','{}','{}','{}','{}' ); """.format(Utils.makeId(), bugId, 'created', currentUser, Utils.getLocalTime()) Utils.log('打印新建问题SQL', sql) # print log count = PySQL.execute(sql) PySQL.execute(recordSQL) except Exception as e: print('ERROR {}'.format(e)) Utils.log('ERROR {}'.format(e)) return count > 0
def inset(self, fileName, projectId, projectName, uploadBy): """ 上传文件信息入库 """ count = 0 try: sql = """ INSERT INTO man_pro_file( ID, FILE_NAME, PRO_ID, PRO_NAME, UPLOAD_BY, UPLOAD_TIME )VALUES( '{}','{}','{}','{}','{}','{}' ); """.format(Utils.makeId(), fileName, projectId, projectName, uploadBy, Utils.getLocalTime()) Utils.log('打印上传文件信息入库SQL', sql) count = PySQL.execute(sql) except Exception as e: print('ERROR {}'.format(e)) Utils.log('ERROR {}'.format(e)) return count > 0
def insert(self, proName, proType, proUse, proDes, userCreator): """ 添加 project 记录 """ count = 0 try: sql = """ INSERT INTO man_pro_info( PRO_ID, PRO_NAME, PRO_TYPE, PRO_LEADER, PRO_USE, PRO_CRE_TIME, PRO_DES )VALUES( '{}','{}','{}','{}','{}','{}','{}' ); """.format(self.makeProId(), proName, proType, userCreator, proUse, Utils.getLocalTime(), proDes) Utils.log('打印创建项目SQL', sql) # print log count = PySQL.execute(sql) except Exception as e: print('ERROR {}'.format(e)) Utils.log('ERROR {}'.format(e)) return count > 0
def insert(self, userId, userName, userAuth, userLogin, userCreator): """ 添加用户记录 """ count = 0 try: sql = """ INSERT INTO man_auth_user( USER_ID, USER_NAME, USER_AUTH, USER_LOGIN, USER_CREATOR, USER_CRE_TIME )VALUES( '{}','{}','{}','{}','{}','{}' ); """.format(userId, userName, userAuth, userLogin, userCreator, Utils.getLocalTime()) Utils.log('添加用户记录SQL', sql) count = PySQL.execute(sql) except Exception as e: print('ERROR {}'.format(e)) Utils.log('ERROR {}'.format(e)) return count > 0
def insert(self, proId, userId, modId, modName, modDes, modStart, modEnd): """ 添加分配任务记录 """ count = 0 try: sql = """ INSERT INTO man_pro_task( PRO_ID, USER_ID, MODULE_ID, MODULE_NAME, MODULE_DES, MODULE_START, MODULE_END, CREATE_TIME )VALUES( '{}','{}','{}','{}','{}','{}','{}','{}' ); """.format(proId, userId, modId, modName, modDes, modStart, modEnd, Utils.getLocalTime()) Utils.log('打印创建项目SQL', sql) count = PySQL.execute(sql) except Exception as e: print('ERROR {}'.format(e)) Utils.log('ERROR {}'.format(e)) return count > 0
def update(self, data, currentUser): """ 更新任务进度 """ count = 0 try: sql = """ UPDATE man_pro_rate SET TASK_RATE={}, UPDATE_BY='{}', UPDATE_TIME='{}' WHERE TASK_RATE != {} AND USER_ID='{}' AND MODULE_ID='{}'; """.format(data['TASK_RATE'], currentUser, Utils.getLocalTime(), data['TASK_RATE'], data['USER_ID'], data['MODULE_ID']) Utils.log('打印更新任务进度SQL', sql) count = PySQL.execute(sql) except Exception as e: print('ERROR {}'.format(e)) Utils.log('ERROR {}'.format(e)) return count > 0
def insert(self, userId, modId, currentUser): """ 初始化任务进度 """ count = 0 try: sql = """ INSERT INTO man_pro_rate( USER_ID, MODULE_ID, TASK_RATE, UPDATE_BY, UPDATE_TIME )VALUES( '{}','{}','{}','{}','{}' ); """.format(userId, modId, 0, currentUser, Utils.getLocalTime()) Utils.log('打印任务进度SQL', sql) count = PySQL.execute(sql) except Exception as e: print('ERROR {}'.format(e)) Utils.log('ERROR {}'.format(e)) return count > 0