Esempio n. 1
0
	def get(self, content_id):
		databaseOperations.connectToDatabase('astrodb')
		
		if self.current_user:
			sessionUserID = databaseOperations.getIDFromUser(self.get_secure_cookie("user"))[0]
		else:
			sessionUserID = -1
		
		code=databaseOperations.fetchCode(content_id)
		if code:
			path = '../code/' + str(code[0])
			codeFile = open(path, 'r+')
			codeContent = codeFile.read()
			codeFile.close()
		else:
			codeContent = None
		
		self.render("../showcode.html", 
			userName=self.get_secure_cookie("user"),
			code=code, 
			codeContent = codeContent, 
			sessionUserID = sessionUserID,
			isAdmin=databaseOperations.isAdmin(self.get_secure_cookie("user")),
			commentNum=databaseOperations.fetchCommentNum(content_id), 
			comments=databaseOperations.fetchComments(content_id), 
			contentID=content_id)
		databaseOperations.closeConnectionToDatabase()
Esempio n. 2
0
	def get(self, content_id):
		databaseOperations.connectToDatabase('astrodb')
		
		if self.current_user:
			sessionUserID = databaseOperations.getIDFromUser(self.get_secure_cookie("user"))[0]
		else:
			sessionUserID = -1
		
		news = databaseOperations.fetchNews(content_id)
		if news:
			path = '../news/' + str(news[0])
			newsFile = open(path, 'r+')
			newsContent = newsFile.read()
			newsFile.close()
		else:
			newsContent = None
		
		self.render("../shownews.html", 
			userName=self.get_secure_cookie("user"),
			news=news,
			newsContent = newsContent,
			sessionUserID = sessionUserID,
			isAdmin=databaseOperations.isAdmin(self.get_secure_cookie("user")),
			commentNum=databaseOperations.fetchCommentNum(content_id), 
			comments=databaseOperations.fetchComments(content_id), 
			contentID=content_id )
		databaseOperations.closeConnectionToDatabase()
Esempio n. 3
0
	def get(self, content_id):
		databaseOperations.connectToDatabase('astrodb')
		
		if self.current_user:
			sessionUserID = databaseOperations.getIDFromUser(self.get_secure_cookie("user"))[0]
		else:
			sessionUserID = -1
		
		self.render("../showart.html", 
			userName=self.get_secure_cookie("user"),
			art=databaseOperations.fetchArt(content_id), 
			sessionUserID = sessionUserID,
			isAdmin=databaseOperations.isAdmin(self.get_secure_cookie("user")),
			commentNum=databaseOperations.fetchCommentNum(content_id), 
			comments=databaseOperations.fetchComments(content_id), 
			contentID=content_id)
		databaseOperations.closeConnectionToDatabase()