Function insertWantedDML

packages/wl-sdk/src/commons/dml.generated.ts:60–83

(input: InsertWantedInput)

 * (id, title) and returns a single multi-row INSERT statement.
 */
export function insertWantedDML(input: InsertWantedInput): string {
  if (input.id === '') throw new Error('wanted item ID cannot be empty');
  if (input.title === '') throw new Error('wanted item title cannot be empty');

  const now = input.now ?? formatNowUtc(new Date());
  const tagsJson = formatTagsJson(input.tags);

  const descField = sqlStringOrNull(input.description);
  const projectField = sqlStringOrNull(input.project);
  const typeField = sqlStringOrNull(input.type);
  const postedByField = sqlStringOrNull(input.postedBy);
  const effortField =
    input.effortLevel && input.effortLevel !== ''
      ? `'${escapeSqlString(input.effortLevel)}'`
      : "'medium'";
  const status =
    input.status && input.status !== '' ? `'${escapeSqlString(input.status)}'` : "'open'";
  const priority = input.priority ?? 0;

  return (
    `INSERT INTO wanted (id, title, description, project, type, priority, tags, posted_by, status, effort_level, created_at, updated_at)\n` +
    `VALUES ('${escapeSqlString(input.id)}', '${escapeSqlString(input.title)}', ${descField}, ${projectField}, ${typeField}, ${priority}, ${tagsJson}, ${postedByField}, ${status}, ${effortField}, '${now}', '${now}')`
  );
}

// ClaimWantedDML (commons.go:329)