python读取数据写入MySQL数据库

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

# -------------------------------------------------------