repWflow = getFldWklInfaRepo(connRep,log) for b in repWflow: rw.append(b.wkfl) nonReg = Set(rw) - Set(nw) lst = list(nonReg) lst.sort() r = _getSubj(lst,repWflow) return sorted(r) if __name__ == '__main__': #log = getLogger(lvl = 'DEBUG') log = getLogger() # MS SQLn PROD connNot = 'DRIVER={SQL Server};SERVER=MAINTSERVER3;DATABASE=RepairHistory;UID=edwuser;PWD=WiWLiC' # r = getTblTaskXRef(connNot,'') # print "getTblTaskXRef(connNot,'') " , r # ORACLE PROD connRep = '%s/%s@%s' % ('infa','Infa4prod' ,'infapd') # r = getFldWklInfaRepo(connStr,'') # print "getFldWklInfaRepo(connStr,'') ", r nr=getNotifInfo(connNot,connRep,log) print "Len = %d" % len(nr) print "NR = ", nr