Enable Duplicate Reports by changing Blob URI scheme

[gbdubs]

{"error": "failed to perform operation: creating blob: creating blob row: ERROR: duplicate key value violates unique constraint \"blob_blob_uri_key\" (SQLSTATE 23505)"}

[bcspragu]

I'd imagine this happens when running an report twice on the same portfolio? IIRC, the blob URI is something like az://reports/<portfolio UUID>/<assets...>

[gbdubs]

Oh, can we change that? We will need to be able to run reports multiple times, specifically thinking portfolios with different properties (ESG ex), or pacta versions.

…

On Fri, Jan 19, 2024, 10:13 AM Brandon Sprague ***@***.***> wrote: I'd imagine this happens when running an report twice on the same portfolio? IIRC, the blob URI is something like az://reports/<portfolio UUID>/<assets...> — Reply to this email directly, view it on GitHub <#148 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ACBXTLP2SH7OPW2RH5JN7BDYPKSSPAVCNFSM6AAAAABCBHOUDCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSMBQG44DONRZHA> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[bcspragu]

Totally, it's just this:

app/cmd/runner/main.go

Lines 478 to 479 in b743bc9

	dirPath := filepath.Join(reportDir, dirEntry.Name())
	tmp, err := h.uploadDirectory(ctx, dirPath, h.reportContainer)

The create_report.R script just outputs to a directory based on the input portfolio name, and we then just use that directly to create the subdir we upload the report to, but it can be set to whatever