def post(self, content_id):
username = self.get_secure_cookie("user")
databaseOperations.connectToDatabase('astrodb')
if not self.current_user or databaseOperations.isBanned(username) or not databaseOperations.isVerified(username):
self.redirect("/login")
return
(comment, user) = (self.get_argument("comment", None), self.current_user)
date = time.strftime("%d %b %G %H:%M", time.localtime(time.time()))
user_id = databaseOperations.getIDFromUser(user)[0]
content_type = databaseOperations.getContentTypeFromID(content_id)[0]
print content_type
if not comment:
self.redirect( "/show%s/%s" %(content_type, str(content_id)) )
return
databaseOperations.insertComment(content_id, user_id, comment, date)
databaseOperations.closeConnectionToDatabase()
self.redirect( "/show%s/%s" %(content_type, str(content_id)) )
def get(self, comment_id):
try:
if not self.current_user:
self.redirect("/login")
return
databaseOperations.connectToDatabase('astrodb')
content_id = databaseOperations.getContentIDFromCommentID(comment_id)[0]
content_type = databaseOperations.getContentTypeFromID(content_id)[0]
contentPath = "/show%s/%s" %(content_type, str(content_id))
user = databaseOperations.getUserFromCommentID(comment_id)[0]
if user == self.get_secure_cookie("user") or databaseOperations.isAdmin(self.get_secure_cookie("user")):
#if user is the author of the comment, or if admin
databaseOperations.deleteComment(comment_id)
databaseOperations.closeConnectionToDatabase()
self.redirect( contentPath )
except:
print "Error deleting comment with comment id", comment_id
