CSAF upload: trying to insert the same organization

[helio-frota]

When trying to upload 296 files via UI we can see the following warning:

2024-11-21T13:34:19.509831Z  WARN ThreadId(36) ingest:load:load:ingest_advisory:ingest_organization:get_organization_by_name:
 sqlx::query: slow statement: execution time exceeded alert threshold 
summary="SELECT \"organization\".\"id\", \"organization\".\"name\", \"organization\".\"cpe_key\", …" 
db.statement="\n\nSELECT\n  \"organization\".\"id\",\n  \"organization\".\"name\",\n  \"organization\".\"cpe_key\",\n  \"organization\".\"website\"\nFROM\n  \"organization\"\nWHERE\n  \"organization\".\"name\" = $1\nLIMIT\n  $2 FOR NO KEY\nUPDATE\n" 
rows_affected=0 rows_returned=1 elapsed=47.105131917s elapsed_secs=47.105131917 slow_threshold=1s format=Advisory labels=Labels(

Then when adding an index for org name, we can fix this warning above but we end up with, trying to insert the same organization again.

[ctron]

I guess this is one of your "get or insert" patterns. It might make sense to turn this into an "upsert" statement.

[helio-frota]

I think that makes sense to close and keep the focus on #999