import tushare as ts	
//3d
pro=ts.pro_api('956e1cff16b9d35d48f458bb7a2c90c1ae6261ddb85569d74ba60f')

/*获取SZSE的股票，获取SSE的股票*/
data = pro.stock_basic(exchange='SZSE', list_status='L',fields='ts_code,symbol,name,area,industry,fullname,exchange,list_status,list_date,is_hs')

//导出为 csv
data.to_csv('stock_basic.csv',encoding='UTF-8')

from sqlalchemy import create_engine  
import tushare as ts
//3d
pro=ts.pro_api('956e1cff16b9d35d48f458bb7a2c90c1ae6261ddb85569d74ba60f')
data = pro.stock_basic(exchange='', list_status='L', fields='ts_code,symbol,name,area,industry,fullname,enname,market,exchange,curr_type,list_status,list_date,delist_date,is_hs')



engine = create_engine("mysql+pymysql://{}:{}@{}/{}?charset={}".format('root', 'abc', '127.0.0.1:3306', 'jay','utf8'))
conn = engine.connect()
data.to_sql(name='stock_basic', con=conn, if_exists='append', index=False)

data = pro.stock_company(exchange='SZSE', fields='ts_code,exchange,chairman,manager,secretary,reg_capital,setup_date,province,city,introduction,website,email,office,employees,main_business,business_scope')
data.to_sql(name='stock_company', con=conn, if_exists='append', index=False)
data = pro.stock_company(exchange='SSE', fields='ts_code,exchange,chairman,manager,secretary,reg_capital,setup_date,province,city,introduction,website,email,office,employees,main_business,business_scope')
data.to_sql(name='stock_company', con=conn, if_exists='append', index=False)