def voted_down(id):
ip = str(IP.ip())
conn = db()
cursor = conn.cursor()
sql = 'select * from down_record where id=\'' + id + '\' and ip=\'' + ip + '\''
cursor.execute(sql)
rows = cursor.fetchall()
if rows == []:
sql = 'update comment set down=down+1 where id=\'' + id + '\''
cursor.execute(sql)
sql = 'insert into down_record(id, ip) VALUES (?,?)'
cursor.execute(sql, (id, ip))
else:
sql = 'update comment set down=down-1 where id=\'' + id + '\''
cursor.execute(sql)
sql = 'delete from down_record where id=\'' + id + '\' and ip=\'' + ip + '\''
cursor.execute(sql)
sql = 'select * from comment where id = \'' + id + '\''
cursor.execute(sql)
rows = cursor.fetchall()
for i in rows:
upvote = i[4]
conn.commit()
cursor.close()
conn.close()
return str(upvote)
def voted_up(id):
ip = str(IP.ip())
conn = db()
cursor = conn.cursor()
sql = 'select * from up_record where id=\'' + id + '\' and ip=\'' + ip + '\''
cursor.execute(sql)
rows = cursor.fetchall()
if rows == []:
sql = 'update article set up=up+1 where id=\'' + id + '\''
cursor.execute(sql)
sql = 'insert into up_record(id, ip) VALUES (?,?)'
cursor.execute(sql, (id, ip))
else:
sql = 'update article set up=up-1 where id=\'' + id + '\''
cursor.execute(sql)
sql = 'delete from up_record where id=\'' + id + '\' and ip=\'' + ip + '\''
cursor.execute(sql)
sql = 'select * from article where id = \'' + id + '\''
cursor.execute(sql)
rows = cursor.fetchall()
for i in rows:
upvote = i[7]
conn.commit()
cursor.close()
conn.close()
return str(upvote)
def sub_forum_add(self):
sql = 'insert into sub_forums(subject, introduce, sub_subject) values (?,?,?)'
conn = db()
cursor = conn.cursor()
cursor.execute(sql, (self.subject, self.introduce, self.sub_subject))
conn.commit() # 提交数据库改动
cursor.close() # 关闭游标
conn.close() # 关闭数据库连接
def forum_add(self, subject, introduce):
conn = db()
cursor = conn.cursor()
sql = 'insert into forums(subject,introduce) values (?,?)'
cursor.execute(sql, (subject, introduce))
conn.commit()
cursor.close()
conn.close()
def browse(self):
conn = db()
cursor = conn.cursor()
sql = 'update ip set count = (count+1) where ip = ' + '\'' + self.ip + '\''
cursor.execute(sql)
conn.commit() # 提交数据库改动
cursor.close() # 关闭游标
conn.close()
def add_ip(self):
print(self.ip)
sql = 'insert or ignore into ip(ip) values (\'' + self.ip + '\'，0)'
conn = db()
cursor = conn.cursor()
cursor.execute(sql)
conn.commit() # 提交数据库改动
cursor.close() # 关闭游标
conn.close()
def addComment(articleID, comment, addr, forum):
conn = db()
cursor = conn.cursor()
time = now_time()
sql = 'insert into comment(articleID, comment,up,down,addr,forum,time) VALUES (?,?,0,0,?,?,?)'
cursor.execute(sql, (articleID, comment, addr, forum, time))
conn.commit()
cursor.close()
conn.close()
def query():
sql = "select * from blacklist"
conn = db()
cursor = conn.cursor()
cursor.execute(sql)
rows = cursor.fetchall()
conn.commit() # 提交数据库改动
cursor.close() # 关闭游标
conn.close() # 关闭数据库连接
return rows
def commentlist(self):
sql = 'select * from comment where addr=\'' + self.addr + '\''
conn = db()
cursor = conn.cursor()
cursor.execute(sql)
rows = cursor.fetchall()
conn.commit() # 提交数据库改动
cursor.close() # 关闭游标
conn.close() # 关闭数据库连接
return rows
def query(self):
sql = 'select * from sub_forums where subject = \'' + self.subject + '\''
conn = db()
cursor = conn.cursor()
cursor.execute(sql)
rows = cursor.fetchall()
conn.commit() # 提交数据库改动
cursor.close() # 关闭游标
conn.close() # 关闭数据库连接
return rows
def NumComment(articleID):
conn = db()
cursor = conn.cursor()
sql = 'select * from comment where articleID = \'' + articleID + '\''
cursor.execute(sql)
rows = cursor.fetchall()
conn.commit()
cursor.close()
conn.close()
return len(rows)
def getIpList():
sql = 'select * from ip'
conn = db()
cursor = conn.cursor()
cursor.execute(sql)
rows = cursor.fetchall()
conn.commit() # 提交数据库改动
cursor.close() # 关闭游标
conn.close()
return rows
def query():
conn = db()
cursor = conn.cursor()
sql = 'select * from forums'
cursor.execute(sql)
rows = cursor.fetchall()
conn.commit()
cursor.close()
conn.close()
return rows
def content(self):
sql = "select * from article where id=\'" + self.id + "\'"
conn = db()
cursor = conn.cursor()
cursor.execute(sql)
rows = cursor.fetchall()
conn.commit() # 提交数据库改动
cursor.close() # 关闭游标
conn.close() # 关闭数据库连接
return rows
def query(forum):
sql = "select * from article where forum=\'" + forum + "\'"
conn = db()
cursor = conn.cursor()
cursor.execute(sql)
rows = cursor.fetchall()
conn.commit() # 提交数据库改动
cursor.close() # 关闭游标
conn.close() # 关闭数据库连接
return rows
def score(self):
conn = db()
cursor = conn.cursor()
sql = 'select * from comment where id=\'' + self.id + '\''
cursor.execute(sql)
rows = cursor.fetchall()
row = rows[0]
score = row[3] - row[4]
conn.commit()
cursor.close()
conn.close()
return score
def is_in_blacklist(self):
conn = db()
cursor = conn.cursor()
sql = 'select * from blacklist where address=\'' + self.address + '\''
cursor.execute(sql)
value = cursor.fetchall()
conn.commit()
cursor.close()
conn.close()
if value == []:
return False
else:
return True
def article_add(title, address, abstract, describle, forum):
conn = db()
cursor = conn.cursor()
id = set_id()
date = time.strftime("%Y-%m-%d %H:%M", time.localtime())
sql = 'insert into article(id, title, address, "date", abstract, describe, forum,up,down,times) VALUES (?,?,?,?,?,?,?,0,0,0)'
cursor.execute(sql,
(id, title, address, date, abstract, describle, forum))
sql = 'insert into article_record(id) values (\'' + id + '\')'
cursor.execute(sql)
conn.commit()
cursor.close()
conn.close()
def sub_forum_list(a):
sql = 'select * from sub_forums where subject=\'' + a + '\''
conn = db()
cursor = conn.cursor()
cursor.execute(sql)
rows = cursor.fetchall()
conn.commit()
cursor.close()
conn.close()
l = []
for row in rows:
l.append(row[3])
return l
def score(self):
conn = db()
cursor = conn.cursor()
sql = 'select * from article where id=\'' + self.id + '\''
cursor.execute(sql)
rows = cursor.fetchall()
row = rows[0]
score = row[7] * 2 - row[8] * 2 + row[9]
sql = 'select count(*) from comment where articleID=\'' + self.id + '\''
cursor.execute(sql)
num = cursor.fetchall()
n = int(num[0][0])
score += n * 3
conn.commit()
cursor.close()
conn.close()
return score
def time_limit(addr):
sql = "select * from comment where addr=\'" + addr + "\'"
conn = db()
cursor = conn.cursor()
cursor.execute(sql)
rows = cursor.fetchall()
conn.commit() # 提交数据库改动
cursor.close() # 关闭游标
conn.close() # 关闭数据库连接
if rows == []:
return 1
time = rows[-1][7]
time = int(re.sub("\D", "", time))
now = now_time()
now = int(re.sub("\D", "", now))
if now - time < 5:
return 0
else:
return 1
