Method findById

backend/src/secrets/secrets.repository.ts:126–161

(secretId: string, options: SecretQueryOptions = {})

  }

  async findById(secretId: string, options: SecretQueryOptions = {}): Promise<SecretSummary> {
    const conditions: SQL[] = [eq(secrets.id, secretId)];
    if (options.organizationId) {
      conditions.push(eq(secrets.organizationId, options.organizationId));
    }

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

    const rows = await 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)),
      )
      .where(whereClause)
      .limit(1);

    const row = rows[0];
    if (!row) {
      throw new NotFoundException(`Secret ${secretId} not found`);
    }

    return this.mapSummary(row);
  }

  async findValueBySecretId(
    secretId: string,