Function closeUpstreamDML

packages/wl-sdk/src/commons/dml.generated.ts:263–279

(input: CloseUpstreamInput)

 * without creating a stamp.
 */
export function closeUpstreamDML(input: CloseUpstreamInput): string[] {
  const hopField = sqlStringOrNull(input.hopUri);

  const deleteCompletion = `DELETE FROM completions WHERE wanted_id='${escapeSqlString(input.wantedId)}'`;

  const insertCompletion =
    `INSERT IGNORE INTO completions (id, wanted_id, completed_by, evidence, hop_uri, completed_at) ` +
    `VALUES ('${escapeSqlString(input.completionId)}', '${escapeSqlString(input.wantedId)}', ` +
    `'${escapeSqlString(input.completedBy)}', '${escapeSqlString(input.evidence)}', ${hopField}, NOW())`;

  const updateWanted =
    `UPDATE wanted SET status='completed', claimed_by='${escapeSqlString(input.completedBy)}', ` +
    `evidence_url='${escapeSqlString(input.evidence)}', updated_at=NOW() ` +
    `WHERE id='${escapeSqlString(input.wantedId)}'`;

  return [deleteCompletion, insertCompletion, updateWanted];
}

// UpdateWantedDML (commons.go:783)