Mirror of forum.nim-lang.org

1497 :: How to get the last error from db_mysql?

• luntik2012 (orginal) [2015-08-05T09:31:53+02:00] view original

  I cannot find the way to do this

---

• Araq (orginal) [2015-08-05T10:40:42+02:00] view original

  db_mysql raises an exception instead, use mysql.nim for a lower level api.

---

• luntik2012 (orginal) [2018-03-19T15:39:12+01:00] view original

  What about db.tryInsertId()? It can return -1 without rasing exception. Is there a way to get error msg?

---

• mashingan (orginal) [2018-03-19T16:43:01+01:00] view original

  Not tested, so dunno if it's correct or not, also, very likely unsafe especially if used in multithreaded

  try:
    ...
    ...
  except DbError:
    var
      err = cast[DbError](getCurrentException())
      msg = err.msg
  
  Run

  EDIT: Ah, sorry, I just realized that you want error code instead of the message.

---

• euant (orginal) [2018-03-26T11:05:20+02:00] view original

  @luntik2012 use insertId rather than tryInsertId instead: https://nim-lang.org/docs/db_mysql.html#insertId,DbConn,SqlQuery,varargs[string,]

---

• luntik2012 (orginal) [2018-03-28T09:58:12+02:00] view original

  @euant, thank you, didn't think about that.

---