def arrange(dbconfig): db = MySQL(dbconfig) sql = "select * from cinema_movie_info_tab" db.query(sql) list = [] results = db.fetchAllRows() for row in results: print row list.append(row) return list
import re import glob import copy logDir = "./log/" dataDir = "./data/" sqlDir = "../binlog/" dbconfig = {'host':dbconf.g_resultDBHost, 'port':dbconf.g_resultDBPort, 'user':dbconf.g_resultDBUser, 'passwd':dbconf.g_resultDBPwd, 'db':dbconf.g_resultDBName, 'charset':'utf8'} db = MySQL(dbconfig) sql1 = "select cID from available_CIDs;" cids = db.fetchAllRows(sql1) sql2 = "select * from available_CIDs;" cidsNum = db.query(sql2) class WorkManager(object): def __init__(self,work_num=10,thread_num=2): self.work_queue = Queue.Queue() self.threads = [] self.__init_work_queue(work_num) self.__init_thread_pool(thread_num) ### Initialize thread def __init_thread_pool(self,thread_num): for i in range(thread_num): self.threads.append(Work(self.work_queue))
import datetime import re dataDir = "./data/" sqlDir = '../sql/' today = datetime.date.today() lastDay = today - datetime.timedelta(days = 1) dbconfig = {'host':dbconf.g_resultDBHost, 'port':dbconf.g_resultDBPort, 'user':dbconf.g_resultDBUser, 'passwd':dbconf.g_resultDBPwd, 'db':dbconf.g_resultDBName, 'charset':'utf8'} db = MySQL(dbconfig) sql1 = "select cID from available_CIDs;" cLists = db.fetchAllRows(sql1) files = glob.glob(dataDir+'record_*') lastDay="2015-12-22" def getSqlName(cid): f = open(dataDir+"record_"+str(cid)) return f.readline().split()[0] def getFileSize(cid,dateStr): print "%s%s-%s.sql"%(sqlDir,cid,dateStr) return os.path.getsize("%s%s-%s.sql"%(sqlDir,cid,dateStr)) def getSeekValue(cid): f = open(dataDir+"record_"+str(cid)) return f.readline().split()[1]
from mysql import MySQL dbconfig = {"host": "172.16.2.226", "port": 3306, "user": "******", "passwd": "root", "db": "sun_test", "charset": "utf8"} db = MySQL(dbconfig) # sql = "select * from cinema_movie_info_tab" # sql = "/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;" # sql = "/*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/;/*!40019 SET @@session.max_insert_delayed_threads=0*/;/*!50003 SET@OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/;DELIMITER /*!*/;" sql = "/*!40019 SET @@session.max_insert_delayed_threads=0*/;" try: db.update(sql) except Exception, e: print "err:" + sql raise e # db.insert(sql) result = db.fetchAllRows() print result # for row in result: # print "**"*30 # print row[0] # for colum in row: # print colum db.close()