merchantAddress.py 739 B

12345678910111213141516171819202122232425262728293031323334
  1. # coding=utf-8
  2. import os
  3. from base import init_env
  4. os.environ["DJANGO_SETTINGS_MODULE"] = "configs.dev_zjl"
  5. init_env(False)
  6. import csv
  7. from apps.web.merchant.models import WxMerchantAddress
  8. def load_city_code():
  9. with open("cityCode.csv", "r") as f:
  10. r = csv.DictReader(f, fieldnames=["code", "name"])
  11. for row in r:
  12. code, name = row["code"], row["name"]
  13. name = name.replace(u"中国,", "")
  14. if name.startswith(","):
  15. name = "{}{}".format(name[1:3], name)
  16. nameSplit = name.split(",")
  17. if len(nameSplit) != 3:
  18. continue
  19. name = "".join(nameSplit)
  20. WxMerchantAddress(code = code, name = name).save()