1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
import pymysql
import traceback
import logging
from vest.request.auto_request import login, time_convs, reply, get_comment, click
from vest.request.auto_request import host, user, db, passwd
from libs.error import logging_exception
def get_topic_id(numtime1, numtime2):
try:
pc = pymysql.connect(host=host, user=user, passwd=passwd, db=db, port=3306)
cursor = pc.cursor()
cursor.execute(
"SELECT id,user_id FROM topic WHERE is_online=1 and create_time > '%s' and create_time < '%s' and id not in "
"(select topic_id from reply where create_time > '%s' and create_time < '%s')" % (
numtime1, numtime2, numtime1, numtime2)
)
data = cursor.fetchall()
topic_id = list(data)
logging.info("Database version : %s " % topic_id)
return topic_id
except:
logging.error("catch exception,get_data:%s" % traceback.format_exc())
return []
def fix_no_comment_click():
try:
numtime1, numtime2 = time_convs(8, 0)
user_id = get_topic_id(numtime1, numtime2)
for i in user_id:
cook = login()
if cook is not None:
click(cook, i[0])
comment = get_comment()
reply(cook, i[0], comment)
except:
logging_exception()
logging.error("catch exception,main :%s" % traceback.format_exc())