Mirror of forum.nim-lang.org

2415 :: db_mysql return column name as well?

• everlast (orginal) [2016-07-28T02:56:41+02:00] view original

  Instead of returning just the row/s is there a way to return column_name:column_value pairs?

---

• jlp765 (orginal) [2016-07-28T06:13:27+02:00] view original

  instantRows iterator calls setColumnInfo()

  so (untested code :-) ) where theDb is your dbConn object and myTestTbl is the table being queried, and using count(*) to return only one result so that the column representation is not printed for multiple rows

  
  var dbC: DbColumns
  for x in theDb.instantRows(dbC, sql"select count(*) from myTestTbl"):
    for c in dbC:
      echo repr(c)
  Run

  and FYI (from db_common lib)

  
    DbColumn* = object   ## information about a database column
      name*: string      ## name of the column
      tableName*: string ## name of the table the column belongs to (optional)
      typ*: DbType       ## type of the column
      primaryKey*: bool  ## is this a primary key?
      foreignKey*: bool  ## is this a foreign key?
    DbColumns* = seq[DbColumn]
  Run

---

• OderWat (orginal) [2016-07-28T15:56:09+02:00] view original

  After realizing that my "native" module attempt is futile since the existence of intantRows() I quickly came up with this example:

  import strutils, os
  
  import db_mysql
  
  proc test() =
    let db: DBConn = open("localhost", "root", "", "test")
    assert(db != nil)
    defer:
      db.close()
    
    var dbC: DbColumns = @[]
    for x in db.instantRows(dbC, sql"SELECT * FROM data LIMIT 2"):
      echo "........."
      for idx, f in dbC:
        echo f.name, ": ", x[idx]
  
  test()
  Run

---

• Libman (orginal) [2016-07-29T01:22:50+02:00] view original

  Will I get in trouble for saying:

  MySQL sucks, use PostgreSQL :P

  </public-service-announcement>

---

• OderWat (orginal) [2016-07-30T13:49:43+02:00] view original

  I would like to use MonetDB in production as our use case is heavily depending on mysql / mariadb just because it's MyISAM tables are so fast. PostgreSQL and a lot of other DBs I tried faint already on importing the data and are magnitudes slower in querying them. But I agree that for "normal" usage PostgreSQL now became an option. The PostgreSQL of the past was very disappointing though :)

---