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