Method createSecret

backend/src/secrets/secrets.repository.ts:201–254

(
    secretData: Omit<NewSecret, 'id' | 'createdAt' | 'updatedAt'>,
    versionData: Omit<NewSecretVersion, 'id' | 'secretId' | 'version' | 'createdAt' | 'isActive'>,
  )

  }

  async createSecret(
    secretData: Omit<NewSecret, 'id' | 'createdAt' | 'updatedAt'>,
    versionData: Omit<NewSecretVersion, 'id' | 'secretId' | 'version' | 'createdAt' | 'isActive'>,
  ): Promise<SecretSummary> {
    try {
      return await this.db.transaction(async (tx) => {
        const [secret] = await tx
          .insert(secrets)
          .values({
            ...secretData,
            organizationId: secretData.organizationId ?? DEFAULT_ORGANIZATION_ID,
          })
          .returning();

        const newVersionNumber = 1;

        const [insertedVersion] = await tx
          .insert(secretVersions)
          .values({
            ...versionData,
            secretId: secret.id,
            version: newVersionNumber,
            isActive: true,
            organizationId:
              versionData.organizationId ?? secret.organizationId ?? DEFAULT_ORGANIZATION_ID,
          })
          .returning();

        const [updatedSecret] = await tx
          .update(secrets)
          .set({ updatedAt: sql`now()` })
          .where(eq(secrets.id, secret.id))
          .returning();

        return this.mapSummary({
          id: updatedSecret.id,
          name: updatedSecret.name,
          description: updatedSecret.description,
          tags: updatedSecret.tags,
          createdAt: updatedSecret.createdAt,
          updatedAt: updatedSecret.updatedAt,
          versionId: insertedVersion.id,
          version: insertedVersion.version,
          versionCreatedAt: insertedVersion.createdAt,
          versionCreatedBy: insertedVersion.createdBy,
        });
      });
    } catch (error: any) {
      if (error?.code === '23505') {
        throw new ConflictException(`Secret name '${secretData.name}' already exists`);
      }
      throw error;
    }
  }

  async rotateSecret(
    secretId: string,