import tushare as ts
import pymysql

code = '300468'
e = ts.get_hist_data(code, start='2018-03-01', end='2018-04-24')
file = open(code + ".txt", 'w')
msg = file.write(str(e))
file.close()

with open(code + '.txt', 'r') as f:
    lines = f.readlines()
    ls = []
    for i in range(2, 39):
        ss = str(lines[i]).strip().split()
        ls.append(ss)
LL = []
for x in ls:
    s = []
    s.append(code)
    s.append(x[0])
    s.append(float(x[1]))
    s.append(float(x[3]))
    s.append(float(x[6]))
    LL.append(s)

db = pymysql.connect("localhost", "root", "", "gp")
cursor = db.cursor()

sql = "insert into gp_price(gp_code,date,open_price,close_price,change_price) values"
for x in LL:
    sql += "('" + str(x[0]) + "','" + str(x[1]) + "'," + \
        str(x[2]) + "," + str(x[3]) + "," + str(x[4]) + "),"

sq = sql[:-1] + ";"

try:
    cursor.execute(sq)
    db.commit()
except:
    db.rollback()

db.close()

print("执行成功！")