def get_corp_list():
select_sql = 'SELECT id, stock_code, bond_short AS stock_name FROM t_jj_corp_info ORDER BY stock_code limit {} offset {}'.format(
LIMIT_SIZE, STOCK_INDEX)
return get_data(select_sql)
def get_list():
select_sql = 'SELECT id, stock_code, bond_short AS stock_name FROM t_jj_corp_info ORDER BY stock_code'
return get_data(select_sql)
def get_list():
select_sql = 'SELECT t1.stock_code AS 股票代码, t1.bond_short AS 证券简称, t.year AS 年度, sw_industry_name AS 所属行业, t1.province AS 省, t1.city AS 市, amt1 AS 销售收入, amt2 AS 净利润, amt3 AS 总资产, amt4 AS 净资产, amt5 AS 研发费用, amt6 AS 政府补助 FROM t_jj_corp_research_subsidy t LEFT JOIN t_jj_corp_info t1 ON t1.id = t.corp_id WHERE 1=1 AND t.amt3 IS NOT NULL ORDER BY t1.stock_code, t.year DESC'
return get_data(select_sql)
def get_corp_research_subsidy_list(corp_id, year):
select_sql = "SELECT id FROM t_jj_corp_research_subsidy WHERE corp_id = '{}' AND year = '{}'".format(
corp_id, year)
return get_data(select_sql)
def get_list():
sql_data = 'SELECT id, stock_code FROM t_jj_corp_info'
array = get_data(sql_data)
return array
