def _parseDS(node):
s = {'CONFIG_DB': None,
'DB_DRIVER' : None}
for elem in node:
for e in elem:
if e.tag != 'DS_Driver' : continue
u = None; p = None; dsn = None; t = None
if e.get('status') =='1':
t = e.get('type')
if t is None or len (ST.strip(t)) < 1: continue
mg.logger.info("Status is one for DS_DRIVER type = %s" % t)
for x in e:
if x.tag == 'uname' : u = ST.strip(x.text)
if x.tag == 'pwd' : p = ST.strip(x.text)
if ST.upper(x.tag) == 'DS_STR' : dsn = ST.strip(x.text)
# get Connect String
if dsn is None or len (dsn) < 1:
mg.logger.error (" %s DSN is null or blank" % e.get('name'))
continue
mg.logger.debug("Invoking getDSConnStr t = %s ,u = %s ,p = %s ,dsn = %s " % (t,u,p,dsn))
return {'CONFIG_DB': ds.getDSConnStr(t, u, p, dsn),
'DB_DRIVER' : t
}
return s
def _connToDB(self, dbEng):
cs = getDSConnStr(dbEng, self.ib.user, self.ib.pwd, self.ib.dbserver, self.ib.db)
self.dbh = NZODBC(cs, self.log)
rc = self.dbh.connToDB ()
if rc != 0 :
self.log.error('Could not connect to the DB rc = %s ' % rc)
return 1
return rc
def _getNZDS(sql, ib, log):
r = []
print('qry = %s' % sql)
cs = getDSConnStr('NZODBC', ib.user, ib.pwd, ib.dbserver, ib.db)
dbh = NZODBC(cs, log)
if dbh.connToDB() != 0: return r
r = dbh.runQry(sql)
dbh.closeDBConn()
return r
def _getDB2CliDS(self, sql,bv=[], po='SEL'):
self.log.debug('qry = %s' % sql)
cs = getDSConnStr('DB2CLI', self.ib.user, self.ib.pwd, self.ib.dsn, self.ib.db)
dbh = DBOracle(cs, self.log)
rc = dbh.connToDB ()
if rc != 0 :
self.log.error('Could not connect to the DB rc = %s ' % rc)
return None
if po == 'SEL': r = dbh.runQry(sql)
else : r = dbh.exeQry(sql,bv)
dbh.closeDBConn()
return r
def connToDB(self):
r = 1
sql = 'SELECT GETDATE() AS [CurrentDate]'
self.logger.debug('qry = %s' % sql)
cs = getDSConnStr('MSSQLNAT',self.ib.db_user,self.ib.db_pwd,self.ib.db_server,self.ib.db_name)
self.logger.debug('ConnStr %s' % cs)
dbh = MSSQLNat(cs,self.logger)
if dbh.connToDB() != 0 : return r
rs = dbh.runQry(sql)
if rs is not None and len(rs) > 0 :
r = 0
self.logger.debug("rs = %s" % rs[0][0])
dbh.closeDBConn()
return r
def connToDB(self):
r = 1
sql = 'select SYSDATE from dual'
cs = getDSConnStr('ORADB',self.ib.db_user,self.ib.db_pwd,self.ib.db_name)
self.logger.debug('qry = %s\nCS =%s ' % (sql,cs))
dbh = DBOracle(cs,self.logger)
if dbh.connToDB() != 0 : return r
rs = dbh.runQry(sql)
if rs is not None and type(rs) == list :
r = 0
self.logger.debug("rs = %s" % rs[0][0])
dbh.closeDBConn()
return r
def connToDB(self):
r = 1
sql = 'select current_timestamp'
self.logger.debug('qry = %s' % sql)
cs = getDSConnStr('NZODBC',self.ib.db_user,self.ib.db_pwd,self.ib.db_server,self.ib.db_name)
self.logger.debug('ConnStr %s' % cs)
dbh = NZODBC(cs,self.logger)
if dbh.connToDB() != 0 : return r
rs = dbh.runQry(sql)
if rs is not None and len(rs) > 0 :
r = 0
self.logger.debug("rs = %s" % rs[0][0])
dbh.closeDBConn()
return r
def test_sel_qry(qry, dsn):
print "QUERY IS %s " % qry
#log = Logger('C:\ptest\all\env\logs','C:\ptest')
log = logging.getLogger(__name__)
#cfg = DBOracle('infadev/infadev@infadev',log)
cs = getDSConnStr('SQLLITE', 'ib.user', 'ib.pwd', dsn)
cfg = DBSQLLite(cs, log)
ret = cfg.connToDB()
print "Connecting to DB : ret = %s " % ret
rs = cfg.runQry(qry)
for r in rs:
print "r = ", r
# D = {}
#print "rs = ", rs
# for (v,k) in rs: D[string.capitalize(k)]=v
# print D
# id = list(x[0] for x in rs)
# print "id = ", id
# sn = list(x[1] for x in rs)
# print "sn = ", sn
cfg.closeDBConn()