Interface TenantStore

mcp/src/server/sqlite.ts:571–601

// -----------------------------------------------------------------------------

export interface TenantStore {
  // Organizations
  createOrganization(name: string): Organization;
  getOrganization(id: string): Organization | undefined;

  // Users
  createUser(email: string, orgId: string, role?: UserRole): User;
  getUser(id: string): User | undefined;
  getUserByEmail(email: string): User | undefined;
  getUsersByOrg(orgId: string): User[];

  // API Keys
  createApiKey(userId: string, name: string, expiresAt?: string): { apiKey: ApiKey; rawKey: string };
  getApiKeyByHash(hash: string): ApiKey | undefined;
  listApiKeys(userId: string): ApiKey[];
  deleteApiKey(id: string): boolean;
  updateApiKeyLastUsed(id: string): void;

  // User-scoped sessions
  createSessionForUser(userId: string, url: string, projectId?: string): Session;
  listSessionsForUser(userId: string): Session[];
  getSessionForUser(userId: string, sessionId: string): Session | undefined;
  getSessionWithAnnotationsForUser(userId: string, sessionId: string): SessionWithAnnotations | undefined;

  // User-scoped annotations
  getPendingAnnotationsForUser(userId: string, sessionId: string): Annotation[];
  getAllPendingForUser(userId: string): Annotation[];

  // Lifecycle
  close(): void;
}

// -----------------------------------------------------------------------------
// Tenant Store Implementation