# -*- coding: utf-8 -*-
import model
import settings
import logging
logging.basicConfig(filename=settings.LOGPATH,
filemode="a",
format='%(asctime)s - %(levelname)s - %(message)s',
level=logging.INFO)
import core
def get_communitylist():
res = []
#for community in model.Community.select().where(model.Community.useFlg == 0):
for community in model.Community.select():
res.append(community.title)
return res
if __name__ == "__main__":
regionlist = settings.REGIONLIST # only pinyin support
model.database_init()
communitylist = get_communitylist() # Read celllist from database
core.GetHouseByCommunitylist(communitylist) #根据小区
#core.GetHouseByRegionlist(regionlist) #根据区域
#core.GetRentByRegionlist(regionlist)
#core.GetCommunityByRegionlist(regionlist) # Init,scrapy celllist and insert database; could run only 1st time
core.GetSellByCommunitylist(communitylist)
def testUpsertDB():
hisprice_data_source = []
# info_dict = {'houseID': "121", 'totalPrice': '12110'}
info_dict = {"id":121, "title":u'京基御景华城', "link":'https://sz.lianjia.com/xiaoqu/12221', 'district': u'福田区', 'bizcircle': u'赤尾1', 'tagList': u'近地铁7号线赤尾站'\
,'onsale':'1', 'year':'' }
# hisprice_data_source.append(
# {"houseID": info_dict["houseID"], "totalPrice": info_dict["totalPrice"]})
# model.Hisprice.insert_many(
# hisprice_data_source).upsert().execute()
# model.Hisprice.insert_many(hisprice_data_source).on_conflict(conflict_target=[model.Hisprice.houseID,model.Hisprice.totalPrice], preserve=[model.Hisprice.totalPrice],update={}).execute()
model.Community.insert(info_dict).on_conflict(conflict_target=[model.Community.id], preserve=[model.Community.title, model.Community.link, model.Community.district, \
model.Community.bizcircle, model.Community.tagList, model.Community.onsale, model.Community.onrent, model.Community.year, \
model.Community.housetype, model.Community.cost, model.Community.service, \
model.Community.company, model.Community.building_num, model.Community.house_num, \
model.Community.price, model.Community.city],update={}).execute()
if __name__ == "__main__":
# originalCode()
regionlist = settings.REGIONLIST # only pinyin support
city = settings.CITY
model.database_init()
core.GetCommunityByRegionlist(city, regionlist)
communitylist = get_communitylist(city)
# print communitylist
core.GetHouseByCommunitylist(city, communitylist)
core.GetSellByCommunitylist(city, communitylist)
core.GetRentByCommunitylist(city, communitylist)
# testUpsertDB()
res.append(community.title)
return res
def get_custom_communitylist():
res = []
res.append(u'木樨地')
res.append(u'物资大院')
res.append(u'三里河北街3号院')
res.append(u'三里河北街5号院')
res.append(u'真武庙')
return res
if __name__ == "__main__":
pages = settings.PAGES
regionlist = settings.REGIONLIST # only pinyin support
model.database_init()
core.GetHouseByRegionlist(regionlist, pages)
core.GetRentByRegionlist(regionlist, pages)
core.GetCommunityByRegionlist(
regionlist
) # Init,scrapy celllist and insert database; could run only 1st time
custom_l = get_custom_communitylist()
core.GetCommunityByCustomlist(custom_l)
communitylist = get_communitylist() # Read celllist from database
core.GetHouseByCommunitylist(communitylist, pages)
core.GetRentByCommunitylist(communitylist, pages)
core.GetSellByCommunitylist(communitylist, pages)
#woaiwojialib.GetSellByCommunitylist()