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
