tushare表生成_tushare 数据库表-CSDN博客

本文链接：https://blog.csdn.net/weixin_42603116/article/details/138408279

批量将tushare接口转成 sqlalchemy 数据库的表定义sql ddl, 一般可以在各数据库运行
可根据各数据库微调所生成sql
tushare 可自行注册用户 https://tushare.pro

import pandas as pd
import tushare as ts

pro = ts.pro_api(your_tushare_token)
## 自行更新tushare接口列表
## 假定表名和接口名一致
tu_list=['stock_basic','trade_cal','stock_company']
for aa in tu_list:
    print(pd.io.sql.get_schema(pro.query(aa), aa).replace('\n','')+';')

生成的ddl示例

CREATE TABLE "stock_basic" ("ts_code" TEXT,  "symbol" TEXT,  "name" TEXT,  "area" TEXT,  "industry" TEXT,  "cnspell" TEXT,  "market" TEXT,  "list_date" TEXT,  "act_name" TEXT,  "act_ent_type" TEXT);
CREATE TABLE "trade_cal" ("exchange" TEXT,  "cal_date" TEXT,  "is_open" INTEGER,  "pretrade_date" TEXT);
CREATE TABLE "stock_company" ("ts_code" TEXT,  "exchange" TEXT,  "chairman" TEXT,  "manager" TEXT,  "secretary" TEXT,  "reg_capital" REAL,  "setup_date" TEXT,  "province" TEXT,  "city" TEXT,  "website" TEXT,  "email" TEXT,  "employees" REAL);