"fullname": data.iloc[i]["fullname"],
"enname": data.iloc[i]["enname"],
"market": data.iloc[i]["market"],
"exchange": data.iloc[i]["exchange"],
"curr_type": data.iloc[i]["curr_type"],
"list_status": data.iloc[i]["list_status"],
"list_date": data.iloc[i]["list_date"],
"delist_date": data.iloc[i]["delist_date"],
"is_hs": data.iloc[i]["is_hs"]})
else:
print("处理%d/%d：：更新：：%s" % (int(i), int(total), ts))
conn.findKeySql(const.UPDATE_BY_ATTR, table="stock_basic",
data={"symbol": data.iloc[i]["symbol"],
"name": data.iloc[i]["name"],
"area": data.iloc[i]["area"],
"industry": data.iloc[i]["industry"],
"fullname": data.iloc[i]["fullname"],
"enname": data.iloc[i]["enname"],
"market": data.iloc[i]["market"],
"exchange": data.iloc[i]["exchange"],
"curr_type": data.iloc[i]["curr_type"],
"list_status": data.iloc[i]["list_status"],
"list_date": data.iloc[i]["list_date"],
"delist_date": data.iloc[i]["delist_date"],
"is_hs": data.iloc[i]["is_hs"]},
params={"ts_code": ts}, join='AND')
except Exception as e:
print("执行sql出错:")
raise e
conn.close()
