from jqdatasdk import *
from sqlalchemy import create_engine
engine = create_engine('mysql://root:123456@127.0.0.1/mystockdata?charset=utf8')
auth("18819317875", "18819317875")
a = is_auth()
print(get_query_count())
stocks = list(get_all_securities(["stock"]).index)
print(stocks)
num = 0
for v in stocks:
q = query(finance.STK_BALANCE_SHEET).filter(finance.STK_BALANCE_SHEET.code == v)
df = finance.run_query(q)
try:
df.to_sql("balance_sheet", engine, if_exists="append")
except Exception as e:
print(e)
q = query(finance.STK_BALANCE_SHEET_PARENT).filter(finance.STK_BALANCE_SHEET_PARENT.code == v)
df = finance.run_query(q)
try:
df.to_sql("balance_sheet_parent", engine, if_exists="append")
except Exception as e:
print(e)
num += 1
print(num)