def getCityXiaoqu(sql=''):
ms = GJDB()
ms.ms()
ms.selectDB('xiaoqu')
ms.executeDB('SET NAMES UTF8;')
if sql == '':
sql = 'SELECT distinct city, name FROM xiaoqu_xiaoqu;'
return ms.selectData(sql)
def getCityDistrictStreet(sql=''):
management = GJDB()
management.management()
management.selectDB('management')
management.executeDB('SET NAMES UTF8;')
if sql == '':
sql = 'SELECT city.short_name city_name, city.domain, district.short_name district_name,district.url, street.street_name, street.url FROM street INNER JOIN district INNER JOIN city ON district.district_id=street.district_id AND city.city_id=district.city_id;'
return management.selectData(sql)
def getCityXiaoqu(sql=''):
ms = GJDB()
ms.ms()
ms.selectDB('xiaoqu')
ms.executeDB('SET NAMES UTF8;')
if sql == '':
sql = 'SELECT distinct city, name FROM xiaoqu_xiaoqu;'
return ms.selectData(sql)
def getCityDistrictStreet(sql=''):
management = GJDB()
management.management()
management.selectDB('management')
management.executeDB('SET NAMES UTF8;')
if sql == '':
sql = 'SELECT city.short_name city_name, city.domain, district.short_name district_name,district.url, street.street_name, street.url FROM street INNER JOIN district INNER JOIN city ON district.district_id=street.district_id AND city.city_id=district.city_id;'
return management.selectData(sql)
#coding:utf-8
from GJDB import GJDB
DB = GJDB()
DB.management()
DB.selectDB('management')
DB.selectData("set names utf8;")
#print DB.selectData("SELECT city.domain,street.street_id,street.script_index,street.street_name,street.url FROM street INNER JOIN district INNER JOIN city ON district.district_id=street.district_id AND city.city_id=district.city_id where city.short_name='北京' and district.short_name='海淀' and street.street_name='西二旗'")
with open('districtStreetM.txt', 'r') as streetAddFile:
for streetAdd in streetAddFile:
try:
city, district, streets = streetAdd.split('\t')
except:
continue
streetDic = streets[:-1].split(',')
for street in streetDic:
sql = "SELECT city.domain,street.street_id,street.script_index,street.street_name,street.url FROM street INNER JOIN district INNER JOIN city ON district.district_id=street.district_id AND city.city_id=district.city_id where city.short_name='" + city + "' and district.short_name = '" + district + "' and street.street_name='" + street + "'"
sql2 = "SELECT city.domain FROM district INNER JOIN city ON city.city_id=district.city_id where city.short_name='" + city + "' and district.short_name = '" + district + "'"
if len(DB.selectData(sql)) == 0:
if len(DB.selectData(sql2)) >= 0:
print city, district, street
#pass
else:
#print sql2
pass
#print city, district, streetDic
#coding:utf-8
from GJDB import GJDB
DB = GJDB()
DB.management()
DB.selectDB('management')
DB.selectData("set names utf8;")
#print DB.selectData("SELECT city.domain,street.street_id,street.script_index,street.street_name,street.url FROM street INNER JOIN district INNER JOIN city ON district.district_id=street.district_id AND city.city_id=district.city_id where city.short_name='北京' and district.short_name='海淀' and street.street_name='西二旗'")
with open('districtStreetM.txt','r') as streetAddFile:
for streetAdd in streetAddFile:
try:
city, district, streets = streetAdd.split('\t')
except:
continue
streetDic = streets[:-1].split(',')
for street in streetDic:
sql = "SELECT city.domain,street.street_id,street.script_index,street.street_name,street.url FROM street INNER JOIN district INNER JOIN city ON district.district_id=street.district_id AND city.city_id=district.city_id where city.short_name='" + city + "' and district.short_name = '" + district + "' and street.street_name='" + street + "'"
sql2 = "SELECT city.domain FROM district INNER JOIN city ON city.city_id=district.city_id where city.short_name='" + city + "' and district.short_name = '" + district + "'"
if len(DB.selectData(sql)) == 0:
if len(DB.selectData(sql2)) >=0:
print city, district, street
#pass
else:
#print sql2
pass
#print city, district, streetDic
