def get_aqi_from_json():
file = open("/data1/www/htdocs/371/timeroute/1/all_cities.json")
content = file.read()
if(content):
cities = json.loads(content)
for city in cities:
current_aqi = Aqi_Position_Name()
current_aqi.aqi = city['aqi']
current_pn = Position_Name()
current_pn = Position_Name.objects.filter(city=city['area']).get(position_name=city['position_name'])
current_aqi.position_name_id = current_pn.id
current_aqi.so2 = city['so2']
current_aqi.so2_24h = city['so2_24h']
current_aqi.co = city['co']
current_aqi.co_24h = city['co_24h']
current_aqi.no2 = city['no2']
current_aqi.no2_24h = city['no2_24h']
current_aqi.o3 = city['o3']
current_aqi.o3_8h = city['o3_8h']
current_aqi.o3_24h = city['o3_24h']
current_aqi.o3_8h_24h = city['o3_8h_24h']
current_aqi.pm10 = city['pm10']
current_aqi.pm10_24h = city['pm10_24h']
current_aqi.pm2_5 = city['pm2_5']
current_aqi.pm2_5_24h = city['pm2_5_24h']
if city['primary_pollutant']:
current_aqi.primary_pollutant = city['primary_pollutant']
else:
current_aqi.primary_pollutant = "——"
if city['quality']:
current_aqi.quality = city['quality']
else:
current_aqi.quality = "——"
current_aqi.time_point = city['time_point']
current_aqi.save()
def get_position_aqi():
url = "http://www.pm25.in/api/querys/all_cities.json?token=YpQx4AByXgTMxEa1YL1k"
resp = urllib2.urlopen(url)
content = resp.read()
if(content):
cities = json.loads(content)
for city in cities:
current_aqi = Aqi_Position_Name()
current_aqi.aqi = city['aqi']
current_pn = Position_Name()
current_pn = Position_Name.objects.filter(city=city['area']).get(position_name=city['position_name'])
current_aqi.position_name_id = current_pn.id
current_aqi.so2 = city['so2']
current_aqi.so2_24h = city['so2_24h']
current_aqi.co = city['co']
current_aqi.co_24h = city['co_24h']
current_aqi.no2 = city['no2']
current_aqi.no2_24h = city['no2_24h']
current_aqi.o3 = city['o3']
current_aqi.o3_8h = city['o3_8h']
current_aqi.o3_24h = city['o3_24h']
current_aqi.o3_8h_24h = city['o3_8h_24h']
current_aqi.pm10 = city['pm10']
current_aqi.pm10_24h = city['pm10_24h']
current_aqi.pm2_5 = city['pm2_5']
current_aqi.pm2_5_24h = city['pm2_5_24h']
if city['primary_pollutant']:
current_aqi.primary_pollutant = city['primary_pollutant']
else:
current_aqi.primary_pollutant = "——"
if city['quality']:
current_aqi.quality = city['quality']
else:
current_aqi.quality = "——"
current_aqi.time_point = city['time_point']
current_aqi.save()