def setValue(strs, begin, end): for i in range(begin, end): pattern = re.compile(r"《(.*)》") name = pattern.findall(strs[i])[0] if IsHaveTheMovie(name): continue # 正则匹配获取页面地址 pattern = re.compile(r"href='(.*)'") # 查找href链接地址 url = pattern.findall(strs[i])[0] one = getMovieNameAndDownUrl(url) mysqlHelper.ExecuteSql( 'insert into movie (url,`name`,`desc`,downurl,score) values ("%s","%s","%s","%s","%s")' % (one.url, one.name, one.desc, one.downUrl, one.score), connection)
def InsertPage(begin, end): pageSql = "insert into getpage(pageAll,pageIndex) values (" + \ end + "," + begin + ")" lock.acquire() mysqlHelper.ExecuteSql(pageSql) lock.release()
def InsertPage(begin, end): pageSql = "insert into getpage(pageAll,pageIndex) values (" + \ end + "," + begin + ")" mysqlHelper.ExecuteSql(pageSql)
import sys if __name__ == '__main__': try: shopInfo = mysqlHelper.GetDb( 'select id from shop where 1=1', 0, None, jd.connection) if shopInfo != None: ids = [] # 获取商品Id合集 for s in shopInfo: ids.append(str(s[0])) # 判断该物品的记录是否存在,不存在则增加 shop = mysqlHelper.GetDb( 'select name from shop where id=%s', 1, s[0], jd.connection) if shop == None: mysqlHelper.ExecuteSql('insert into shop (id,name,isSelf,businessman) values("%s","%s","%s","%s")' % ( id, jd.getName(id), 1, ''), jd.connection) # 获取价格 prices = jd.getPrice(ids) # 时间(datetime类型) dt = time.strptime(time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()), "%Y-%m-%d %H:%M:%S") # 多条插入时,使用的值 pars = [] for price in prices: par = (int(price['id'][2:]), float(price['p']), dt) pars.append(par) # 插入数据库 mysqlHelper.ExecuteManySql( 'insert into price (shopId,price,addtime) values("%s","%s",%s)', pars, jd.connection) # 遍历价格与通知表 for price in prices:
stops=GetLineStop(busId) i=1 for stop in stops: print('%d. 站点:%s' % (i,stop)) i=i+1 stopPlace=[] line=input("请输入要记录的站点的序号,按-1取消输入:") while line!='-1': #判断是否输入的是数字 stopPlace.append(stops[int(line)]) print('已经记录%s' % (stops[int(line)])) line=input("请输入要记录的站点的序号,按-1取消输入:") #查询该车辆是否有记录 无则添加 busInfo=mysqlHelper.GetDb('select * from businfo where guid="%s"' % (busId),1,None,connection) if busInfo==None: mysqlHelper.ExecuteSql('insert into busInfo (guid,name,arriveplace) values ("%s","%s","%s")' % (busId,busLine,overPlace),connection) #查询该车辆是否有记录位置 有则修改后保存 busarriverecord=mysqlHelper.GetDb('select * from recordPlace where guid="%s"' % (busId),1,None,connection) if busarriverecord==None: mysqlHelper.ExecuteSql('insert into recordPlace (needrecordplace,guid) values ("%s","%s")' % (','.join(stopPlace),busId),connection) else: #判断是否已经记录过此站点,若记录过,则不再记录 stopPlace=busarriverecord[1]+','+','.join(stopPlace) mysqlHelper.ExecuteSql('update recordPlace set needrecordplace="%s" where guid="%s"' % (stopPlace,busId),connection) line= input("请输入线路号,输入exit退出") # 控制台程序 # if __name__ == '__main__': # paras = sys.argv[1].split('&') # 用&分隔参数 # if paras[0] == "GetLine": # result = GetLineInfo(paras[1])