const uidEncomenda = _req.getUID('uid');

const dbEncomenda = _db.queryFirst(`SELECT status FROM encomenda WHERE uid = ?::uuid`,uidEncomenda);

if (dbEncomenda == null) {
  _header.status(404);
  _out.json(
    _val.map()
      .set("error",true)
      .set("message", "encomenda does not exists!")
  )
  _exec.stop();
}

/*
 * CREATED - 1
 * SENT - 2
 * CANCELED - 3
*/

if (dbEncomenda.getInt('status') == 3) {
  _header.status(400);
  _out.json(
    _val.map()
      .set("error",true)
      .set("message", "encomenda already canceled!")
  )
  _exec.stop();
}

_db.execute("UPDATE encomenda set status = ?::int WHERE uid = ?::uuid",
  _val.init()
    .add(3)
    .add(uidEncomenda)
);

_out.json(
  _val.map(
    _val.map()
      .set("result",true)
  )
);