Function create_profile

skills/storage-helper/scripts/db_ops.py:536–553

Create a new user profile

(user_id: str, profile_json: Dict)

# ============== Profile Operations ==============

def create_profile(user_id: str, profile_json: Dict) -> Optional[int]:
    """Create a new user profile"""
    conn = get_connection()
    cursor = conn.cursor()
    try:
        cursor.execute("""
            INSERT INTO profiles (user_id, profile_json, version)
            VALUES (?, ?, ?)
        """, (user_id, json.dumps(profile_json), profile_json.get("version", "0.1")))
        conn.commit()
        profile_id = cursor.lastrowid
        print(f"Profile created with id: {profile_id}")
        return profile_id
    except sqlite3.IntegrityError:
        print(f"Profile already exists for user: {user_id}")
        return None
    finally:
        conn.close()


def save_paper(