def sync(ran): r = Red(0) for i in range(0,ran): try: s = session.query(MovieDB).filter_by(id=i).first() if(s): r.add('全部',i) for t in str2list(s.types): r.add('type',t) r.add(t,i) for o in str2list(s.ontime): o = o.split('-')[0] r.add('ontimes',o) r.add(o,i) for x in s.country.split(' / '): r.add('country',x) r.add(x,i) except Exception: pass
writer = d['writer'], actor = d['actor'], types = d['types'], country = d['country'], lang = d['lang'], ontime = d['ontime'], runtime = d['runtime'], another = d['another'], summary = d['summary'], average = d['average'], votes = d['votes'] ) session.add(s) session.commit() #查询刚插入的电影的ID,然后写入redis s = session.query(MovieDB).filter_by(title=i['title']).first() r.add('全部',s.id) for i in d['type']: r.add('type',i) r.add(i,s.id) #print(r.get(i)) for x in d['ontimes']: r.add('ontimes',x) r.add(x,s.id) for x in d['countrys']: r.add('country',x) r.add(x,s.id) time.sleep(6*60*60)