get_all_topics function

[MagnusLii]

Vote History Data Retrieval Function from DB

Goal

This function should contain a pre-defined SQL query to retrieve the entire vote history from the database. After obtaining this information, the function transforms it into JSON string format.

Arguments

• None

Returns

• JSON formatted data: Contains votes, where each vote includes an ID and the corresponding vote name/topic.

Function Name: get_all_topics

[MagnusLii]

The function utilizes SQLAlchemy instead of queries.

# GET all topics (votes) from the database.
def get_all_topics():
    try:
        topics = Topics.query.all()
        topic_data_list = []

        for topic in topics:
            topic_data = {
                "TopicID": topic.TopicID,
                "Title": topic.Title,
                "Description": topic.Description,
                "StartTime": str(topic.StartTime),
                "EndTime": str(topic.EndTime)
            }
            topic_data_list.append(topic_data)

        return jsonify(topic_data_list)

    except Exception as errorMsg:
        error_message = {"error": str(errorMsg)}
        return jsonify(error_message), 500