if 문을 대신db로 같은 역할을 하게끔 하고싶습니다

Question

처음에 getcategory함수를 이용하여 이름을 한글로 변경하고 맞게 단위를 출력하게끔 코딩하였는데요 DB로 저장해서 불러오게끔 해보고싶어서요 selete문으로 디비 정보는 불러오는데 if 문처럼 사용하고싶어요 from urllib.parse import urlencode, quote_plus from urllib.request import urlopen, Request import xml.etree.ElementTree as etree from django.shortcuts import render from datetime import date import pymysql import requests ''' def getcategory(category): ret &#61; {} if category &#61;&#61; &#34;POP&#34;: ret['category'] &#61; &#34;강수확률&#34; ret['unit'] &#61; &#34;%&#34; elif category &#61;&#61; &#34;PTY&#34;: ret['category'] &#61; &#34;강수형태&#34; ret['unit'] &#61; &#34;코드값&#34; elif category &#61;&#61; &#34;R06&#34;: ret['category'] &#61; &#34;6시간 강수량&#34; ret['unit'] &#61; &#34;범주&#34; elif category &#61;&#61; &#34;REH&#34;: ret['category'] &#61; &#34;습도&#34; ret['unit'] &#61; &#34;%&#34; elif category &#61;&#61; &#34;S06&#34;: ret['category'] &#61; &#34;6시간 신적설&#34; ret['unit'] &#61; &#34;범주&#34; elif category &#61;&#61; &#34;SKY&#34;: ret['category'] &#61; &#34;하늘상태&#34; ret['unit'] &#61; &#34;(코드값)&#34; elif category &#61;&#61; &#34;T3H&#34;: ret['category'] &#61; &#34;3시간 기온&#34; ret['unit'] &#61; &#34;℃&#34; elif category &#61;&#61; &#34;TMN&#34;: ret['category'] &#61; &#34;아침 최저기온&#34; ret['unit'] &#61; &#34;℃&#34; elif category &#61;&#61; &#34;TMX&#34;: ret['category'] &#61; &#34;낮 최고기온&#34; ret['unit'] &#61; &#34;℃&#34; elif category &#61;&#61; &#34;UUU&#34;: ret['category'] &#61; &#34;풍속(동서성분)&#34; ret['unit'] &#61; &#34;m/s&#34; elif category &#61;&#61; &#34;VVV&#34;: ret['category'] &#61; &#34;풍속(남북성분)&#34; ret['unit'] &#61; &#34;m/s&#34; elif category &#61;&#61; &#34;WAV&#34;: ret['category'] &#61; &#34;파고&#34; ret['unit'] &#61; &#34;M&#34; elif category &#61;&#61; &#34;VEC&#34;: ret['category'] &#61; &#34;풍향&#34; ret['unit'] &#61; &#34;deg&#34; elif category &#61;&#61; &#34;WSD&#34;: ret['category'] &#61; &#34;풍속&#34; ret['unit'] &#61; &#34;m/s&#34; else: category &#61; &#34;error&#34; print(&#34;00&#34;,ret) return ret def settingItem(item): print(&#34;&#61;&#61;>&#34;,item['category']) print(&#34;11&#34;,item) ret &#61; {} print(&#34;22&#34;,item['category']) ret &#61; getcategory(item['category']) print(&#34;33&#34;, item['category']) item['category'] &#61; ret['category'] print(&#34;44&#34;, ret['category']) item['fcstValue'] &#61; item['fcstValue']&#43;ret['unit'] return (item) print(&#34;55&#34;, item) ''' def getweather(request): #공공데이터 url url &#61; 'http://apis.data.go.kr/1360000/VilageFcstInfoService/getVilageFcst' today &#61; date.today() d1 &#61; today.strftime(&#34;%Y%m%d&#34;) queryParams &#61; '?' &#43; urlencode({ quote_plus('ServiceKey') : ', quote_plus('pageNo') : '1', quote_plus('numOfRows') : '20', quote_plus('dataType') : 'xml', quote_plus('base_date') : d1, quote_plus('base_time') : '0500', quote_plus('nx') : '57', quote_plus('ny') : '71' }) #서비스 url에 필요한 파라미터들을 붙여서 응답 결과를 얻음 print(url&#43;queryParams) response_body &#61; Request(url &#43; queryParams) #response_body는 GET형식으로 response_body.get_method &#61; lambda: 'GET' response_body &#61; urlopen(response_body).read() #print(type(response_body)) #string to xmlstring readString &#61; str(response_body, 'utf-8') #print(type(readString)) tree &#61; etree.ElementTree(etree.fromstring(readString)) note &#61; tree.getroot() # res &#61; note.find('body') # items &#61; res.find('items') # item &#61; items.find('item') items &#61; [] #items를 저장할 list 초기화 print(items) iter_element &#61; note.iter(tag&#61;&#34;item&#34;) #item태그에 있는 값을 차례대로 꺼냄 for element in iter_element: item &#61; {} print(&#34;55&#34;, item) item['baseDate'] &#61; element.find(&#34;baseDate&#34;).text item['fcstTime'] &#61; element.find(&#34;fcstTime&#34;).text item['category'] &#61; element.find(&#34;category&#34;).text #item['category'] &#61; getcategory(element.find(&#34;category&#34;).text) item['fcstValue'] &#61; element.find(&#34;fcstValue&#34;).text # item['fcstValue2'] &#61; getunit(element.find(&#34;category&#34;).text) conn &#61; pymysql.connect(host&#61;'127.0.0.1', user&#61;'', password&#61;'', db&#61;'locallibrary', charset&#61;'utf8') curs &#61; conn.cursor() sql &#61; 'select api.category_kr, api.unit from api where category&#61;&#34;pop&#34; OR category&#61;&#34;PTY&#34; OR category&#61;&#34;R06&#34; OR category&#61;&#34;REH&#34;OR category&#61;&#34;S06&#34;OR category&#61;&#34;SKY&#34;OR category&#61;&#34;T3H&#34;OR category&#61;&#34;TMN&#34;OR category&#61;&#34;TMX&#34;OR category&#61;&#34;UUU&#34;OR category&#61;&#34;VVV&#34;OR category&#61;&#34;WAV&#34;OR category&#61;&#34;WSD&#34;' curs.execute(sql) rows &#61; curs.fetchall() print (&#34;-data-&#34;,rows) print(&#34;66&#34;,item) # item &#61; settingItem(item) print (&#34;77&#34;,item) items.append(item) #items에 item정보 저장 print (&#34;88&#34;,item) print('baseDate') context &#61; { 'baseDate' : item['baseDate'], 'items':items } return render(request, 'weather/info.html', context&#61;context)

xml개발자 · Answer

쿼리에서는 if문하고 비슷한 case 문이 있습니다.

mj2 · Answer

질문의 요지는 긴 if문을 db를 활용하여 없애고 싶다는 말씀이신가요?

if 문을 대신db로 같은 역할을 하게끔 하고싶습니다

2개의 답변

#case 목록