#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)
#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")