def db_readAll(dt): # DB에서 [종목명,종목코드] 로 구성된 데이터셋을 받아옴. # dbUpdateDate = db.selectSingleValue('SELECT max(date) FROM test.t_stock_shares_info') query = """ SELECT A.STOCKCODE, A.STOCKNAME FROM jazzdb.T_STOCK_CODE_MGMT A WHERE 1=1 AND A.STOCKCODE NOT IN ( SELECT STOCKCODE FROM jazzdb.T_STOCK_SND_ANALYSIS_RESULT_TEMP WHERE DATE = '%s' GROUP BY STOCKCODE ) AND A.LISTED = 1 """ % (dt) for eachRow in db.select(query): if (len(eachRow) > 0): itemDic[eachRow[1].upper()] = eachRow[0] codeDic[eachRow[0]] = eachRow[1].upper() print("[INFO] 종목명/종목코드를 메모리에 읽어왔습니다, 남은 종목 수: ", len(itemDic.keys()))
def get_original_stockcode(): global codeDic, old_list old_list = db.select( 'select stockcode, stockname from jazzdb.T_STOCK_CODE_MGMT') # jazzdb.t_stock_code_mgmt 테이블 # 신규상장종목 및 종목명 변경여부 확인,업데이트하는 소스 # 데이터 출처 : Kiwoom for each in old_list: codeDic[each[0]] = each[1]
def get_stockcode_to_update(dt): # DB에서 [종목명,종목코드] 로 구성된 데이터셋을 받아옴. # dbUpdateDate = db.selectSingleValue('SELECT max(date) FROM test.t_stock_shares_info') query = ''' SELECT STOCKCODE FROM ( SELECT STOCKCODE, ROW_NUMBER() OVER (ORDER BY STOCKCODE DESC) AS RN FROM jazzdb.T_STOCK_CODE_MGMT A WHERE 1=1 AND A.STOCKCODE IN ( SELECT STOCKCODE FROM jazzdb.T_STOCK_OHLC_MIN WHERE DATE = '%s' GROUP BY STOCKCODE ) AND A.LISTED = 1 ) A WHERE RN =3 ''' % (dt) m = db.selectSingleValue(query) print(m) if m is None: m = '000000' query = """ SELECT A.STOCKCODE, A.STOCKNAME FROM jazzdb.T_STOCK_CODE_MGMT A WHERE 1=1 AND A.LISTED = 1 AND A.STOCKCODE > '%s' """ % (m) for eachRow in db.select(query): if (len(eachRow) > 0): itemDic[eachRow[1].upper()] = eachRow[0] codeDic[eachRow[0]] = eachRow[1].upper() print("[INFO] 종목명/종목코드를 메모리에 읽어왔습니다, 남은 종목 수: ", len(itemDic.keys()))
def db_readAll(dt): query = """ SELECT A.STOCKCODE, A.STOCKNAME FROM jazzdb.T_STOCK_CODE_MGMT A WHERE 1=1 AND A.STOCKCODE NOT IN ( SELECT STOCKCODE FROM jazzdb.T_STOCK_MA WHERE DATE = '%s' GROUP BY STOCKCODE ) AND A.LISTED = 1 """ % (dt) for eachRow in db.select(query): if (len(eachRow) > 0): itemDic[eachRow[1].upper()] = eachRow[0] codeDic[eachRow[0]] = eachRow[1].upper() print("[INFO] 종목명/종목코드를 메모리에 읽어왔습니다, 남은 종목 수: ", len(itemDic.keys()))