def read_post(self):
pid = int(self.argv[1])
if not db.post_existed_check(pid):
return "Post does not exist."
post = ""
result = db.select_post(pid = pid)
object_name = result[0][3]
comment_object_name = result[0][4]
post = "Author\t:{}\nTitle\t:{}\nDate\t:{}\n--\n".format(result[0][0], result[0][1], result[0][2])
return '&<!read::>' + db.get_bucket(result[0][0]) + '&<!spl>' + object_name + '&<!spl>' + comment_object_name + '&<!meta|msg>' + post
def read_post(self):
pid = int(self.argv[1])
if not db.post_existed_check(pid):
return "Post does not exist."
post = ""
result = db.select_post(pid=pid)
content = result[0][3].replace("\r\n", "\r\n ")
post = " Author\t:{}\r\n Title\t:{}\r\n Date\t:{}\r\n --\r\n {}\r\n --".format(
result[0][0], result[0][1], result[0][2], content)
comments = ""
results = db.select_comment(pid=pid)
for row in results:
comments += "\r\n {}: {}".format(row[2], row[3])
return post + comments
def list_post(self):
boardname = self.argv[1]
if not db.board_existed_check(boardname):
return "Board does not exist."
header = "\tID\tTitle\tAuthor\tDate"
data = ""
key = ""
if len(self.argv) == 3:
if self.argv[2][0:2] == "##":
key = self.argv[2][2:]
else:
return self.usage()
results = db.select_post(boardname = boardname, key = key)
for row in results:
data += "\n\t{}\t{}\t{}\t{}".format(row[0], row[1], row[2], row[3][5:7]+'/'+row[3][8:10])
return header + data
def list_post(self):
boardname = self.argv[1]
if not db.board_existed_check(boardname):
return "Board does not exist."
header = " ID Title Author Date"
data = ""
key = ""
if len(self.argv) == 3:
if self.argv[2][0:2] == "##":
key = self.argv[2][2:]
else:
return self.usage()
results = db.select_post(boardname=boardname, key=key)
for row in results:
data += "\r\n {}{}{}{}".format(
str(row[0]).ljust(8, ' '), row[1].ljust(16, ' '),
row[2].ljust(16, ' '), row[3][5:7] + '/' + row[3][8:10])
return header + data
def select_post(pid):
if cp.has(pid): return cp.get(pid);
dbout = db.select_post(pid);
if not dbout: return None;
cp.put(pid, dbout);
return cp.get(pid);
def select_post(pid):
if cp.has(pid): return cp.get(pid)
dbout = db.select_post(pid)
if not dbout: return None
cp.put(pid, dbout)
return cp.get(pid)