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