Seats and Games as an Account: one Seat across devices, Games owned and listed by the Account #382

New issue

Closed

opened 2026-10-11 16:27:08 +00:00 by root · 13 comments

root commented

2026-10-11 16:27:08 +00:00

(Migrated from gitlab.core-project.space)

Imported from GitHub amaurycoudr/chess-project#382, opened by @amaurycoudr on 2026-10-11 16:27 UTC.

Parent

#364

What to build

A call with a Session creates a Room or takes a Seat as its Account; without one, as its Guest. A call is a Seat's occupant when either its Account or its Guest matches. So a second signed-in device opens the same Seat, a browser that signed in mid-Game keeps its Guest-held Seat, and signing out leaves the Seat taken and disconnected. A caller who already occupies a Seat by either identity cannot take the other. The room.changes stream identifies its Connection once, when it opens.

A decided Game records each Color's owner as an Account or a Guest. The games table gains a nullable account owner per Color with ON DELETE SET NULL and at most one owner per Color. An owner whose Account was deleted before the Game ended is stored as no owner. game.list and game.get answer as the caller's Account when there is a Session, else their Guest. The Seat view in the snapshot and each side in a Game read gain the occupant's name: an Account with its Username, or a Guest. No email, account id or hash crosses the wire.

Seam: the RPC wire

Acceptance criteria

Create and take record the Account with a Session and the Guest without one
One Account on two devices, with the other Seat free, never takes it; the second device is seated in the same Seat
Signing in mid-Game keeps the Guest-held Seat playable from that browser
Signing out leaves the Seat taken and disconnected, and signing in again resumes it
A decided Game is stored with the Account as owner; one decided after its Account owner was deleted is stored with no owner for that Color
game.list as an Account lists its Games newest first, including when it has none; game.get as the Account answers its Color
The snapshot's Seats and the sides of game.list and game.get carry the occupant's name and nothing else that identifies them
The migration adds the owner columns, the one-owner-per-Color check and the indexes for "My games"

> _Imported from GitHub [amaurycoudr/chess-project#382](https://github.com/amaurycoudr/chess-project/issues/382), opened by [@amaurycoudr](https://github.com/amaurycoudr) on 2026-10-11 16:27 UTC._  --- ## Parent #364 ## What to build A call with a **Session** creates a **Room** or takes a **Seat** as its **Account**; without one, as its **Guest**. A call is a **Seat**'s occupant when either its **Account** or its **Guest** matches. So a second signed-in device opens the same **Seat**, a browser that signed in mid-**Game** keeps its **Guest**-held **Seat**, and signing out leaves the **Seat** taken and disconnected. A caller who already occupies a **Seat** by either identity cannot take the other. The `room.changes` stream identifies its **Connection** once, when it opens. A decided **Game** records each **Color**'s owner as an **Account** or a **Guest**. The `games` table gains a nullable account owner per **Color** with `ON DELETE SET NULL` and at most one owner per **Color**. An owner whose **Account** was deleted before the **Game** ended is stored as no owner. `game.list` and `game.get` answer as the caller's **Account** when there is a **Session**, else their **Guest**. The **Seat** view in the snapshot and each side in a **Game** read gain the occupant's name: an **Account** with its **Username**, or a **Guest**. No email, account id or hash crosses the wire. Seam: the RPC wire ## Acceptance criteria - [ ] Create and take record the **Account** with a **Session** and the **Guest** without one - [ ] One **Account** on two devices, with the other **Seat** free, never takes it; the second device is seated in the same **Seat** - [ ] Signing in mid-**Game** keeps the **Guest**-held **Seat** playable from that browser - [ ] Signing out leaves the **Seat** taken and disconnected, and signing in again resumes it - [ ] A decided **Game** is stored with the **Account** as owner; one decided after its **Account** owner was deleted is stored with no owner for that **Color** - [ ] `game.list` as an **Account** lists its **Games** newest first, including when it has none; `game.get` as the **Account** answers its **Color** - [ ] The snapshot's **Seats** and the sides of `game.list` and `game.get` carry the occupant's name and nothing else that identifies them - [ ] The migration adds the owner columns, the one-owner-per-**Color** check and the indexes for "My games"

root commented

2026-10-11 16:27:08 +00:00

(Migrated from gitlab.core-project.space)

GitHub issue relations, imported as "related" links (GitLab CE has no sub-issues or blocking links).

Parent (sub-issue of): #364
Blocked by: #378
Blocking: #384, #383

> _GitHub issue relations, imported as "related" links (GitLab CE has no sub-issues or blocking links)._  - Parent (sub-issue of): #364 - Blocked by: #378 - Blocking: #384, #383

root commented

2026-10-13 08:39:49 +00:00

(Migrated from gitlab.core-project.space)

mentioned in issue #383