def get_today():
global dateA, dateB
dateA, dateB = am.api_checkDate(apiObj, dm.todayStr('n'))
if (len(sys.argv) > 1):
dateA = sys.argv[1]
print(" passed argv : ", dateA) # 과거 수집용
else:
print(" passed argv : None") # 일 배치
def update_stockcode():
global codeDic, old_list
new_list = apiObj.get_list('p')
new_list = new_list + apiObj.get_list('d')
for eachcode in new_list:
# 신규 상장 종목 인서트
if eachcode[0] != '' and eachcode[0] not in codeDic.keys():
print(eachcode + [dm.todayStr('-')])
db.insert(
"INSERT INTO `jazzdb`.`T_STOCK_CODE_MGMT` (`STOCKCODE`, `STOCKNAME`, `MARKET`, `LISTED`, `UPDATEDATE`) VALUES ('%s', '%s', '%s', '%s','%s');"
% tuple(eachcode + [dm.todayStr('-')]))
print("신규상장 종목", eachcode)
# 종목명 바뀐경우 업데이트
if eachcode[0] != '' and eachcode[0] in codeDic.keys(
) and eachcode[1] != codeDic[eachcode[0]]:
print("종목명 변경", codeDic[eachcode[0]], eachcode)
db.insert(
"UPDATE `jazzdb`.`T_STOCK_CODE_MGMT` SET `STOCKNAME` = '%s', `UPDATEDATE` = '%s' WHERE (`STOCKCODE` = '%s')"
% (eachcode[1], dm.todayStr('-'), eachcode[0]))
def get_today():
global dateA, dateB, today
dateA, dateB = am.api_checkDate(apiObj, dm.todayStr('n'))
today = dateA
from jazzstock_crawl.windows.kiwoom import dateManager as dp
from jazzstock_bot.common import connector_db as db
from jazzstock_crawl.windows.kiwoom import Kiwoom as kapi, dateManager as dm, apiManager as am
from jazzstock_crawl.wrapper import _check_running_time
from jazzstock_bot.util import index_calculator as cal
import time
apiObj = kapi.Kiwoom()
apiObj.comm_connect()
recent_trading_day, _ = am.api_checkDate(apiObj, dp.todayStr('n'))
codeDic, itemDic = {}, {}
def db_readAll():
q = '''
SELECT INDEXCODE, INDEXNAME
FROM jazzdb.T_INDEX_CODE_MGMT
WHERE 1=1
'''
df = db.selectpd(q)
for each in df.values:
codeDic[each[0]] = each[1]
db_readAll()
def sync_ohlc_day(code, dt=recent_trading_day):
'''
특정지수의 일봉을 업데이트하는 함수
print("[INFO] 종목명/종목코드를 메모리에 읽어왔습니다, 남은 종목 수: ", len(itemDic.keys()))
print("[INFO] 종목명/종목코드를 메모리에 읽어왔습니다, 남은 종목 수: ", len(itemDic.keys()))
def drop_connection():
apiObj.destroy()
itemDic = {}
codeDic = {}
apiObj = kapi.Kiwoom()
apiObj.comm_connect()
dateA, dateB = am.api_checkDate(apiObj, dm.todayStr('n'))
#target_dt = dateA[:4] + '-' + dateA[4:6] + '-' + dateA[6:]
if len(sys.argv) > 1:
wincode = sys.argv[1]
else:
wincode = '58'
db_readAll(dateA, wincode)
# for winCode in ['61', '58', '43', '35', '41']:
# processrunner_forwin('07.crawl_forwin.py',28,winCode)
#
# for winCode in ['36','42', '44', '45', '54']:
# processrunner_forwin('07.crawl_forwin.py',28,winCode)
#