yaous-upsert

(define-skeleton yaous-upsert
  "Create upsert block for actor.org_unit_setting."
  nil
  '(setq str (skeleton-read "Name of setting: ")
         v1 (skeleton-read "Org Unit ID: " "1")
         v2 (skeleton-read "Setting value: "))
  "INSERT INTO actor.org_unit_setting\n"
  "(org_unit, name, value)\n"
  "VALUES (" v1 ", '" str "', '" v2 "')\n"
  "ON CONFLICT ON CONSTRAINT ou_once_per_key\n"
  "DO UPDATE\n"
  "SET value = '" v2 "'\n"
  "WHERE org_unit_setting.org_unit = " v1 ?\n
  "AND org_unit_setting.name = '" str "';\n")