def migComplex(): print("Function migComplex") #지금 소스보니 문제가 있는듯 tupSmallArea = REP_DAO.SELECT_RET_SMALL_AREA_CD2tup() for SmallArea in tupSmallArea: url = URL.getJsonKBRealEstatePastPriceInquery( 'S', '01', '', '', REP_COM.tuple2Str(SmallArea), '', '', '', '', '', '') print(url) html = get_html(url) soup = BeautifulSoup(html, 'html.parser') l = str(soup) jSonSmallArea = json.loads(l) for smallRegn in jSonSmallArea['msg']['servicedata']['ARRAY수4']: print(smallRegn['물건식별자'], smallRegn['아파트명'], smallRegn['X좌표값'], smallRegn['Y좌표값']) dicRetComplex = { 'CMPX_IDF_ID': smallRegn['물건식별자'], 'CMPX_IDF_NM': smallRegn['아파트명'], 'KB_REGN_CD': REP_COM.tuple2Str(SmallArea), 'X_COOR_VAL': smallRegn['X좌표값'], 'Y_COOR_VAL': smallRegn['Y좌표값'] } REP_DAO.INSERT_KMIG_KB_CMPX(dicRetComplex) time.sleep(sleeptime)
def migRetSmallAreaCode(): print("Function migRetSmallAreaCode") tupMidArea = REP_DAO.SELECT_RET_MID_AREA_CD2tup() for MidArea in tupMidArea: url = URL.getJsonKBRealEstatePastPriceInquery( 'S', '01', '', REP_COM.tuple2Str(MidArea), '', '', '', '', '', '', '') html = get_html(url) soup = BeautifulSoup(html, 'html.parser') l = str(soup) jSonMidArea = json.loads(l) for midRegn in jSonMidArea['msg']['servicedata']['소지역목록ARRAY']: print(midRegn['부동산소지역코드'], midRegn['부동산소지역명']) dicRetSmallArea = { 'KB_REGN_CD': midRegn['부동산소지역코드'], 'KB_REGN_NM': midRegn['부동산소지역명'], 'UP_KB_REGN_CD': REP_COM.tuple2Str(MidArea) } REP_DAO.INSERT_KMIG_KB_SMALL_REGN(dicRetSmallArea) time.sleep(sleeptime)
def migComplexTyp(): print("Function migComplexTyp") dicComplex = REP_DAO.SELECT_RET_CMPX_CD2dic() for Complex in dicComplex: url = URL.getJsonKBRealEstatePastPriceInquery( 'S', '01', '', '', Complex['SMALL_KB_REGN_CD'], Complex['CMPX_IDF_ID'], '', '', '', '', '') print(url) html = get_html(url) soup = BeautifulSoup(html, 'html.parser') l = str(soup) jSon = json.loads(l) for sJSon in jSon['msg']['servicedata']['ARRAY수5']: print(sJSon['주택형일련번호'], sJSon['주택형']) dicRetComplex = { 'CMPX_IDF_ID': Complex['CMPX_IDF_ID'], 'HOUSE_TYP_SEQ': sJSon['주택형일련번호'], 'HOUSE_TYP_NM': sJSon['주택형'] } REP_DAO.INSERT_KMIG_KB_CMPX_TYP(dicRetComplex) time.sleep(sleeptime)