def index2():
'''
db 추가로직.
:input wha: = 검색 키워드 radiorate or weather
:return: None
'''
key = 'bMkM%2FSABk%2BZWxCygmK%2FjiC1l0m%2FcEOA5SWWYGGM4IJNBVoJCjxKGhz9LXSXL9lnDIxP%2FhmHc2%2F3Tyfdbk2p2Hg%3D%3D'
keywordlist = ["WS", "KR", "YK", "UJ", "SU"]
whalist = ['weather', 'radiorate']
for ei in range(len(whalist)):
wha = whalist[ei]
for i in range(len(keywordlist)):
keyword = keywordlist[i]
trueUrl = 'http://www.khnp.co.kr/environ/service/realtime/{wha}?serviceKey={key}&genName={keyword}'.format(
wha=wha, key=key, keyword=keyword)
req = requests.get(trueUrl)
html = req.text
soup = (BeautifulSoup(html, 'html.parser'))
str_xml = soup.prettify()
root_element = ElementTree.fromstring(str_xml)
iter_element = root_element.iter(tag="item")
whichslist = []
for element in iter_element:
whichdict = {}
whichdict['expl'] = element.find('expl').text
whichdict['name'] = element.find('name').text
whichdict['time'] = element.find('time').text
whichdict['value'] = element.find('value').text
whichslist.append(whichdict)
for i in range(len(whichslist)):
where = whichslist[i]['expl'].replace('\n', '')
where = where.replace(' ', '', 6)
time = whichslist[i]['time'].replace('\n', '')
time = time.replace(' ', '', 6)
time = time.replace(':', '-')
name = whichslist[i]['name'].replace('\n', '')
name = name.replace(' ', '', 6)
value = whichslist[i]['value'].replace('\n', '')
value = value.replace(' ', '', 6)
try:
db = CRUD()
db.insertData(keyword=keyword,
wha=wha,
where=where,
time=time,
name=name,
value=value)
except Exception as e:
print('errorpoint 2', e)
continue
return "hellow flask2"
