Method listHubUsers

packages/memos-core/src/storage/sqlite.ts:2179–2188

(status?: UserStatus)

  }

  listHubUsers(status?: UserStatus): HubUserRecord[] {
    const rows = status
      ? this.db.prepare('SELECT * FROM hub_users WHERE status = ? ORDER BY created_at').all(status) as HubUserRow[]
      : this.db.prepare('SELECT * FROM hub_users ORDER BY created_at').all() as HubUserRow[];
    return rows.map(r => {
      const user = rowToHubUser(r);
      user.groups = this.getGroupsForHubUser(r.id);
      return user;
    });
  }

  deleteHubMemoriesByUser(userId: string): void {
    this.db.prepare('DELETE FROM hub_memories WHERE source_user_id = ?').run(userId);