Function log_behavior

skills/storage-helper/scripts/db_ops.py:819–840

Log user behavior

(
    user_id: str,
    push_id: str,
    paper_id: Optional[int],
    action: str,
    action_type: str,
    category: str = "",
    metadata: Optional[Dict] = None
)

# ============== Behavior Log Operations ==============

def log_behavior(
    user_id: str,
    push_id: str,
    paper_id: Optional[int],
    action: str,
    action_type: str,
    category: str = "",
    metadata: Optional[Dict] = None
) -> int:
    """Log user behavior"""
    conn = get_connection()
    cursor = conn.cursor()
    cursor.execute("""
        INSERT INTO behavior_logs
        (user_id, push_id, paper_id, action, action_type, category, metadata)
        VALUES (?, ?, ?, ?, ?, ?, ?)
    """, (user_id, push_id, paper_id, action, action_type, category,
          json.dumps(metadata) if metadata else None))
    conn.commit()
    log_id = cursor.lastrowid
    conn.close()
    return log_id


def _build_created_report_record(row: sqlite3.Row, metadata: Optional[Dict[str, Any]] = None) -> Optional[Dict[str, Any]]: