#coding:utf-8
from GJDB import GJDB
db = GJDB()
db.ms()
db.selectData('set names utf8')
output = open('xiaoquPinyin.txt','w')
with open('xiaoqu.txt','r') as xiaoqu:
for xq in xiaoqu:
name = xq[:-1]
sql = 'select name,pinyin from xiaoqu.xiaoqu_xiaoqu where name="' + name + '" limit 1;'
#print db.selectData(sql)
try:
name,pingyin = db.selectData(sql)[0]
output.write(name + '|' + pingyin+'\n')
except:
pass
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.ms()
db.selectData('set names utf8')
output = open('xiaoquPinyin.txt', 'w')
with open('xiaoqu.txt', 'r') as xiaoqu:
for xq in xiaoqu:
name = xq[:-1]
sql = 'select name,pinyin from xiaoqu.xiaoqu_xiaoqu where name="' + name + '" limit 1;'
#print db.selectData(sql)
try:
name, pingyin = db.selectData(sql)[0]
output.write(name + '|' + pingyin + '\n')
except:
pass
# coding:utf-8
from GJDB import GJDB
import time, os
from googleSMS import sendSMS
os.system("color f0")
db = GJDB()
db.ms()
db.selectData("set names utf8")
for i in range(1, 1000):
sql = "SELECT FROM_UNIXTIME(show_time),title,huxing_shi,price,person,phone FROM beijing.house_source_rent WHERE show_time >=UNIX_TIMESTAMP('2014-09-18') AND show_time <UNIX_TIMESTAMP('2014-09-19') AND agent=0 AND xiaoqu REGEXP '新龙城';"
datas = db.selectData(sql)
print datas
if datas:
sendSMS(str(datas))
print "waiting..."
time.sleep(60)
os.system("cls")
#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
#coding:utf-8
from GJDB import GJDB
import time, os
from googleSMS import sendSMS
os.system("color f0")
db = GJDB()
db.ms()
db.selectData('set names utf8')
for i in range(1, 1000):
sql = "SELECT FROM_UNIXTIME(show_time),title,huxing_shi,price,person,phone FROM beijing.house_source_rent WHERE show_time >=UNIX_TIMESTAMP('2014-09-18') AND show_time <UNIX_TIMESTAMP('2014-09-19') AND agent=0 AND xiaoqu REGEXP '新龙城';"
datas = db.selectData(sql)
print datas
if datas:
sendSMS(str(datas))
print 'waiting...'
time.sleep(60)
os.system("cls")
