def get_detail(start=0):
try:
conn = mysql.connector.connect(**config.mysql)
except mysql.connector.Error as err:
if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:
print("cann't connect to mysql server")
if err.errno == errorcode.ER_BAD_DB_ERROR:
print("database doesn't exist")
cursor = conn.cursor()
# cursor.execute("set NAMES latin1")
try:
if start == 0:
cursor.execute("select * from logs")
else:
cursor.execute("select * from logs limit " + str(start) + ", 10000")
except Exception as e:
print(e)
for i in cursor:
ip = i[4]
address = ip_info.get_ip_info(i[4])[-1]
vid = i[5].split(".")[0]
video_info = ip_info.get_vedio_info(vid)
if video_info:
video_name = video_info[0]
video_type = video_info[1]
video_png = video_info[2]
detail = (vid, ip, str(address), video_name, video_type, video_png)
yield detail
# details.append(detail)
cursor.close()
def get_detail(start=0):
try:
conn = mysql.connector.connect(**config.mysql)
except mysql.connector.Error as err:
if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:
print("cann't connect to mysql server")
if err.errno == errorcode.ER_BAD_DB_ERROR:
print("database doesn't exist")
cursor = conn.cursor()
#cursor.execute("set NAMES latin1")
try:
if start == 0:
cursor.execute("select * from logs")
else:
cursor.execute("select * from logs limit " + str(start) +
", 10000")
except Exception as e:
print(e)
for i in cursor:
ip = i[4]
address = ip_info.get_ip_info(i[4])[-1]
vid = i[5].split('.')[0]
video_info = ip_info.get_vedio_info(vid)
if video_info:
video_name = video_info[0]
video_type = video_info[1]
video_png = video_info[2]
detail = (vid, ip, str(address), video_name, video_type, video_png)
yield detail
#details.append(detail)
cursor.close()
def get_valid_top10(self, tops, top10_vid=None):
if top10_vid is None:
top10_vid = []
res = []
top10_count = 0
f = open("vid.txt", 'w+')
for i in tops:
f.write(i[1] + '\t' + str(i[0]))
f.write('\n')
vid_name = ip_info.get_vedio_info(i[1])
if not vid_name:
continue
if self.is_valid(vid_name[0]):
top10_count += 1
top10_vid.append(i[1])
res.append((i, vid_name))
''' don't get video name
top10_count += 1
res.append((i[0], i[1]))
'''
if top10_count >= 10:
break
return res