#coding=utf-8
import MySQLdb
conn=MySQLdb.connect(host="123.232.102.237",user="tsgzuser",passwd="Shandongfea3.0",db="tsgz",charset="utf8",port = 33306)
cursor = conn.cursor()
dispathList = ["659001","659002","659003","659004","659005","659006","659007"]
pro_sql = "select adcode,name from amap WHERE `level`='province'"
p_ret = cursor.execute(pro_sql)
for p_row in cursor.fetchall():
province = p_row[1]
sql = "select adcode,name from amap WHERE `level`='city' AND adcode LIKE '%s%%'"%(p_row[0][:2])
ret = cursor.execute(sql)
for c_row in cursor.fetchall():
adcode = c_row[0]
city = c_row[1]
if adcode in dispathList:
pass
else:
_str = adcode[:4]
_sql = "SELECT adcode,name from amap WHERE `level`='district' AND adcode LIKE '%s%%'"%(_str)
# print _sql
t_ret = cursor.execute(_sql)
for t_row in cursor.fetchall():
district = t_row[1]
print province,city,t_row[0],t_row[1]
insertsql = "insert into area_test SET province='%s',city='%s',district='%s'"%(province,city,district)
cursor.execute(insertsql)
conn.commit()
conn.close()