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