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)