def hgSqlConnect(db, config=None, **kwargs):
" connect using information parsed from ~/.hg.conf "
if config==None:
config = maxCommon.parseConfig("~/.hg.conf")
conn = MySQLdb.connect(host=config["db.host"], user=config["db.user"], \
passwd=config["db.password"], db=db, **kwargs)
return conn
def hgSqlConnect(db, config=None, **kwargs):
" connect using information parsed from ~/.hg.conf "
if config == None:
config = maxCommon.parseConfig("~/.hg.conf")
conn = MySQLdb.connect(host=config["db.host"], user=config["db.user"], \
passwd=config["db.password"], db=db, **kwargs)
return conn
def _getBlatServersFromHgCentral(self):
config = maxCommon.parseConfig("~/.hg.conf")
hgCentralDb = config["central.db"]
conn = maxTables.hgSqlConnect(hgCentralDb, config=config)
# | db | host | port | isTrans | canPcr |
# +---------+--------+-------+---------+--------+
# | petMar2 | blat4b | 17839 | 0 | 1 |
dbList = ["'%s'" % db for db in self.dbList]
dbStr = ",".join(dbList)
sql = "SELECT db, host, port FROM blatServers WHERE db IN (%s) AND canPcr=1" % dbStr
rows = maxTables.sqlGetRows(conn, sql)
self.blatServers = {}
for row in rows:
host = row["host"]+".cse.ucsc.edu"
self.blatServers[row["db"]] = (host, row["port"])
logging.debug("Using blat servers: %s " % self.blatServers)