Function get_recent_pushes

skills/storage-helper/scripts/db_ops.py:1266–1297

Get recently pushed papers for a user Args: user_id: User ID limit: Maximum number of papers to return Returns: List of papers with push information

(user_id: str, limit: int = 50)

# ============== Recent Push Operations ==============

def get_recent_pushes(user_id: str, limit: int = 50) -> List[Dict]:
    """
    Get recently pushed papers for a user

    Args:
        user_id: User ID
        limit: Maximum number of papers to return

    Returns:
        List of papers with push information
    """
    conn = get_connection()
    cursor = conn.cursor()

    # Get papers pushed in the last 7 days
    since_date = (datetime.now() - timedelta(days=7)).date().isoformat()

    cursor.execute("""
        SELECT p.*, bl.push_id, bl.timestamp as pushed_at, bl.metadata
        FROM papers p
        JOIN behavior_logs bl ON p.id = bl.paper_id
        WHERE bl.user_id = ?
          AND bl.action = 'pushed'
          AND date(bl.timestamp) >= ?
        ORDER BY bl.timestamp DESC
        LIMIT ?
    """, (user_id, since_date, limit))

    rows = cursor.fetchall()
    conn.close()

    return [_build_paper_dict(row) for row in rows]


def get_latest_push(user_id: str) -> Optional[Dict]: