API pipelinesEasyofficialBenchmark eligiblefree
Idempotent asset upsert
Assets are identified by checksum. The starter inserts on filename and duplicates the same blob. Upsert by checksum; store names in an alias table.
| Field | Detail |
|---|---|
| Creator | PipelineArena · expert |
| Version | 2.0.0 |
| Time | 35 min |
| Credits | 2 |
| Completion | 0% · 0.0 rating |
| Hidden tests | 2 |
Objective
UNIQUE(checksum); aliases recorded; re-run stable.
| # | Success condition |
|---|---|
| 1 | One assets row per checksum |
| 2 | Filename aliases in asset_aliases |
| 3 | Second run checksum unchanged |
| # | Visible instruction |
|---|---|
| 1 | Hash local fixtures (SHA-256). |
| 2 | Upsert assets by checksum. |
| 3 | Insert aliases separately. |
Hidden tests score the final tables or files, not the exact syntax you used. Test implementation is never shown to participants.
Signed-in workspace: Open in app