Method listSecrets

backend/src/secrets/secrets.repository.ts:50–87

(options: SecretQueryOptions = {})

  ) {}

  async listSecrets(options: SecretQueryOptions = {}): Promise<SecretSummary[]> {
    const baseQuery = this.db
      .select({
        id: secrets.id,
        name: secrets.name,
        description: secrets.description,
        tags: secrets.tags,
        createdAt: secrets.createdAt,
        updatedAt: secrets.updatedAt,
        versionId: secretVersions.id,
        version: secretVersions.version,
        versionCreatedAt: secretVersions.createdAt,
        versionCreatedBy: secretVersions.createdBy,
      })
      .from(secrets)
      .leftJoin(
        secretVersions,
        and(eq(secretVersions.secretId, secrets.id), eq(secretVersions.isActive, true)),
      );

    const conditions: SQL[] = [];
    if (options.organizationId) {
      conditions.push(eq(secrets.organizationId, options.organizationId));
    }

    const whereClause =
      conditions.length === 0
        ? undefined
        : conditions.length === 1
          ? conditions[0]
          : and(...conditions);

    const rows = await (whereClause ? baseQuery.where(whereClause) : baseQuery).orderBy(
      secrets.name,
    );

    return rows.map((row) => this.mapSummary(row));
  }

  async findByName(secretName: string, options: SecretQueryOptions = {}): Promise<SecretSummary> {
    const conditions: SQL[] = [eq(secrets.name, secretName)];