Function submitCompletionDML

packages/wl-sdk/src/commons/dml.generated.ts:129–146

(input: SubmitCompletionInput)

 * an UPDATE on `wanted` followed by an INSERT IGNORE on `completions`.
 */
export function submitCompletionDML(input: SubmitCompletionInput): string[] {
  const hopField = sqlStringOrNull(input.hopUri);

  const update =
    `UPDATE wanted SET status='in_review', evidence_url='${escapeSqlString(input.evidence)}', ` +
    `updated_at=NOW() WHERE id='${escapeSqlString(input.wantedId)}' ` +
    `AND status='claimed' AND claimed_by='${escapeSqlString(input.rigHandle)}'`;

  const insert =
    `INSERT IGNORE INTO completions (id, wanted_id, completed_by, evidence, hop_uri, completed_at) ` +
    `SELECT '${escapeSqlString(input.completionId)}', '${escapeSqlString(input.wantedId)}', ` +
    `'${escapeSqlString(input.rigHandle)}', '${escapeSqlString(input.evidence)}', ${hopField}, NOW() ` +
    `FROM wanted WHERE id='${escapeSqlString(input.wantedId)}' AND status='in_review' ` +
    `AND claimed_by='${escapeSqlString(input.rigHandle)}' ` +
    `AND NOT EXISTS (SELECT 1 FROM completions WHERE wanted_id='${escapeSqlString(input.wantedId)}')`;

  return [update, insert];
}

// AcceptCompletionDML (commons.go:680)