Function reset_user_profiles

scripts/clear_database.py:179–212

Replace stored profiles with fresh role-specific seed profiles.

(
    conn: sqlite3.Connection,
    roles_meta: Dict[str, Any],
    roles: Optional[Iterable[str]] = None,
)

def reset_user_profiles(
    conn: sqlite3.Connection,
    roles_meta: Dict[str, Any],
    roles: Optional[Iterable[str]] = None,
) -> Dict[str, Dict[str, float]]:
    """Replace stored profiles with fresh role-specific seed profiles."""
    all_roles = roles_meta.get("roles", {})
    target_roles = list(roles) if roles else list(all_roles.keys())

    missing_roles = [role_name for role_name in target_roles if role_name not in all_roles]
    if missing_roles:
        raise ValueError(f"Unknown roles: {', '.join(missing_roles)}")

    cursor = conn.cursor()
    cursor.execute("DELETE FROM profiles")

    seeded_profiles: Dict[str, Dict[str, float]] = {}
    for role_name in target_roles:
        role_data = all_roles[role_name]
        profile = build_seed_profile(role_name, role_data)
        cursor.execute(
            """
            INSERT INTO profiles (user_id, profile_json, version, updated_at)
            VALUES (?, ?, ?, CURRENT_TIMESTAMP)
            """,
            (
                profile["user_id"],
                json.dumps(profile, ensure_ascii=False),
                profile.get("version", "0.1"),
            ),
        )
        seeded_profiles[role_name] = dict(profile.get("core_directions") or {})

    return seeded_profiles


def clear_tables(conn: sqlite3.Connection, table_names: Iterable[str]) -> None: