def getAuthFtp(shenqingh, documentType): authSql = ''' select saomiaojid,wenjianxclb from gg_wj_sqwjgdbb where shendingwjlx = '130001' and wenjianxclb in ('design publish', 'gzgg publish') and youxiaobz = '0' and shenqingh=:shenqingh ''' conn = pool1521.acquire() cursor = conn.cursor() cursor.execute(authSql, shenqingh=str(shenqingh)) #gzgg_publish对应的fid优先级最高 authFidTuples = cursor.fetchall() cursor.close() pool1521.release(conn) if len(authFidTuples) == 0: return None elif len(authFidTuples) == 1: authResult = authFidTuples[0] else: for fidTuple in authFidTuples: if fidTuple[1] == 'gzgg publish': authResult = fidTuple break fid = authResult[0] ftp = getFTP(fid, version) if ftp is not None: submitDate = getTime() case = {} case['shenqingh'] = shenqingh case['wenjianlx'] = documentType case['fid'] = fid case['submitDate'] = submitDate case['url'] = ftp return case return None
def getFid(sql, shenqingh): conn = pool1521.acquire() cursor = conn.cursor() cursor.execute(sql, shenqingh=str(shenqingh)) result = cursor.fetchall() cursor.close() pool1521.release(conn) return result
def getDate(sql, shenqingh, originFid): conn = pool1521.acquire() cursor = conn.cursor() cursor.execute(sql, shenqingh=str(shenqingh), fid=str(originFid)) result = cursor.fetchone() cursor.close() pool1521.release(conn) if result is not None: return result[0] return None
def getShenqingH(startNum, endNum): logger.info("oracle start: " + str(startNum) + ", end: " + str(endNum)) shenqinghSql = ''' select shenqingh from (select rownum num, shenqingh from gg_zlx_zhu where zhuanlilx='3' and youxiaobj='0' and shenqingr>='20090101' and rownum<:endNum ) where num>=:startNum ''' conn = pool1521.acquire() cursor = conn.cursor() cursor.execute(shenqinghSql, endNum=endNum, startNum=startNum) result = cursor.fetchall() cursor.close() pool1521.release(conn) return result
def insertExceptionTable(shenqingh, fid, filingno, originfid, statuscode): logger.info('exception, shenqingh: ' + str(shenqingh) + ',fid: ' + str(fid) + ',statuscode: ' + str(statuscode)) conn = pool1521.acquire() cursor = conn.cursor() insertSql = "insert into migrate_failure(shenqingh, fid, filingno, originfid,statuscode) values(:shenqingh,:fid,:filingno,:originfid,:statuscode)" try: cursor.execute(insertSql, shenqingh=str(shenqingh), fid=str(fid), filingno=str(filingno), originfid=str(originfid), statuscode=statuscode) conn.commit() cursor.close() pool1521.release(conn) except Exception as e: logger.info("插入表异常:" + traceback.format_exc()) if conn is not None: pool1521.release(conn)
def getAuthDate(shenqingh): ''' 授权入库图片日期:获取申请号的所有图片名称、日期 :param logicName: :return:map<name:date> ''' context = {} conn = pool1521.acquire() cur = conn.cursor() sql = "select currentpicname,submitdate from wg_qtxxb where filingno =:shenqingh and passflag = '1'" cur.execute(sql, shenqingh=str(shenqingh)) tups = cur.fetchall() if not tups: return context for tup in tups: if len(tup) == 2: key = tup[0] context[key] = tup[1] cur.close() pool1521.release(conn) return context