Method upsertHubUser

packages/memos-core/src/storage/sqlite.ts:2151–2169

(user: HubUserRecord)

  // ─── Hub Users / Groups ───

  upsertHubUser(user: HubUserRecord): void {
    this.db.prepare(`
      INSERT INTO hub_users (id, username, device_name, role, status, token_hash, created_at, approved_at, identity_key, left_at, removed_at, rejected_at, rejoin_requested_at)
      VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
      ON CONFLICT(id) DO UPDATE SET
        username = excluded.username,
        device_name = excluded.device_name,
        role = excluded.role,
        status = excluded.status,
        token_hash = excluded.token_hash,
        created_at = excluded.created_at,
        approved_at = excluded.approved_at,
        identity_key = excluded.identity_key,
        left_at = excluded.left_at,
        removed_at = excluded.removed_at,
        rejected_at = excluded.rejected_at,
        rejoin_requested_at = excluded.rejoin_requested_at
    `).run(user.id, user.username, user.deviceName ?? "", user.role, user.status, user.tokenHash, user.createdAt, user.approvedAt, user.identityKey ?? "", user.leftAt ?? null, user.removedAt ?? null, user.rejectedAt ?? null, user.rejoinRequestedAt ?? null);
  }

  getHubUser(userId: string): HubUserRecord | null {
    const row = this.db.prepare('SELECT * FROM hub_users WHERE id = ?').get(userId) as HubUserRow | undefined;