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