def can_reverse(_c):
logger.debug("in can_reverse")
sql="select canreverse from master_relation where cluster_name_qq='%s' limit 1" %(_c)
logger.debug(sql)
rowset = dbtools.fetchall(sql,"dbproxy")
canreverse = dbtools.fetchone(sql,"dbproxy").canreverse
return canreverse
def get_current_master(_c):
logger.debug("in get_current_master")
sql="select ip from db_account where tablet='%s_1' and is_master=1 and is_online=1" %(_c)
logger.debug(sql)
rowset = dbtools.fetchall(sql,"dbproxy")
masterip= dbtools.fetchone(sql,"dbproxy").ip
if re.match( r'100.',masterip, re.M|re.I):
return "hna"
else:
return "hnq"
def get_clustername(_dbuser):
logger.debug("in get_clustername")
sql="select cluster_name_qq from master_relation where dbuser='******' limit 1" %(_dbuser)
logger.debug(sql)
rowset = dbtools.fetchall(sql,"dbproxy")
#if dbuser is correct , rowset's type should be instance.
if type(rowset) is list:
logger.error("there is no this dbuser.")
exit()
if rowset:
clustername = dbtools.fetchone(sql,"dbproxy").cluster_name_qq
return clustername
else:
exit()
def get_proxyname(_c):
sql="select proxy from cluster where name='%s' limit 1" %(_c)
rowset = dbtools.fetchall(sql,"dbproxy")
proxy = dbtools.fetchone(sql,"dbproxy").proxy
return proxy
