Method getGroupsForHubUser

packages/memos-core/src/storage/sqlite.ts:2250–2256

(userId: string)

  }

  getGroupsForHubUser(userId: string): Array<{ id: string; name: string; description: string }> {
    return this.db.prepare(`
      SELECT g.id, g.name, g.description FROM hub_groups g
      JOIN hub_group_members m ON m.group_id = g.id
      WHERE m.user_id = ?
    `).all(userId) as Array<{ id: string; name: string; description: string }>;
  }

  getHubUserContributions(): Record<string, { memoryCount: number; taskCount: number; skillCount: number }> {
    const result: Record<string, { memoryCount: number; taskCount: number; skillCount: number }> = {};