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 existscluster(_c):
logger.debug("in get_clustername")
sql="select cluster_name_qq from master_relation where cluster_name_qq='%s' limit 1" %(_c)
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 cluster.")
return 0
else:
return 1
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_tabletinfo(_c):
logger.debug("in get_tabletinfo")
tablet=[]
sql = "select cluster_name_qq,tablet_name_qq,master_ip_qq,master_port_qq,cluster_name_gz,tablet_name_gz,master_ip_gz,master_port_gz from master_relation where cluster_name_qq='%s'" %_c
rowset = dbtools.fetchall(sql,"dbproxy")
if dbtools.isfull(rowset) :
logger.debug("in get_tabletinfo if")
for cluster_name_qq,tablet_name_qq,master_ip_qq,master_port_qq,cluster_name_gz,tablet_name_gz,master_ip_gz,master_port_gz in rowset :
tabletdto = (cluster_name_qq,tablet_name_qq,master_ip_qq,master_port_qq,cluster_name_gz,tablet_name_gz,master_ip_gz,master_port_gz)
tablet.append(tabletdto)
logger.debug("in get_tabletinfo for")
else :
logger.error('This cluster named "%s" has no tablet.' %(_c))
exit()
return tablet
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
