def find_latest_date():
engine = create_engine(hedge_fund_db_settings)
sql = 'select publicationDate from HOWBUY_FUND_HOLDING'
exist_data = pd.read_sql(sql, engine).sort_values('publicationDate')
if len(exist_data) > 0:
return exist_data.iloc[len(exist_data) - 1]['publicationDate']
else:
return pd.Timestamp('2014-01-01')
def find_latest_date():
engine = create_engine(exchange_db_settings)
sql = 'select effectiveDate from suspend_info'
exist_data = pd.read_sql(sql, engine).sort_values('effectiveDate')
if len(exist_data) > 0:
return exist_data.iloc[len(exist_data) - 1]['effectiveDate']
else:
return pd.Timestamp('2015-01-01')
def find_latest_date():
engine = create_engine(hedge_fund_db_settings)
sql = 'select tradingDate, howbuyStrategy from HOWBUY_STYLE_RET'
exist_data = pd.read_sql(sql, engine).sort_values('tradingDate')
if len(exist_data) > 0:
return exist_data.iloc[len(exist_data) - 1]['tradingDate']
else:
return pd.Timestamp('1990-01-01')
def find_latest_date():
engine = create_engine(hedge_fund_db_settings)
sql = 'select DISTINCT(setupDate) from HOWBUY_FUND_TYPE'
data = pd.read_sql(sql, engine).sort_values('setupDate')
if len(data) > 0:
return data.iloc[len(data) - 1]['setupDate']
else:
return dt.datetime(1900, 1, 1)
def find_existing(query_date):
engine = create_engine(exchange_db_settings)
sql = "select url from announcement_info where reportDate ='{0}' and exchangePlace = 'xshe'".format(
query_date)
exist_data = pd.read_sql(sql, engine)
return exist_data