def show_detail_ifo(e): index = video_listbox.curselection() item = video_listbox.get(index) id = int(item.split(':')[1]) # print(id) if str(item).startswith('aid'): sql = 'select * from user_video where aid=%s' res = sql_util.sql_execute(sql, (id)) # print(res) res = res[0] created = time.ctime(res['created']) mesg = "aid:{}\ntitle:{}\ndesc:{}\n长度:{}\n上传时间:{}\n".format( res['aid'], res['title'], res['description'], res['length'], created) mesgbox.showinfo('视频信息', mesg) return elif str(item).startswith('doc_id'): sql = 'select * from user_doc where doc_id=%s' res = sql_util.sql_execute(sql, (id)) res = res[0] ctime = time.ctime(res['ctime']) mesg = "doc_id: {}\ntitle: {}\ndesc:{}\ncount:{}\n上传时间{}\n".format( res['doc_id'], res['title'], res['description'], res['count'], ctime) mesgbox.showinfo('相簿信息', mesg) else: return
def init_sql_userdoc(): id_map = sql_util.sql_execute('select uid from basic_ifo') max_mid = sql_util.sql_execute( 'select poster_uid from user_doc order by poster_uid DESC limit 1') for id in id_map: if len(max_mid) == 0 or id.get('uid') > max_mid[0].get('poster_uid'): doclist_spider(id.get('uid')).start() time.sleep(0.3)
def init_sql_uservideo(): id_map = sql_util.sql_execute('select uid from basic_ifo') max_mid = sql_util.sql_execute( 'select mid from user_video order by mid DESC limit 1') for id in id_map: if len(max_mid) == 0 or id.get('uid') > max_mid[0].get('mid'): submitvidoe_spider(id.get('uid')).start() time.sleep(0.3)
def get_userifo(event): # print(event) index = user_listbox.curselection() item = user_listbox.get(index) if item == '' or item is None: return data = item.split(':')[1] # print(data) if data.isdigit(): uid = int(data) else: # sql="select uid from user_ifo where name=%s" # res=sql_util.sql_execute(sql,data) # print(res[0].get('uid')) index = (index[0] - 1, ) uid = user_listbox.get(index).split(':')[1] sql = 'select birthday,sex,sign from user_ifo where uid=%s' user_ifo = sql_util.sql_execute(sql, (uid)) print(user_ifo) if len(user_ifo) > 0: userifo.set("生日:{} 性别:{}\n sign:{}".format( user_ifo[0]['birthday'], user_ifo[0]['sex'], user_ifo[0]['sign'])) sql = "SELECT uv.aid,uv.title FROM user_video AS uv WHERE uv.mid=%s" video_res = sql_util.sql_execute(sql, (uid)) # print(video_res) video_listbox.delete(0, tk.END) if len(video_res) > 0: video_listbox.insert(tk.END, '------视频-------') for v in video_res: video_listbox.insert( tk.END, 'aid:{}:{}'.format(v['aid'], v['title'])) sql = "SELECT doc_id,description FROM user_doc WHERE poster_uid=%s" doc_res = sql_util.sql_execute(sql, (uid)) # print(doc_res) if len(doc_res) > 0: video_listbox.insert(tk.END, '------相簿-------') for d in doc_res: video_listbox.insert( tk.END, 'doc_id:{}:{}'.format(d['doc_id'], d['description']))
def show(): user_listbox.delete(0, tk.END) v = explor_entry.get().replace(' ', '') if v.isdigit(): v = int(v) sql = 'select uid,name from user_ifo where uid=%s' else: sql = "select uid,name from user_ifo where name like '%%%s%%'" % ( v) v = None res = sql_util.sql_execute(sql, (v)) # print(res) str = '' for r in res: for k in r: str = "{}:{}".format(k, r.get(k)) user_listbox.insert(tk.END, str) user_listbox.insert(tk.END, '') user_listbox.insert(tk.END, '没有其他的了...')
def init_txt_uservidoes(): pool = ThreadPoolExecutor(40) id_map = sql_util.sql_execute('select uid from basic_ifo') fp = os.getcwd() + '/docs/user_videos.txt' if not os.path.exists(fp): f = open(fp, mode="w", encoding='utf-8') f.close() with open(fp, mode="r", encoding='utf-8', closefd=True) as f: line_num = len(f.readlines()) f.close() max_num = len(id_map) lock = threading.Lock() while True: u = submitvidoe_spider(id_map[line_num].get('uid'), fp=fp, lock=lock) # u.start() pool.submit(u.start) line_num += 1 if line_num > max_num: break time.sleep(0.3)