def getArrayPostsFormDDictionary(dictionary, related):
from Thread import getThreadDetailsByID
from User import getUserInfoByEmail
from Forum import getForumDetailsByShortName
array = []
for item in dictionary:
dict = {}
dict["id"] = item[0]
dict["parent"] = item[1]
dict["isApproved"] = item[2]
dict["isHighlighted"] = item[3]
dict["isEdited"] = item[4]
dict["isSpam"] = item[5]
dict["isDeleted"] = item[6]
dict["likes"] = item[7]
dict["dislikes"] = item[8]
dict["date"] = str(item[9])
dict["message"] = item[10]
dict["forum"] = getForumShortNameById(item[11])
dict["thread"] = item[12]
dict["user"] = getUserEmailByID(item[13])
dict["points"] = dict["likes"] - dict["dislikes"]
if "thread" in related:
dict["thread"] = getThreadDetailsByID(dict["thread"], [])
if "user" in related:
dict["user"] = getUserInfoByEmail(dict["user"])
if "forum" in related:
dict["forum"] = getForumDetailsByShortName(dict["forum"])
# logging.info(" dictionary item, no message : " + str(dict))
array.append(dict)
return array
def getArrayPostsFormDDictionary(dictionary, related):
from Thread import getThreadDetailsByID
from User import getUserInfoByEmail
from Forum import getForumDetailsByShortName
array = []
for item in dictionary:
dict = {}
dict["id"] = item[0]
dict["parent"] = item[1]
dict["isApproved"] = item[2]
dict["isHighlighted"] = item[3]
dict["isEdited"] = item[4]
dict["isSpam"] = item[5]
dict["isDeleted"] = item[6]
dict["likes"] = item[7]
dict["dislikes"] = item[8]
dict["date"] = str(item[9])
dict["message"] = item[10]
dict["forum"] = getForumShortNameById(item[11])
dict["thread"] = item[12]
dict["user"] = getUserEmailByID(item[13])
dict["points"] = dict["likes"] - dict["dislikes"]
if "thread" in related:
dict["thread"] = getThreadDetailsByID(dict["thread"], [])
if "user" in related:
dict["user"] = getUserInfoByEmail(dict["user"])
if "forum" in related:
dict["forum"] = getForumDetailsByShortName(dict["forum"])
logging.info(" dictionary item, no message : " + str(dict))
array.append(dict)
return array
def getPostDetailsByID(postID, related):
sql = "SELECT * FROM Post WHERE idPost = %s"
cursor.execute(sql, [postID])
data = cursor.fetchone()
# logging.info(data)
if (not data):
#logging.info(" Thread not found")
return None
answer = {}
answer["id"] = data[0]
answer["parent"] = data[1]
answer["isApproved"] = data[2]
answer["isHighlighted"] = data[3]
answer["isEdited"] = data[4]
answer["isSpam"] = data[5]
answer["isDeleted"] = data[6]
answer["likes"] = data[7]
answer["dislikes"] = data[8]
answer["date"] = str(data[9])
answer["message"] = data[10]
answer["forum"] = getForumShortNameById(data[11])
answer["thread"] = data[12]
answer["user"] = getUserEmailByID(data[13])
answer["points"] = answer["likes"] - answer["dislikes"]
if "user" in related:
data_user = getUserInfoByEmail(answer["user"])
answer["user"] = data_user
if "forum" in related:
answer["forum"] = getForumDetailsByShortName(answer["forum"])
if "thread" in related:
answer["thread"] = getThreadDetailsByID(answer["thread"], [])
# logging.info(" ===========Answer getPostByID() : ")
# logging.info(answer)
#logging.info(" ===================================")
return answer
def getPostDetailsByID(postID, related):
sql = "SELECT * FROM Post WHERE idPost = %s"
cursor.execute(sql, [postID])
data = cursor.fetchone()
logging.info(data)
if (not data):
logging.info(" Thread not found")
return None
answer = {}
answer["id"] = data[0]
answer["parent"] = data[1]
answer["isApproved"] = data[2]
answer["isHighlighted"] = data[3]
answer["isEdited"] = data[4]
answer["isSpam"] = data[5]
answer["isDeleted"] = data[6]
answer["likes"] = data[7]
answer["dislikes"] = data[8]
answer["date"] = str(data[9])
answer["message"] = data[10]
answer["forum"] = getForumShortNameById(data[11])
answer["thread"] = data[12]
answer["user"] = getUserEmailByID(data[13])
answer["points"] = answer["likes"] - answer["dislikes"]
if "user" in related:
data_user = getUserInfoByEmail(answer["user"])
answer["user"] = data_user
if "forum" in related:
answer["forum"] = getForumDetailsByShortName(answer["forum"])
if "thread" in related:
answer["thread"] = getThreadDetailsByID(answer["thread"], [])
logging.info(" ===========Answer getPostByID() : ")
logging.info(answer)
logging.info(" ===================================")
return answer
