def write_codetable2db():
try:
mysql = mh.Mysql_Helper()
ds = dsts.Datasource()
df = ds.get_code_list()
for index in df.index:
sql = "replace into code (obj,name,updatetime) values ('%s','%s',now())" % (
df.loc[index, 'ts_code'], df.loc[index, 'name'])
print(sql)
mysql.runsql(sql)
except Exception as err:
print(err)
mysql.close()
def write_codetable2db():
try:
mysql = mh.Mysql_Helper()
ds = dsts.Datasource()
df = ds.get_code_list()
for row in df.itertuples():
sql = "replace into code (obj,name,updatetime) values ('%s','%s',now())" \
% (row.ts_code, row.name)
print(sql)
mysql.runsql(sql)
except Exception as err:
print(err)
mysql.close()
def getlastdayline():
mysql = mh.Mysql_Helper()
cursor = mysql.connection.cursor()
d = {}
try:
with mysql.connection.cursor() as cursor:
# Create a new record
sql = "select max(date),obj from dayline group by obj"
cursor.execute(sql)
while True:
result = cursor.fetchone()
if result is None:
break
code = result[1][0:6]
date = result[0]
d[code] = date
#print(date, code)
return d
except Exception as err:
print(err)
finally:
mysql.close()
from datasource_tushare import datasource_ts as ds_ts
from datasource_tushare import mysql_helper as mh
import math
if __name__ == '__main__':
try:
mysql = mh.Mysql_Helper()
ds = ds_ts.Datasource()
df = ds.get_code_list()
for row in df.itertuples():
# print(row) print(row.Index, row.ts_code, row.symbol, row.name, row.area, row.industry, row.list_date)
df2 = ds.get_month_line(row.ts_code, '19800101')
if df2 is None:
continue
for row2 in df2.itertuples():
print(row2)
if math.isnan(row2.close):
continue
sql = "replace into monthline2_qfq (obj,date,open,high,low,close,vol,amout,updatetime) values " \
"('%s','%s','%s','%s','%s','%s','%s','%s',now())"\
% (row2.ts_code, row2.trade_date, row2.open, row2.high, row2.low, row2.close, row2.vol, row2.amount)
print(sql)
mysql.runsql(sql)
except Exception as err:
print(err)
finally:
mysql.close()