def get_add_insert_industry(table_name):
import sys
sys.path.append('../')
from stocks_pool_for_HZ300 import select_good_stocks
symbols = select_good_stocks()
from_table_name = "hz300_stocks"
to_table_name, insert_column = table_name, "industry_type"
add_column_into_table(to_table_name, insert_column)
for stock_code in symbols:
industry = get_industry_from_table(from_table_name, stock_code)
insert_industry_into_table(to_table_name, insert_column, stock_code,
industry)
get_recover_data_function(table_name, stock_code,
date_has_data_list[i],
date_no_data_list1[i],
date_no_data_list2[i],
recover_column_list, db, cursor)
cursor.close()
db.close()
if __name__ == "__main__":
# all_December31_many_years,all_Jan31_many_years,all_FebEnd_many_years = get_all_December31_Jan31_FebEnd_many_years()
from stocks_pool_for_HZ300 import select_good_stocks
symbols = select_good_stocks()
table_name = "table_month_data"
recover_column_list = [
"profit_ttm", "bps", 'fcff', 'cfps_ttm', 'wgsd_oper_cf', 'wgsd_com_eq',
'wgsd_assets', 'yoy_or', 'qfa_yoysales', 'yoyprofit', 'qfa_yoyprofit',
'grossprofitmargin', 'roe_ttm2', 'roa_ttm2', 'yoybps', 'yoy_assets',
'wgsd_yoyocf', 'roa', 'roe', 'grossprofitmargin_ttm2', 'assetsturn',
'faturn', 'op_ttm2', 'current', 'cashtocurrentdebt', 'quick',
'wgsd_com_eq_paholder', 'longdebttodebt', 'tot_liab', 'debttoassets'
]
print len(recover_column_list)
control_get_recover(symbols, table_name, recover_column_list)
