#---zhangpengxu---
#-*- coding: utf-8 -*-
import datetime
import time
import pymysql.cursors
import decimal
# 创建一个游标
conn = pymysql.connect(
host='localhost',
port=3306,
user='root',
passwd='xu19931026',
db='cd_taxi',
charset='utf8'
)
start_time=datetime.datetime.now()
if conn:
print("连接成功!")
cursor = conn.cursor() # 获取游标
sql = "INSERT INTO Order_Data (OrderId,BeginTime,EndTime,BeginLongitude,BeginLatitude,EndLongitude,EndLatitude) VALUES (%s,%s,%s,%s,%s,%s,%s);" # sql语句
bl=0 #读取了多少行
with open('order_20161101', 'r') as file:
try:
while True:
text_line = file.readline()
if(text_line!=''):
bl += 1 #加一行
text_line_list = text_line.split(",") # 读取txt文件内容默认是str类型,此处将其分割成一个个元素形成列表
cursor.execute(sql, (text_line_list[0],text_line_list[1],int(text_line_list[2]),text_line_list[3],text_line_list[4],text_line_list[5],text_line_list[6].strip("\n"))) # 传值
conn.commit() # 提交事务
if bl%50000==0: #5万行休息1s
time.sleep(1)
print('已完成插入SQLsever'+str(bl)+'行数据'+'正在插入'+str(bl)+'至'+str(bl+50000)+'行数据')
finally:
print("读取完毕")
file.close()
end_time = datetime.datetime.now()
speed = end_time - start_time
print('一共用时:'+str(speed))
# -------------------------------------------------------
python读取数据写入MySQL数据库
最新推荐文章于 2024-06-13 01:06:55 发布