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)