서버의 핀, 폰의 핀

def save(raw: dict, *, conversation_id: str | None) -> dict:
    # A private turn must leave no durable trace in the shared map.
    if conversation_id and conversation_id.startswith("priv-"):
        raise ValueError("Private conversations cannot save shared Pathfinder pins.")
    place = my_places.normalize_place(raw)
    if place is None:
        raise ValueError("A pin needs a name and finite latitude/longitude on the globe.")
    trip = my_places._text(raw.get("trip"), 120)
    key = json.dumps([trip or "", place["name"].casefold(), round(place["lat"], 5), round(place["lon"], 5)])
    fingerprint = hashlib.sha256(key.encode()).hexdigest()
    pin = {k: place[k] for k in ("name", "lat", "lon")}
    pin.update(note=my_places._text(raw.get("note"), 1000), trip=trip,
               source_conversation=conversation_id,
               added_at=dad_location.stamp(datetime.now(timezone.utc)))
    # A large building's door, so Pathfinder walks Dad to it on its level
    # instead of the map's centre point (todo #369).
    entrance = dad_location.normalize_entrance(raw, place["lat"], place["lon"])
    if entrance:
        pin["entrance"] = entrance

# A minimal sketch of the place_pins upsert: one fingerprint per
# (trip, name, rounded point); a re-pin keeps its id, its first stamp and its row.
import hashlib, json, sqlite3, uuid
from datetime import datetime, timezone

db = sqlite3.connect(":memory:")
db.execute("CREATE TABLE pins (id TEXT PRIMARY KEY, fingerprint TEXT UNIQUE NOT NULL, body TEXT NOT NULL)")

def save(name, lat, lon, trip=None, note=None):
    key = json.dumps([trip or "", name.casefold(), round(lat, 5), round(lon, 5)])
    fingerprint = hashlib.sha256(key.encode()).hexdigest()
    pin = dict(name=name, lat=lat, lon=lon, note=note, trip=trip,
               added_at=datetime.now(timezone.utc).isoformat())
    with db:
        old = db.execute("SELECT body FROM pins WHERE fingerprint = ?", (fingerprint,)).fetchone()
        if old:
            previous = json.loads(old[0])
            pin.update(id=previous["id"], added_at=previous["added_at"])
            if pin["note"] is None:
                pin["note"] = previous.get("note")
        else:
            pin["id"] = uuid.uuid4().hex[:8]
        db.execute("INSERT INTO pins VALUES (?, ?, ?) "
                   "ON CONFLICT(fingerprint) DO UPDATE SET body=excluded.body",
                   (pin["id"], fingerprint, json.dumps(pin)))
    return pin

def listing():
    return [json.loads(b)["name"] + ":" + str(json.loads(b)["note"])
            for (b,) in db.execute("SELECT body FROM pins ORDER BY rowid DESC")]

a = save("Cafe Uno", 48.85837, 2.29448, trip="Paris", note="good coffee")
save("Bakery", 48.86061, 2.33760, trip="Paris")
again = save("CAFE UNO", 48.858372, 2.294481, trip="Paris")   # same place, said again
print("same id:", a["id"] == again["id"], "| same stamp:", a["added_at"] == again["added_at"])
print("rows:", db.execute("SELECT count(*) FROM pins").fetchone()[0])
print("newest first:", listing())
other = save("Cafe Uno", 48.85837, 2.29448, trip="Another trip")
print("another trip is another pin:", other["id"] != a["id"])

# Output:
# same id: True | same stamp: True
# rows: 2
# newest first: ['Bakery:None', 'CAFE UNO:good coffee']
# another trip is another pin: True

  /// Newest recommendation first: the default order (Dad, todo #390).
  public var visible: [PlacePin] { ordered(.newestFirst) }

  /// The pins in Dad's chosen order, whatever order the server or an older
  /// saved replica holds. Undated pins keep their order after the dated ones.
  public func ordered(_ order: PinOrder) -> [PlacePin] {
    snapshot.pins.enumerated()
      .filter { !removals.contains($0.element.id) }
      .map { (pin: $0.element, added: $0.element.addedDate, index: $0.offset) }
      .sorted { lhs, rhs in
        switch (lhs.added, rhs.added) {
        case let (l?, r?) where l != r: order == .newestFirst ? l > r : l < r
        case (_?, nil): true
        case (nil, _?): false
        default: lhs.index < rhs.index
        }
      }
      .map(\.pin)
  }