def init_zip_code():
try:
ZipCode.query.delete()
import openpyxl
file_path = '20160406_zip_code_sido_sigungu.xlsx'
workbook = openpyxl.load_workbook(file_path, use_iterators=True)
sheet_names = workbook.get_sheet_names()
if len(sheet_names) == 0:
return
sheet = workbook.get_sheet_by_name(name=sheet_names[0])
idx = 0
for row in sheet.rows:
if idx == 0:
idx += 1
continue
zip_code = ZipCode()
zip_code.code = int(row[0].value)
zip_code.sub_code = int(zip_code.code / 1000)
zip_code.sido = row[1].value
zip_code.sigungu = row[2].value
db.session.add(zip_code)
db.session.commit()
except Exception as e:
print(e)
return
def list_code(self, request):
logging.info("list_code code: " + request.code + '. limit: ' + str(request.limit))
query = ZipCode.query_code(request.code)
items = [entity.to_message() for entity in query.fetch(request.limit, offset=request.offset)]
return ZipCodeListResponse(items=items)
def list(self, request):
query = ZipCode.query_all()
items = [entity.to_message() for entity in query.fetch(request.limit, offset=request.offset)]
return ZipCodeListResponse(items=items)
