Mirror of forum.nim-lang.org

1573 :: db_postgres

• z954134 (orginal) [2015-08-23T23:59:49+02:00] view original

  import strutils, db_postgres var db = open("127.0.0.1", user="***", password="***",database="nimcn") var checkSql = sql"select id from Nimer where email = ? and pass_word =?" var email="zxg@126.com" var passWord="256e921e0909d11ba3e267843bfb9bd7" var rowId =db_postgres.getValue(db,checkSql,email,passWord) echo rowId db_postgres.close(db)

  i get error at db_postgres.getValue(db,checkSql,email,passWord),i found the error in setupQuery function in db_postgres.nim.Who can help me?

---

• jlp765 (orginal) [2015-08-24T00:54:52+02:00] view original

  Sounds like the same problem that is in db_mysql (https://github.com/nim-lang/Nim/issues/3220)

  try

  getAllRows(....)[0][0]

  as a quick fix

---

• z954134 (orginal) [2015-08-24T02:30:42+02:00] view original

  i change the function:

  proc setupQuery(db: TDbConn, query: TSqlQuery,

  args: varargs[string]): PPGresult =

  var arr = allocCStringArray(args) var q = dbFormat(query, args) #result = pqexecParams(db, query.string, int32(args.len), nil, arr,nil, nil, 0) result = pqexecParams(db, q.string, 0, nil, nil,nil, nil, 0) deallocCStringArray(arr) if pqResultStatus(result) != PGRES_TUPLES_OK: dbError(db)

  proc exec*(db: TDbConn, query: TSqlQuery, args: varargs[string, $]) {.

  tags: [FReadDB, FWriteDb].} = ## executes the query and raises EDB if not successful. #var arr = allocCStringArray(args) var q = dbFormat(query, args) #var res = pqexecParams(db, query.string, int32(args.len), nil, arr, # nil, nil, 0) var res = pqexecParams(db, q.string, 0, nil, nil,nil, nil, 0) #deallocCStringArray(arr) if pqresultStatus(res) != PGRES_COMMAND_OK: dbError(db) pqclear(res)

---