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()
