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_INCOME_STATEMENT).filter(finance.STK_INCOME_STATEMENT.code == v)
df = finance.run_query(q)
try:
df.to_sql("income_statement", engine, if_exists="append")
except Exception as e:
print(e)
q = query(finance.STK_INCOME_STATEMENT_PARENT).filter(finance.STK_INCOME_STATEMENT_PARENT.code == v)
df = finance.run_query(q)
try:
df.to_sql("income_statement_parent", engine, if_exists="append")
except Exception as e:
print(e)
num += 1
print(num)