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()))
