Function get_feed_data

api/app/api/utils/caesar_logging.py:251–281

(app)

@failsoft
def get_feed_data(app):
    if not EVENTS_ENGINE:
        return None

    params = {
        "app": app,
    }

    query = text("""
        select input_text, category, emoji, id
        from featured_queries
        where app = :app
        and featured = true
    """)

    with EVENTS_ENGINE.connect() as conn:
        result = conn.execute(query, params)
        conn.commit()
        rows = result.fetchall()

        rows = [
            {
                "input_text": row[0],
                "category": row[1],
                "emoji": row[2],
                "img": "https://census-gpt-assets.s3.us-west-2.amazonaws.com/" + str(row[3]) + ".png",
            }
            for row in rows
        ]

    return rows