Function profiler_collect_optional

Scripts/ButSystem.py:15109–15165

profiler_collect_optional. Internal helper function. This docstring was added automatically to improve maintainability. Args: form: Parameter. Returns: Varies.

(form)

        acc = None
    sharing = 1 if bool(data.get("sharing")) else 0
    if not (-90.0 <= lat <= 90.0 and -180.0 <= lon <= 180.0):
        return jsonify({"ok": False, "error": "Invalid coordinates"}), 400

    conn = db_connect()
    conn.execute("""
        INSERT INTO user_locations(username, lat, lon, accuracy, sharing, updated_at)
        VALUES(?,?,?,?,?,?)
        ON CONFLICT(username) DO UPDATE SET
            lat=excluded.lat, lon=excluded.lon, accuracy=excluded.accuracy,
            sharing=excluded.sharing, updated_at=excluded.updated_at
    """, (me, lat, lon, acc, sharing, now_z()))
    conn.commit()
    conn.close()
    return jsonify({"ok": True})

@app.route("/api/location/stop", methods=["POST"])
@login_required
def api_location_stop():
    """api_location_stop.

Route handler or application helper.

This docstring was expanded to make future maintenance easier.

Returns:
    Varies.
"""
    me = current_user()
    conn = db_connect()
    conn.execute("UPDATE user_locations SET sharing=0, updated_at=? WHERE username=?", (now_z(), me))
    conn.commit()
    conn.close()
    return jsonify({"ok": True})

@app.route("/api/locations")
@login_required
def api_locations():
    """api_locations.

Route handler or application helper.

This docstring was expanded to make future maintenance easier.

Returns:
    Varies.
"""
    conn = db_connect()
    rows = conn.execute("""
        SELECT l.username, l.lat, l.lon, l.accuracy, l.updated_at, p.nickname_enc
        FROM user_locations l
        LEFT JOIN profiles p ON p.username=l.username
        WHERE l.sharing=1 AND l.lat IS NOT NULL AND l.lon IS NOT NULL
        ORDER BY l.updated_at DESC
        LIMIT 200
    """).fetchall()
    items = []
    for r in rows:
        nick = r["username"]