def do_use(self, args):
''''''
if args == "":
self.help_use()
return
items = args.split()
cluster_name = items[0]
if cluster_name not in clusters:
print "Cluster name {0} is not in this cluster list, please run 'list' for details.".format(cluster_name)
return
self.current_instance = clusters[cluster_name].slave
if len(items) == 2 and items[1].lower() == "master":
self.current_instance = clusters[cluster_name].master
if self.current_connection is not None:
conn.close_conn(self.current_connection)
self.prompt = "{0}> ".format(self.current_instance.get_summary())
self.current_connection = conn.get_conn(self.current_instance, self.user, self.pwd)
self.cursor = self.current_connection.cursor()
def run_on_instance(self, instance, sql, autocommit=False):
''' '''
cnx = conn.get_conn(instance, self.user, self.pwd)
cursor = cnx.cursor()
if autocommit:
cursor.execute("set autocommit=1")
cursor.execute(sql)
rows = cursor.fetchall()
columns = cursor.column_names
cnx.close()
return rows, columns
