Social Feed (For You Page)

@feed_bp.route('/api/fyp',methods=['GET'])
def fyp():
    token = request.headers.get('Authorization')
    if not token:
        return jsonify({'error':'invalid token , please login again'}),401
    
    # Authenticate user
    c.execute('SELECT username FROM users WHERE token=?',(token,))
    user = c.fetchone()
    username = user[0]
    
    # Get list of followed users
    c.execute('SELECT following FROM following WHERE follower=?',(username,))
    followed = c.fetchall()
    if followed:
        followed_users = [f[0] for f in followed]
    else:
        return jsonify({'message':'no users being followed , yet'}),200
    
    # Get recent posts from followed users
    placeholders = ','.join(['?'] * len(followed_users))
    query = '''SELECT id, username, content, created_at, upvotes, downvotes 
               FROM posts 
               WHERE username IN ({}) 
               ORDER BY created_at DESC 
               LIMIT 20'''.format(placeholders)
    c.execute(query, followed_users)
    recent_posts = c.fetchall()

# Extract hashtags from recent global posts
hashtags = []
for post in global_posts_data:
    if 'content' in post:
        found_hashtags = re.findall(r'#(\w+)', post['content'])
        hashtags.extend(found_hashtags)
        
# Get top 3 trending hashtags
hashtag_counts = Counter(hashtags)
trending_hashtags = hashtag_counts.most_common(3)
trending_topics = [f'#{tag}' for tag, count in trending_hashtags]

return jsonify({
    'posts': combined_posts,
    'trending_topics': trending_topics
}), 200

if not followed:
    return jsonify({'message':'no users being followed , yet'}),200