37,721
社区成员
发帖
与我相关
我的任务
分享
#! /usr/bin/python
import sys
reload(sys)
sys.setdefaultencoding('utf8')
import mysql.connector
from mysql.connector.constants import ClientFlag
from mysql.connector.constants import SQLMode
import MySQLdb
mysql_config = {
'host':'127.0.0.1',
'user':'root',
'password':'***',
'port':3306,
'database':'Center',
'charset':'utf8',
'client_flags':[ClientFlag.LOCAL_FILES],
}
def isset(v):
try:
type (eval(v))
except:
return False
else:
return True
def LoadFile():
try:
cnn = mysql.connector.connect(**mysql_config)
sql = "LOAD DATA LOCAL INFILE '/app/python-study/test.csv' REPLACE INTO TABLE Center.test FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n'"
cursor = cnn.cursor()
cursor.execute(sql)
cnn.commit()
except mysql.connector.Error as e:
print('LoadFile sql fails {}'.format(e))
finally:
if isset("cursor"):
cursor.close()
if isset("cnn"):
cnn.close()
def LoadFile2():
cnn = MySQLdb.connect(host="127.0.0.1", user="root", passwd="***", db="Center", charset="utf8")
cursor = cnn.cursor()
sql = "LOAD DATA LOCAL INFILE '/app/python-study/test.csv' REPLACE INTO TABLE Center.test FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n'"
cursor.execute(sql)
cnn.commit()
if __name__ == "__main__":
# LoadFile()
LoadFile2()