Function profiler_sync_from_user_profile

Scripts/ButSystem.py:15240–15321

Ensure a user's My Profile is mirrored into their Profiler list. This creates (or updates) one special encrypted Profiler entry owned by the same user. No username is excluded from the profile -> profiler sync.

(username: str)

                SELECT g.id, g.name, g.owner, g.created_at, m.role AS my_role
                FROM groups g
                JOIN group_members m ON m.group_id=g.id
                WHERE m.username=?
                ORDER BY g.id DESC
                """,
                (me,),
            ).fetchall()
            return rows
        finally:
            conn.close()

    try:
        rows = _fetch_rows()
    except Exception:
        # One more attempt after ensuring schema (covers 'no such table' cases)
        try:
            db_init()
        except Exception:
            pass
        rows = _fetch_rows()

    class Obj:
        def __init__(self, r):
            self.__dict__.update(dict(r))

    return render_template("groups.html", title="Groups", gs=[Obj(r) for r in rows])

@app.route("/groups/create", methods=["POST"])
@login_required
def group_create():
    """group_create.

Chat/group feature helper or route handler.

This docstring was expanded to make future maintenance easier.

Returns:
    Varies.
"""
    me = current_user()
    name = (request.form.get("name") or "").strip()[:64]
    members_raw = (request.form.get("members") or "").strip()
    if not name:
        flash("Group name required.")
        return redirect(url_for("groups"))

    members = set()
    if members_raw:
        for part in members_raw.split(","):
            part = part.strip()
            if part:
                members.add(part)
    members.add(me)

    valid = set(all_usernames())
    members = [m for m in members if m in valid]

    conn = db_connect()
    cur = conn.cursor()