def selectAllCred(self):
cred = None
qryStr = eval("DBMain.sel%sQry" % (self.qry))
rs = self.dbHandler.runQry(qryStr)
self.logger.debug("table = %s rs len = %d \nQry=%s " % (self.qry,len(rs),qryStr))
if (rs is not None and len(rs) > 0 ):
cred = []
for r in rs:
o = CredIDBean()
o.setCredIDBean(r,getIDX(DBMain.selCredIDIdx))
cred.append(o)
return cred
def getFldWklInfaRepo(connStr,log):
rs = None
db = DBOracle(connStr,'')
re = db.connToDB()
if (re != 0 ) : return rs
tr = []
rs = db.runQry(dbi.DBInfaRepo.selRepWflQry)
for r in rs:
b = ib.InfaWFBean()
b.setInfaWFBean(r,getIDX(dbi.DBInfaRepo.selRepWflIdx))
log.debug("r = %s lb = %s" % (r,b))
tr.append(b)
db.closeDBConn()
return tr
def getTblTaskXRef(connStr,log):
rs = None
db = DBPYODBC(connStr,'')
re = db.connToDB()
if (re != 0 ) : return rs
tr = []
rs = db.runQry(dbn.Notif.selTaskRefQry)
for r in rs:
b = nb.TaskRefBean()
b.setTaskRefBean(r,getIDX(dbn.Notif.selTaskRefIdx))
log.debug("task = %s tskBean = %s" % (r,b))
tr.append(b)
db.closeDBConn()
return tr
