用 Python 讀取 MySQL 資料轉存CSV

如下程式碼

#!/usr/bin/env python
import MySQLdb
#import csv
import json
import sqlite3
#from subprocess import check_output, call
import subprocess
import string
import time
import codecs
import unicodecsv as csv
import os
import io
import sys

reload(sys)
sys.setdefaultencoding('utf8')

sys.stdout = codecs.lookup('iso8859-1')[-1](sys.stdout)
db = MySQLdb.connect(db='urp',host='mysql.tutk.com',user='analysis',passwd='gameflier',port=3306)
print('Connection OK')


with open('1.csv','r' ) as csvinput:
	with open('2.csv', 'w') as csvoutput:
		writer = csv.writer(csvoutput,   lineterminator=os.linesep)
		#uid = []
		#db.text_factory = str
		cursor = db.cursor()
        	for rowreader in csv.reader(csvinput,  lineterminator=os.linesep):
			vid = rowreader[0]
		#	uid.append(vid)
			#cursor.execute(u"""SELECT CONV(urp_uid.vid, 10,16) FROM urp_uid WHERE uid='{0}';""".format(vid))
			cursor.execute("SELECT CONV(urp_uid.vid, 10,16) FROM urp_uid WHERE uid='{0}';".format(vid))
			#uid.append(vid)
			vid = cursor.fetchall()
			for row in vid:
				output = []
				for vid in range(len(row)):
					output.append(str(row[vid]))
			#	print (output)
			#print ((vid))
			#uid.append((row[3]))
			#print (vid)
			writer.writerow((output)+(rowreader))