def is_working_day(self, date):
sql = "SELECT fn_is_holiday('" + date + "')"
flag = dbu.get_data(sql)[0][0]
if flag == 'W':
return True
else:
return False
def get_stock_list(self, end_date):
sql = "SELECT CODE, LASTUPDATEDDATE FROM pdtb_stock_list where LASTUPDATEDDATE < '" + end_date + "' and TIMETOMARKET <> '0000-00-00' ORDER BY CODE"
return dbu.get_data(sql)