因为项目需要,需要用户在客户端选择国家和州。然后提交给服务器。
搜索了一下暂时没有这些。服务器用的是js的代码。说要不要返回API。
我想了下还是算了。正好项目采用了BeeFramework,提供对象关系映射。
考虑本地DB,直接转换成对象使用
拿到js地址。http://imybags.com/Js/imybags.countries.js
因为 国家的比较少。直接复制到python内部。
其他部分保存txt用python加载文件解析匹配到国家。然后写入数据库。
直接上代码
#/usr/bin/python
#coding: utf8
import os,sys
import sqlite3
__author__ = 'watsy'
scountry = """
"Afghanistan","Albania","Algeria","American Samoa","Angola","Anguilla","Antartica","Antigua and Barbuda","Argentina","Armenia","Aruba","Ashmore and Cartier Island","Australia","Austria","Azerbaijan","Bahamas","Bahrain","Bangladesh","Barbados","Belarus","Belgium","Belize","Benin","Bermuda","Bhutan","Bolivia","Bosnia and Herzegovina","Botswana","Brazil","British Virgin Islands","Brunei","Bulgaria","Burkina Faso","Burma","Burundi","Cambodia","Cameroon","Canada","Cape Verde","Cayman Islands","Central African Republic","Chad","Chile","China","Christmas Island","Clipperton Island","Cocos (Keeling) Islands","Colombia",&