python&DBA遍历文件夹下ip名称SQL 执行该IP下SQL
前两天有个需求 500多台数据库要执行不一样的SQL
其实也就是不同IP执行不同SQL
想了想可以实现
思路如下:
遍历文件夹 取到IP
打开指定的文件
链接MySQL
#!/usr/bin/env Python
#coding:utf-8
import os
import MySQLdb
#import * from process
ls = os.listdir('/export/sql/')
for file_name in ls:
ip = os.path.splitext(file_name)[0]
sql_filename = os.path.join('/export/sql/',file_name)
sql = open(sql_filename,'r')
#exec_sql = unicode(sql.read())
exec_sql = sql.read()
#exec_sql = sql.read().encode("utf-8")
db = MySQLdb.connect(ip,"tangnanbing","1qaz@WSX","report",port=3358, charset="utf8")
cursor = db.cursor()
cursor.execute(exec_sql)
data = cursor.fetchone()
cursor.close()
db.close()
posted on 2016-11-23 10:50 Sunnynanbing 阅读(100) 评论(0) 编辑 收藏 举报