Esempio n. 1
0
 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
Esempio n. 2
0
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
Esempio n. 3
0
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